# Course Project Hospital Stays, Impact of Education, Health

Course Project: Hospital Stays, Impact of Education, Health DataIntroduction | 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 andCorrelation Analysis | Project Part C: Grading RubricIntroduction Back to TopIn 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.Hosp_StayHosp_SatisfactionDiab_PretestDiab_PosttestGlucose2VeryDissat34391223 SWDissat33301161SWSat29221081SWSat1714637SWDissat6960747VerySat6970848SWDissat8182678VerySat8188579SWSat 521002314SWDissat4548931SWSat3828761VerySat27331636VeryDissat45542178SWDissat58711127SWDissat68841076SWDissat 4849951VerySat9151048VerySat5051636SWDissat65511891 of 69/24/2014 6:08 AMMATH399 Course Home Course Project (NOV14) https://devry.equella.ecollege.com/file/cd2c455d-ffcf-411c-ae8d-2c5175…6SWDissat6478531VerySat2530965VerySat5045 1022VeryDissat47411422VeryDissat24181333VerySat3530881SWDissat2931874SWDissat39331614SWDissat53421045VeryDissat5749 924SWSat50501688VeryDissat64100726VeryDissat90951008SWDissat5263639SWSat52641329VerySat67771718SWSat6868163 5SWSat6760847SWSat44531027VeryDissat57511303SWSat585071The variables areHospital stay – number of days in hospitalHospital satisfaction – level of satisfaction with hospital services during stay (very highly satisfied, highlysatisfied, somewhat dissatisfied, and very dissatisfied)Diabetes Pretest – score on diabetes knowledge test (must score 95 or higher to leave)Diabetes Posttest – score on diabetes knowledge test after receiving educational material created forthis studyGlucose – blood glucose in mg/dL.The data are available in Doc Sharing Course Project Data Set as an Excel file. You are to copy and pastethe data set into a Minitab Worksheet.PROJECT PART A: Exploratory Data Analysis Back to TopOpen 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. Thesecalculations may not be possible for each variable. If you cannot calculate any or all of these for aspecific variable, please note that and state why.2 of 69/24/2014 6:08 AMMATH399 Course Home Course Project (NOV14) https://devry.equella.ecollege.com/file/cd2c455d-ffcf-411c-ae8d-2c5175…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 diabetesposttest, hospital stay and glucose, hospital satisfaction and diabetes pretest, hospital satisfaction anddiabetes posttest, hospital satisfaction and glucose, diabetes pretest and diabetes posttest, diabetespretest and glucose, and diabetes posttest and glucose ). Choose two of these pairings and find thecorrelation coefficient and show the scatter plot. Explain what you see. Some variables show clearrelationships, while others do not.Prepare your report in Microsoft Word (or some other word processing package), integrating yourgraphs and tables with text explanations and interpretations. Be sure that you have graphical andnumerical back up for your explanations and interpretations. Be selective in what you include in thereport. 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 ofinterpretation. For the two pairings you selected, identify and report your results using graphical andnumerical summary (as appropriate), with interpretations.Project Part B: Hypothesis Testing and Confidence Intervals Back to TopYour 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 outputProject Part C: Regression and Correlation Analysis Back to TopUsing Minitab perform the regression and correlation analysis for the data on diabetes posttest (Y), thedependent 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 ‘bestfit’ line. Interpret.Determine the equation of the ‘best fit’ line, which describes the relationship between diabetes posttestand diabetes pretest.Determine the coefficient of correlation. Interpret.Determine the coefficient of determination. Interpret.Test the utility of this regression model (use a two tail test with α =.05). Interpret your results, includingthe p-value.Based on your findings in 1-5, what is your opinion about using diabetes pretest to predict diabetespostest? Explain.Compute the 95% confidence interval for beta-1 (the population slope). Interpret this interval. In anattempt to improve the model, we attempt to do a multiple regression model predicting diabetes posttestbased on diabetes pretest and glucose.Using Minitab, run the multiple regression analysis using the variables diabetes pretest and glucose topredict diabetes posttest. State the equation for this multiple regression model.Perform the Global Test for Utility (F-Test). Explain your conclusion.Perform the t-test on each independent variable. Explain your conclusions and clearly state how youshould proceed. In particular, which independent variables should we keep and which should bediscarded.Is this multiple regression model better than the linear model that we generated in parts 1-7? Explain.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 andinterprets the results in ways that are understandable to someone who does not know statistics.5 of 6 9/24/2014 6:08 AMMATH399 Course Home Course Project (NOV14) https://devry.equella.ecollege.com/file/cd2c455d-ffcf-411c-ae8d-2c5175…Submission: The summary report + all of the work done in 1-11 (Minitab Output + interpretations) as anappendix.Format:A. Summary ReportB. Points 1-11 addressed with appropriate output, graphs and interpretations. Be sure to number eachpoint 1-11.Project Part C: Grading Rubric Back to TopCategoryPoints%DescriptionQuestions 1 – 9 and 11,are worth 6.5 pts. each6565addressed withappropriate output,graphs andinterpretationsQuestion 101515addressed withappropriate output,graphs andinterpretationsSummary2020writing, grammar,clarity, logic, andcohesivenessTotal100100A quality paper willmeet or exceed allof the aboverequirements.Back to Top