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

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
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
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman