(Answered):Excel 4 Questions With Attachment . . . .

Question Description

Create an Excel workbook with worksheet templates (similar to the Excel workbook Confidence Intervals) for one-sample hypothesis tests for means 1. and proportions. Apply your templates to the example problems in this chapter. (For subsequent problems, you should use the formulas in this chapter to perform the calculations, and use this template only to verify your results!)

2. A business school has a goal that the average number of years of work experience of MBA applicants is at least 3 years. Based on last year’s applicants, it was found that among a sample of 47, the average number of