2. For this question, you will use spreadsheet software such as Excel or Google Sheets to...

Transcribed Image Text:

2. For this question, you will use spreadsheet software such as Excel or Google Sheets to simulate dice rolls. In this spreadsheet, there will be three columns. The first column will represent the first die, the second column will represent the second die, and the third column will be the sum of those two columns. Use the function RANDBETWEEN(1,6) in the first two columns to create a random number from 1 to 6, then add their values together for the third column. This simulates the rolling of two 6-sided dice. Apply this calculation down 1000 rows to simulate 1000 dice rolls. Note: the RANDBETWEEN() function will frequently recalculate its values. This should not impact answering the question, but it can be distracting, so following this guide may be useful. a. Make a histogram of the third column (the one representing the sum of the dice). Excel's default formatting for histograms may leave large gaps in the histogram. To avoid this, right click on the histogram, select Format > Scries > Number of bins and then enter 11 for the number of bins. This will make decimal numbers appear on the horizontal axis, but the histogram will no longer have any large gaps. b. Is this histogram normally distributed? How can you tell? 2. For this question, you will use spreadsheet software such as Excel or Google Sheets to simulate dice rolls. In this spreadsheet, there will be three columns. The first column will represent the first die, the second column will represent the second die, and the third column will be the sum of those two columns. Use the function RANDBETWEEN(1,6) in the first two columns to create a random number from 1 to 6, then add their values together for the third column. This simulates the rolling of two 6-sided dice. Apply this calculation down 1000 rows to simulate 1000 dice rolls. Note: the RANDBETWEEN() function will frequently recalculate its values. This should not impact answering the question, but it can be distracting, so following this guide may be useful. a. Make a histogram of the third column (the one representing the sum of the dice). Excel's default formatting for histograms may leave large gaps in the histogram. To avoid this, right click on the histogram, select Format > Scries > Number of bins and then enter 11 for the number of bins. This will make decimal numbers appear on the horizontal axis, but the histogram will no longer have any large gaps. b. Is this histogram normally distributed? How can you tell?

Answer rating: 100% (QA)

The question youve presented is related to the use of spreadsheet software like Excel or Google Sheets to simulate dice rolls and analyze the results ... View the full answer