Normal Probability Plot Template

Goal create a normal probability plot in Excel that can be modified to deal with other distributions. 

Description a screen shot of the template with an explanation of the formulae used is shown in Fig. 8.17. The resulting normal probability plot is shown in Fig. 8.18. The steps for creating a normal probability plot can be summarised as follows  

Obtain the order of the data in Column A in Column B. You can use the rank function. 

In Column C, enter=normsinv( (ColumnBl-0.5)/count (Column 

In Colunm D, compute the Z-score for each of the data points, that is, subtract the mean and divide the resulting value by the standard deviation of the values in Column A. 

---

Description a screenshot of the plain template is shown in Fig. 8.26. The yellow blocks are where the required data are entered. Note that Solver needs to be used to obtain a solution to the problem. The configuration of Solver is shown as an inset in Fig. 8.26. The layout and formatting of the results are similar to the linear regression case. Two important differences are that the model and its Jacobian must be entered as a macro and that Solver must be used. The spreadsheet automatically creates the normal probability plot for the residuals and plots of the residuals as a function of y and y, as well as a time series plot of the residuals. Additional plots can be created by the user. An example of how to use the template is provided in Sect. 8.7.2 Nonlinear Regression Example. 

The spreadsheet automatically creates the normal probability plot for the parameters and residuals as well as plots of the residuals as a function of y and y and a time series plot of the residuals. Additional plots can be created by the user. An example of how to use the template is provided in Sect. 8.7.3 Factorial Design Examples. 

---