A regional health authority is investigating the monthly man-hours that are used for patient care in the hospitals in their region. They are particularly interested in the factors that might influence man-hours. The following data has been collected from 17 hospitals on the monthly man-hours and five possible influencing factors (data available on the online platform in either file CSE23.xlsx or CSE24.sav):
![](https://test.transtutors.com/qimg/140cc05c-2c05-4142-bf13-9d401bf27bab.png)
![](https://test.transtutors.com/qimg/5c9e2a29-84ac-4c70-a61c-f42ee64e8637.png)
a. Plot the scatter diagrams and find the correlation coefficients between the six variables. Which of the five independent variables are likely to explain the variation in man-hours?
b. Starting with all the independent variables, develop a regression model to estimate manhours. You should carry out suitable statistical analysis in this development.
c. Having arrived at a suitable model perform a residual analysis.