These are the tables for the discrete version of the 6-MP example.
Model Prior Likelihood*K Prior*L'hood*K Posterior
0 0.091 0 0 0 0
0.1 0.091 7.29E-13 6.62727E-14 2.11201E-15 2.11E-16
0.2 0.091 1.34218E-07 1.22016E-08 3.88847E-10 7.78E-11
0.3 0.091 0.000132885 1.20805E-05 3.84986E-07 1.15E-07
0.4 0.091 0.014843407 0.001349401 4.30033E-05 1.72E-05
0.5 0.091 0.476837158 0.043348833 0.001381461 0.000691
0.6 0.091 6.499837227 0.590894293 0.018830903 0.011299
0.7 0.091 43.96716714 3.997015195 0.127378799 0.089165
0.8 0.091 144.1151881 13.10138073 0.417521092 0.334017
0.9 0.091 150.0946353 13.64496685 0.434844355 0.39136
1 0.091 0 0 0 0
31.37896739 0.826549
Model Prior Likelihood*K Prior*L'hood*K Posterior
0 0.000 0 0 0 0
0.1 0.018 7.29E-13 1.32545E-14 2.55522E-16 2.56E-17
0.2 0.036 1.34218E-07 4.88064E-09 9.40893E-11 1.88E-11
0.3 0.055 0.000132885 7.24829E-06 1.39733E-07 4.19E-08
0.4 0.073 0.014843407 0.001079521 2.0811E-05 8.32E-06
0.5 0.091 0.476837158 0.043348833 0.000835681 0.000418
0.6 0.109 6.499837227 0.709073152 0.013669544 0.008202
0.7 0.127 43.96716714 5.595821273 0.107876495 0.075514
0.8 0.145 144.1151881 20.96220917 0.404110414 0.323288
0.9 0.164 150.0946353 24.56094032 0.473486915 0.426138
1 0.182 0 0 0 0
51.87247953 0.833568
a = 13 You can get to see different beta distributions by entering
b= 3 new values for a and b in the yellow cells.
Beta(a,b) Density
5
4.5
4
f(x)
3.5
3
2.5
2
1.5
1
0.5
0
x value
Probability = 0.975 Change the probability and Excel will calculate
x value = 0.956688 the x value where the cdf reaches that probability.
x value = 0.5 Enter an x value and Excel will calculate the
cdf = 0.003693 cumulative distribution value at that x.
0.00001 1.365E-57
0.05 3.0076E-13
0.1 1.1057E-09
0.15 1.2796E-07
0.2 3.5783E-06
0.25 4.5765E-05
0.3 0.00035545
0.35 0.00194884
0.4 0.00824432
0.45 0.02847136
0.5 0.08331299
0.55 0.2117922
0.6 0.47540926
0.65 0.95110622
0.7 1.70040213
0.75 2.70238878
0.8 3.75208343
0.85 4.36859997
0.9 3.85516317
0.95 1.8439788
0.99999 1.3648E-07
a= 100 You can get to see different gamma distributions by entering
b= 10 new values for a and b in the yellow cells.
Gamma(a,b) density
0.45
0.4
0.35
0.3
0.25
0.2
0.15
0.1
0.05
0
Probability = 0.975 Change the probability and Excel will calculate
x value = 12.05289 the x value where the cdf reaches that probability.
x value = 27 Enter an x value and Excel will calculate the
cdf = 1 cumulative distribution value at that x.
13.62113 0.001 0 0
2 0.025 0.3 9.1647E-110
0.05 0.7 4.51483E-75
0.075 1 4.86465E-61
0.1 1.4 2.60945E-48
0.125 1.7 2.89357E-41
0.15 2 1.39983E-35
0.175 2.4 1.76946E-29
0.2 2.7 1.02108E-25
0.225 3.1 1.62808E-21
0.25 3.4 7.59271E-19
0.275 3.7 1.63332E-16
0.3 4.1 7.75398E-14
0.325 4.4 4.19618E-12
0.35 4.8 4.23393E-10
0.375 5.1 8.51972E-09
0.4 5.4 1.2164E-07
0.425 5.8 2.63201E-06
0.45 6.1 1.93057E-05
0.475 6.5 0.000190229
0.5 6.8 0.00082481
0.525 7.2 0.004332223
0.55 7.5 0.012273694
0.575 7.8 0.029675116
0.6 8.2 0.076810433
0.625 8.5 0.134103165
0.65 8.9 0.233022638
0.675 9.2 0.308957625
0.7 9.5 0.368686714
0.725 9.9 0.400614719
0.75 10.2 0.383156498
0.775 10.6 0.316272859
0.8 10.9 0.24952905
0.825 11.2 0.182641143
0.85 11.6 0.107938748
0.875 11.9 0.067313501
0.9 12.3 0.032537269
0.925 12.6 0.01760255
0.95 12.9 0.009003047
0.975 13.3 0.003389555
1 13.6 0.001535673
df = 3 Enter the (integer) number of degrees of
freedom for the t-distribution in cell B1.
t_n density function
0.4
0.35
0.3
probability
0.25
0.2
0.15
0.1
0.05
0
-5 -4 -3 -2 -1 0 1 2 3 4 5
x values
x value = 2 Enter a value for x and Excel will find
0.860674 the area under the density curve between -x and x.
probability = 0.86067 Enter a probability p and Excel will find the x such that
1.99997 the area under the density between -x and x equals p.
2 -5 0.004219
0.367553 -4.8 0.004878
-4.6 0.005667
-4.4 0.006616
-4.2 0.007765
-4 0.009163
-3.8 0.010876
-3.6 0.012987
-3.4 0.015604
-3.2 0.018871
-3 0.022972
-2.8 0.028152
-2.6 0.034727
-2.4 0.043108
-2.2 0.053818
-2 0.06751
-1.8 0.084956
-1.6 0.107007
-1.4 0.134462
-1.2 0.167802
-1 0.206748
-0.8 0.249666
-0.6 0.293011
-0.4 0.331274
-0.2 0.357944
0 0.367553
0.2 0.357944
0.4 0.331274
0.6 0.293011
0.8 0.249666
1 0.206748
1.2 0.167802
1.4 0.134462
1.6 0.107007
1.8 0.084956
2 0.06751
2.2 0.053818
2.4 0.043108
2.6 0.034727
2.8 0.028152
3 0.022972
3.2 0.018871
3.4 0.015604
3.6 0.012987
3.8 0.010876
4 0.009163
4.2 0.007765
4.4 0.006616
4.6 0.005667
4.8 0.004878
5 0.004219