Hello I did the first two parts just need help with the last one. the blank page of excel. thank you!
Excel File Edit View Insert Format Tools Data Window Help X Q 8 * Fri Jul 2 11:09 AM Dice Lab QL Q . Search Sheet Home Insert Page Layout Formulas Data Review View Tell me what you want to do '+ Share ~ K Cut Calibri 16 A- A Wrap Text General AutoSum Copy Fill Paste Format BI UT VS. A Merge & Center $ % 00 .0 Conditional Format Cell Insert Delete Format Sort & Formatting as Table Styles Clear Filter Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. Check for Updates F1 X V fx Ammaar Tariq M N O P Q R S T U V W X Y 2 AA AB AC AD AE AF AG AH AI ize of smaller die size of larger die Read all instructions below thoroughly and carefully. 1. Decide what two dice you want to use for your data collection and record them in cells 14 and HS above. Your smaller die should have at least 4 sides. Your larger die should have at least 10 sides. 2. Go to the following website: http://dicelog.com/dice he cell labeled "Dice to Roll" type Id followed by the number of sides you want your smaller die to have. In the cell labeled "Options" choose "also roll". In the last box type Id followed by the number of sides you want your larger die to have. For example, if I wanted to roll an & sided die and a 20 sided die I would enter: 1ds also roll 1dzo 4. In the cell labeled "Roll dice how many times" type 50 5. Click on the "Roll!" button. 6. Enter your rolls in the columns to the left. Data Collection Empirical vs. Theoretical New Data Set + Ready -+ 70% M Ed JUL 2 MA C 25Excel File Edit View Insert Format Tools Data Window Help X Q 8 * Fri Jul 2 11:09 AM Dice Lab QL Q . Search Sheet Home Insert Page Layout Formulas Data Review View Tell me what you want to do '+ Share ~ K Cut Calibri 11 A- A So Wrap Text General 14#1 AutoSum Copy Fill Paste BI UT . S.A Merge & Center $ % 00 .0 Conditional Format Cell Insert Delete Format Sort & Format Formatting as Table Styles Clear Filter Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. Check for Updates B15 * X V fx B C D E F G H 1 J K L M N P Q R S T U V w X Y Z AA Table 1 Read all instructions below thoroughly and carefully. Calculate the empirical probabilities: 4 P (smaller die is odd) 29/50 1. Using the data you collected from the "Data Collection" Sheet, complete Table 1. P(sum of the numbers is 5) 1/25 Write your probabilities in fractional form. To write your probabilities in fractional form, type an apostrophe before typing the fraction. For example, 3/8 needs to be P (same number appears on both entered as '3/8 to show up as a fraction. Make sure all fractions are reduced. 6 dice) 3/50 P(number on larger die exceeds 2. Explain why the probabilities in Table 1 are empirical rather than theoretical. To the receive full credit, your explanation should be written in at least three substantive 7 number of the smaller die) 19/25 sentences. D CO Table 2 10 Calculate the theoretical probabilites: 3. To the right of this text box, show the sample space for the theoretical 11 P(smaller die is odd) 1/2 probabilities. 12 P(sum of the numbers is 5) 1/10 P (same number appears on both 4. Using the sample space you created in (3) above, complete Table 2. Write your 13 dice 1/10 probabilities in fractional form just like you did in Table 1. P(number on larger die exceeds 5. Rewrite your probabilities from Tables 1 and 2 in decimal form for Table 3. The the column labeled "Empirical" in Table 3 should match all of your values from Table 1 14 [number of the smaller die) 3/4 except your values will now be written as decimals instead of fractions. The column 15 labeled "Theoretical" in Table 3 should match all of your values from Table 2 except 16 Table 3 your values will now be written as decimals instead of fractions. After you've filled 17 Probability to Compare Empirical Theoretical Difference in the Empirical and Theoretical columns compute the difference between the 18 P(smaller die is odd) 0.58 empirical and theoretical probabilities 0.5 0.08 19 P(sum of the number is 5) 0.04 0.1 0.06 6. Compare your empirical and theoretical probabilities for each of the four events. P(same number appears on both Are any the same? If not, why is there a difference? Explain using at least 3 20 dice) 0.06 0.1 0.04 complete sentences. P(Number on larger die exceeds 21 the number of the smaller die 0.76 0.75 0.01 22 23 Data Collection Empirical vs. Theoretical New Data Set + Ready - PW JUL 25 2 MA C XExcel File Edit View Insert Format Tools Data Window Help X Q 2 * Fri Jul 2 11:10 AM Dice Lab QL Q . Search Sheet Home Insert Page Layout Formulas Data Review View Tell me what you want to do '+ Share ~ K Cut Calibri 11 A- A So Wrap Text General AutoSum Copy Fill Paste Merge & Center $ % Conditional Format Insert Delete Format Sort & Format B I U- . . A EE. 00 $.0 Cell Formatting as Table Styles Clear Filter Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. Check for Updates D8 X V fx M N 0 P Q T U V w Z AA AB AC AD AE Roll # Smaller Die Larger Die |Product Read all Instructions below thoroughly and carefully 1. Copy your data from the "Data Collection" Sheet to Columns B and C in the table to the left. 2. Now, calculate the products of the smaller and larger die for each roll number in Column D. 3. Using the data from the left, complete Table 1 below. 3. To the right of this text box, show the sample space for the theoretical probabilities. 4. Using the sample space you created in (3] above, complete Table 2 below. Table 1 Calculate the following empirical probabil Poroduct is even) (Pproduct is greater than 20] [Plproduct is less than 20) [Piproduct is 20) Table 2 Calculate the following theoretical probabilites [Pproduct is even) Piproduct is greater than 20) Plproduct is less than 20) [Piproduct is 20) Data Collection Empirical vs. Theoretical New Data Set + Ready -+ 75% PW JUL 2 & tv MA C 25
