*47*

AnÂ **ogiveÂ **is a graph that shows how many data values lie above or below a certain value in a dataset. This tutorial explains how to create an ogive in Excel.

**Example: How to Create an Ogive in Excel**

Perform the following steps to create an ogive for a dataset in Excel.

**Step 1: Enter the data.**

Enter the data values in a single column:

**Step 2: Define the class limits.**

Next, define the class limits youâ€™d like to use for the ogive. Iâ€™ll choose class widths of 10:

**Step 3: Find class frequencies.**

Next, weâ€™ll use the following formula to calculate the frequencies for the first class:

Copy this formula to the rest of the classes:

**Step 4: Find cumulative frequencies.**

Next, weâ€™ll use the following formulas to calculate the cumulative frequency for each class:

**Step 5: Create the ogive graph.**

To create the ogive graph, hold down CTRL and highlight columns D and F.

Along the top ribbon in Excel, go to theÂ **InsertÂ **tab, then the **ChartsÂ **group. Click **Scatter Chart**, then clickÂ **Scatter with Straight Lines and Markers**.

This will automatically produce the following ogive graph:

Feel free to modify the axes and the title to make the graph more aesthetically pleasing: