- Complete Problems 44 and 45 Use a 5% significance level.
- Problem 44: For the data in the Excel file Helpdesk Survey, determine if the mean overall satisfaction ratings differ by the ratings given for response time.
- Problem 45: Using the data in the Excel file Cell Phone Survey, apply ANOVA to determine if the mean response for value for the dollar is the same for different types of cell phones.
- o You will have to sort and separate the data into columns first. (copy and paste into a new labeled columns)
- · For each hypothesis test, state the null and alternative hypotheses.
· For each hypothesis test, highlight your P-value · For each hypothesis test, state whether you would reject or not reject the null hypothesis. · For each hypothesis test, interpret the conclusion of the test in context.