WEEK 7 ACTIVITY - HYPOTHESIS TESTINGDUE NOVEMBER 22, 2021 Hypothesis Testing The Lazer Company has a contract to produce a part for Boeing Corporation that must have an average diameter of 6 inches and a standard deviation of 0.10 inch. The Lazer Company has developed a process that will meet the specifications with respect to the standard deviation, but it is still trying to meet the mean specifications. A test run (considered a random sample) of parts was produced, and the company wishes to determine whether this latest process that produced the sample will produce parts meeting the requirement of an average diameter equal to 6 inches.  Use Excel to: Construct      the appropriate null and alternative hypotheses with correct      parameters.  Develop      the decision rule assuming that the sample size is 200 parts and the      significance level is 0.01. In a Word document: Recommend      what the Lazer Company should conclude if the sample mean diameter for the      200 parts is 6.03 inches.

To prepare for this Assignment:Review this week’s Learning Resources and media program related to regression and correlation.Using the SPSS software, open the Afrobarometer dataset or the High School Longitudinal Study dataset (whichever you choose) found in the Learning Resources for this week.Based on the dataset you chose, construct a research question that can be answered with a Pearson correlation and bivariate regression.Once you perform your correlation and bivariate regression analysis, review Chapter 11 of the Wagner text to understand how to copy and paste your output into your Word document.For this Assignment:Write a 2- to 3-paragraph analysis of your correlation and bivariate regression results for each research question. In your analysis, display the data for the output. Based on your results, provide an explanation of what the implications of social change might be.Use proper APA format, citations, and referencing for your analysis, research question, and display of output.