Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing Cases An Active Learning Approach

Authors: Mark S. Beasley, Frank A. Buckless, Steven M. Glover, Douglas F. Prawitt

2nd Edition

0130674842, 978-0130674845

Students also viewed these Mathematics questions