I hope you’re well. We have a research report/proposal due for Statistics next month. We were told to gather data on anything related to schools, learners or teachers. I have chosen to gather data on academic achievement and sports participation. I am interested in the difference between a learners academic achievement and whether he/she takes part in sports or not. I received data from the school which I put into a table. It is the academic term average for those who do sports and those who do not. We are now required to carry out two tests along with graphs etc. I have done the t-test and am happy with the results. I would like to do a chi-square test as my second test, but I am completely lost. I have my raw data (please see attached) but I am struggling to move forward. I need to find out what the observed and expected data is (from my raw data) and carry out the test.  Please could you assist me. I would really love to do well in this course, but it is not my strongest subject. I would really appreciate your help

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter10: Statistics
Section10.3: Measures Of Spread
Problem 8PPS
icon
Related questions
Question
100%

Hi there,

I hope you’re well. We have a research report/proposal due for Statistics next month. We were told to gather data on anything related to schools, learners or teachers. I have chosen to gather data on academic achievement and sports participation. I am interested in the difference between a learners academic achievement and whether he/she takes part in sports or not.

I received data from the school which I put into a table. It is the academic term average for those who do sports and those who do not. We are now required to carry out two tests along with graphs etc. I have done the t-test and am happy with the results. I would like to do a chi-square test as my second test, but I am completely lost. I have my raw data (please see attached) but I am struggling to move forward. I need to find out what the observed and expected data is (from my raw data) and carry out the test. 

Please could you assist me. I would really love to do well in this course, but it is not my strongest subject.

I would really appreciate your help.

 

Thank you kindly,

Carmen Loureiro

AutoSave On
Paste
File Home Insert
X Cut
K9
23456700
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
Copy
Format Painter
Clipboard
1
2
3
4
E
1 Difference in Academic Term Averages
5
6
7
8
9
10
11
12
13
14
15
F
85
86
88
82
88
90
92
90
90
Page Layout
77
80
89
79
Calibri
BIU
Sports
No Sports
Participation Participation
Treatment x Treatment y
83
92
fx
86
67
65
68
68
79
79
83
72
84
82
75
74
52
75
Formulas Data
A A
A Y
FR-
Font
Chi-square excel • Last Modified: 26 August
Review View Help
=
11
D
E
Fy
F
G
Alignment
H
Wrap Text
Merge & Cente
I
Transcribed Image Text:AutoSave On Paste File Home Insert X Cut K9 23456700 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 Copy Format Painter Clipboard 1 2 3 4 E 1 Difference in Academic Term Averages 5 6 7 8 9 10 11 12 13 14 15 F 85 86 88 82 88 90 92 90 90 Page Layout 77 80 89 79 Calibri BIU Sports No Sports Participation Participation Treatment x Treatment y 83 92 fx 86 67 65 68 68 79 79 83 72 84 82 75 74 52 75 Formulas Data A A A Y FR- Font Chi-square excel • Last Modified: 26 August Review View Help = 11 D E Fy F G Alignment H Wrap Text Merge & Cente I
Expert Solution
steps

Step by step

Solved in 3 steps

Blurred answer
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question

Thanks again for the solution. I now need to represent this data visually using either a bar graph, histogram, pie chart, distribution graph etc. I need two visual representations. I have spent all day trying to google how to represent chi-square results visually in excel, but haven't had much success. 

Please please can you assist, I would really appreciate it.

Thank you so much.

Solution
Bartleby Expert
SEE SOLUTION
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Holt Mcdougal Larson Pre-algebra: Student Edition…
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL