Excel probability distributions
On Sep 27, 11:34 am, rcc wrote:
I'm looking to create a probability distribution in Excel. My probability
distribution is similar to a normal distribution, but it's scewed. My data
ranges (for example) from 200 to 800 and has a mean of 400. If my mean
were 500, then this would look like a normal curve with 2*stdev of approx
150. But since the mean is 400, the curve is scewed to the left a bit.
Does anyone have an idea as to what kind of probability distribution I
would use for this?
Have you looked at the beta distribution?
I had a similar problem some time ago. I tried to make the beta
distribution work for me. I don't believe I succeeded. But it might
make more sense to you.
|