ExampleofModelDiagnostics.docVIP

Example of Model Diagnostics Calculator Maintenance Data Using EXCEL First, we begin with the original data. I have sorted it with respect to the predictor variable (X = number of machines serviced). Note that in this case we wish to preserve the pairs (Xi,Yi). To do this: Move the cursor into the field of data Click on Data on the main toolbar, then Sort Select Column 2 (X) and Ascending. If you have already placed headers on the columns, make sure you click on the correct option regarding headers. Y (minutes) X (Machines) 10 1 17 1 33 2 25 2 39 3 62 4 53 4 49 4 78 5 75 5