MR P -

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

71 77 68 ...

...

Can you help me do this and the proper way to solve this? I see one

response

that sorting the data from lease to greatest value will make an ogive

curve.

Is there a mathematical way of doing this? Hoping for your immediate

response.

What do you mean by "a mathematical way of doing this"?

You asked the original question in an Excel newsgroup, and I provided

step-by-step instructions for creating an ogive curve using Excel. Please

provide more details about what you want.

- Mike

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

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
++++++++++++++++++++++++++