Creating a Normal Plot in Microsoft® Excel

Chapter 5, Example 13


  1. Launch Excel.

  2. Enter the data.

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

    Screenshot: screenshot

  4. Plot Weight vs. Standard Normal Quantile.

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

    Screenshot: 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.