Minitab Open Project $80 Open Worksheet New Project New Worksheet C1 C2 C3 C4 C5 C6 C7 CB C9 C10 C11 C12 C13 SEC PPG C14 C1 1 79.7 81.4 81.8 68.8 71.9 6 74.2 70.4 59.3 73.4 10 77.2 11 77.5 12 72.5 13 71.8 14 64.3 161. For a specific survey, the Gallup Poll reported that 45% of individuals felt they were worse off than 1 year ago. A politician feels that this is too high for her district, so she commissions her own survey and finds that, out of 150 randomly selected citizens, 58 feel they are worse off today than 1 year ago. At a 5% level of significance, is the politician correct about her district? a) (5 pts) What are the hypotheses for this test? b) (10 pts) Are the conditions for this hypothesis test met? Provide details to justify your answer. c) (10 pts) Use Minitab to do the hypothesis test. Be sure to copy the Minitab output to your Word doc. Be sure to clearly state what the test statistic and p-value are for this test (i.e. showing just the Minitab output is not sufficient... you must also state what these are). d) (10 pts) What is your conclusion to this hypothesis test? Show precisely how you made your decision. e) (10 pts) Answer the question stated in the problem... At a 5% level of significance, is the politician correct about her district? Give a clear explanation, i.e. you cannot just answer "Yes" or "No". 2. In your Minitab project CA4.mpx, in the column entitled SEC PPG, is the number of points per game that the SEC Basketball teams scored in the 2020-2021 season. (Note: The SEC, Southeastern Conference, is the conference that the University of Kentucky plays in.) An avid Louisville Cardinals basketball fan, whose team plays in the ACC (Atlantic Coast Conference), and being a stathead, knows the mean points per game (PPG) for the ACC is 71.47. He also feels the ACC is more competitive than the SEC so as a result he speculates that the mean PPG in the SEC is higher than the mean PPG for the ACC (which is 71.47). Is our Louisville fan correct? Test his claim at the 5% level of significance. a) (5 pts) What are the hypotheses for this test? b) (10 pts) Are the conditions for this hypothesis test met? Provide details to justify your answer.c) (10 pts) Use Minitab to do the hypothesis test. Be sure to copy the Minitab output to your Word doc. Be sure to clearly state what the test statistic and p-value are for this test (i.e. showing just the Minitab output is not sufficient... you must also state what these are). d) (10 pts) What is your conclusion to this hypothesis test? Show precisely how you made your decision. e) (10 pts) Is the Louisville fan's speculation believable? Give a clear explanation, i.e. you cannot just answer "Yes" or "No". 3. (10 points) Now, you are done with this assignment, be sure to save both your Minitab project and Word document. To complete this assignment, upload both files in Blackboard