A major client of your company is interested in the salary distributions of jobs in the state of Minnesota that range from $30,000 to $200,000 per year. As a Business Analyst, your boss asks you to research and analyze the salary distributions. You are given a spreadsheet that contains the following information. You will be examining 599 records in the spreadsheet's data set, which comes from the Bureau of Labor Statistics. The data set includes a list of various job titles in Minnesota with annual incomes ranging from about $30,000 to $200,000. The spreadsheet in Excel has four tabs. You must use the appropriate Excel formulas to determine the mean, standard deviation, and sample size in the first tab, "data." You have questions to answer on the next three tabs. Make sure that every question you respond to includes instructions, step-by-step directions, and proper formatting.

1. Describe the 8 steps in the process for hypothesis testing. Include an explanation of the decision criteria for rejecting the null hypothesis for both the p-value method and the critical value method. 2. A claim is made that the average salary for all jobs in Minnesota is less than $67,500. You are going to test the claim using =0.01 and assume that your data is normally distributed and the population standard deviation () is not known. 2a. 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. 2b. 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. 2c. What is the critical value? Describe the rejection region of this hypothesis test. Provide your calculations in the cells designated to the right. Explain your answers below. 2d. Using the critical value approach, should you reject the null hypothesis or not reject the null hypothesis? Explain. After making your decision, restate it in non-technical terms and make a conclusion about the original claim. 2e. Calculate the p-value for this hypothesis test, and state the hypothesis conclusion based on the p-value. Does this match your results from the critical value method? Provide your calculations in the cells designated to the right. Explain your answers below. 3. In the sample given on the data tab, 386 of the 599 jobs have an average salary of at least $50,000. Test the claim that more than 60% of the jobs have an average salary of at least $50,000 using a 0.05 significance . 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.3c. What is the critical value? Describe the rejection region of this hypothesis test. Provide your calculations in the cells designated to the right. Explain your answers below. 3d. Using the critical value approach, should you reject the null hypothesis or not reject the null hypothesis? Explain. After making your decision, restate it in non-technical terms and make a conclusion about the original claim. 3e. Calculate the p-value for this hypothesis test, and state the hypothesis conclusion based on the p-value. Does this match your results from the critical value method? Provide your calculations in the cells designated to the right. Explain your answers below.