Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

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.29