Statistical Analysis-Distribution Curve

  • Thread starter Thread starter sunjoy
  • Start date Start date
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
 
Hmmm... when I use the Histogram tool, I set up a range containing the bin
boundaries. Aren't you doing that?
 
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.
 
You must log in or register to reply here.

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

Statistical Analysis-Distribution Curve 1
Histogram, And "Normal" Curve For ? 1
statistical analysis / trend repetition 1
histogram is counting input data wrong 2
Histogram Question 2
Excel Macro Filtered Visible Cells 1
Acoustics - 80Hz loss in car! 0
histograms - frequency and relative frequency? 2

Back
Top