Question
One needs to be careful when writing formulas for simulation. =round( rand() * 6, 0) will take a value uniformly distributed between 0 and 1,
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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started