Please do Part B of the course project, you should check out

Please do Part B of the course project, you should check out the PDF and EXCEL attachment for the detail instructionIn this case, 40 individuals visited the hospital looking for information and education regarding their diabetes.Since diabetes relates to the body’s ability to use glucose, their glucose level was measured. These patiencetook a knowledge test about diabetes before and after being given some educational materials. Satisfactionwith their overall visit was also measured through a survey. The data appear below for your reference. TheExcel spreadsheet with these data can be found in Doc Sharing and should be opened in Minitab to completethe analyses required in each part of this project. Your manager has speculated the following:the average (mean) level of glucose is less than 130the true population proportion of number somewhat satisfied with their hospital stay is greater than 28%,the average (mean) score on the diabetes pretest is greater than 52.the average (mean) score on the diabetes posttest ONLY among those that are ‘somewhat satisfied’ isless than 75.Using the sample data, perform the hypothesis test for each of the above situations in order tosee if there is evidence to support your manager’s belief in each case a.-d. In each case use theSeven Elements of a Test of Hypothesis, in Section 6.2 of your textbook with α = .05, and explainyour conclusion in simple terms. Also be sure to compute the p-value and interpret.Follow this up with computing 95% confidence intervals for Glucose and Diabetes Posttest, andagain interpreting these intervals.Write a report to your manager about the results, distilling down the results in a way that would beunderstandable to someone who does not know statistics. Clear explanations and interpretationsare critical.All DeVry University policies are in effect, including the plagiarism policy.Project Part B report is due by the end of Week 6.Project Part B is worth 100 total points. See grading rubric below.Submission: The report from part 3 + all of the relevant work done in the hypothesis testing (includingMinitab) in 1, and the confidence intervals (Minitab) in 2 as an appendix.Format for report:Summary Report (about 1 paragraph on each of the speculations a.-d.)Appendix with all of the steps in hypothesis testing (the format of the Seven Elements of a Test ofHypothesis, in Section 6.2 of your textbook) for each speculation a.-d. as well as the confidenceintervals, and including all Minitab outputMATH533_Course_Project_Requirements_HOSPITAL-2.pdfMATH533_Course_Project__Data_HOSPITAL-2.xlsx