Please do Part B of the course project 2

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:

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

  2. the true population proportion of number somewhat satisfied with their hospital stay is greater than 28%,

  3. the average (mean) score on the diabetes pretest is greater than 52.

  4. the average (mean) score on the diabetes posttest ONLY among those that are “somewhat satisfied” is

    less than 75.

    1. 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.

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

    3. 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:

  1. Summary Report (about 1 paragraph on each of the speculations a.-d.)

  2. 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