Sunday, October 23, 2011

How Do I Create a Polygon Frequency Graph Using Excel?


1. Highlight the frequency data in the worksheet. For example, if your data is in cells A2 to A10, highlight these cells by left-clicking in A2 and dragging the cursor down over the cells.
2. Click on the 'Chart Wizard' and choose 'Line > Line With Markers.' Click 'Next.'
3. Click on the 'Series' tab.
4. Click on 'Category (X) axis labels' and then click the red mark.
5. Highlight the cells containing your midpoints. For example, if your midpoints are in cells B2 to B10, highlight cells B2 to B10.
6. Click the red marker again to return to the Chart Wizard, and then click Next. This will create the polygon frequency graph.

Blogger news