home
edited
... ...and this file: {Amateur Meteorologist.xlsx}
These videos should help:
1 - The problem …
...
...and this file: {Amateur Meteorologist.xlsx}
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?
