How To Make An Ogive

Ogive graph, the name might scare yous, but believe me this is very simple to create. The ogive graph is a cumulative frequency graph. The graph is plotted between the fixed intervals vs the frequency added upwards before. It is a bend plotted for cumulative frequency distribution on a graph. There are two types of ogive graph available:

1. Less than ogive graph: Given class intervals, x as the lower limit and y as the upper limit for a detail interval. Then for each of these intervals, it is read every bit frequency obtained less than y i.e. the upper limit. The slope of the graph will always be increasing positively. For example, i of the very common less than ogive graphs looks like this shown below.

Less-than-ogive-graph

2. More than ogive graph: Given class intervals, ten as the lower limit and y every bit the upper limit for a particular interval. Then for each of these intervals, information technology is read as frequency obtained more than than x i.e. the lower limit. The gradient of the graph will always be decreasing negatively. For instance, one of the very mutual more than ogive graphs looks like this shown beneath.

More-than-ogive-graph

Creating an Ogive Graph in Excel

In that location is no direct fashion to create an ogive graph in excel, but with the use of some functions and basic graphs. You can catechumen whatever given data gear up to an ogive graph.

Creating Less than Ogive Graph

Given the data ready, of range of marks with stock-still class intervals and frequency of students. Describe a less than Ogive graph.

Note: We take the Upper limit of grade intervals while creating a less than ogive graph.

Example-of-ogive-graph

Following are the steps to create Less than Ogive Graph:

Pace 1: Add a new attribute, named Upper Limit. In the cell values D3:D7, insert the upper limit of each Marks Range. For example, in cell B3, the range of marks is ten-twenty, so the upper limit will be 20. Similarly, fill the entire column.

Add-a-new-attribute

Step 2: Add together a new column, named Cumulative Frequency. In Prison cell E3, fill the value of the first frequency i.e. the cell value of C3.

Add-a-new-column

Footstep 3: At present, y'all need to present a formula to fill up E4:E7. Cell value E4 is the sum of C4 + E3. The formula is the sum of the current frequency plus the frequency added previously. For case, E5 will take the formula C5 + E4.

Add-the-current-frequency-with-the-previous-summed-frequency

Step 4: Now, re-create the formula for the rest of the cells E5:E7. Hover, on the lower right corner of the active cell E4. A plus symbol appears. Double click on it and the entire column will be filled.

Copy-the-same-formula-in-the-remaining-cells

Footstep 5: The table will wait similar this now.

Table-will-look-like-this-now

Step 6: Now, the only work left is to create the table. Select range D3:E7.

Select-range-D3:E7

Step vii: Go to the Insert tab, and in the charts section, select Scatter with direct lines and marker.

Select-Scatter-with-straight-lines-and-marker

Step eight: A less than ogive graph is created.

Less-than-ogive-graph-is-created

Creating More than Ogive graph

Given the data set, of range of marks with stock-still form intervals and frequency of students. Depict a more than Ogive graph.

Note: Nosotros have Lower limit of grade intervals while creating a more than ogive graph.

Example-of-More-than-Ogive-graph

Following are the steps to create More than than Ogive graph:

Pace one: Add a new attribute, named LowerLimit. In the cell values D3:D7, insert the lower limit of each Marks Range. For example, in jail cell B3, the range of marks is ten-20, so the lower limit will be 10. Similarly, fill the entire column.

Add-a-new-attribute

Step 2: Add a new column, named Cumulative Frequency. This pace is the opposite of the less than ogive graph. As the graph type is more than ogive graph, we will start filling the cumulative frequency from the last row. In Cell E7, fill the value of the last frequency i.east. the cell value of C7. Now, y'all need to present a formula to make full E3:E6. Cell value E6 is the sum of C6 + E7. The formula is the sum of the current frequency plus the frequency added previously. For example, E5 will have the formula C5 + E6.

Sum-of-the-current-frequency-with-the-previous-sum-frequency

Footstep 3: Copy the same formula to the residue of the upper cells. In the active cell, E6. Become to the lower right corner of that active cell. A plus symbol appears. Go on clicking it and drag it till E3.

Copy-the-same-formula-for-upper-cells

Step 4: The table looks like this now.

Table-looks-like-this-now

Step 5: Now, the just work left is to create the table. Select range D3:E7. Go to the Insert tab, and in the charts section, select Besprinkle with straight lines and marker.

Select-Scatter-with-straight-lines-and-marker