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 p-value 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
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