Please answer in Excel so I can understand how the formula works. 9.13 Do busine
ID: 3219218 • Letter: P
Question
Please answer in Excel so I can understand how the formula works.
9.13 Do business seniors at your school prepare for class more than, less than, or about the same as business seniors at other schools? The National Survey of Student Engagement (NSSE) found that business seniors spent a mean of 14 hours per week preparing for class. (Source: A Fresh Look at Student Engagement Annual Results 2013, available at bit.ly/1j3Ob7N.)a. State the null and alternative hypotheses to try to prove that the mean number of hours preparing for class by business seniors at your school is different from the 14-hour-per-week benchmark reported by the NSSE.b. What is a Type I error for your test?c. What is a Type II error for your test?
Explanation / Answer
Mathematically
Null hypothesis(H0): =14.
Alternative hypothesis(Ha): 14
Type 1 error:
When we reject null hypothesis that population mean studied hours are 14 per week but in actual it is equal to 14 hours.
Type 2 error:
When we accept the null hypothesis that population mean studied hours are 14 per week but in actual it is different from 14.