Sum of Two Dice (In this activity, we use simulation tool to generate outcomes from rolling two dice 240 times.) Use a c

[answerhappygod]

Sum Of Two Dice In This Activity We Use Simulation Tool To Generate Outcomes From Rolling Two Dice 240 Times Use A C 1 (43.48 KiB) Viewed 37 times

Sum Of Two Dice In This Activity We Use Simulation Tool To Generate Outcomes From Rolling Two Dice 240 Times Use A C 2 (28.46 KiB) Viewed 37 times

Sum of Two Dice (In this activity, we use simulation tool to generate outcomes from rolling two dice 240 times.) Use a cell reference or a single formula where appropriate in order to receive full credit. Do not copy and paste values or type values, as you will not receive full credit for your answers 2.) Aj Sum Roll 1 2 3 4 S 6 7 8 D 10 11 12 13 14 15 16 17 181 19 Die 20 21 22 23 24 25 26 27 28 24 Die 2 total 21 3 4 S 4 2 31 9 10 11 Frequency 12 Mean: d Frequency 7 or 11 Use "RANDBETWEEN" to simulate rolling two dice 240 times in columns and C. Sum the two dice incolume D. Each die ha faces numbed from 1 to 6 63 "COUNT" applied to D50345 to determine the frequency of each sum, than compute the relative frequency out of the 240 rolls Format the relative frequencies as percentages to 1 decimal place Use the "SUMPRODUCT applied to 35 and 3 of "AVERAGE applied to CS C245 to compute the mean sum Format as a decimal rounded to the 2nd decimal d 43 Compute the percentage of times a natural or 11) occurred in the 260 ralls format a percentage to 1 decimal place (Do not type in a number it should be a formula) el Create a Relative Frequency Histogram for the summ shart for discrete How to do 10 Highlight F5F36, then while pressing CTRL highlight HS 6 Go to "art", then to "Recommended Chart then choose the column chart Add as labels Click on the chart, then click symbol at the righe upper comer. Check mark "Axis Tide. Then, manly edit horizontal axis label to "Sums" and vertical axis ties DO NOT USE "HISTOGRAM in the CEART

17 18 19 20 21 22 23 24 25 26 27 25 29 30 31 32 33 34 35 36 37 38 39 29392 99 25 Mean Values from my simulations were el Create a Relative Frequency Histogram for the sums (column shirt for dtirete da How to do Highlight F5F16, then while pressing CTRL key highlights Go to "mrt, then to Recommended Charts", then choose the couchar Add a Cick on the chart, then click symbol at the right upper om Check mark "Aais Title. Then, manually horizontalis label to "Suns" and vertical axis title as Frequency. DO NOT USE HISTOGRAM Run the simulation several times for 40 times if needed) To run the simulation, click any empty cell and press SHIFT 19 that doesn't work "SHIFT CTRL+ALT+F wilde. Record the mean from each simulation with a pencil on a piece of paper and report those numbers below. (At least 7 of them)