How to Create an Ogive Graph in Excel

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:

Defining class limits for ogive graph in Excel

Step 3: Find class frequencies.

Next, we’ll use the following formula to calculate the frequencies for the first class:

Calculating class frequency in Excel

Copy this formula to the rest of the classes:

Class frequency calculation in Excel

Step 4: Find cumulative frequencies.

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

Cumulative frequency calculation in Excel

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:

Ogive graph in Excel

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

Ogive chart in Excel

Featured Posts

3 Replies to “How to Create an Ogive Graph in Excel”

  1. Do you happen to know how to do this in Numbers on a Macbook? I get as far as making the graph but when you say to choose “Scatter with Lines,” this isn’t an option in Numbers.

Leave a Reply

Your email address will not be published. Required fields are marked *