1.) In the past, 35% of the students at ABC University were in the Business Coll
ID: 3060934 • Letter: 1
Question
1.) In the past, 35% of the students at ABC University were in the Business College, 35% of the students were in the Liberal Arts College, and 30% of the students were in the Education College. The University took a sample of 300 students to see whether the proportions have changed. Ninety of the sample students are in the Business College, 120 are in the Liberal Arts College, and 90 are in the Education College. The hypothesis is to be tested at the 5% level of significance. What is the p-value equals to?
Please help me break down the process. Please show me in Excel if possible.
a. 0.333 b. 0.645 c. 0.117 d. 0.0000
Explanation / Answer
here applying chi square goodness of fit test :
fr degree of freedom =categories-1= 3-1 =2
for 2 df and above test statistic use excel function =chidist(4.29,2) =0.117
option C is correct
observed Expected Chi square x Probability(p) Oi Ei=total*p R2i=(Oi-Ei)2/Ei Business 0.350 90.000 105.0 2.14 Liberal arts 0.350 120.000 105.0 2.14 Education 0.300 90.000 90.0 0.00 total 1 300 300 4.29Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.