The Hive - Learn, Help, Connect

How to Analyse Categorical Survey Data in Excel and in R

In this course you're going to master the ​fundamentals of analysing categorical survey data in Excel. You'll then expand your skillset by learning to make the transition and analyse the same data using the same techniques in R.

​Video lessons

​Articles

​Downloadable resources

​Certificate of completion

​Interactive experience

​Perfect for beginners


$ 97

$ 200

Try it first - decide later!

​No obligation to buy or register


Single Payment

Lifetime Access


All Access Pass

  • ​Description
  • ​Content
  • ​Learning Outcomes
  • ​FORUM
  • ​Certification

​​If you’ve ever looked at categorical survey data and didn’t know how to analyse them, didn’t know which statistical tests to use, didn’t understand what the tests were doing or didn’t know how to interpret the results correctly, then this course is for you.

In the end, you’ll have the knowledge, experience and strategies to be able to analyse your categorical survey data in both Excel and in R with confidence!

​Here's what you'll learn:

1.

​you’ll learn how to recognise and work with the different forms of categorical data – by playing with the data, just like you did as a child when learning Lego!

2.

​you’ll learn how to handle categorical data in Excel to prepare them for statistical analysis

3.

​in Excel you’ll learn to use the ​correct statistical tests ​on your data – more importantly you’ll learn exactly what these tests are doing with your data, making correct interpretation of the results a doddle!

​4.

​you’ll learn exactly how to visualise your results in Excel so that your results make sense

​5.

​you’ll learn how to make the transformation from Excel to R, so that everything you’ve learned so far can be replicated in R

​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

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

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

3

​Pairwise Analysis of Categorical Data in Excel

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

​Premium

CHAPTER HIGHLIGHTS

4

Visualising Relationships ​with MS ​(XL & PP)

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

​Premium

CHAPTER HIGHLIGHTS

5

Handling Categorical Data in ​R

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

​Premium

CHAPTER HIGHLIGHTS

6

Pairwise Analysis of Categorical Data in ​R

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

​Premium

CHAPTER HIGHLIGHTS

7

Visualising Relationships in ​R

​​Here you'll learn ​how to visualise your results in R in the best way to aid knowledge & understanding.

​Premium

CHAPTER HIGHLIGHTS

8

​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

100% Satisfaction Guarantee for 30-Days

​​We are proud to offer a 30 day no-quibble money back guarantee.

We don't like being hassled when we want our money back, and we extend that same courtesy to you.

​You can be refunded in full any time during the first 30 days of your purchase or subscription*. After the 30 day period you will not be able to get a full refund, but you may cancel ​your subscription any time you like.

*If any member exceeds 10% of total progress or ​logs in several times and follows the majority of ​any premium course, we reserve the right to refuse refund.

CEO Lee Baker

Got any questions or comments? I need your feedback to help me create the perfect course for your needs!

​Ask your ​questions ​below.

Your view really matters, and I will respond to every comment personally!


How to analyse categorical survey data in Excel and in R