Make a bell curve chart

J

jackeen

i have a spreadsheet with results of a 5k race, 950 finishers.
i am trying to make a bell curve chart that shows the rate at which
finishers come in;
i changed the time to a decimal by using the formula "=(C2-INT(C2))*24"
that helped, and i now have a valid line chart
i trying to show that the majority of finishers are between 8 - 11 minutes,
some before and lots after.
any ideas on this?
 
M

Mike Middleton

jackeen -

I suggest that you consider using a histogram, i.e., a column chart of a
frequency distribution. (The histogram may or may not have a bell shape,
depending on your data.) Here are three approaches:

(a) Excel's Analysis ToolPak has a Histogram tool.
(b) My free Better Histogram add-in is available at www.treeplan.com.
(c) Excel's array-entered FREQUENCY function can create a frequency
distribution from which you can construct a Column chart type.

- Mike
http://www.MikeMiddleton.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a bell curve chart 1
How to chart a bell curve with x, mean, standard deviation, cumula 1
Bell Curve Graph 2
How do I make a normal bell shaped curve in ms 2007? 3
Bell Curve Chart 2
Bell curve from Excel data... 0
what's the best way to depict a bell curve? 2
Standard deviation and bell curve 0

Top