{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Frequentist","Bayesian"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":0,"defined_names":10,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Frequentist","index":0,"n_rows":116,"n_cols":9,"rows_kept":116,"cut":false,"hidden":false,"merged":[]}
["FROM:","Mark Biegert"]
["SUBJECT:","German Tank Problem Example",null,null,null,null,null,"Title","Frequentist German Tank Production Model"]
["DATE:","2015-04-21",null,null,null,null,null,"X-Axis","Bin"]
[null,null,null,null,null,null,null,"Y-Axis","Percentage (%)"]
["Reference Link"]
[null,"Wikipedia"]
[null,"Wikieducator"]
[]
["Monte Carlo Simulation"]
[]
["max",10000]
["min",1]
["k",100,null,null,"Bins","Freq","Percentage"]
["Ave",{"$f":"AVERAGE(_Predictions)","v":9981.5572000000011},null,null,9700,{"$f":"FREQUENCY(_Predictions,_bins)","v":4},{"$f":"F14/$F$35","v":0.04}]
[null,null,null,null,9730,0,{"$f":"F15/$F$35","v":0}]
["Sample Set","Max Val","Max Est",null,9760,0,0]
[1,{"$f":"RANDSamples(_min,_max,_k)","v":9984},{"$f":"B17*(1+1/_k)-1","v":10082.84},null,9790,2,0.02]
[2,9914,10012.14,null,9820,4,0.04]
[3,9971,10069.710000000001,null,9850,1,0.01]
[4,9907,10005.07,null,9880,3,0.03]
[5,9762,9858.6200000000008,null,9910,6,0.06]
[6,9814,9911.14,null,9940,11,0.11]
[7,9781,9877.81,null,9970,4,0.04]
[8,9747,9843.4699999999993,null,10000,7,7.0000000000000007E-2]
[9,9980,10078.799999999999,null,10030,14,0.14000000000000001]
[10,9678,9773.7800000000007,null,10060,12,0.12]
[11,9902,10000.02,null,10090,26,0.26]
[12,9997,10095.969999999999,null,10120,6,0.06]
[13,9794,9890.94,null,10150,0,0]
[14,9764,9860.64,null,10180,0,0]
[15,9673,9768.73,null,10210,0,0]
[16,9923,10021.23,null,10240,0,0]
[17,9795,9891.9500000000007,null,10270,0,0]
[18,9860,9957.6,null,10300,0,0]
[19,9951,10049.51,null,null,{"$f":"SUM(F14:F34)","v":100}]
[20,9180,9270.7999999999993]
[21,9984,10082.84]
[22,9839,9936.39]
[23,9990,10088.9]
[24,9571,9665.7100000000009]
[25,9897,9994.9699999999993]
[26,9980,10078.799999999999]
[27,9916,10014.16]
[28,9830,9927.2999999999993]
[29,9994,10092.94]
[30,9987,10085.870000000001]
[31,9993,10091.93]
[32,9864,9961.64]
[33,{"$f":"RANDSamples(_min,_max,_k)","v":9982},{"$f":"B49*(1+1/_k)-1","v":10080.82}]
[34,9963,10061.629999999999]
[35,9903,10001.030000000001]
[36,9960,10058.6]
[37,9970,10068.700000000001]
[38,9923,10021.23]
[39,9944,10042.44]
[40,9983,10081.83]
[41,9979,10077.790000000001]
[42,9922,10020.219999999999]
[43,9827,9924.27]
[44,9818,9915.18]
[45,9995,10093.950000000001]
[46,9813,9910.1299999999992]
[47,9968,10066.68]
[48,9894,9991.94]
[49,9695,9790.9500000000007]
[50,9899,9996.99]
[51,9952,10050.52]
[52,9987,10085.870000000001]
[53,9846,9943.4600000000009]
[54,9894,9991.94]
[55,9976,10074.76]
[56,9987,10085.870000000001]
[57,9842,9939.42]
[58,9986,10084.86]
[59,9840,9937.4]
[60,9991,10089.91]
[61,9787,9883.8700000000008]
[62,9927,10025.27]
[63,10000,10099]
[64,9938,10036.379999999999]
[65,{"$f":"RANDSamples(_min,_max,_k)","v":9936},{"$f":"B81*(1+1/_k)-1","v":10034.36}]
[66,9979,10077.790000000001]
[67,9709,9805.09]
[68,9790,9886.9]
[69,9952,10050.52]
[70,9709,9805.09]
[71,9983,10081.83]
[72,9964,10062.64]
[73,9931,10029.31]
[74,9966,10064.66]
[75,9577,9671.77]
[76,10000,10099]
[77,9928,10026.280000000001]
[78,9960,10058.6]
[79,9788,9884.8799999999992]
[80,9714,9810.14]
[81,9948,10046.48]
[82,9906,10004.06]
[83,9977,10075.77]
[84,9861,9958.61]
[85,9795,9891.9500000000007]
[86,9826,9923.26]
[87,9981,10079.81]
[88,9961,10059.61]
[89,9832,9929.32]
[90,9961,10059.61]
[91,9984,10082.84]
[92,9833,9930.33]
[93,9950,10048.5]
[94,9921,10019.210000000001]
[95,9908,10006.08]
[96,9890,9987.9]
[97,9894,{"$f":"B113*(1+1/_k)-1","v":9991.94}]
[98,9881,9978.81]
[99,9574,9668.74]
[100,9990,10088.9]

{"sheet":"Bayesian","index":1,"n_rows":116,"n_cols":9,"rows_kept":116,"cut":false,"hidden":false,"merged":[]}
["FROM:","Mark Biegert"]
["SUBJECT:","German Tank Problem Example",null,null,null,null,null,"Title","Bayesian German Tank Production Model"]
["DATE:","2015-04-21",null,null,null,null,null,"X-Axis","Bin"]
[null,null,null,null,null,null,null,"Y-Axis","Percentage (%)"]
["Reference Link"]
[null,"Wikipedia"]
[null,"Wikieducator"]
[]
["Monte Carlo Simulation"]
[]
["max",10000]
["min",1]
["k",100,null,null,"Bins","Freq","Percentage"]
["Ave",{"$f":"AVERAGE(_Predictions)","v":10010.930510204076},null,null,9700,{"$f":"FREQUENCY(_Predictions,_bins)","v":0},{"$f":"F14/$F$35","v":0}]
[null,null,null,null,9730,1,{"$f":"F15/$F$35","v":0.01}]
["Sample Set","Max Val","Max Est",null,9760,1,0.01]
[1,{"$f":"RANDSamples(_min,_max,_k)","v":9741},{"$f":"(_k-1)/(_k-2)*(B17-1)","v":9839.3877551020396},null,9790,0,0]
[2,9720,9818.1734693877534,null,9820,2,0.02]
[3,9996,10096.989795918367,null,9850,4,0.04]
[4,9959,10059.612244897959,null,9880,1,0.01]
[5,9904,10004.051020408162,null,9910,5,0.05]
[6,9946,10046.479591836734,null,9940,6,0.06]
[7,9962,10062.642857142857,null,9970,7,7.0000000000000007E-2]
[8,9966,10066.683673469386,null,10000,7,7.0000000000000007E-2]
[9,9917,10017.183673469386,null,10030,9,0.09]
[10,9985,10085.877551020407,null,10060,17,0.17]
[11,9978,10078.806122448979,null,10090,34,0.34]
[12,9961,10061.632653061224,null,10120,6,0.06]
[13,9973,10073.755102040815,null,10150,0,0]
[14,9893,9992.9387755102034,null,10180,0,0]
[15,9951,10051.530612244896,null,10210,0,0]
[16,9986,10086.88775510204,null,10240,0,0]
[17,9987,10087.897959183672,null,10270,0,0]
[18,9909,10009.102040816326,null,10300,0,0]
[19,9722,9820.1938775510189,null,null,{"$f":"SUM(F14:F34)","v":100}]
[20,9897,9996.9795918367345]
[21,9966,10066.683673469386]
[22,9932,10032.336734693876]
[23,9853,9952.5306122448965]
[24,9997,10097.999999999998]
[25,9938,10038.397959183672]
[26,9977,10077.795918367347]
[27,9801,9899.9999999999982]
[28,9834,9933.3367346938758]
[29,9948,10048.499999999998]
[30,9868,9967.6836734693861]
[31,9951,10051.530612244896]
[32,9998,10099.010204081631]
[33,{"$f":"RANDSamples(_min,_max,_k)","v":9776},{"$f":"(_k-1)/(_k-2)*(B49-1)","v":9874.7448979591827}]
[34,9963,10063.65306122449]
[35,9968,10068.704081632652]
[36,9980,10080.826530612243]
[37,9891,9990.9183673469379]
[38,9645,9742.4081632653051]
[39,9982,10082.846938775509]
[40,9803,9902.0204081632637]
[41,9730,9828.275510204081]
[42,9911,10011.122448979591]
[43,9979,10079.816326530612]
[44,9981,10081.836734693876]
[45,9853,9952.5306122448965]
[46,9947,10047.489795918367]
[47,9971,10071.73469387755]
[48,9986,10086.88775510204]
[49,9921,10021.224489795917]
[50,9901,10001.020408163264]
[51,9959,10059.612244897959]
[52,9950,10050.520408163264]
[53,9823,9922.2244897959172]
[54,9627,9724.2244897959172]
[55,9868,9967.6836734693861]
[56,9975,10075.775510204081]
[57,9967,10067.693877551019]
[58,9978,10078.806122448979]
[59,9890,9989.9081632653051]
[60,9940,10040.418367346938]
[61,9996,10096.989795918367]
[62,9977,10077.795918367347]
[63,9816,9915.1530612244896]
[64,9986,10086.88775510204]
[65,{"$f":"RANDSamples(_min,_max,_k)","v":9951},{"$f":"(_k-1)/(_k-2)*(B81-1)","v":10051.530612244896}]
[66,9969,10069.714285714284]
[67,10000,10101.030612244896]
[68,9947,10047.489795918367]
[69,9892,9991.9285714285706]
[70,9973,10073.755102040815]
[71,9945,10045.469387755102]
[72,9917,10017.183673469386]
[73,9980,10080.826530612243]
[74,9919,10019.204081632652]
[75,9831,9930.3061224489793]
[76,9980,10080.826530612243]
[77,9967,10067.693877551019]
[78,9721,9819.1836734693861]
[79,9890,9989.9081632653051]
[80,9803,9902.0204081632637]
[81,9954,10054.561224489795]
[82,9804,9903.0306122448965]
[83,9741,9839.3877551020396]
[84,9867,9966.6734693877534]
[85,9996,10096.989795918367]
[86,9953,10053.551020408162]
[87,9957,10057.591836734693]
[88,9807,9906.0612244897948]
[89,9960,10060.622448979591]
[90,9859,9958.5918367346931]
[91,9968,10068.704081632652]
[92,9960,10060.622448979591]
[93,9833,9932.3265306122448]
[94,9883,9982.8367346938758]
[95,9855,9954.551020408162]
[96,9904,10004.051020408162]
[97,9811,{"$f":"(_k-1)/(_k-2)*(B113-1)","v":9910.1020408163258}]
[98,9981,10081.836734693876]
[99,9967,10067.693877551019]
[100,9980,10080.826530612243]