MAT 144 Grand Canyon University Technology Report

I’m working on a mathematics multi-part question and need a sample draft to help me study.

Here are some additional hints for completing the DQ:

Hint #1: The RANDBETWEEN() function used in cell B2 will be invoked each time you make a change in the Excel sheet, so your Frequency and Empirical Probability column entries in E2:F16 will keep updating as you change the worksheet. This is normal.

Hint #2: Use these steps to copy and paste the contents of cells E2:F16 by value:

1. Select the range of cells E2:F16, then press Copy.
2. Now right-click in the top-left cell that you’ll be copying to (either D21 or F21), and then select the “By Value” option (the clipboard with “123” underneath it) from the Paste Options section of the right-click menu.
3. Once you have copied-and-pasted the cell contents, the values in the cells that you’re copying to should no longer change.

Here’s a link to a video that may also help with this: https://www.youtube.com/watch?v=PbRQBse3Ob0.

Hint #3: For your response comparing the empirical probability with 1,000 rolls against the empirical probability with 4,000 rolls, what you should do is compare each set of empirical probabilities against the theoretical probabilities in cells G2:G16. Which group of empirical probabilities is, on average, closer to the theoretical probabilities? (How would you be able to quantify “closer” in this case?) How might the number of rolls be contributing to this result?