Number of sides Table 1 Take these steps to complete the DO: 15 Number of Rolls (column A]: 6 1. Change the number of sides in A2 to be between 10 and 14. Rolls for Rolls for Outcome Empirical Theoretical Absolute Difference Table 1 Table 2 Frequency Probability Probability Between Empirical and Theoretical Probabilities 2. The formulas in cells A4 and B4 generate random numbers between 1 and the number in cell A2, to simulate rolling a die with that number 0.0000 of sides. Use the fill-down feature to copy this formula down so that there are 1000 rolls in column A and 4000 rolls in column B. Note that 0.0000 the COUNTIF() function in column E counts how many of each number appear in column A (for Table 1) and in column B (for Table 2). 0.0000 B. For both Table 1 and Table 2, write formulas to calculate the empirical probabilities of each outcome in column F (EP = frequency / # of 0.0000 rolls), using an absolute cell reference to the number of rolls in cell F2 for Table 1 and cell F22 for Table 2. (Hint: once you write the first 0.0000 formula in each table with absolute cell references, you can use the fill down feature to complete the columns.) Here, you should complete 0.0000 only as many entries as match your number of sides; for example, if your number of sides is 11, you would complete the formulas in cells 0.0000 F4:F14 in Table 1 and F24:F34 in Table 2. 0.0000 0.0000 4. For both Table 1 and Table 2, write formulas to calculate the theoretical probabilities for each outcome in column G (TP = 1 / # of sides), 0.0000 this time using an absolute cell reference to the number of sides in cell A2. As with your empirical probability formulas, you should complete 0.0000 only as many entries as there are sides on your die. 0.000 5. In cells H19 and H39, use an Excel function to calculate the average value of the absolute difference between the empirical and theoretical 0.000 probabilities in columns F and G. Here, you should use only as many entries in your averages as there are sides on your die. 0.000 0.0000 5. Compare the average absolute differences for Table 1 (1000 rolls) versus Table 2 (4000 rolls). What do you notice here? (Hint: see also the Average: chart below; try adding more rolls in column A or column B to see what happens to the average differences with different relative numbers of rolls in each column. For example, see what happens if you enter 4000 rolls in column A and 16000 rolls in column B.) Table 2 Response : Number of Rolls (column B) 4 Outcome Frequency Empirical Theoretical Absolute Difference Between Empirical and Probability Probability Theoretical Probabilities 1 O 0.000 0.0000 Absolute differences between empirical and and theoretical 0.0000 probabilities with different numbers of rolls 0.0000 - Differences for Table 1 (default 1000 rolls) -Differences for Table 2 (default 4000 rolls) 0.000 0.000 Average difference for Table 1 - Average difference for Table 2 0.000 1.0000 0.000 0.8000 empirical and theoretical P 0.000 Absolute difference between 0.60 00 0.000 0.0000 0.4000 0.0000 2 0.2000 0.0000 0.0000 3 5 6 7 8 10 11 12 13 14 15 0.0000 Number Rolled Average