You are working at a water bottling company that bottles natural spring water. The spring wat Spring Quality Sulphates PH SpringCoded PH*SpringCoded springs. You are tasked by your manager to determine what factors are related to water quality RedRiverSpring 0.8 3.05 water quality measurement samples. The data collection results are provided to your left. RedRiverSpring 0.76 3.08 RedRiverSpring 0.86 3.1 RedRiverSpring 0.7 3.27 Develop several multiple regression models and decide which one best predicts water quality. RedRiverSpring 0.85 3.35 options: RedRiverSpring 1,09 3.36 Model 1: all independent variables (sulphates, ph, springcoded) included without interaction RedRiverSpring 0.9 34 Model 2: all independent variables included with interaction term RedRiverSpring 3.45 Final Model: only include independent variables that significantly contribute to the model at a RedRiverSpring 0.83 3.46 > provide the analyses outputs in the povided sheets or rename your created sheets according RedRiverSpring 0.9 3.51 Points possible: 40 RedRiverSpring 0.85 3.56 RedRiverSpring 0.71 3.57 RedRiverSpring 0.99 3.76 RedRiverSpring 1,06 40 For your final model, provide the following information on this sheet: RedRiverSpring 1.07 RedRiverSpring 0.98 4.1 ) Create a residuals versus predicted y plot and analyze all plots. Provide a statement whether th (including why) to achieve valid results from the regression model. RedRiverSpring 0.85 RedRiverSpring 0 98 A. 2 Predicted Y Residual PLOT: RedRiverSpring WWN-NNI 0.9 4.39 RedRiverSpring 0.98 1 39 RedRiverSpring 0.73 4.6 ooooooooo. RedRiverSpring RedRiverSpring 1.03 4 72 RedRiverSpring 0.88 4 74 RedRiverSpring 0.96 4.7 RedRiverSpring 0.9 4 7 RedRiverSpring 0.9 49 RedRiverSpring 0.87 4 9 RedRiverSpring 1,08 4 9 RedRiverSpring W W N 171 5.0 RedRiverSpring 0.9 507 RedRiverSpring 0.92 RedRiverSpring 0.73 5.2 Answer: NWNW RedRiverSpring 5.29 RedRiverSpring 0.83 5.29 RedRiverSpring 5.32 b) State the multiple regression equation using the names of your variables instead of x1, etc. (2 decimals 1.07 RedRiverSpring 0.95 5.37 RedRiverSpring 0.75 5.53 RedRiverSpring L.07 5.61 RedRiverSpring 0.98 5.64 c) Provide the test statistic with its p-value that indicates the significance of the overall multiple regressic RedRiverSpring 0.97 5.65 RedRiverSpring 0.98 5.69 RedRiverSpring 0.77 5 84 RedRiverSpring 0.86 5 86 d) Provide the value of the coefficient of multiple determination (2 decimals) and explain its meaning. RedRiverSpring 59 RedRiverSpring 0,96 5.96 RedRiverSpring 0.76 5.9 RedRiverSpring 1.02 6.13 RedRiverSpring 1,09 6.3 RedRiverSpring 1,09 6.32 RedRiverSpring 6.49 RedRiverSpring WW NW w ww Nu 0.73 6.51 RedRiverSpring 1,05 6.58 RedRiverSpring 1,02 6.65 RedRiverSpring 1.1 6.7 RedRiverSpring 0.7 6.74 RedRiverSpring 0.71 6.83 RedRiverSpring 0.87 6.99 RedRiverSpring 1.09 RedRiverSpring WhiteRiverSpring 0.49 7.29 WhiteRiverSpring 0.28 7.3 WhiteRiverSpring 0.59 7.33 WhiteRiverSpring 0.52 7.42 WhiteRiverSpring 0.42 7.5 WhiteRiverSpring 0.54 7.5 WhiteRiverSpring 0.05 7.53 WhiteRiverSpring 0.15 7.54 WhiteRiverSpring 0.24 7.58 WhiteRiverSpring 0.03 7.65 WhiteRiverSpring 0.62 7.79 WhiteRiverSpring 0.58 7.88 WhiteRiverSpring 0.4 7.91 WhiteRiverSpring 0.27 7.9 WhiteRiverSpring 0.07 7.97 WhiteRiverSpring 0.12 8.27 WhiteRiverSpring 0.25 WhiteRiverSpring 0.24 WhiteRiverSpring 0.23 8.51 WhiteRiverSpring 02 8.9 WhiteRiverSpring 0.54 9.21 WhiteRiverSpring 03 0 23 WhiteRiverSpring 0.37 9.36 WhiteRiverSpring 9 39 WhiteRiverSpring 0,32 942 WhiteRiverSpring 0.33 9.85 WhiteRiverSpring 0.57 10.01 WhiteRiverSpring 0.47 0.14 WhiteRiverSpring 0.17 10.15 WhiteRiverSpring 0.49 10.17 WhiteRiverSpring 0.29 10.32 WhiteRiverSpring 0.26 10.35 WhiteRiverSpring 0.15 10.38 WhiteRiverSpring 0.52 10.52 WhiteRiverSpring 0.14 10.7 WhiteRiverSpring 0.12 10.93 WhiteRiverSpring 1109 WhiteRiverSpring 0.08 11.11 WhiteRiverSpring 0.17 11.2 WhiteRiverSpring 0.6 1.38 WhiteRiverSpring 0.38 11.43 WhiteRiverSpring 0.43 11.61 WhiteRiverSpring 0.15 11.68 WhiteRiverSpring 0.33 11.77 WhiteRiverSpring 0.5 11.79 WhiteRiverSpring 0.30 11.82 WhiteRiverSpring 0.4 11.83 WhiteRiverSpring 0.22 11.88 aviaaaa WhiteRiverSpring 0.12 11.89 WhiteRiverSpring 0.51 11.92 WhiteRiverSpring 0.36 12 WhiteRiverSpring 0.12 12.0 WhiteRiverSpring 0.05 12.17 WhiteRiverSpring 0.2 12.25 WhiteRiverSpring 12.35 a ac 0.63 WhiteRiverSpring 0.26 12.41 WhiteRiverSpring 0.18 12.47 WhiteRiverSpring 0.51 12.79 WhiteRiverSpring 0,38 12.96 WhiteRiverSpring 0.01 12.99