Statistical Analysis-Distribution Curve

S

sunjoy

HELP PLEASE!! I know that this program should be able to do this; excep
I can't figure it out.
I have a set of data that I would like to know the frequency of value
as well as see a distribution curve. Therefore, seperating the dat
into say 4 ranges of values based on the frequency.

I have tried some of the add-in features, but I when I used th
histogram function but the bin ranges it denotes are way off base.
guess I want Excel to tell me what the bin ranges would be.

If anyone can offer some help....that would be great!!

Thanks

JO
 
M

Myrna Larson

Hmmm... when I use the Histogram tool, I set up a range containing the bin
boundaries. Aren't you doing that?
 
M

Myrna Larson

PS: You can leave the the Bin range blank, and when you do, Excel will create
the bins. If you don't like them, you have to set up your own.
 
Top