Please do Part B of the course project.
Please do Part B of the course project, you should check out the PDF and EXCEL attachment for the detail instruction
In 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 patience took a knowledge test about diabetes before and after being given some educational materials. Satisfaction with their overall visit was also measured through a survey. The data appear below for your reference. The Excel spreadsheet with these data can be found in Doc Sharing and should be opened in Minitab to complete the analyses required in each part of this project.
Your manager has speculated the following:

the average (mean) level of glucose is less than 130

the 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" is
less than 75.

Using the sample data, perform the hypothesis test for each of the above situations in order to
see if there is evidence to support your manager’s belief in each case a.d. In each case use the Seven Elements of a Test of Hypothesis, in Section 6.2 of your textbook with α = .05, and explain your conclusion in simple terms. Also be sure to compute the pvalue and interpret.

Follow this up with computing 95% confidence intervals for Glucose and Diabetes Posttest, and again interpreting these intervals.

Write a report to your manager about the results, distilling down the results in a way that would be understandable to someone who does not know statistics. Clear explanations and interpretations are 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 (including Minitab) 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 of
Hypothesis, in Section 6.2 of your textbook) for each speculation a.d. as well as the confidence intervals, and including all Minitab output
Tutor Answer
Review from our student for this Answer
Brown University
1271 Tutors
California Institute of Technology
2131 Tutors
Carnegie Mellon University
982 Tutors
Columbia University
1256 Tutors
Dartmouth University
2113 Tutors
Emory University
2279 Tutors
Harvard University
599 Tutors
Massachusetts Institute of Technology
2319 Tutors
New York University
1645 Tutors
Notre Dam University
1911 Tutors
Oklahoma University
2122 Tutors
Pennsylvania State University
932 Tutors
Princeton University
1211 Tutors
Stanford University
983 Tutors
University of California
1282 Tutors
Oxford University
123 Tutors
Yale University
2325 Tutors