Creating Ogive Curve

[A P]

I have a set of data and wanting to create an Ogive Curve

71 77 68 64 55 50 45 40 35
31 33 36 40 45 50 55 63 70
72 74 66 63 61 60 56 50 46
41 38 34 39 41 46 50 56 57
51 48 42 46 51 58 59 52 47
43 44 47 53 48 48 49 50 42


Can you help me do this?

Me

 

[Mike Middleton]

A P Me -

An ogive curve is a chart of a cumulative frequency distribution or
cumulative relative frequency distribution.

In Excel, arrange the data in a single column. Sort the data (select the
column and click the AZ-with-the-down-arrow icon or use the Data | Sort
command). In an adjacent column on the right, enter the ranks (1 through 54
for your data, which can be entered by typing the 1 and the 2, selecting
both cells, and double-clicking the fill button in the lower right corner of
the selection or dragging the fill button down). Select the cells containing
the data and the ranks (e.g., the range A1:B54 if that's where the data and
ranks are). Click the Chart Wizard icon (which looks like a vertical bar
column chart), choose the XY (Scatter) chart type, and choose the "Scatter
with data points connected by lines" chart sub-type.

- Mike
www.mikemiddleton.com

++++++++++++++++++++++++++