I am having issues with a Statistic assignment that has been assigned. Attached is what we have been assigned.

West SouthEast 4 7 8 3 4 4 4 5 6 10 9 7 7 4 3 2 1 2 3 9 MidWest 3 2 4 2 8 3 5 6 2 4 3 3 9 2 3 1 2 1 2 2 1 1 3 2 NewEngland 2 2 8 9 10 12 1 9 9 3 6 5 6 4 4 4 4 2 2 1 1 3 3 4 8 7 3 5 6 2 2 1 4 3 3 5 10 10 9 11 STAT 2050/2070 Statistics Lab Report 3 Guidelines Consider the data set Education by Region. The data provide the number of years of education beyond high school for a number of residents in each region. Let us consider New England. Suppose we need to test whether the mean number of years of education beyond high school is significantly different from 9. We state the hypotheses first: 0 : = 9 1 : 9 Go to: http://www.graphpad.com/quickcalcs/oneSampleT1/?Format=SD. We copy and paste the data from the Excel data spreadsheet as follows: Note: you need to select \"Enter or paste up to 10,000 rows\" or \"Enter or paste up to 50 rows\" depending on the size of the sample. Copy the data, and specify the hypothetical mean of 9 years (this is the null hypothesis). Click on \"Calculate now\" to obtain the following results. The sample mean is 5.21. The test statistic is 5.3567, df = 18, and the p-value is less than 0.0001. This means that the observed difference (5.21 - 9) is extremely statistically significant. Therefore, we have to reject the null hypothesis, and conclude that the population mean of number of years of education beyond high school in New England region is significantly different from 9. Note that the confidence interval does not include 0. This confirms the conclusion, i.e., it is highly unlikely that the difference between the population mean and 9 would be 0, i.e., the population mean is significantly different from 0. Alternatively, one could calculate a confidence interval for the population mean to observe that 9 is not included in that confidence interval. Next, let us explore the difference in the mean number of years of education between New England and West regions. We formulate the hypotheses first: 0 : New England West = 0 1 : New England West 0 The null hypothesis claims that there is no difference between the mean number of years of education beyond high school in the two regions. Go to: http://www.graphpad.com/quickcalcs/ttest1/?Format=C. Next copy and paste the data from the Excel spreadsheet as follows: Select the \"Unpaired t test\". Note: you can label the groups as shown in the figure. Click \"Calculate now\" to obtain the following results: First observe that the p-value is 0.9044. Since this number is larger than 0.05 (a standard value for the significance level), we fail to reject the null hypothesis. This means that the difference between the two means is statistically non-significant. In other words, there is no significant difference in the mean number of years of education beyond high school between New England and West regions (the test statistic is 0.1210). Note also that the 95% confidence interval for the mean difference is -1.74 to 1.96. Clearly, 0 is included, and, therefore, it is plausible that the mean difference is equal to 0. In other words, there is no difference between the two population means. Statistics Lab Report 3 Due by 11:59 PM, Sunday, April 19 Make sure your work is complete. Make sure your work is truly yours; penalty for cheating is an F on the assignment and/or an F in the course. All your work should be in a single Word document. Use the data set: Education by Region_1_.xlsx. Part 1 Using the same data set, analyze the data for Southeast region. Do the following: (1) Obtain a histogram and boxplot for the data (revisit one of the earlier lab reports). (2) Test whether the mean number of years of education in this region is significantly different from 5. State the hypotheses. Mean number of years is 3.08333 53.08333=1.91667 H 0=5 H A 5 (3) Perform an appropriate test of hypotheses; copy and paste the results. (4) Identify the test statistic and the p-value, and state the decision. (5) Interpret the p-value, and answer the research question. Part 2 Using the same data set, consider the data for Southeast and New England regions. Do the following: (1) Test whether there is a significant difference in the mean number of years of education beyond high school between the two regions. State the hypotheses. (2) Perform an appropriate test of hypothesis; copy and paste the results. (3) Identify the test statistic and the p-value, and state the decision. (4) Interpret the p-value, and answer the research question. (5) Identify the 95% confidence interval for the mean difference, and interpret the result. How does this result relate to the results in parts (3) and (4)