{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Input","Tables","Graphs"],"not_rendered":{"charts":2,"images":4,"macros":1,"external_links":0,"defined_names":1,"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":"Input","index":0,"n_rows":201,"n_cols":1,"rows_kept":201,"cut":false,"hidden":false,"merged":[]}
["Data Input"]
[58.459999999999994]
[18.3]
[1162.6499999999999]
[59.05]
[74.05]
[55.83]
[64.95]
[60.23]
[139.05000000000001]
[64.95]
[39.61]
[44.89]
[50.79]
[61.41]
[29.55]
[62.589999999999996]
[77.929999999999993]
[28.13]
[60.23]
[47.25]
[54.69]
[55.51]
[60.23]
[56.69]
[62.589999999999996]
[52.05]
[17.05]
[41.629999999999995]
[64.95]
[37.809999999999995]
[30.970000000000002]
[12.850000000000001]
[10.850000000000001]
[44.61]
[30.970000000000002]
[62.589999999999996]
[53.15]
[57.87]
[59.05]
[53.15]
[41.349999999999994]
[64.95]
[51.97]
[67.31]
[72.03]
[148.85000000000002]
[72.03]
[67.31]
[51.89]
[401.65000000000003]
[143.85000000000002]
[69.67]
[10.850000000000001]
[54.33]
[60.23]
[69.67]
[56.69]
[22.77]
[57.87]
[55.51]
[54.33]
[48.43]
[59.05]
[21.77]
[22.28]
[21.77]
[22.05]
[18.77]
[60.82]
[38.449999999999996]
[40.049999999999997]
[67.649999999999991]
[55.65]
[15.510000000000002]
[15.05]
[12.05]
[12.850000000000001]
[22.85]
[15.17]
[13.850000000000001]
[11.850000000000001]
[18.010000000000002]
[21.330000000000002]
[20.53]
[110.63]
[92.89]
[141.93]
[223.89000000000001]
[110.63]
[40.01]
[141.85000000000002]
[40.01]
[71.05]
[106.05]
[63.769999999999996]
[131.35000000000002]
[37.049999999999997]
[35.489999999999995]
[105.36999999999999]
[69.67]
[57.87]
[27.05]
[172.61]
[50.57]
[73.209999999999994]
[49.61]
[31.91]
[20.330000000000002]
[61.41]
[63.769999999999996]
[48.43]
[19.490000000000002]
[12.42]
[12.42]
[12.05]
[14.05]
[94.97]
[88.55]
[60.23]
[81.47]
[60.23]
[60.23]
[435.09000000000003]
[68.09]
[24.650000000000002]
[56.449999999999996]
[56.449999999999996]
[56.449999999999996]
[56.449999999999996]
[63.769999999999996]
[16.010000000000002]
[29.970000000000002]
[41.349999999999994]
[59.05]
[51.97]
[63.769999999999996]
[21.41]
[49.73]
[195.89000000000001]
[217.13000000000002]
[828.05]
[129.13000000000002]
[25.05]
[50.41]
[114.33]
[42.61]
[51.25]
[323.05]
[43.25]
[35.209999999999994]
[115.25]
[15.370000000000001]
[13.850000000000001]
[73.77]
[94.97]
[183.65]
[241.05]
[166.37]
[27.05]
[142.93]
[88.649999999999991]
[116.17]
[16.05]
[62.97]
[19.490000000000002]
[252.65]
[115.09]
[90.89]
[11.930000000000001]
[100.28999999999999]
[128.21]
[28.89]
[42.69]
[26.89]
[197.04000000000002]
[63.97]
[14.05]
[107.69]
[53.33]
[20.330000000000002]
[34.209999999999994]
[32.049999999999997]
[31.55]
[50.449999999999996]
[36.769999999999996]
[92.81]
[228.11]
[239.97]
[46.05]
[267.61]
[140.61000000000001]
[63.75]
[113.09]
[110.05]
[122.64999999999999]
[50.05]
[65.05]
[20.05]
[48.05]
[112.83]

{"sheet":"Tables","index":1,"n_rows":202,"n_cols":16,"rows_kept":202,"cut":false,"hidden":false,"merged":[[0,6,0,14],[11,6,11,15]]}
["Total Obs:",200,null,null,null,null,"1st Digit Summary"]
["Data Input","Conversion","1st Digit","2nd Digit",null,null,1,2,3,4,5,6,7,8,9]
[58.459999999999994,{"$f":"IFERROR(ABS(A3*1000),\"-\")","v":58459.999999999993},{"$f":"IFERROR(LEFT(B3,1),\"-\")","v":"5"},{"$f":"IFERROR(LEFT(B3,2)-10*C3,\"-\")","v":8},null,"Digit Counts",{"$f":"COUNTIF(C3:C202,1)","v":56},{"$f":"COUNTIF(C3:C202,2)","v":28},{"$f":"COUNTIF(C3:C202,3)","v":14},{"$f":"COUNTIF(C3:C202,4)","v":20},{"$f":"COUNTIF(C3:C202,5)","v":34},{"$f":"COUNTIF(C3:C202,6)","v":32},{"$f":"COUNTIF(C3:C202,7)","v":7},{"$f":"COUNTIF(C3:C202,8)","v":4},{"$f":"COUNTIF(C3:C202,9)","v":5}]
[18.3,18300,"1",8,null,"Sample %",{"$f":"G3/$B$1","v":0.28000000000000003},0.14000000000000001,7.0000000000000007E-2,0.1,0.17,0.16,3.5000000000000003E-2,0.02,2.5000000000000001E-2]
[1162.6499999999999,1162649.9999999998,"1",1,null,"Benford %",0.30102999566398098,0.17609125905568099,0.1249387366083,9.6910013008056003E-2,7.9181246047624998E-2,6.6946789630612999E-2,5.7991946977687003E-2,5.1152522447380999E-2,4.5757490560674997E-2]
[59.05,59050,"5",9,null,"Absolute Deviation",{"$f":"ABS(G4-G5)","v":2.1029995663980949E-2},3.6091259055680974E-2,5.4938736608299996E-2,3.0899869919440021E-3,9.0818753952375014E-2,9.3053210369387004E-2,2.2991946977687E-2,3.1152522447380999E-2,2.0757490560674996E-2]
[74.05,74050,"7",4,null,"Mean Absolute Deviation",{"$f":"AVERAGE(G6:O6)","v":4.1547100291934549E-2}]
[55.83,55830,"5",5,null,"Standard Deviation",{"$f":"(G5*(1-G5)/B1)^(1/2)","v":3.2435392503754643E-2},{"$f":"(H5*(1-H5)/B1)^(1/2)","v":2.6933541128105122E-2},{"$f":"(I5*(1-I5)/B1)^(1/2)","v":2.3380445750992625E-2},{"$f":"(J5*(1-J5)/B1)^(1/2)","v":2.0918707224256764E-2},{"$f":"(K5*(1-K5)/B1)^(1/2)","v":1.9093398901448958E-2},{"$f":"(L5*(1-L5)/B1)^(1/2)","v":1.7672707346183189E-2},{"$f":"(M5*(1-M5)/B1)^(1/2)","v":1.6527080967827342E-2},{"$f":"(N5*(1-N5)/B1)^(1/2)","v":1.557818055721707E-2},{"$f":"(O5*(1-O5)/B1)^(1/2)","v":1.4775612105470409E-2}]
[64.95,64950,"6",4,null,"Z-Statistic",{"$f":"(G6-1/(2*B1))/G8","v":0.57128939203790929},{"$f":"(H6-1/(2*B1))/H8","v":1.2471905901979048},{"$f":"(I6-1/(2*B1))/I8","v":2.2428458878323005},{"$f":"(J6-1/(2*B1))/J8","v":2.8203797950758121E-2},{"$f":"(K6-1/(2*B1))/K8","v":4.6256171783889499},{"$f":"(L6-1/(2*B1))/L8","v":5.1239014258301498},{"$f":"(M6-1/(2*B1))/M8","v":1.239901166913741},{"$f":"(N6-1/(2*B1))/N8","v":1.8392727149453176},{"$f":"(O6-1/(2*B1))/O8","v":1.2356503697004528}]
[60.23,60230,"6",0,null,"Chi-Square Test",60.826763298515885]
[139.05000000000001,139050,"1",3,null,"P-Value",{"$f":"(1-_xlfn.NORM.S.DIST(G9,TRUE))*2","v":0.56780349124633633},0.21232762236515912,2.4906754212664861E-2,0.97749960810390224,3.734845789526986E-6,2.9927748701474854E-7,0.2150119522337044,6.587508413982035E-2,0.21658855308026315]
[64.95,64950,"6",4,null,null,"2nd Digit Summary"]
[39.61,39610,"3",9,null,null,0,1,2,3,4,5,6,7,8,9]
[44.89,44890,"4",4,null,"Digit Counts",{"$f":"COUNTIF(D3:D202,0)","v":30},{"$f":"COUNTIF(D3:D202,1)","v":30},{"$f":"COUNTIF(D3:D202,2)","v":29},{"$f":"COUNTIF(D3:D202,3)","v":18},{"$f":"COUNTIF(D3:D202,4)","v":23},{"$f":"COUNTIF(D3:D202,5)","v":13},{"$f":"COUNTIF(D3:D202,6)","v":13},{"$f":"COUNTIF(D3:D202,7)","v":14},{"$f":"COUNTIF(D3:D202,8)","v":14},{"$f":"COUNTIF(D3:D202,9)","v":16}]
[50.79,50790,"5",0,null,"Sample %",{"$f":"G14/$B$1","v":0.15},0.15,0.14499999999999999,0.09,0.115,6.5000000000000002E-2,6.5000000000000002E-2,7.0000000000000007E-2,7.0000000000000007E-2,0.08]
[61.41,61410,"6",1,null,"Benford %",0.11967926859688099,0.113890103407556,0.108821499005508,0.104329560230959,0.100308202267579,9.6677235802322403E-2,9.3374735783036206E-2,9.0351989269603306E-2,8.7570053578861398E-2,8.4997352057692196E-2]
[29.55,29550,"2",9,null,"Absolute Deviation",{"$f":"ABS(G16-G15)","v":3.0320731403119E-2},3.6109896592443999E-2,3.6178500994491991E-2,1.4329560230959007E-2,1.4691797732421005E-2,3.1677235802322401E-2,2.8374735783036203E-2,2.0351989269603299E-2,1.7570053578861392E-2,4.9973520576921948E-3]
[62.589999999999996,62589.999999999993,"6",2,null,"Mean Absolute Deviation",{"$f":"AVERAGE(G17:P17)","v":2.3460185344495049E-2}]
[77.929999999999993,77929.999999999985,"7",7,null,"Standard Deviation",{"$f":"(G16*(1-G16)/B1)^(1/2)","v":2.2951703778259752E-2},{"$f":"(H16*(1-H16)/B1)^(1/2)","v":2.2463208559038512E-2},{"$f":"(I16*(1-I16)/B1)^(1/2)","v":2.2020374697050711E-2},{"$f":"(J16*(1-J16)/B1)^(1/2)","v":2.1615376829120247E-2},{"$f":"(K16*(1-K16)/B1)^(1/2)","v":2.1242229970676981E-2},{"$f":"(L16*(1-L16)/B1)^(1/2)","v":2.089626137374154E-2},{"$f":"(M16*(1-M16)/B1)^(1/2)","v":2.057375688838628E-2},{"$f":"(N16*(1-N16)/B1)^(1/2)","v":2.0271717651031546E-2},{"$f":"(O16*(1-O16)/B1)^(1/2)","v":1.9987688622631776E-2},{"$f":"(P16*(1-P16)/B1)^(1/2)","v":1.9719635164078583E-2}]
[28.13,28130,"2",8,null,"Z-Statistic",{"$f":"(G17-1/(2*B1))/G19","v":1.2121423172719437},{"$f":"(H17-1/(2*B1))/H19","v":1.4962197632679859},{"$f":"(I17-1/(2*B1))/I19","v":1.5294245196927871},{"$f":"(J17-1/(2*B1))/J19","v":0.54727522561726594},{"$f":"(K17-1/(2*B1))/K19","v":0.5739415188165603},{"$f":"(L17-1/(2*B1))/L19","v":1.3962897611429583},{"$f":"(M17-1/(2*B1))/M19","v":1.2576573118564596},{"$f":"(N17-1/(2*B1))/N19","v":0.88063525631706319},{"$f":"(O17-1/(2*B1))/O19","v":0.75396679743138395},{"$f":"(P17-1/(2*B1))/P19","v":0.126642913873041}]
[60.23,60230,"6",0,null,"Chi-Square Test",12.53676365000897]
[47.25,47250,"4",7,null,"P-Value",{"$f":"(1-_xlfn.NORM.S.DIST(G20,TRUE))*2","v":0.22545790741046567},0.13459639604215257,0.12615923774558557,0.58418966160602603,0.56600737607108664,0.1626272558140136,0.20851571675469249,0.37851526965077675,0.45086915900580382,{"$f":"(1-_xlfn.NORM.S.DIST(P20,TRUE))","v":0.44961151500745034}]
[54.69,54690,"5",4]
[55.51,55510,"5",5]
[60.23,60230,"6",0]
[56.69,56690,"5",6,null,"Note: Italics indicates significance at 5%; bold italics indicates significance at 1%."]
[62.589999999999996,62589.999999999993,"6",2]
[52.05,52050,"5",2]
[17.05,17050,"1",7]
[41.629999999999995,41629.999999999993,"4",1]
[64.95,64950,"6",4]
[37.809999999999995,37809.999999999993,"3",7]
[30.970000000000002,30970.000000000004,"3",0]
[12.850000000000001,12850.000000000002,"1",2]
[10.850000000000001,{"$f":"IFERROR(ABS(A35*1000),\"-\")","v":10850.000000000002},{"$f":"IFERROR(LEFT(B35,1),\"-\")","v":"1"},{"$f":"IFERROR(LEFT(B35,2)-10*C35,\"-\")","v":0}]
[44.61,44610,"4",4]
[30.970000000000002,30970.000000000004,"3",0]
[62.589999999999996,62589.999999999993,"6",2]
[53.15,53150,"5",3]
[57.87,57870,"5",7]
[59.05,59050,"5",9]
[53.15,53150,"5",3]
[41.349999999999994,41349.999999999993,"4",1]
[64.95,64950,"6",4]
[51.97,51970,"5",1]
[67.31,67310,"6",7]
[72.03,72030,"7",2]
[148.85000000000002,148850.00000000003,"1",4]
[72.03,72030,"7",2]
[67.31,67310,"6",7]
[51.89,51890,"5",1]
[401.65000000000003,401650.00000000006,"4",0]
[143.85000000000002,143850.00000000003,"1",4]
[69.67,69670,"6",9]
[10.850000000000001,10850.000000000002,"1",0]
[54.33,54330,"5",4]
[60.23,60230,"6",0]
[69.67,69670,"6",9]
[56.69,56690,"5",6]
[22.77,22770,"2",2]
[57.87,57870,"5",7]
[55.51,55510,"5",5]
[54.33,54330,"5",4]
[48.43,48430,"4",8]
[59.05,59050,"5",9]
[21.77,21770,"2",1]
[22.28,{"$f":"IFERROR(ABS(A67*1000),\"-\")","v":22280},{"$f":"IFERROR(LEFT(B67,1),\"-\")","v":"2"},{"$f":"IFERROR(LEFT(B67,2)-10*C67,\"-\")","v":2}]
[21.77,21770,"2",1]
[22.05,22050,"2",2]
[18.77,18770,"1",8]
[60.82,60820,"6",0]
[38.449999999999996,38449.999999999993,"3",8]
[40.049999999999997,40050,"4",0]
[67.649999999999991,67649.999999999985,"6",7]
[55.65,55650,"5",5]
[15.510000000000002,15510.000000000002,"1",5]
[15.05,15050,"1",5]
[12.05,12050,"1",2]
[12.850000000000001,12850.000000000002,"1",2]
[22.85,22850,"2",2]
[15.17,15170,"1",5]
[13.850000000000001,13850.000000000002,"1",3]
[11.850000000000001,11850.000000000002,"1",1]
[18.010000000000002,18010,"1",8]
[21.330000000000002,21330.000000000004,"2",1]
[20.53,20530,"2",0]
[110.63,110630,"1",1]
[92.89,92890,"9",2]
[141.93,141930,"1",4]
[223.89000000000001,223890.00000000003,"2",2]
[110.63,110630,"1",1]
[40.01,40010,"4",0]
[141.85000000000002,141850.00000000003,"1",4]
[40.01,40010,"4",0]
[71.05,71050,"7",1]
[106.05,106050,"1",0]
[63.769999999999996,63769.999999999993,"6",3]
[131.35000000000002,131350.00000000003,"1",3]
[37.049999999999997,{"$f":"IFERROR(ABS(A99*1000),\"-\")","v":37050},{"$f":"IFERROR(LEFT(B99,1),\"-\")","v":"3"},{"$f":"IFERROR(LEFT(B99,2)-10*C99,\"-\")","v":7}]
[35.489999999999995,35489.999999999993,"3",5]
[105.36999999999999,105369.99999999999,"1",0]
[69.67,69670,"6",9]
[57.87,57870,"5",7]
[27.05,27050,"2",7]
[172.61,172610,"1",7]
[50.57,50570,"5",0]
[73.209999999999994,73210,"7",3]
[49.61,49610,"4",9]
[31.91,31910,"3",1]
[20.330000000000002,20330.000000000004,"2",0]
[61.41,61410,"6",1]
[63.769999999999996,63769.999999999993,"6",3]
[48.43,48430,"4",8]
[19.490000000000002,19490.000000000004,"1",9]
[12.42,12420,"1",2]
[12.42,12420,"1",2]
[12.05,12050,"1",2]
[14.05,14050,"1",4]
[94.97,94970,"9",4]
[88.55,88550,"8",8]
[60.23,60230,"6",0]
[81.47,81470,"8",1]
[60.23,60230,"6",0]
[60.23,60230,"6",0]
[435.09000000000003,435090.00000000006,"4",3]
[68.09,68090,"6",8]
[24.650000000000002,24650.000000000004,"2",4]
[56.449999999999996,56449.999999999993,"5",6]
[56.449999999999996,56449.999999999993,"5",6]
[56.449999999999996,56449.999999999993,"5",6]
[56.449999999999996,{"$f":"IFERROR(ABS(A131*1000),\"-\")","v":56449.999999999993},{"$f":"IFERROR(LEFT(B131,1),\"-\")","v":"5"},{"$f":"IFERROR(LEFT(B131,2)-10*C131,\"-\")","v":6}]
[63.769999999999996,63769.999999999993,"6",3]
[16.010000000000002,16010.000000000002,"1",6]
[29.970000000000002,29970.000000000004,"2",9]
[41.349999999999994,41349.999999999993,"4",1]
[59.05,59050,"5",9]
[51.97,51970,"5",1]
[63.769999999999996,63769.999999999993,"6",3]
[21.41,21410,"2",1]
[49.73,49730,"4",9]
[195.89000000000001,195890.00000000003,"1",9]
[217.13000000000002,217130.00000000003,"2",1]
[828.05,828050,"8",2]
[129.13000000000002,129130.00000000003,"1",2]
[25.05,25050,"2",5]
[50.41,50410,"5",0]
[114.33,114330,"1",1]
[42.61,42610,"4",2]
[51.25,51250,"5",1]
[323.05,323050,"3",2]
[43.25,43250,"4",3]
[35.209999999999994,35209.999999999993,"3",5]
[115.25,115250,"1",1]
[15.370000000000001,15370.000000000002,"1",5]
[13.850000000000001,13850.000000000002,"1",3]
[73.77,73770,"7",3]
[94.97,94970,"9",4]
[183.65,183650,"1",8]
[241.05,241050,"2",4]
[166.37,166370,"1",6]
[27.05,27050,"2",7]
[142.93,142930,"1",4]
[88.649999999999991,{"$f":"IFERROR(ABS(A163*1000),\"-\")","v":88649.999999999985},{"$f":"IFERROR(LEFT(B163,1),\"-\")","v":"8"},{"$f":"IFERROR(LEFT(B163,2)-10*C163,\"-\")","v":8}]
[116.17,116170,"1",1]
[16.05,16050,"1",6]
[62.97,62970,"6",2]
[19.490000000000002,19490.000000000004,"1",9]
[252.65,252650,"2",5]
[115.09,115090,"1",1]
[90.89,90890,"9",0]
[11.930000000000001,11930.000000000002,"1",1]
[100.28999999999999,100289.99999999999,"1",0]
[128.21,128210.00000000001,"1",2]
[28.89,28890,"2",8]
[42.69,42690,"4",2]
[26.89,26890,"2",6]
[197.04000000000002,197040.00000000003,"1",9]
[63.97,63970,"6",3]
[14.05,14050,"1",4]
[107.69,107690,"1",0]
[53.33,53330,"5",3]
[20.330000000000002,20330.000000000004,"2",0]
[34.209999999999994,34209.999999999993,"3",4]
[32.049999999999997,32049.999999999996,"3",2]
[31.55,31550,"3",1]
[50.449999999999996,50449.999999999993,"5",0]
[36.769999999999996,36769.999999999993,"3",6]
[92.81,92810,"9",2]
[228.11,228110,"2",2]
[239.97,239970,"2",3]
[46.05,46050,"4",6]
[267.61,267610,"2",6]
[140.61000000000001,140610,"1",4]
[63.75,63750,"6",3]
[113.09,{"$f":"IFERROR(ABS(A195*1000),\"-\")","v":113090},{"$f":"IFERROR(LEFT(B195,1),\"-\")","v":"1"},{"$f":"IFERROR(LEFT(B195,2)-10*C195,\"-\")","v":1}]
[110.05,110050,"1",1]
[122.64999999999999,122649.99999999999,"1",2]
[50.05,50050,"5",0]
[65.05,65050,"6",5]
[20.05,20050,"2",0]
[48.05,48050,"4",8]
[112.83,112830,"1",1]

{"sheet":"Graphs","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}