Statistics - course project part A - economics or statistic majors only!!!

Course Project: Hospital Stays, Impact of Education, Health Data

Introduction | PROJECT PART A: Exploratory Data Analysis | Project Part A: Grading Rubric | Project Part B:

Hypothesis Testing and Confidence Intervals | Project Part B: Grading Rubric | Project Part C: Regression and

Correlation Analysis | Project Part C: Grading Rubric

Print

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.

Hosp_Stay Hosp_Satisfaction Diab_Pretest Diab_Posttest Glucose

2 VeryDissat 34 39 122

3 SWDissat 33 30 116

1 SWSat 29 22 108

1 SWSat 17 14 63

7 SWDissat 69 60 74

7 VerySat 69 70 84

8 SWDissat 81 82 67

8 VerySat 81 88 57

9 SWSat 52 100 231

4 SWDissat 45 48 93

1 SWSat 38 28 76

1 VerySat 27 33 163

6 VeryDissat 45 54 217

8 SWDissat 58 71 112

7 SWDissat 68 84 107

6 SWDissat 48 49 95

1 VerySat 9 15 104

8 VerySat 50 51 63

6 SWDissat 65 51 189

Introduction Back to Top

MATH399 Course Home Course Project (NOV14) https://devry.equella.ecollege.com/file/cd2c455d-ffcf-411c-ae8d-2c5175...

1 of 6 9/24/2014 6:08 AM

6 SWDissat 64 78 53

1 VerySat 25 30 96

5 VerySat 50 45 102

2 VeryDissat 47 41 142

2 VeryDissat 24 18 133

3 VerySat 35 30 88

1 SWDissat 29 31 87

4 SWDissat 39 33 161

4 SWDissat 53 42 104

5 VeryDissat 57 49 92

4 SWSat 50 50 168

8 VeryDissat 64 100 72

6 VeryDissat 90 95 100

8 SWDissat 52 63 63

9 SWSat 52 64 132

9 VerySat 67 77 171

8 SWSat 68 68 163

5 SWSat 67 60 84

7 SWSat 44 53 102

7 VeryDissat 57 51 130

3 SWSat 58 50 71

The variables are

Hospital stay – number of days in hospital1.

Hospital satisfaction – level of satisfaction with hospital services during stay (very highly satisfied, highly

satisfied, somewhat dissatisfied, and very dissatisfied)

2.

Diabetes Pretest – score on diabetes knowledge test (must score 95 or higher to leave)3.

Diabetes Posttest – score on diabetes knowledge test after receiving educational material created for

this study

4.

Glucose – blood glucose in mg/dL.5.

The data are available in Doc Sharing Course Project Data Set as an Excel file. You are to copy and paste

the data set into a Minitab Worksheet.

Open the file MATH533_Course_Project_Data_HOSPITAL.xlsx from Doc Sharing. Summarize the data for each of the five variables. For each variable, find the mean, median, variance,

and standard deviation. Use Minitab as appropriate, and explain what the results mean. These

calculations may not be possible for each variable. If you cannot calculate any or all of these for a

specific variable, please note that and state why.

PROJECT PART A: Exploratory Data Analysis Back to Top

MATH399 Course Home Course Project (NOV14) https://devry.equella.ecollege.com/file/cd2c455d-ffcf-411c-ae8d-2c5175...

2 of 6 9/24/2014 6:08 AM

Analyze the connections or relationships between two variables. There are ten pairings possible here

(Hospital stay and hospital satisfaction, hospital stay and diabetes pretest, hospital stay and diabetes

posttest, hospital stay and glucose, hospital satisfaction and diabetes pretest, hospital satisfaction and

diabetes posttest, hospital satisfaction and glucose, diabetes pretest and diabetes posttest, diabetes

pretest and glucose, and diabetes posttest and glucose ). Choose two of these pairings and find the

correlation coefficient and show the scatter plot. Explain what you see. Some variables show clear

relationships, while others do not.

Prepare your report in Microsoft Word (or some other word processing package), integrating your

graphs and tables with text explanations and interpretations. Be sure that you have graphical and

numerical back up for your explanations and interpretations. Be selective in what you include in the

report. You should not generate a 20 page report on every variable and every possible relationship.

Rather what you should do is to highlight what you see for the individual and two or three sentences of

interpretation. For the two pairings you selected, identify and report your results using graphical and

numerical summary (as appropriate), with interpretations.

All DeVry University policies are in effect, including the plagiarism policy.

Project Part A report is due by the end of Week 2.

Project Part A is worth 100 total points. See grading rubric below.

Submission: The report from part 4 including all relevant graphs and numerical analysis along with

interpretations.

Format for report:

Brief IntroductionA.

Discuss your 1st individual variableB.

