 You don't need to be an 'investor' to invest in Singletrack: 6 days left: 95% of target - Find out more
OK stats folks, can i get a data set in excel to shwo the distribution curve?
Just got a list of numbers in column A can it show the curve or is there some fancy manipulation needed?
The distribution curve of what?
you want the actual distribution? in which case you will need to create a histogram, using count().
If you are assuming a certain distribution e.g. normal, then you need to calculate your Standard Deviation and mean, and then use e.g. normdist() for a spread of numbers
Which do you need?
The frequency command is your friend if you want a histogram.
I'll have a look see if there's an example to hand.
Edited for example:
=Frequency(value range,histogram bin range) then use ctrl,shift,return to make it an array command.
You can put as many bins in the histogram as you want, the frequency command will return all values less than the bin value (and above the previous bin obviously).
Hope this helps
Matt