Question

how to prepare
a histogram and frequency polygon from the given data in ms excel software

Answer 1

Step-by-step explanation:

To create the frequency polygon:

Right-click on the chart, then click on Select Data.

Click on Add.

For the Series Values, select the same range that you selected for histogram.

Click OK, then click OK again. ...

Right-click a bar of the second histogram, then click on Change Series Chart Type.

Click on XY (Scatter), then click on the subtype you want, probably "with Lines and Markers".

Click OK. Excel automagically connects the midpoints of the first histogram bars.

To change the size of the markers, if any, right-click the frequency polygon (curve), then click on Marker Options.

Select Built-In, and make the desired adjustments. Then click Close.