Home |
Search |
Today's Posts |
#9
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
CHANGING THE DISTRIBUTIONS OF THE INFORMATION | Excel Worksheet Functions | |||
Excel should be able to plot better probability graphs | Charts and Charting in Excel | |||
frequency distributions | Excel Discussion (Misc queries) | |||
Using RAND() with Different Distributions!? | Excel Worksheet Functions | |||
How do I graph normal probability distributions in excel? | Excel Worksheet Functions |