# Creating a Normal Plot in Microsoft® Excel

## Chapter 5, Example 13

1. Launch Excel.

2. Enter the data.

• 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.

3. Generate the values to be plotted against the data.

• 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."

Screenshot:

4. Plot Weight vs. Standard Normal Quantile.

• 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."

Excel plots Standard Normal Quantile vs. Weight and inserts the chart into Sheet1.

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.