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.
Este exercício faz parte do curso
Introduction to Statistics in Google Sheets
Instruções do exercício
- 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.
Exercício interativo prático
Transforme a teoria em ação com um de nossos exercícios interativos
Começar o exercício