Question
MATH399 Course Home Course Project (NOV14) Project Part C: Regression and Correlation Analysis Back to Top Using Minitab perform the regression and correlation analysis for
Project Part C: Regression and Correlation Analysis Back to Top 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.
- 1.Generateascatterplotfordiabetesposttest(Y)vs.diabetespretest(X)includingthegraphofthe"bestfit"line.Interpret.
- 2. Determine the equation of the "best fit" line, which describes the relationship between diabetes posttest and diabetes pretest.
- 3.Determine the coefficient of correlation. Interpret.
- 4.Determine the coefficient of determination. Interpret.
- 5.Test the utility of this regression model (use a two tail test with =.05). Interpret your results, including the p-value.
- 6. Based on your findings in 1-5, what is your opinion about using diabetes pretest to predict diabetes postest? Explain.
- 7. 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.
- 8.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.
- 9. 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 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.
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.
MATH399 Course Home Course Project (NOV14)
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 | 18 |
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 |
** Answer In MS Word DOC please
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started