In: Finance
One needs to be careful when writing formulas for simulation. "=round( rand() * 6, 0)" will take a value uniformly distributed between 0 and 1, multiply it by 6, and round it to the nearest integer. Using that formula, what is the probability of getting 6? (Note: probability is a number between 0 and 1; give your answer to three decimal places.)
Hint: rand() is uniformly distributed from 0 to 1. Hence rand()*6 is uniformly distributed from 0 to 6. Only values above 5.5 will be rounded to 6. We can find the probability from this.
Alternatively, we can simulate a thousand values of "=round(rand()*6,0)", say in the range A1:A1000. Now "=COUNTIF (A1:A1000, 6)" will give us a count of the value 6 in the range A1:A1000. From this we can estimate the probability.
Using that formula, what is the probability of getting 6?
=(b-x)/(b-a)
=(6-5.5)/(6-0)
=0.083