Rolling dice.xlsx - Possible Sums of possible ways to get...

This preview shows page 1 - 5 out of 5 pages.

Total Sum Mean Variance 2 3 6 7 25 1.028037 1.0139217836 3 6 18 16 4 9 36 9 5 12 60 4 6 15 90 1 7 18 126 0 8 15 120 1 9 12 108 4 10 9 90 9 11 6 66 16 12 3 36 25 Possible Sums # of possible ways to get sum (Frequency) Deviation Squared Standard Deviation 2 3 4 5 6 7 8 9 10 11 12 0 25 50 75 100 125 Theoretical Distribution Possible Sums Total Sum
0.000002062 0.0001641742 0.0049417437 0.0562348367 0.2419248991 0.3934645521 0.2419248991 0.0562348367 0.0049417437 0.0001641742 0.000002062 0.9999999835 Probability Distribution
Total Sum Mean Variance 2 5 10 6.787037 22.9157236 1.0327 1.0162184 5.962135E-006 3 4 12 14.3416495 0.0003786905 4 10 40 7.76757545 0.0091332234 5 15 75 3.19350137 0.0836413469 6 14 84 0.6194273 0.2908540824 7 21 147 0.04535322 0.3840488954 8 15 120 1.47127915 0.192555127 9 8 72 4.89720508 0.0366590211 10 7 70 10.323131 0.0026501097 11 5 55 17.7490569 7.274515E-005 12 4 48 27.1749829 7.582309E-007 0.9999999619 Possible Sums Tally (Frequency) Deviation Squared Standard Deviation Probability Distribution 2 3 4 5 6 7 8 9 10 11 12 0 25 50 75 100 125 150 Frequency Distribution Possible Sums Total Sum
Summary A) Both of the graphs have in common that 7 was the possible sum with the highest where the bars increase to 7 with it having the highest frequency and then decline. B) The probability distribution for the experiment did match my expectations. Firstly,

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture