Question: Use Excel to develop a linear regression equation to predict number of patients staying at a hospital. Use the number of operations performed and number
Use Excel to develop a linear regression equation to predict number of patients staying at a hospital. Use the number of operations performed and number of accidents reported as your independent variables. First run a simple regression for \# of Patients and \# of Operations and create a forecast if the \# of Operations is 24 . Then run a simple regression for \# of Patients and \# of Accidents, forecasting for 50 accidents. Finally run a multiple regression for \# of Patients using both \# of Operations and \# of Accidents and give that forecast as well. Please answer the following questions: 1) What does R-Square tell you for the simple regression? What about the multiple regression? 2) What does Adjusted R-Square tell you for the simple regression? What about the multiple regression? 3) What does the coefficients for an X-variable tell you? 4) What are the coefficients for \# of Operations in the simple and multiple regression. Comment. 5) What is the forecast for \# of Patients from each regression
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
