{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["typing_data"],"not_rendered":{"charts":3,"images":0,"macros":0,"external_links":1,"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":"typing_data","index":0,"n_rows":75,"n_cols":16,"rows_kept":75,"cut":false,"hidden":false,"merged":[]}
["brand","speed"]
["REGAL",70]
["SPEEDYTYPE",87]
["SPEEDYTYPE",79]
["REGAL",73]
["SPEEDYTYPE",77]
["REGAL",72]
["WORD-O-MATIC",62]
["REGAL",71]
["WORD-O-MATIC",77]
["SPEEDYTYPE",80,null,null,null,null,null,null,null,null,"Bin","Frequency"]
["REGAL",72,null,null,null,null,null,null,null,null,61,1]
["WORD-O-MATIC",66,null,null,null,null,null,null,null,null,67.5,3]
["SPEEDYTYPE",81,null,null,null,null,null,null,null,null,74,7]
["REGAL",68,null,null,null,null,null,null,null,null,80.5,4]
["WORD-O-MATIC",61,null,null,null,null,null,null,null,null,"More",2]
["REGAL",66]
["REGAL",70]
[]
[]
[]
[]
[]
[null,null,null,"Descriptive Statistics",null,null,"Box Plot",null,null,"Shapiro-Wilk Test",null,null,"Outliers and Missing Data"]
[]
[null,null,null,null,{"$f":"B2","v":70},null,null,{"$f":"B2","v":70},null,null,{"$f":"B2","v":70},null,null,{"$f":"B2","v":70}]
[null,null,null,"Mean",{"$f":"AVERAGE(B3:B18)","v":72.625},null,"Min",{"$f":"MIN(B3:B18)","v":61},null,"W",{"$f":"[1]!SHAPIRO(B3:B18)","v":0.97749748163553196},null,"mean",{"$f":"AVERAGE(B3:B18)","v":72.625}]
[null,null,null,"Standard Error",{"$f":"STDEV(B3:B18)/SQRT(COUNT(B3:B18))","v":1.8001736027394692},null,"Q1-Min",{"$f":"QUARTILE(B3:B18,1)-H27","v":6.5},null,"p-value",{"$f":"[1]!SWTEST(B3:B18)","v":0.94061232783740911},null,"stdev",{"$f":"STDEV(B3:B18)","v":7.200694410957877}]
[null,null,null,"Median",{"$f":"MEDIAN(B3:B18)","v":72},null,"Med-Q1",{"$f":"MEDIAN(B3:B18)-QUARTILE(B3:B18,1)","v":4.5},null,"alpha",0.05,null,"# outliers",{"$f":"COUNTIF(N32:N47,\">=2.5\")+COUNTIF(N32:N47,\"<=-2.5\")","v":0}]
[null,null,null,"Mode",{"$f":"MODE(B3:B18)","v":77},null,"Q3-Med",{"$f":"QUARTILE(B3:B18,3)-MEDIAN(B3:B18)","v":5.5},null,"normal",{"$f":"IF(K28<K29,\"no\",\"yes\")","v":"yes"},null,"# blank",{"$f":"COUNTIF(N32:N47,\"\")","v":0}]
[null,null,null,"Standard Deviation",{"$f":"STDEV(B3:B18)","v":7.200694410957877},null,"Max-Q3",{"$f":"MAX(B3:B18)-QUARTILE(B3:B18,3)","v":9.5},null,null,null,null,"# non-num",{"$f":"COUNTIF(N32:N47,\" ******* \")","v":0}]
[null,null,null,"Sample Variance",{"$f":"VAR(B3:B18)","v":51.85},null,null,null,null,null,null,null,1,{"$f":"IF(B3=\"\",\"\",IF(ISNUMBER(B3),STANDARDIZE(B3,N$27,N$28),\" ******* \"))","v":1.9963352392964218},{"$f":"IF(COUNTIF(N32,\">=2.5\")+COUNTIF(N32,\"<=-2.5\")>0,\"*\",\"\")","v":""}]
[null,null,null,"Kurtosis",{"$f":"KURT(B3:B18)","v":-0.43506456393567827},null,null,null,null,null,null,null,{"$f":"M32+1","v":2},{"$f":"IF(B4=\"\",\"\",IF(ISNUMBER(B4),STANDARDIZE(B4,N$27,N$28),\" ******* \"))","v":0.88533128003580441},{"$f":"IF(COUNTIF(N33,\">=2.5\")+COUNTIF(N33,\"<=-2.5\")>0,\"*\",\"\")","v":""}]
[null,null,null,"Skewness",{"$f":"SKEW(B3:B18)","v":0.18607288379543971},null,null,null,null,null,null,null,{"$f":"M33+1","v":3},5.2078310590341438E-2,""]
[null,null,null,"Range",{"$f":"E36-E37","v":26},null,null,null,null,null,null,null,4,0.60758029022065008,""]
[null,null,null,"Maximum",{"$f":"MAX(B3:B18)","v":87},null,null,null,null,null,null,null,5,-8.6797184317235723E-2,""]
[null,null,null,"Minimum",{"$f":"MIN(B3:B18)","v":61},null,null,null,null,null,null,null,6,-1.4755521333930073,""]
[null,null,null,"Sum",{"$f":"SUM(B3:B18)","v":1162},null,null,null,null,null,null,null,7,-0.22567267922481291,""]
[null,null,null,"Count",{"$f":"COUNT(B3:B18)","v":16},null,null,null,null,null,null,null,8,0.60758029022065008,""]
[null,null,null,"Geometric Mean",{"$f":"GEOMEAN(B3:B18)","v":72.291183436287795},null,null,null,null,null,null,null,9,1.0242067749433816,""]
[null,null,null,"Harmonic Mean",{"$f":"HARMEAN(B3:B18)","v":71.958558260729021},null,null,null,null,null,null,null,10,-8.6797184317235723E-2,""]
[null,null,null,"AAD",{"$f":"AVEDEV(B3:B18)","v":5.703125},null,null,null,null,null,null,null,11,-0.92005015376269872,""]
[null,null,null,"MAD",{"$f":"[1]!MAD(B3:B18)","v":5.5},null,null,null,null,null,null,null,12,1.1630822698509589,""]
[null,null,null,"IQR",{"$f":"[1]!IQR(B3:B18,FALSE)","v":10},null,null,null,null,null,null,null,13,-0.64229916394754438,""]
[null,null,null,null,null,null,null,null,null,null,null,null,14,-1.6144276283005845,""]
[null,null,null,null,null,null,null,null,null,null,null,null,15,-0.92005015376269872,""]
[null,null,null,null,null,null,null,null,null,null,null,null,16,-0.36454817413239005,""]
[]
[]
[]
[null,null,null,null,"Descriptive Statistics",null,null,"Box Plot",null,null,"Shapiro-Wilk Test",null,null,"Outliers and Missing Data"]
[]
[null,null,null,null,null,{"$f":"B1","v":"speed"},null,null,{"$f":"B1","v":"speed"},null,null,{"$f":"B1","v":"speed"},null,null,{"$f":"B1","v":"speed"}]
[null,null,null,null,"Mean",{"$f":"AVERAGE(B2:B18)","v":72.470588235294116},null,"Min",{"$f":"MIN(B2:B18)","v":61},null,"W",{"$f":"[1]!SHAPIRO(B2:B18)","v":0.97671471309325208},null,"mean",{"$f":"AVERAGE(B2:B18)","v":72.470588235294116}]
[null,null,null,null,"Standard Error",{"$f":"STDEV(B2:B18)/SQRT(COUNT(B2:B18))","v":1.6980041204542422},null,"Q1-Min",{"$f":"QUARTILE(B2:B18,1)-I54","v":7},null,"p-value",{"$f":"[1]!SWTEST(B2:B18)","v":0.92142527345097502},null,"stdev",{"$f":"STDEV(B2:B18)","v":7.0010503413668541}]
[null,null,null,null,"Median",{"$f":"MEDIAN(B2:B18)","v":72},null,"Med-Q1",{"$f":"MEDIAN(B2:B18)-QUARTILE(B2:B18,1)","v":4},null,"alpha",0.05,null,"# outliers",{"$f":"COUNTIF(O59:O75,\">=2.5\")+COUNTIF(O59:O75,\"<=-2.5\")","v":0}]
[null,null,null,null,"Mode",{"$f":"MODE(B2:B18)","v":70},null,"Q3-Med",{"$f":"QUARTILE(B2:B18,3)-MEDIAN(B2:B18)","v":5},null,"normal",{"$f":"IF(L55<L56,\"no\",\"yes\")","v":"yes"},null,"# blank",{"$f":"COUNTIF(O59:O75,\"\")","v":0}]
[null,null,null,null,"Standard Deviation",{"$f":"STDEV(B2:B18)","v":7.0010503413668541},null,"Max-Q3",{"$f":"MAX(B2:B18)-QUARTILE(B2:B18,3)","v":10},null,null,null,null,"# non-num",{"$f":"COUNTIF(O59:O75,\" ******* \")","v":0}]
[null,null,null,null,"Sample Variance",{"$f":"VAR(B2:B18)","v":49.014705882352942},null,null,null,null,null,null,null,1,{"$f":"IF(B2=\"\",\"\",IF(ISNUMBER(B2),STANDARDIZE(B2,O$54,O$55),\" ******* \"))","v":-0.35288822602749192},{"$f":"IF(COUNTIF(O59,\">=2.5\")+COUNTIF(O59,\"<=-2.5\")>0,\"*\",\"\")","v":""}]
[null,null,null,null,"Kurtosis",{"$f":"KURT(B2:B18)","v":-0.28156546913531599},null,null,null,null,null,null,null,{"$f":"N59+1","v":2},{"$f":"IF(B3=\"\",\"\",IF(ISNUMBER(B3),STANDARDIZE(B3,O$54,O$55),\" ******* \"))","v":2.0753188530664421},{"$f":"IF(COUNTIF(O60,\">=2.5\")+COUNTIF(O60,\"<=-2.5\")>0,\"*\",\"\")","v":""}]
[null,null,null,null,"Skewness",{"$f":"SKEW(B2:B18)","v":0.25948273138853695},null,null,null,null,null,null,null,{"$f":"N60+1","v":3},0.9326331687869438,""]
[null,null,null,null,"Range",{"$f":"F63-F64","v":26},null,null,null,null,null,null,null,4,7.5618905577319984E-2,""]
[null,null,null,null,"Maximum",{"$f":"MAX(B2:B18)","v":87},null,null,null,null,null,null,null,5,0.64696174771706927,""]
[null,null,null,null,"Minimum",{"$f":"MIN(B2:B18)","v":61},null,null,null,null,null,null,null,6,-6.7216804957617324E-2,""]
[null,null,null,null,"Sum",{"$f":"SUM(B2:B18)","v":1232},null,null,null,null,null,null,null,7,-1.4955739103069905,""]
[null,null,null,null,"Count",{"$f":"COUNT(B2:B18)","v":17},null,null,null,null,null,null,null,8,-0.21005251549255463,""]
[null,null,null,null,"Geometric Mean",{"$f":"GEOMEAN(B2:B18)","v":72.154355590165451},null,null,null,null,null,null,null,9,0.64696174771706927,""]
[null,null,null,null,"Harmonic Mean",{"$f":"HARMEAN(B2:B18)","v":71.840320065504045},null,null,null,null,null,null,null,10,1.0754688793218812,""]
[null,null,null,null,"AAD",{"$f":"AVEDEV(B2:B18)","v":5.4948096885813147},null,null,null,null,null,null,null,11,-6.7216804957617324E-2,""]
[null,null,null,null,"MAD",{"$f":"[1]!MAD(B2:B18)","v":5},null,null,null,null,null,null,null,12,-0.92423106816724121,""]
[null,null,null,null,"IQR",{"$f":"[1]!IQR(B2:B18,FALSE)","v":9},null,null,null,null,null,null,null,13,1.2183045898568186,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,14,-0.63855964709736657,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,15,-1.6384096208419276,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,16,-0.92423106816724121,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,17,-0.35288822602749192,""]