Students should work in pairs
One iPad should be set up to roll a pair of dice using the app make dice (or similar)
The second iPad - use a spreadsheet to make a column of numbers from 1 to 18 and a second column from 19 to 36.
Roll the pair of dice 36 times and record the sum of each roll by the corresponding roll number.
Arrange their data in order from least to greatest using the spread
4.)Have students calculate the mean, median, mode, and range of their data and record the results on their papers.
5.)In the computer lab, have students open an Excel spreadsheet.
5.)In A1 Type "Dice Roll Project."
6.)Skip one row and type "Roll" in A3 and "Outcome" in C3.
7.)From A4:A39 type 1-36. From C4:C39 type the corresponding outcomes.
8.)Have students highlight the outcomes in C4:C39, copy, and paste them into column E, where the first outcome is in E4.
9.)While the spaces E4-E39 are still highlighted, go to Data>Sort>Ascending (this is the button with the capital letters A and Z and the arrow pointing downward). This will put the outcomes in order from least to greatest.
10.)Type "Mean," "Median," "Mode," and "Range" in A42, A43, A44, and A45, respectively.
11.)Click in C42, go to Insert>Function. A function screen will appear. Click "Statistical" in the left column, then "Average" in the right column. The next screen will ask for the cells to include in the calculation. Our outcomes start in C4 and end in C39, so we will type C4:C39 for Number 1. (Use C4:C39 for all the calculations.)
12.)Click in C43, go to Insert>Function. A function screen will appear. Click "Statistical" in the left column, then "Median" in the right column. Type C4:C39 for Number 1.
13.)Click in C44, go to Insert>Function. A function screen will appear. Click "Statistical" in the left column, then "Mode" in the right column. Again type C4:C39 for Number 1.
14.)Click in C45. Simply subtract the number in E4 from the number in E39 to find the range.
15.)Now that students have calculated statistical data for their own experiment, they will now determine the theoretical probability of each of the possible outcomes (2-12). Have students go to the website and complete the applet by assigning Player A to Score 2, Player B to Score 3, Player C to Score 4, and so on.
(Shodor Education Foundation)
This website is an applet that allows students to calculate the probability (theoretical) of each number from 2 to 12 appearing when two dice are rolled.
16.)Have students compare their outcomes (experimental) to the theoretical probability obtained from the website.
Roll the pair of dice 36 times and record the sum of each roll by the corresponding roll number.
Arrange their data in order from least to greatest using the spread
4.)Have students calculate the mean, median, mode, and range of their data and record the results on their papers.
5.)In the computer lab, have students open an Excel spreadsheet.
5.)In A1 Type "Dice Roll Project."
6.)Skip one row and type "Roll" in A3 and "Outcome" in C3.
7.)From A4:A39 type 1-36. From C4:C39 type the corresponding outcomes.
8.)Have students highlight the outcomes in C4:C39, copy, and paste them into column E, where the first outcome is in E4.
9.)While the spaces E4-E39 are still highlighted, go to Data>Sort>Ascending (this is the button with the capital letters A and Z and the arrow pointing downward). This will put the outcomes in order from least to greatest.
10.)Type "Mean," "Median," "Mode," and "Range" in A42, A43, A44, and A45, respectively.
11.)Click in C42, go to Insert>Function. A function screen will appear. Click "Statistical" in the left column, then "Average" in the right column. The next screen will ask for the cells to include in the calculation. Our outcomes start in C4 and end in C39, so we will type C4:C39 for Number 1. (Use C4:C39 for all the calculations.)
12.)Click in C43, go to Insert>Function. A function screen will appear. Click "Statistical" in the left column, then "Median" in the right column. Type C4:C39 for Number 1.
13.)Click in C44, go to Insert>Function. A function screen will appear. Click "Statistical" in the left column, then "Mode" in the right column. Again type C4:C39 for Number 1.
14.)Click in C45. Simply subtract the number in E4 from the number in E39 to find the range.
15.)Now that students have calculated statistical data for their own experiment, they will now determine the theoretical probability of each of the possible outcomes (2-12). Have students go to the website and complete the applet by assigning Player A to Score 2, Player B to Score 3, Player C to Score 4, and so on.
(Shodor Education Foundation)
This website is an applet that allows students to calculate the probability (theoretical) of each number from 2 to 12 appearing when two dice are rolled.
16.)Have students compare their outcomes (experimental) to the theoretical probability obtained from the website.