Lab 7 This assignment is due before the end of your Monday/Tuesday section

Lab 7

This assignment is due before the end of your Monday/Tuesday section.

For every section you will submit your handwritten work to your TA. Only

neat and organized assignments will be graded for credit. Take pride in all

of your work. Note: you may print plots for your assignment or you can just

demonstrate to your TA during section that you can create plots.

1. Open the Excel file GolfIncome.xlsx. The data represent income (in thousands of

dollars) earned by a population of 40 professional golfers from their endorsement

deals. Assume that the data follow a normal distribution. Last time we found

population mean was 4,215. Randomly select 12 incomes and test the hypothesis:

H0 : µ = 4215 vs. Ha : µ 6= 4215

Test at a 10% level of significance using a z-test and t-test using sample standard

deviation. Follow the instructions on pg 348 Nots of Technology: Test for mean

and provide an updated version of instructions for the Excel item along with the

differences observed between the two tests.