Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Probability of random numbers
i am currently working with a some rainfall data and am trying to give a
somewhat probable forecast. i have data for the past 100 years, which gives me my Average Annual rainfall, and based off of that i can get my standard Deviation/bell curve. What i want to do is be able to generate random numbers based off of its probability of happening. Is there a way i can do this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Probability of random numbers
Soccer boy -
If the data are approximately normally distributed (bell-shaped histogram), you could use =NORMINV(RAND(),mean,stdev) If the data are not normally distributed, or if you don't want dynamic values, post again with more details. - Mike Middleton http://www.DecisionToolworks.com "Soccer boy" wrote in message ... i am currently working with a some rainfall data and am trying to give a somewhat probable forecast. i have data for the past 100 years, which gives me my Average Annual rainfall, and based off of that i can get my standard Deviation/bell curve. What i want to do is be able to generate random numbers based off of its probability of happening. Is there a way i can do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
getting numbers divisible by 4 from random numbers in ascending order | Excel Worksheet Functions | |||
Can Excel pick random numbers from 1-300 and not repeat numbers? | Excel Discussion (Misc queries) | |||
Non-random numbers generated by excel's data analysis random gener | Excel Worksheet Functions | |||
Non-random numbers generated by excel's data analysis random gener | Excel Discussion (Misc queries) | |||
Selecting at random with weighted probability | Excel Worksheet Functions |