es WetCOM\" 20 Student Homecomir Oulook Web App Lab 5: Chi-Square Directions: Us
ID: 2908848 • Letter: E
Question
es WetCOM" 20 Student Homecomir Oulook Web App Lab 5: Chi-Square Directions: Use Excel (or SPSS) to compute the Chi-Sqaare Test Problem: Using the following data, test the question that an equal number of boys (code- 1) and girls (code-2) participate in soccer at the elementary level at the 01 level of significance. Use Excel (or SPSS) and compute the exact probability of the chi-square value. What's your Gender Boys- 1 Girls-2 45 Online resources to help with this assignment Excel (SPSS) earch 45 8 6 8Explanation / Answer
Solution:
Here, we have to use Chi square test for goodness of fit. The null and alternative hypothesis for this test is given as below:
Null hypothesis: H0: Equal number of boys and girls participate in soccer at the elementary level.
Alternative hypothesis: Ha: No equal number of boys and girls participate in soccer at the elementary level.
We are given
Level of significance = alpha value = ? = 0.01
The test statistic formula is given as below:
Chi square = ?[(O – E)^2/E]
Where O is observed frequencies and E is expected frequencies.
Excel calculations for this test are given as below:
Gender
O
E
(O - E)
(O - E)^2
(O - E)^2/E
Boys
45
50
-5
25
0.5
Girls
55
50
5
25
0.5
Total
100
100
1
Chi square = ?[(O – E)^2/E] = 1
DF = n – 1 = 2 – 1 = 1
? = 0.01
Critical value = 6.634896712 (by using excel)
[Excel command: =chiinv(0.01,1)]
P-value = 0.317310813 (by using excel)
[Excel command: =chidist(1,1)]
P-value > ? = 0.01
So, we do not reject the null hypothesis that Equal number of boys and girls participate in soccer at the elementary level.
There is sufficient evidence to conclude that equal number of boys and girls participate in soccer at the elementary level.
Gender
O
E
(O - E)
(O - E)^2
(O - E)^2/E
Boys
45
50
-5
25
0.5
Girls
55
50
5
25
0.5
Total
100
100
1
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.