Question

Create a figure showing the probability of rolling a 5 as a function of the number of rolls. Don't forget to include a figure caption describing the significance of the figure. At what point does the calculated odds converge to the theoretical probability? You will want a sufficiently dense data set to show convergence (maybe below 100 go by 10, 100-1000 go by 100, above 1000 go by 1000). Also, it is possible to run multiple roll numbers to show the potential spread in probability at lower roll numbers. Use excel and show all work.

Answer 1

empirical prob- Microsoft Excel View Conditional Formatting Format as Table- Home Insert Page Layout Formuulas Data Review Developer General Insert E Delete ▼ Format Cells %: ,_.| | | Paste Cell Styles Clipbo.. FontD Alignment Numbe Styles G10 0 .0125 1 :No of trials :-: Prob of getting different number of 5s in throw of 10 dice 3 10 100.10.5 20 0.150.3 6 0 0 0 0.2:0.1: 0.1 0 0 0 0 一 0.50.050 30 0.1 0.367 0.2 0.2330.1 40 0.15 0.4250.2 0.0750.15 50 0.1 0.44. 0.30.16 0 8ー゜ 三 60 0.15 0.333 0.317: 0.15 0.05 70 0.157 0.357 0.1140.3 0.0570.014 80 0. 90 0.189 0.322 0.278 0.15б 0.033 0.022 0 0 1630.3 0.35 0.113 0.063 0 0 100 0.22 0.31 0.29 0.12 0.05 0.01 12 13 Theoretical 14 0.162 G.323 0.291 0.155 0.0540.013 0.002 2E-04 2E-05 8E-07 2E-08 16 17 Ready StartMicrosoft Excel emp.Mcrosoft Word

a- | Manager ? create from setertion Defined Names Date & Time Function ibrary N12 1 No of trials prob 1 0.1 5 0.5 no of 5s 11 556 3 2 32s 23 2 0.2 1 0.1 4 233 51 1 1 0.1 0 0 0 0 0 10 l1 0 10 4 153 2 4 4 2 2 4 1 0 13 14 15 3 0.15 6 0.3 10 0.5 Wireless networks detected One or more To see the ist and connect, dick this message 17 o wireless networks are in range of this computer Read