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:
H 0 : µ = 4215 vs. H a : µ 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.