- In cell A1, type "Weight"
- In cells A2-101, enter the weight data from Table 5.6 (p. 265). Note: for values occurring more than once (as indicated in the Frequency column of the table), you will have to enter the value once for each separate occurrence.
- In cell B1, type "Standard Normal Quantile"
- In cell B2, type '=NORMINV((CELL("row",B2)-1.5)/100,0,1)'
(Explanation: NORMINV is a function in Excel that "returns the inverse of the normal cumulative distribution for the specified mean and standard deviation." The CELL function is used to insert the row number of the current cell. 100 is the total number of data points.)
- Select columns B2-B101.
- Select "Edit --> Fill --> Down."
- Select "Insert --> Chart."
- In the dialog box that follows, select "XY (Scatter)" from the list labeled "Chart Type. Under "Chart sub-type," select the first option (no lines).
Screenshot:
- Click "Next."
- Fill out the "Data Range" panel of the resulting dialog box as follows:
Input Type Label Value 
Data Range: =Sheet1!$A$2:$B$101 
Columns selected Screenshot:
- Click "Next."
- Fill out the "Titles" pane of the resulting dialog box as follows:
Input Type Label Value Chart title: Normal Quantile Plot of Weight Value (X) axis: Weight Value (Y) axis: Standard Normal Quantile Screenshot:
- Click "Next."
- Fill out the resulting dialog box as follows:
Input Type Label Value As object in: selected 
As object in: Sheet1 Screenshot:
- Click "Finish."
Screenshot:
Note: you can resize the chart that contains the plot by clicking a blank area in the chart to select it and dragging one of the handles that appears on the chart's border. You can further modify the chart by double-clicking various chart elements.