Are gender and number of roommates independent?
As it turns out, the dating website also has information on gender and the number of roommates each profile has, so let's "pivot" for a moment and explore whether the two are independent using a chi-squared independence test.
Although you believe age and roommates could be related, you suspect that gender has no impact on the number of roommates.
On the right is a frequency pivot table from 200 profiles. Check out DataCamp’s Pivot Tables in Google Sheets learn all about pivot tables. Your hypotheses:
H0: The `roommates` & `gender` variables are independent
H1: The `roommates` & `gender` variables are not independent
Assume a 0.05 p-value cutoff. As a refresher, if the p-value result is less than the significance level (0.05), you can reject the null hypothesis.
This exercise is part of the course
Introduction to Statistics in Google Sheets
Exercise instructions
- In
K2, conduct a chi-squared test by passing in the observed rangeB3:C7and then the expected range 'G3:H7' to get the p-value. - Enter
REJECTorFAIL TO REJECTdemonstrating your interpretation of the test.
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
Start Exercise