This procedure performs regression with a single predictor, in linear, second-order or third-order polynomial terms. The residuals and fitted values of the response are shown in Columns AC:AD.
At the Excel Menu (For Excel 2007, go to Add-ins first)
Choose ProcessMA > Statistics > Regression > Regression (Single Predictor)
In Response, select the column containing the response data (Numeric)
In Predictor, select the column containing the predictor data (Numeric)
In Model, choose the order of the regression equation
Check Plot Residual, if you want to display residual plots
Check Plot Fitted Line, if you want to display the fitted line plot
Check Show Confidence Bands, if you want to plot confidence bands in the fitted line plot
Check Show Prediction Bands, if you want to plot prediction bands in the fitted line plot
In Confidence Level, enter the desired confidence level (Numeric, >0 & <1)
You want to model the relationship between the size of the valve and the speed of the machine using a quadratic model. You collected data on various settings of the valve size and the resultant speed of the machine.
Open data worksheet by choosing ProcessMA > Tools > Data
Choose ProcessMA > Statistics > Regression > Regression (Single Predictor)
In Response, select O - Speed
In Predictor, select P - Valve
In Model, choose Quadratic
Check Plot Residual
Check Plot Fitted Line
Check Show Confidence Bands
Check Show Prediction Bands
Click OK
The p value for the model suggests a good fit to the data. The R2 value indicates that about 94% of the variation in speed is explained by the variation in the valve size. The 95%CL lines are the confidence limits for the machine speed and the 95% PL lines are the prediction limits for new observations.
Copyright © ProcessMA