The Problem from Kyle Berry on Vimeo.
Set up the simulation from Kyle Berry on Vimeo.
=RAND() from Kyle Berry on Vimeo.
Make a row of randomness... from Kyle Berry on Vimeo.
Make a table of randomness from Kyle Berry on Vimeo.
Select the numbers below 0.36 from Kyle Berry on Vimeo.
Highlight the selected numbers from Kyle Berry on Vimeo.
An important thought... from Kyle Berry on Vimeo.
You need to enable Javascript in your browser to edit pages.
help on how to format text
Amateur Meteorologist
Download this file:
...and this file:
These videos should help:
1 - The problem we are simulating
The Problem from Kyle Berry on Vimeo.
2 - Type in the days of the week and the number of simulations
Set up the simulation from Kyle Berry on Vimeo.
3 - The random function: =rand()
=RAND() from Kyle Berry on Vimeo.
4 - Copy the function across the row
Make a row of randomness... from Kyle Berry on Vimeo.
5 - Copy the row to fill out the columns
Make a table of randomness from Kyle Berry on Vimeo.
6 - Hold "Ctrl" to select all numbers less than the probability we are testing (0.36). Those correspond to "days of rain".
Select the numbers below 0.36 from Kyle Berry on Vimeo.
7 - Use the paint bucket to highlight the selected cells.
Highlight the selected numbers from Kyle Berry on Vimeo.
8 - An important thing to remember...
An important thought... from Kyle Berry on Vimeo.
Out of my ten simulations, I only had one that had at least four "days of rain". For me, the probability that we would get at least four days of rain was 0.10. That can also be written as a 10% chance. What did you get?