PHY2053L_Sec903F19_Lab 2 - Statistical Analysis_LPC.xlsx -...

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

Simulation of four rolled dice Variances Equation 1 Dice 1 Dice 2 Dice 3 Dice 4 1 4 3 1 15 0.92833225 14.0365 3 1 1 6 16 3.85533225 6 2 6 5 15 0.92833225 5 5 6 6 15 0.92833225 2 1 2 1 12 4.14733225 2 3 2 2 19 24.63633225 4 2 2 6 16 3.85533225 3 2 3 2 12 4.14733225 2 1 4 6 13 1.07433225 3 6 6 4 12 4.14733225 3 1 1 5 12 4.14733225 2 1 3 6 8 36.43933225 5 5 3 6 16 3.85533225 2 1 6 3 9 25.36633225 6 2 5 4 12 4.14733225 2 2 1 1 23 80.34433225 1 5 6 2 18 15.70933225 3 3 3 4 13 1.07433225 4 4 6 2 11 9.22033225 4 5 1 2 19 24.63633225 6 4 3 5 8 36.43933225 2 1 3 3 14 0.00133225 2 1 1 6 13 1.07433225 2 4 3 4 9 25.36633225 5 2 3 4 16 3.85533225 5 2 5 4 20 35.56333225 6 1 5 3 12 4.14733225 1 2 4 6 12 4.14733225 2 1 3 6 15 0.92833225 1 4 4 4 10 16.29333225 2 4 3 4 16 3.85533225 Sum of four possibilities
Standard deviation 3.38731526468252 4 1 0 2.922216731616 5 6 30 6.709264649038 6 16 96 14.11844273322 7 41 287 27.23002521866 8 33 264 48.13474372996 9 90 810 77.98636137209 10 109 1090 115.8051904554 11 159 1749 157.6110876093 12 209 2508 196.6051456247 13 228 2964 224.7772573724 14 218 3052 235.5370486943 15 218 3270 226.2119083871 16 200 3200 199.1228371795 17 166 2822 160.6482700349 18 109 1962 118.7901438125 19 81 1539 80.50709140068 20 60 1200 50.00774120622 21 30 630 28.47014727356 22 22 484 14.85564670427 23 4 92 7.104651583812 24 1 24 3.114177627884 2000 28073 1996.269399401 14.0365 Possible sums (#) No. of times the sum occurs Normal distribution ?(𝑥_𝑖 )∗𝑥_𝑖
SDOM 0.075743 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 2 0 50 100 150 200 250 Normal Distribution of Four Rolled Dice Column J Column L Possible Sums (#) Number of times the sum occurs (#) 1. Leslie Pena-Cardenas
Lab 2: Statistical Analysis Group Members' Name
Summary: The theoretical and experimental graphs are very similar as represented by the line and bar graph. While it

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture