Ogive graph maker

An ogive is a statistical graph that presents the cumulative frequency distribution of a dataset. It displays the cumulative frequencies below specific data points as a curved line.

How to make an ogive in google sheets

Ogives are utilized to summarize data concisely, calculate percentiles and quartiles, and facilitate comparisons between datasets. By visually representing the spread, concentration, and central tendency of the data. Ogives aid in analyzing and comprehending the dataset more effectively. 

In this tutorial, we will use a dataset containing student weights and frequencies to create an ogive in Excel.

Follow the steps below to learn how to generate an ogive graph using the given data, which will help visualize the cumulative frequency distribution. 

Method 1 – Cumulative Frequency Line Chart 

Step 1 – Create columns 

• Create two separate columns for cumulative frequency and class limits. 

Step 2 – Fill the data in the class limits column  

• Fill the class limits cell by entering the values starting from 25 till  45, m
  how to create an ogive graph in excel
  how to make ogive curve in excel