GRAPH

[friend.05]

I have lots of data (around 10000). I want to draw graph to analyze
these data. I want to see the distribution.

Example data:
0.0158880
0.0168880
1.0158880
0.2158880



What type of graph should I draw and how ?

 

[Bernie Deitrick]

friend,

You could use the FREQUENCY function to count and then plot the data. Take a look in Help.

HTH,
Bernie
MS Excel MVP

 

[Mike Middleton]

friend.05 -

"Manual" method uses array-entered FREQUENCY worksheet function and a Column
chart type.

Automated method uses the Histogram tool of the Analysis ToolPak add-in
(provided on the Install disk).

Or, try the free Better Histogram add-in, available from the Histogram page
at http://www.treeplan.com.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel