Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
My apologies if this is more an "academic" question than an Excel question...
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? My end result is using the distribution for a Monte Carlo simulation (which I have all set up in a worksheet). Thank 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 |