Question: I need help for Question 12 and Question 15. salary. determine if these independent variab 12. Hospital XYZ has the following data measuring patient satisfaction


I need help for Question 12 and Question 15.
salary. determine if these independent variab 12. Hospital XYZ has the following data measuring patient satisfaction levels with the patients' length of stay and their number of prior hospital Impacts on admissions the past five years. Length of Stay (Days) Number of Previous Admissions Patient Satisfaction Rating 84 5 3 5 98 2 7 72 14 2 8 75 90 4 3 6 89 4 1 80 4 four days a. Using Excel, compute the multiple regression output. b. Predict the satisfaction of a patient with a length of stay who has been admitted to the hospital twice before. c. List and explain the assumptions used in this regression. 13. Referring to question 12: a. Calculate R. FORECASTI b. Calculate multiple R. c. Calculate the adjusted RP. d. Compute the t-statistic for each independent variable. e. Compute the F-statistic for each independent variable. f. Compute the p-value for each independent variable. 14. Referring to question 9: a. Calculate MSE and explain its meaning. b. Calculate MAD and explain its meaning. c. Calculate MAPE and explain its meaning. d. Calculate MPE and explain its meaning. 15. Referring to question 12: a. Calculate MSE and explain its meaning. b. Calculate MAD and explain its meaning. c. Calculate MAPE and explain its meaning. d. Calculate MPE and explain its meaning. REFERENCES Dielman, T. E. 1996. Applied Regression Analysis for Business and Econa PacificStep by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
