PROVIDE ALL EXCELL FORMULAS USED TO SOLVE THIS PROBLEM! THANK YOU!

DATA TABLE IS BELOW HERE

3. A claim is made that the average salary for all jobs in Minnesota is greater than $71,000. You are going to test the claim using ?=0.05 and assume that your data is normally distributed and the population standard deviation (?) is not known.

3a. Write the null and alternative hypotheses symbolically and identify which hypothesis is the claim. Then identify if the test is left-tailed, right-tailed, or two-tailed and explain why.

3b. Identify and explain which test statistic you will use for your hypothesis test: z or t? Find the value of the test statistic.

Provide your calculations in the cells designated to the right. Explain your answers below.

Calculations/Values Formulas/Answers Mean (x-bar) Standard Deviation n mu Test Statistic Critical Value P-valueCalculations/Values Formulas/Answers Mean (x-bar) Standard Deviation n mu Test Statistic Critical Value P-value