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.