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):
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.