{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Histogram Generator ","Sample Data"],"not_rendered":{"charts":1,"images":6,"macros":1,"external_links":0,"defined_names":1,"comments":1,"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":"Histogram Generator ","index":0,"n_rows":207,"n_cols":19,"rows_kept":207,"cut":false,"hidden":false,"merged":[[5,6,6,6],[5,5,6,5],[5,3,6,3],[5,1,6,1],[5,0,6,0],[0,0,0,3],[2,0,3,7],[5,4,6,4],[5,2,6,2]]}
["Automatic Histogram Generator"]
[]
["Directions: Enter your data in the data column, in no particular order. Even though the observation numbers only go up to 200, you can enter as many as you want. Note that there is a maximum of 10 histogram intervals; the worksheet can be modified to increase the number of intervals."]
[null,null,null,null,null,null,null,null,null,{"$f":"IF($L$18<COUNT($B$8:$B$1007),\"WARNING: Not All Observations Included in Frequency Distribution\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Range","Freq"]
["Observation #","Data","Interval Number","Lower Limit",null,"Upper Limit","Frequency","Relative","Cumulative","Cum. Rel.","SD","Number of intervals",null,null,null,null,null,{"$f":"IF(ISNUMBER(D8),CONCATENATE(D8,\" ~ \",F8),\"\")","v":"2.8 ~ 2.949"},{"$f":"IF(H8=\"\",0,H8)","v":7.4999999999999997E-2}]
[null,null,null,null,null,null,null,"Frequency","Frequency","Frequency",{"$f":"STDEV(B8:B1007)","v":0.30841041229514327},8,null,{"$f":"$B$6","v":"Data"},{"$f":"$B$6","v":"Data"},null,null,"2.949 ~ 3.098",0.11]
["Observation 1",2.82,1,{"$f":"MIN(B8:B1007)","v":2.8},"< X <",{"$f":"ROUND(D8 + L$9,3)","v":2.9489999999999998},{"$f":"IF(ISBLANK(F8),\"\",P8)","v":15},{"$f":"IF(ISNUMBER(G8),G8/L$18,\"\")","v":7.4999999999999997E-2},{"$f":"IF(ISNUMBER(G8),G8,\"\")","v":15},{"$f":"IF(ISNUMBER(H8),H8,\"\")","v":7.4999999999999997E-2},null,null,{"$f":"IF(MAX(F8:F17)<MAX(B8:B207),\"WARNING: Maximum Score Not Included\",\"\")","v":""},{"$f":"CONCATENATE(\">=\",D8)","v":">=2.8"},{"$f":"CONCATENATE(\"<\",F8)","v":"<2.949"},{"$f":"DCOUNTA($B$6:$B$1006,1,N7:O8)","v":15},null,"3.098 ~ 3.247",0.14499999999999999]
["Observation 2",3.49,2,{"$f":"IF($F8>=MAX($B$8:$B1007),\"\",$F8)","v":2.9489999999999998},"< X <",{"$f":"IF(D9=\"\",\"\",IF(((MAX($B$8:B1007)-(F8+$L$9))/$L$7) <=0.01,MAX(B$8:B1007),ROUND(D9+$L$9,3)))","v":3.0979999999999999},{"$f":"IF(ISBLANK(F9),\"\",P10)","v":22},{"$f":"IF(ISNUMBER(G9),G9/L$18,\"\")","v":0.11},{"$f":"IF(ISNUMBER(G9),G9+I8,\"\")","v":37},{"$f":"IF(ISNUMBER(H9),H9+J8,\"\")","v":0.185},"Interval width = ",0.14900000393390656,{"$f":"IF(MIN(D8:D17)>MIN(B8:B207),\"WARNING: Minimum Score Not Included\",\"\")","v":""},{"$f":"$B$6","v":"Data"},{"$f":"$B$6","v":"Data"},null,null,"3.247 ~ 3.396",0.12]
["Observation 3",3.28,3,{"$f":"IF($F9>=MAX($B$8:$B1007),\"\",$F9)","v":3.0979999999999999},"< X <",{"$f":"IF(D10=\"\",\"\",IF(((MAX($B$8:B1008)-(F9+$L$9))/$L$7) <=0.01,MAX(B$8:B1008),ROUND(D10+$L$9,3)))","v":3.2469999999999999},{"$f":"IF(ISBLANK(F10),\"\",P12)","v":29},{"$f":"IF(ISNUMBER(G10),G10/L$18,\"\")","v":0.14499999999999999},66,0.32999999999999996,"(Select width rule:)",null,null,{"$f":"CONCATENATE(\">=\",D9)","v":">=2.949"},{"$f":"IF(F9=MAX(B8:B1007),CONCATENATE(\"<=\",F9),CONCATENATE(\"<\",F9))","v":"<3.098"},{"$f":"DCOUNTA($B$6:B1006,1,N9:O10)","v":22},null,"3.396 ~ 3.545",0.15]
["Observation 4",3.25,4,{"$f":"IF($F10>=MAX($B$8:$B1007),\"\",$F10)","v":3.2469999999999999},"< X <",{"$f":"IF(D11=\"\",\"\",IF(((MAX($B$8:B1009)-(F10+$L$9))/$L$7) <=0.01,MAX(B$8:B1009),ROUND(D11+$L$9,3)))","v":3.3959999999999999},{"$f":"IF(ISBLANK(F11),\"\",P14)","v":24},{"$f":"IF(ISNUMBER(G11),G11/L$18,\"\")","v":0.12},90,0.44999999999999996,"Scott's",null,{"$f":"IF(L18>COUNT(B8:B207),\"WARNING: Some Observations Are Double-Counted in Frequency Distribution\",\"\")","v":""},{"$f":"$B$6","v":"Data"},{"$f":"$B$6","v":"Data"},null,null,"3.545 ~ 3.694",0.17499999999999999]
["Observation 5",3.26,5,{"$f":"IF($F11>=MAX($B$8:$B1007),\"\",$F11)","v":3.3959999999999999},"< X <",{"$f":"IF(D12=\"\",\"\",IF(((MAX($B$8:B1010)-(F11+$L$9))/$L$7) <=0.01,MAX(B$8:B1010),ROUND(D12+$L$9,3)))","v":3.5449999999999999},{"$f":"IF(ISBLANK(F12),\"\",P16)","v":30},{"$f":"IF(ISNUMBER(G12),G12/L$18,\"\")","v":0.15},120,0.6,"Sturgis'",null,null,{"$f":"CONCATENATE(\">=\",D10)","v":">=3.098"},{"$f":"IF(F10=MAX(B8:B1005),CONCATENATE(\"<=\",F10),CONCATENATE(\"<\",F10))","v":"<3.247"},{"$f":"DCOUNTA(B$6:B$1006,1,N11:O12)","v":29},null,"3.694 ~ 3.843",0.15]
["Observation 6",2.87,6,{"$f":"IF($F12>=MAX($B$8:$B1007),\"\",$F12)","v":3.5449999999999999},"< X <",{"$f":"IF(D13=\"\",\"\",IF(((MAX($B$8:B1011)-(F12+$L$9))/$L$7) <=0.01,MAX(B$8:B1011),ROUND(D13+$L$9,3)))","v":3.694},{"$f":"IF(ISBLANK(F13),\"\",P18)","v":35},{"$f":"IF(ISNUMBER(G13),G13/L$18,\"\")","v":0.17499999999999999},155,0.77499999999999991,"Freedman-Diaconis",null,null,{"$f":"$B$6","v":"Data"},{"$f":"$B$6","v":"Data"},null,null,"3.843 ~ 3.99",7.4999999999999997E-2]
["Observation 7",3.16,7,{"$f":"IF($F13>=MAX($B$8:$B1007),\"\",$F13)","v":3.694},"< X <",{"$f":"IF(D14=\"\",\"\",IF(((MAX($B$8:B1012)-(F13+$L$9))/$L$7) <=0.01,MAX(B$8:B1012),ROUND(D14+$L$9,3)))","v":3.843},{"$f":"IF(ISBLANK(F14),\"\",P20)","v":30},{"$f":"IF(ISNUMBER(G14),G14/L$18,\"\")","v":0.15},185,0.92499999999999993,null,null,null,{"$f":"CONCATENATE(\">=\",D11)","v":">=3.247"},{"$f":"IF(F11=MAX(B8:B1005),CONCATENATE(\"<=\",F11),CONCATENATE(\"<\",F11))","v":"<3.396"},{"$f":"DCOUNTA(B$6:B$1006,1,N13:O14)","v":24},null,"",0]
["Observation 8",3.4,8,{"$f":"IF($F14>=MAX($B$8:$B1007),\"\",$F14)","v":3.843},"< X <",{"$f":"IF(D15=\"\",\"\",IF(((MAX($B$8:B1013)-(F14+$L$9))/$L$7) <=0.01,MAX(B$8:B1013),ROUND(D15+$L$9,3)))","v":3.99},{"$f":"IF(ISBLANK(F15),\"\",P22)","v":15},{"$f":"IF(ISNUMBER(G15),G15/L$18,\"\")","v":7.4999999999999997E-2},200,0.99999999999999989,null,null,null,{"$f":"$B$6","v":"Data"},{"$f":"$B$6","v":"Data"},null,null,"",0]
["Observation 9",2.84,9,{"$f":"IF($F15>=MAX($B$8:$B1007),\"\",$F15)","v":""},"< X <",{"$f":"IF(D16=\"\",\"\",IF(((MAX($B$8:B1014)-(F15+$L$9))/$L$7) <=0.01,MAX(B$8:B1014),ROUND(D16+$L$9,3)))","v":""},{"$f":"IF(ISBLANK(F16),\"\",P24)","v":0},{"$f":"IF(ISNUMBER(G16),G16/L$18,\"\")","v":0},200,0.99999999999999989,null,null,null,{"$f":"CONCATENATE(\">=\",D12)","v":">=3.396"},{"$f":"IF(F12=MAX(B$8:B$1005),CONCATENATE(\"<=\",F12),CONCATENATE(\"<\",F12))","v":"<3.545"},{"$f":"DCOUNTA(B$6:B$1006,1,N15:O16)","v":30}]
["Observation 10",3.72,10,{"$f":"IF($F16>=MAX($B$8:$B1007),\"\",$F16)","v":""},"< X <",{"$f":"IF(D17=\"\",\"\",IF(((MAX($B$8:B1015)-(F16+$L$9))/$L$7) <=0.01,MAX(B$8:B1015),ROUND(D17+$L$9,3)))","v":""},{"$f":"IF(ISBLANK(F17),\"\",P26)","v":0},{"$f":"IF(ISNUMBER(G17),G17/L$18,\"\")","v":0},200,0.99999999999999989,"Checks:",null,null,{"$f":"$B$6","v":"Data"},{"$f":"$B$6","v":"Data"}]
["Observation 11",3.22,null,null,null,null,null,null,null,null,"1. Sample Size =",{"$f":"SUM(G$8:G$17)","v":200},null,{"$f":"CONCATENATE(\">=\",D13)","v":">=3.545"},{"$f":"IF(F13=MAX(B16:B1013),CONCATENATE(\"<=\",F13),CONCATENATE(\"<\",F13))","v":"<3.694"},{"$f":"DCOUNTA(B$6:B$1006,1,N17:O18)","v":35}]
["Observation 12",3.44,null,null,null,null,null,null,null,null,"2. Frequency Sum =",{"$f":"SUM(H$8:H$17)","v":0.99999999999999989},null,{"$f":"$B$6","v":"Data"},{"$f":"$B$6","v":"Data"}]
["Observation 13",3.65,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\">=\",D14)","v":">=3.694"},{"$f":"IF(F14=MAX(B8:B1005),CONCATENATE(\"<=\",F14),CONCATENATE(\"<\",F14))","v":"<3.843"},{"$f":"DCOUNTA(B$6:B$1006,1,N19:O20)","v":30}]
["Observation 14",3.02,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$B$6","v":"Data"},{"$f":"$B$6","v":"Data"}]
["Observation 15",3.03,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\">=\",D15)","v":">=3.843"},{"$f":"IF(F15=MAX(B8:B1005),CONCATENATE(\"<=\",F15),CONCATENATE(\"<\",F15))","v":"<=3.99"},{"$f":"DCOUNTA(B$6:B$1006,1,N21:O22)","v":15}]
["Observation 16",3.8,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$B$6","v":"Data"},{"$f":"$B$6","v":"Data"}]
["Observation 17",3.23,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\">=\",D16)","v":">="},{"$f":"IF(F16=MAX(B8:B1005),CONCATENATE(\"<=\",F16),CONCATENATE(\"<\",F16))","v":"<"},{"$f":"DCOUNTA(B$6:B$1006,1,N23:O24)","v":0}]
["Observation 18",3.26,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$B$6","v":"Data"},{"$f":"$B$6","v":"Data"}]
["Observation 19",3.53,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\">=\",D17)","v":">="},{"$f":"IF(F17=MAX(B8:B1005),CONCATENATE(\"<=\",F17),CONCATENATE(\"<\",F17))","v":"<"},{"$f":"DCOUNTA(B$6:B$1006,1,N25:O26)","v":0}]
["Observation 20",3.75]
["Observation 21",3.15]
["Observation 22",3.66]
["Observation 23",3.36]
["Observation 24",3.79]
["Observation 25",2.85]
["Observation 26",3.74]
["Observation 27",3.23]
["Observation 28",3.52]
["Observation 29",3.32]
["Observation 30",2.89]
["Observation 31",2.83]
["Observation 32",2.93]
["Observation 33",3.71]
["Observation 34",3.47]
["Observation 35",3.52]
["Observation 36",2.83]
["Observation 37",3.64]
["Observation 38",2.96]
["Observation 39",3.59]
["Observation 40",3.33]
["Observation 41",3.38]
["Observation 42",3.44]
["Observation 43",3.31]
["Observation 44",3.03]
["Observation 45",3.26]
["Observation 46",3.04]
["Observation 47",2.98]
["Observation 48",2.8]
["Observation 49",3.75]
["Observation 50",3.64]
["Observation 51",3.65]
["Observation 52",3.18]
["Observation 53",3.44]
["Observation 54",3.06]
["Observation 55",3.51]
["Observation 56",3.33]
["Observation 57",2.81]
["Observation 58",3.64]
["Observation 59",3.05]
["Observation 60",2.85]
["Observation 61",3.56]
["Observation 62",2.92]
["Observation 63",3.35]
["Observation 64",3.46]
["Observation 65",3.59]
["Observation 66",3.11]
["Observation 67",3.65]
["Observation 68",3.17]
["Observation 69",2.97]
["Observation 70",3.77]
["Observation 71",3.21]
["Observation 72",3.17]
["Observation 73",3.65]
["Observation 74",2.94]
["Observation 75",3.53]
["Observation 76",3.65]
["Observation 77",3.61]
["Observation 78",3.7]
["Observation 79",2.91]
["Observation 80",3.09]
["Observation 81",3.77]
["Observation 82",3.79]
["Observation 83",3.59]
["Observation 84",3.38]
["Observation 85",3.57]
["Observation 86",2.97]
["Observation 87",3.44]
["Observation 88",3.64]
["Observation 89",3.48]
["Observation 90",2.99]
["Observation 91",3.73]
["Observation 92",2.91]
["Observation 93",3.78]
["Observation 94",3.4]
["Observation 95",3.13]
["Observation 96",3.14]
["Observation 97",3.24]
["Observation 98",3.56]
["Observation 99",3.16]
["Observation 100",3.53]
["Observation 101",3.01]
["Observation 102",3.3]
["Observation 103",3.62]
["Observation 104",3.21]
["Observation 105",3.39]
["Observation 106",3.65]
["Observation 107",3.47]
["Observation 108",3.44]
["Observation 109",3.88]
["Observation 110",3.83]
["Observation 111",3.53]
["Observation 112",3.22]
["Observation 113",3.56]
["Observation 114",3.2]
["Observation 115",3.17]
["Observation 116",3.41]
["Observation 117",3.56]
["Observation 118",3.34]
["Observation 119",3.44]
["Observation 120",3.76]
["Observation 121",3.55]
["Observation 122",3.88]
["Observation 123",3.31]
["Observation 124",3.09]
["Observation 125",3.82]
["Observation 126",3.01]
["Observation 127",3.66]
["Observation 128",3.64]
["Observation 129",3.59]
["Observation 130",3.49]
["Observation 131",3.13]
["Observation 132",3.83]
["Observation 133",3.04]
["Observation 134",3.91]
["Observation 135",3.56]
["Observation 136",3.96]
["Observation 137",3.46]
["Observation 138",3.22]
["Observation 139",3.27]
["Observation 140",3.43]
["Observation 141",3.85]
["Observation 142",3.89]
["Observation 143",3.37]
["Observation 144",3.32]
["Observation 145",3.54]
["Observation 146",3.8]
["Observation 147",3.74]
["Observation 148",3.17]
["Observation 149",3.27]
["Observation 150",3.32]
["Observation 151",3.56]
["Observation 152",3.95]
["Observation 153",3.56]
["Observation 154",3.79]
["Observation 155",3.93]
["Observation 156",3.79]
["Observation 157",3.71]
["Observation 158",3.05]
["Observation 159",3.22]
["Observation 160",3.85]
["Observation 161",3.82]
["Observation 162",3.23]
["Observation 163",3.56]
["Observation 164",3.53]
["Observation 165",3.62]
["Observation 166",3.8]
["Observation 167",3.47]
["Observation 168",3.64]
["Observation 169",3.03]
["Observation 170",3.17]
["Observation 171",3.22]
["Observation 172",3.92]
["Observation 173",3.82]
["Observation 174",3.26]
["Observation 175",3.8]
["Observation 176",3.2]
["Observation 177",3.46]
["Observation 178",3.67]
["Observation 179",3.06]
["Observation 180",3.66]
["Observation 181",3.96]
["Observation 182",3.75]
["Observation 183",3.83]
["Observation 184",3.22]
["Observation 185",3.36]
["Observation 186",3.21]
["Observation 187",3.02]
["Observation 188",3.99]
["Observation 189",3.07]
["Observation 190",3.65]
["Observation 191",3.67]
["Observation 192",3.06]
["Observation 193",3.98]
["Observation 194",3.93]
["Observation 195",3.41]
["Observation 196",3.43]
["Observation 197",3.7]
["Observation 198",3.76]
["Observation 199",3.9]
["Observation 200",3.23]

{"sheet":"Sample Data","index":1,"n_rows":203,"n_cols":3,"rows_kept":203,"cut":false,"hidden":false,"merged":[]}
["This is a set of 200 observations for use in trying out the Histogram Generator."]
["Copy the DATA into columns B8:B207 in the Histogram Generator."]
["N",null,"DATA"]
[1,null,2.82]
[2,null,3.49]
[3,null,3.28]
[4,null,3.25]
[5,null,3.26]
[6,null,2.87]
[7,null,3.16]
[8,null,3.4]
[9,null,2.84]
[10,null,3.72]
[11,null,3.22]
[12,null,3.44]
[13,null,3.65]
[14,null,3.02]
[15,null,3.03]
[16,null,3.8]
[17,null,3.23]
[18,null,3.26]
[19,null,3.53]
[20,null,3.75]
[21,null,3.15]
[22,null,3.66]
[23,null,3.36]
[24,null,3.79]
[25,null,2.85]
[26,null,3.74]
[27,null,3.23]
[28,null,3.52]
[29,null,3.32]
[30,null,2.89]
[31,null,2.83]
[32,null,2.93]
[33,null,3.71]
[34,null,3.47]
[35,null,3.52]
[36,null,2.83]
[37,null,3.64]
[38,null,2.96]
[39,null,3.59]
[40,null,3.33]
[41,null,3.38]
[42,null,3.44]
[43,null,3.31]
[44,null,3.03]
[45,null,3.26]
[46,null,3.04]
[47,null,2.98]
[48,null,2.8]
[49,null,3.75]
[50,null,3.64]
[51,null,3.65]
[52,null,3.18]
[53,null,3.44]
[54,null,3.06]
[55,null,3.51]
[56,null,3.33]
[57,null,2.81]
[58,null,3.64]
[59,null,3.05]
[60,null,2.85]
[61,null,3.56]
[62,null,2.92]
[63,null,3.35]
[64,null,3.46]
[65,null,3.59]
[66,null,3.11]
[67,null,3.65]
[68,null,3.17]
[69,null,2.97]
[70,null,3.77]
[71,null,3.21]
[72,null,3.17]
[73,null,3.65]
[74,null,2.94]
[75,null,3.53]
[76,null,3.65]
[77,null,3.61]
[78,null,3.7]
[79,null,2.91]
[80,null,3.09]
[81,null,3.77]
[82,null,3.79]
[83,null,3.59]
[84,null,3.38]
[85,null,3.57]
[86,null,2.97]
[87,null,3.44]
[88,null,3.64]
[89,null,3.48]
[90,null,2.99]
[91,null,3.73]
[92,null,2.91]
[93,null,3.78]
[94,null,3.4]
[95,null,3.13]
[96,null,3.14]
[97,null,3.24]
[98,null,3.56]
[99,null,3.16]
[100,null,3.53]
[101,null,3.01]
[102,null,3.3]
[103,null,3.62]
[104,null,3.21]
[105,null,3.39]
[106,null,3.65]
[107,null,3.47]
[108,null,3.44]
[109,null,3.88]
[110,null,3.83]
[111,null,3.53]
[112,null,3.22]
[113,null,3.56]
[114,null,3.2]
[115,null,3.17]
[116,null,3.41]
[117,null,3.56]
[118,null,3.34]
[119,null,3.44]
[120,null,3.76]
[121,null,3.55]
[122,null,3.88]
[123,null,3.31]
[124,null,3.09]
[125,null,3.82]
[126,null,3.01]
[127,null,3.66]
[128,null,3.64]
[129,null,3.59]
[130,null,3.49]
[131,null,3.13]
[132,null,3.83]
[133,null,3.04]
[134,null,3.91]
[135,null,3.56]
[136,null,3.96]
[137,null,3.46]
[138,null,3.22]
[139,null,3.27]
[140,null,3.43]
[141,null,3.85]
[142,null,3.89]
[143,null,3.37]
[144,null,3.32]
[145,null,3.54]
[146,null,3.8]
[147,null,3.74]
[148,null,3.17]
[149,null,3.27]
[150,null,3.32]
[151,null,3.56]
[152,null,3.95]
[153,null,3.56]
[154,null,3.79]
[155,null,3.93]
[156,null,3.79]
[157,null,3.71]
[158,null,3.05]
[159,null,3.22]
[160,null,3.85]
[161,null,3.82]
[162,null,3.23]
[163,null,3.56]
[164,null,3.53]
[165,null,3.62]
[166,null,3.8]
[167,null,3.47]
[168,null,3.64]
[169,null,3.03]
[170,null,3.17]
[171,null,3.22]
[172,null,3.92]
[173,null,3.82]
[174,null,3.26]
[175,null,3.8]
[176,null,3.2]
[177,null,3.46]
[178,null,3.67]
[179,null,3.06]
[180,null,3.66]
[181,null,3.96]
[182,null,3.75]
[183,null,3.83]
[184,null,3.22]
[185,null,3.36]
[186,null,3.21]
[187,null,3.02]
[188,null,3.99]
[189,null,3.07]
[190,null,3.65]
[191,null,3.67]
[192,null,3.06]
[193,null,3.98]
[194,null,3.93]
[195,null,3.41]
[196,null,3.43]
[197,null,3.7]
[198,null,3.76]
[199,null,3.9]
[200,null,3.23]