Question: Could you please help show how this is done in excel (chi-squared test of independance, I think) and give me the excel output? the question

Could you please help show how this is done in excel (chi-squared test of independance, I think) and give me the excel output? the question is "Test, at the 5% level of significance, whether a student owning an Ipad is dependent to how often they exercise?"

How often do you exercise? (1 = Not At All, 2= Sometimes, 3 = Regularly) Do you have an ipad? (1= no, 2=yes)
Exercise Ipad
1 2
2 2
1 2
1 2
2 2
1 1
2 2
3 2
2 2
2 1
1 1
1 1
3 1
3 2
3 1
3 2
3 1
1 2
1 1
1 1
1 2
2 1
1 1
1 1
1 1
2 2
3 2
1 2
1 1
1 1
1 1
1 2
2 2
1 2
2 1
1 2
1 1
1 1
2 2
3 2
1 1
2 1
1 1
2 2
1 2
3 2
1 2
1 2
1 1
1 2
2 1
2 2
1 1
1 2
3 2
2 2
1 2
3 2
3 2
1 2

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!