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.
Cet exercice fait partie du cours
Introduction to Statistics in Google Sheets
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.
Exercice interactif pratique
Passez de la théorie à la pratique avec l’un de nos exercices interactifs
Commencer l’exercice