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.
この演習はコースの一部です
Google Sheets ではじめる統計学
演習の手順
- 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.
