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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!