The Hive - Learn, Help, Connect

How to Analyse Categorical Data...

...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

Downloadable resources

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:

Your Curriculum

**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

Road Map

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

Chapter 1 Road Map Review

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

Road Map Review

3

Pairwise Analysis of Categorical Data in Excel

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

Premium

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

Chapter 3 Road Map Review

4

The 2x2 Contingency Table

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

Premium

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

Chapter 4 Road Map Review

5

Visualising Relationships

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

Premium

CHAPTER HIGHLIGHTS

Chapter Road Map

Introduction to the Correlation Matrix

Introduction to Node-Link diagrams

Road Map Review

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!

Premium

CHAPTER HIGHLIGHTS

Course Road Map

Understanding Categorical Data

Handling Categorical Data

Pairwise Analysis

2x2 Contingency Tables

Visualising Relationships

Road Map Review

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...

How to analyse categorical survey data in Excel and in R
Remember Me
Success message!
Warning message!
Error message!