Discuss your 2nd individual variableC.

Discuss your 3rd individual variableD.

Discuss your 4th individual variableE.

Discuss your 5th individual variableF.

Discuss your 1st pairing of variablesG.

Discuss your 2nd pairing of variablesH.

ConclusionI.

Category Points % Description

Five Individual Variables

- 12pts. each 60 60

graphical analysis, numerical analysis (when

appropriate) and interpretation

Two Relationships - 15

pts. each 30 30

graphical analysis, numerical analysis (when

appropriate) and interpretation

Communication Skills 10 10 writing, grammar, clarity, logic, cohesiveness,

adherence to the above format

Project Part A: Grading Rubric Back to Top

MATH399 Course Home Course Project (NOV14) https://devry.equella.ecollege.com/file/cd2c455d-ffcf-411c-ae8d-2c5175...

3 of 6 9/24/2014 6:08 AM

Category Points % Description

Total 100 100 A quality paper will meet or exceed all of the

above requirements.

Your manager has speculated the following:

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

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

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

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.

1.

Follow this up with computing 95% confidence intervals for Glucose and Diabetes Posttest, and

again interpreting these intervals.

2.

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.

3.

d.

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.)A.

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

B.

Project Part B: Hypothesis Testing and Confidence Intervals Back to Top

Category Points % Description

Project Part B: Grading Rubric Back to Top

MATH399 Course Home Course Project (NOV14) https://devry.equella.ecollege.com/file/cd2c455d-ffcf-411c-ae8d-2c5175...

4 of 6 9/24/2014 6:08 AM

Category Points % Description

Addressing each

speculation - 20 pts.

each

80 80 hypothesis test, interpretation, confidence

interval (where applicable) and interpretation

Summary report 20 20 1 paragraph on each of the speculations

Total 100 100 A quality paper will meet or exceed all of the

above requirements.

Using Minitab perform the regression and correlation analysis for the data on diabetes posttest (Y), the

dependent variable, and diabetes pretest (X), the independent variable, by answering the following.

Generate a scatterplot for diabetes posttest (Y) vs. diabetes pretest (X) including the graph of the "best

fit" line. Interpret.

1.

Determine the equation of the "best fit" line, which describes the relationship between diabetes posttest

and diabetes pretest.

2.

Determine the coefficient of correlation. Interpret.3.

Determine the coefficient of determination. Interpret.4.

Test the utility of this regression model (use a two tail test with α =.05). Interpret your results, including

the p-value.

5.

Based on your findings in 1-5, what is your opinion about using diabetes pretest to predict diabetes

postest? Explain.

6.

Compute the 95% confidence interval for beta-1 (the population slope). Interpret this interval. In an

attempt to improve the model, we attempt to do a multiple regression model predicting diabetes posttest

based on diabetes pretest and glucose.

7.

Using Minitab, run the multiple regression analysis using the variables diabetes pretest and glucose to

predict diabetes posttest. State the equation for this multiple regression model.

8.

Perform the Global Test for Utility (F-Test). Explain your conclusion.9.

Perform the t-test on each independent variable. Explain your conclusions and clearly state how you

should proceed. In particular, which independent variables should we keep and which should be

discarded.

10.

Is this multiple regression model better than the linear model that we generated in parts 1-7? Explain.11.

All DeVry University policies are in effect, including the plagiarism policy.

Project Part C report is due by the end of Week 7.

Project Part C is worth 100 total points. See grading rubric below.

Summarize your results from 1-11 in a report that is three pages or less in length and explains and

interprets the results in ways that are understandable to someone who does not know statistics.

Project Part C: Regression and Correlation Analysis Back to Top

MATH399 Course Home Course Project (NOV14) https://devry.equella.ecollege.com/file/cd2c455d-ffcf-411c-ae8d-2c5175...

5 of 6 9/24/2014 6:08 AM

Submission: The summary report + all of the work done in 1-11 (Minitab Output + interpretations) as an

appendix.

Format:

Summary ReportA.

Points 1-11 addressed with appropriate output, graphs and interpretations. Be sure to number each

point 1-11.

B.

Category Points % Description

Questions 1 - 9 and 11,

are worth 6.5 pts. each 65 65

addressed with

appropriate output,

graphs and

interpretations

Question 10 15 15

addressed with

appropriate output,

graphs and

interpretations

Summary 20 20

writing, grammar,

clarity, logic, and

cohesiveness

Total 100 100

A quality paper will

meet or exceed all

of the above

requirements.

Project Part C: Grading Rubric Back to Top

Back to Top

MATH399 Course Home Course Project (NOV14) https://devry.equella.ecollege.com/file/cd2c455d-ffcf-411c-ae8d-2c5175...

6 of 6 9/24/2014 6:08 AM