Scribd Logo
Upload

Welcome to Scribd!

  • 19 views

    Spreadsheet Dice Simulation

    Uploaded by

    412160120
    The document describes using a spreadsheet to simulate dice rolls by generating random numbers from 1 to 6 and counting the frequency of each result. It provides instructions to: 1. Set up the spreadsheet with labels and formulas to generate 100 random dice rolls and count the frequency of each result. 2. Compare the results to expected equal probabilities and check for any imbalances. 3. "Toss more dice" by extending the random number generation and adjusting the count formulas to analyze more dice rolls and improve probability accuracy.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Spreadsheet Dice Simulation

    Uploaded by

    412160120
    19 views2 pages
    The document describes using a spreadsheet to simulate dice rolls by generating random numbers from 1 to 6 and counting the frequency of each result. It provides instructions to: 1. Set up the spreadsheet with labels and formulas to generate 100 random dice rolls and count the frequency of each result. 2. Compare the results to expected equal probabilities and check for any imbalances. 3. "Toss more dice" by extending the random number generation and adjusting the count formulas to analyze more dice rolls and improve probability accuracy.

    Original Title

    Spreadsheet-Dice-simulation

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document describes using a spreadsheet to simulate dice rolls by generating random numbers from 1 to 6 and counting the frequency of each result. It provides instructions to: 1. Set up the spreadsheet with labels and formulas to generate 100 random dice rolls and count the frequency of each result. 2. Compare the results to expected equal probabilities and check for any imbalances. 3. "Toss more dice" by extending the random number generation and adjusting the count formulas to analyze more dice rolls and improve probability accuracy.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    19 views2 pages

    Spreadsheet Dice Simulation

    Uploaded by

    412160120
    The document describes using a spreadsheet to simulate dice rolls by generating random numbers from 1 to 6 and counting the frequency of each result. It provides instructions to: 1. Set up the spreadsheet with labels and formulas to generate 100 random dice rolls and count the frequency of each result. 2. Compare the results to expected equal probabilities and check for any imbalances. 3. "Toss more dice" by extending the random number generation and adjusting the count formulas to analyze more dice rolls and improve probability accuracy.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    You are on page 1of 2

    SPREADSHEET: DICE SIMULATION

    You can use a spreadsheet to simulate the tossing of a die. You can generate
    hundreds of random numbers from 1 to 6 by entering a formula and copying it
    to as many cells as you need.

    You can also get the spreadsheet to count how many ones, twos, threes etc in your list and how many
    dice throws you have altogether.

    TASK 1 Construct your spreadsheet

    Step 1: Enter the labels


    Open your spreadsheet and enter the labels shown below into the correct cells.
    A B C D E F G H I J K L M
    1 Die results Counts
    2 number of ones
    3 number of twos
    4 number of threes
    5 number of fours
    6 number of fives
    7 number of sixes
    8
    9 total

    Step 2: Enter the formulas


    Enter the formulas shown below into the correct cells. Remember to start your formulas with ‘=’.
    These formulas will not show in the cells, but the numbers that are the results of the formulas will.
    A B K L M
    1 Die results Counts
    2 =INT(Rand()*6 + 1) number of ones =Countif(A2:J11, 1)
    3 number of twos =Countif(A2:J11, 2)
    4 number of threes =Countif(A2:J11, 3)
    5 number of fours =Countif(A2:J11, 4)
    6 number of fives =Countif(A2:J11, 5)
    7 number of sixes =Countif(A2:J11, 6)
    8
    9 total =Sum(M2:M7)

    Meaning of the formulas


    =INT(Rand()*6 + 1) produces a random whole number from 1 to 6 inclusive
    =Sum(M2:M7) calculates the sum of the numbers in the cells from M2 to M7
    =Countif(A2:J11, 1) counts the number of ones in the cells A2 to J11
    =Countif(A2:J11, 2) counts the number of twos the numbers in the cells A2 to J11
    The formulas will not show in the spreadsheet. Instead you should see some thing like this:
    A B C D E F G H I J K L M
    1 Die results Counts
    2 3 number of ones 0
    3 number of twos 0
    4 number of threes 1
    5 number of fours 0
    6 number of fives 0
    7 number of sixes 0
    8
    9 total 1
    *** You may have a different result in A2 which will show in your counts in column M.

    Step 3: Copy formula to “throw more dice”


    Now the result of “throwing one die” shows in A2. “Throw more dice” by clicking in A2 and dragging
    the small marker at the bottom right corner of the cell across to J2. You will have the results of
    throwing 10 dice.
    A B C D E F G H I J K L M
    1 Die results Counts
    2 3 number of ones 0
    To “throw even more dice”, highlight the row from A2 to J2 and drag this whole row down to row 11.
    You should now have 100 dice results.
    Look at column M. These numbers show how many of each result occurred and the total tosses of 100.
    A B C D E F G H I J K L M
    1 Die results Counts
    2 4 4 1 6 4 3 2 5 2 1 number of ones 19
    3 6 3 5 5 1 5 5 1 5 1 number of twos 17
    4 3 2 6 5 4 1 5 5 1 1 number of threes 17
    5 2 3 5 5 4 3 6 1 4 1 number of fours 15
    6 6 4 1 2 4 3 1 3 2 6 number of fives 18
    7 3 6 5 2 5 3 6 3 6 6 number of sixes 14
    8 3 2 1 5 6 2 4 1 1 3
    9 4 1 5 4 3 5 3 6 1 6 total 100
    10 4 4 2 5 5 3 3 2 4 2
    11 1 2 2 3 2 4 2 2 6 1

    TASK 2 Compare results

    Probability predicts that you will get an equal number of each result. Did you? Look at the results of
    the counts in column M.

    TASK 3 Toss more dice

    “Toss even more dice” by copying the random-number formula to more cells. Change J11 in all the
    formulas in column M. For example, if you copy the formula to all cells down to J21 then you
    will have 200 results but you must change the formulas in column M from J11 to J21.
    How many times do you need to toss a die to be pretty sure of getting the same number of each result?

    You might also like