In: Statistics and Probability
Construct a frequency polygon for the following:
60-69   12
70-79   15
80-89 10
90-99 2
100-109 1
110-119 0
120-129 1
The frequency polygon is obtained in following steps in excel,
Step 1: Write the data values in excel.
| Class | Frequency | 
| 60-69 | 12 | 
| 70-79 | 15 | 
| 80-89 | 10 | 
| 90-99 | 2 | 
| 100-109 | 1 | 
| 110-119 | 0 | 
| 120-129 | 1 | 
Step 2: make a column mid point by taking the mid point of class interval.
| Class | Mid point | Frequency | 
| 60-69 | 64.5 | 12 | 
| 70-79 | 74.5 | 15 | 
| 80-89 | 84.5 | 10 | 
| 90-99 | 94.5 | 2 | 
| 100-109 | 104.5 | 1 | 
| 110-119 | 114.5 | 0 | 
| 120-129 | 124.5 | 1 | 
Step 3: Now Select the midpoint and frequency column then INSERT > Recommended Plots > Lines > OK. The screenshot is shown below,

The Chart is obtained. The screenshot is shown below,

The frequency polygon show a normal distribution skewed to right.