Exercise 12.7.2 Multiple Regression

Data has been collected on a process where four predictors are thought to affect a single continuous Response variable. The data has not been collected in time order. Conduct the appropriate Regression analysis and answer the questions below.

The data in File 12 Regression.xlsx worksheet Exercise2.

- Are any of the predictors correlated?
- Are all the predictors significant?
- How much of the variation in the Response can be explained by changes in the Predictors?
- What terms are present in the model?
- Are there any unusual data points in the study and are they an issue?
- What are the top solutions to obtain a value of 200 in the Response?

- Click Stat<<Basic Stats<<Correlation.
- Enter the 4 predictors so we can check if they are correlated.
- Click OK.
- Go to the Session Window to check the results.

The P-

On the top left of the Summary Report we are told that the model is significant and that 87.46% of the changes in the response can be explained by changes in the predictor.

- Click Assistant<<Regression. Click on the Optimize Response box.
- Enter Response as the response.
- Select ‘Achieve a target value’ from the drop-
down menu and set ‘200’ as the target. - Enter Pred1 to Pred4 as the four predictor variables.
- Click OK to run the procedure and produce the 6 page report.

On the Diagnostic Report we see the Residuals vs Fitted Values plot. On this we are shown two points with large residuals and 3 points with unusual X values. We should review the data collected at these points to check for anything unusual.

From the Model Building Report we are given the Regression Equation and we can see that it has five terms. Predictor 4 was not included as it was not significant.

The Prediction and Optimisation Report shows us an optimal setting to achieve a response of 200. It was gives us 5 alternate settings.

The Report Card warns us of the large residuals and Unusual X values. It would be prudent to check any history on those 5 data points that have been highlighted.