**Launch Excel.****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.

- In cell A1, type "
**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:*- In cell B1, type "
**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). - 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* - 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` - Click
**"Next."** - Fill out the resulting dialog box as follows:
Input Type Label Value **As object in:***selected***As object in:**`Sheet1` - Click
**"Finish."**

*Excel plots Standard Normal Quantile vs. Weight and inserts the chart into Sheet1.***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.- Select