Names: DATA ANDREW DEERING AND DAVID Smaller Die Larger Die 3 10 3 17 5 6 4 9 3 11 5 2 4 2 5 5 3 7 1 19 4 4 6 5 2 18 1 20 4 15 1 12 4 11 1 9 4 4 1 9 6 11 5 11 6 17 1 8 5 20 5 10 5 9 3 12 3 14 2 19 6 19 4 3 5 7 3 17 4 9 1 3 5 20 1 7 3 4 3 1 6 15 5 18 size of smaller die size of larger die What is the sample space of the smaller die? What is the sample space of the larger die? How many combinations can be made from rolling bo 1 5 4 3 1 1 6 6 19 11 16 19 14 12 17 7 pace of the smaller die? pace of the larger die? tions can be made from rolling both dice together? In order to help you complete this page, you can play with sorting your data and adding columns to compute different excel functions (fx) like SUM and IF. You may want to make a copy of your data on a NEW sheet so that you always have the orginal data to go back to. I want to se form (pleas To get Excel an apostrop For example Use your data to calculate the following probabilities: P(smaller die is odd) P(sum of the numbers is 5) P(same number appears on both dice) P(number on larger die exceeds the number of the smaller die) Fraction Decimal Calculate the following theoretical probabilites: P(smaller die is odd) P(sum of the numbers is 5) P(same number appears on both dice) P(number on larger die exceeds the number of the smaller die) Fraction Decimal Probability to Compare P(smaller die is odd) P(sum of the numbers is 5) P(same number appears on both dice) P(number on larger die exceeds the number of the smaller die) Empirical Theoretical Difference I want to see the probabilities written in fraction form and decimal form (please round to 2 decimal places) for these first 2 tables. To get Excel to display the answers as fractions, you need to type an apostrophe before typing in the fraction. For example, 3/8 needs to be entered as '3/8 Explain why these probabilities are empirical (relative frequency) rather than theoretical. Include the definitions of these types of probability in your explanation. This should be done in a paragraph of at least three sentences. Put that paragraph in a text box. Compare your empirical and theoretical probabilities for each of the four events using your decimals. To do this, reference the decimal cells from the the probabilities you found above. Then, compute the difference in the Difference column. (Don't forget to start with an equals sign). Are any the same? If not, why is there a difference? Is it a large difference? Is this what you would or would not expect? Explain using complete sentences in a textbox. Use your data to form a new data set. This new data set will consist of the products of the numbers on the dice. Smaller Die Larger Die Product In order to help you complete this page, you can play with adding columns to compute different excel functions (fx) like ISEVEN and IF. Use your data to calculate the following probabilities: P(product is even) P(product is greater than 20) P(product is less than 20) P(product is 20) Fraction Decimal Calculate the following theoretical probabilites: P(product is even) P(product is greater than 20) P(product is less than 20) P(product is 20) Fraction Decimal Probability to Compare P(product is even) P(product is greater than 20) P(product is less than 20) P(product is 20) Empirical Theoretical Difference