## ...The Right Way!

In this course you're going to master the fundamentals of analysing categorical data in Excel. You'll learn everything you need to know about Pairwise analysis, Contingency Tables, and visualising all the relationships in your data.

By the time you've finished this course, you'll know more about handling and analysing categorical data than almost everyone around you!

Video lessons

Articles

Certificate of completion

Interactive experience

Perfect for beginners

[wpc_button]

• Description
• Content
• Outcomes
• FORUM
• CertificatE

This course has a dedicated forum where you can ask questions, get answers and connect with our learners.

You can find the forum here:

**Disclaimer**

This course is a work in progress. As a consequence of your feedback, the following curriculum may be subject to change...

...for the better!

0

#### Introduction

Getting started, and learning what this course is all about and - just as importantly - what it isn't about!

Open Access

#### CHAPTER HIGHLIGHTS

What’s in this course, and what isn’t

Mission Statement

1

#### Understanding Categorical Data

In this chapter you'll learn the fundamentals of categorical data, and how to handle Ordinal and Nominal data.

Open Access

#### CHAPTER HIGHLIGHTS

What is a Survey?

Introduction to Categorical Data

Introduction to Likert Scales

My Experiences with Scale Data

2

#### Handling Categorical Data in Excel

The focus in this chapter is on handling categorical data in each situation that you will encounter.

Free Plan

#### CHAPTER HIGHLIGHTS

How to create dummy variables

The importance of Descriptive Statistics

Calculating and understanding descriptive statistics of numerical categorical data

Calculating and understanding descriptive statistics of textual categorical data

Creating combined categories

3

#### Pairwise Analysis of Categorical Data in Excel

In this chapter you'll learn everything you need to know about pairwise analysis.

#### CHAPTER HIGHLIGHTS

Introduction to Contingency Tables

Introduction to Observed and Expected Values

How to Calculate Residuals

How to Calculate Chi-Squared and p-values

How to Interpret Contingency Tables

4

#### The 2x2 Contingency Table

In this chapter you'll learn everything you need to know about contingency tables.

#### CHAPTER HIGHLIGHTS

Introduction to 2x2 Contingency Tables

The Tea Lady - Introducing Fisher's Exact Test

Explaining Fisher's Exact Test

How to Interpret p-values

Comparison of Fisher's Exact Test and Chi-Squared Test

Introduction to Odds Ratios

Discussion of multiple testing

5

#### Visualising Relationships

The focus in this chapter is on how to visualise your results in the best way to aid knowledge & understanding.

#### CHAPTER HIGHLIGHTS

Introduction to the Correlation Matrix

Feedback

6

#### Course Review

Finally, we will review the whole course to reinforce what we've learnt - and then celebrate the end of the course!

#### CHAPTER HIGHLIGHTS

Understanding Categorical Data

Handling Categorical Data

Pairwise Analysis

2x2 Contingency Tables

Visualising Relationships

Course completion certificate

Feedback

Get Started

It's free to get started, with no obligation to buy or register.

Try it now, decide later!

Just click the link below to go to the first lesson...

Remember Me
Success message!
Warning message!
Error message!