1. According to a recent National Association of Colleges and Employers (NACE) report, 48% of college student internships are unpaid. (Source: "Just 38 Percent of Unpaid Internships Were Subject to FLSA Guidelines," bit.ly/Rx76M8.) A recent survey of 60 college interns at a local university found that 30 had unpaid internships. a. Use the five-step p-value approach to hypothesis testing and a 0.05 level of significance to determine whether the propor-tion of college interns that had unpaid internships is different from 0.48.b. Assume that the study found that 37 of the 60 college interns had unpaid internships and repeat (a). Are the conclusions the same?
2. You are the manager of a restaurant that delivers pizza to college dormitory rooms. You have just changed your delivery process in an effort to reduce the mean time between the order and completion of delivery from the current 25 minutes. A sample of 36 orders using the new delivery process yields a sample mean of 22.4 minutes and a sample standard deviation of 6 minutes.a. Using the six-step critical value approach, at the 0.05 level of significance, is there evidence that the population mean deliv-ery time has been reduced below the previous population mean value of 25 minutes?b. At the 0.05 level of significance, use the five-step p-value ap-proach.c. Interpret the meaning of the p-value in (b).d. Compare your conclusions in (a) and (b).
Could you please insert these into excel? Showing work?