{"text_format":"1","workbook":"xlsx","n_sheets":23,"sheets":["HW==>","(1)","(2)","(3)","(6)","(9)","(11)","(12)","(13)","(14)","(17)","(18)","(20)","(21)","(22)","(23)","(26)","(37)","(38)","(55)","Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":1,"images":0,"macros":0,"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":"HW==>","index":0,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["1,2,3,6,9,11,12,13,14,17,18,20,21,22,23,26,37,38,55"]

{"sheet":"(1)","index":1,"n_rows":128,"n_cols":7,"rows_kept":128,"cut":false,"hidden":false,"merged":[]}
["n",40]
["Xbar",25]
["Sigma",5]
["Standard Error of Mean =Sigma/SQRT(n)",{"$f":"B3/SQRT(B1)","v":0.79056941504209477},{"$f":"ShowFormula","v":" =B3/SQRT(B1)"},"Standard Deviation of Sampling Distribution of Xbar"]
["Confidence Level",0.95,null,"How sure we are that pop mean is in interval"]
["Alpha",{"$f":"1-B5","v":5.0000000000000044E-2},{"$f":"ShowFormula","v":" =1-B5"},"How sure we are that pop mean is NOT in interval. Risk we take that Pop Mean is not in interval"]
["Alpha/2",{"$f":"B6/2","v":2.5000000000000022E-2},{"$f":"ShowFormula","v":" =B6/2"}]
[]
["Method 1:"]
["NORM.INV Method"]
["Lower Limit",{"$f":"_xlfn.NORM.INV(B7,B2,B4)","v":23.450512419238596},{"$f":"ShowFormula","v":" =NORM.INV(B7,B2,B4)"},null," =NORM.INV(Alpha/2,Xbar,Standard Error)"]
["Upper Limit",{"$f":"_xlfn.NORM.INV(1-B7,B2,B4)","v":26.549487580761404},{"$f":"ShowFormula","v":" =NORM.INV(1-B7,B2,B4)"},null," =NORM.INV(1-Alpha/2,Xbar,Standard Error)"]
[]
["Method 2:"]
["NORM.S.INV Method"]
["Z Associated with upper Alpha/2",{"$f":"_xlfn.NORM.S.INV(1-B7)","v":1.9599639845400536},{"$f":"ShowFormula","v":" =NORM.S.INV(1-B7)"},null," =NORM.S.INV(1-Alpha/2)"]
["Margin of Error = Alpha/2 * Standard Error",{"$f":"B4*B16","v":1.5494875807614035},{"$f":"ShowFormula","v":" =B4*B16"}]
["Lower Limit",{"$f":"B2-B17","v":23.450512419238596},{"$f":"ShowFormula","v":" =B2-B17"}]
["Upper Limit",{"$f":"B2+B17","v":26.549487580761404},{"$f":"ShowFormula","v":" =B2+B17"}]
[]
["Method 3:"]
["CONFIDENCE.NORM Method"]
["Margin of Error",{"$f":"_xlfn.CONFIDENCE.NORM(B6,B3,B1)","v":1.5494875807614035},{"$f":"ShowFormula","v":" =CONFIDENCE.NORM(B6,B3,B1)"},null," =CONFIDENCE.NORM(Alpha,Sigma,Sample Size)"]
["Lower Limit",{"$f":"B2-B23","v":23.450512419238596},{"$f":"ShowFormula","v":" =B2-B23"}]
["Upper Limit",{"$f":"B2+B23","v":26.549487580761404},{"$f":"ShowFormula","v":" =B2+B23"}]
[{"$f":"\"Our \"&TEXT($B$5,\"0%\")&\" Confidence Interval has limits of \"&ROUND($B$24,2)&\" and \"&ROUND($B$25,2)&\". We are about \"&TEXT($B$5,\"0%\")&\" sure that the population mean will lie within this interval. We are about \"&TEXT(1-$B$5,\"0%\")&\" sure that the population mean will NOT lie within this interval. \"","v":"Our 95% Confidence Interval has limits of 23.45 and 26.55. We are about 95% sure that the population mean will lie within this interval. We are about 5% sure that the population mean will NOT lie within this interval. "}]
[{"$f":"\"If we were to construct 100 similar intervals we would expect \"&B5*100&\" to contain the population mean and \"&(1-B5)*100&\" to NOT contain the population mean.\"","v":"If we were to construct 100 similar intervals we would expect 95 to contain the population mean and 5 to NOT contain the population mean."}]
[{"$f":"\"We estimate the population mean to be about \"&B2&\" with a margin of error of +/- \"&ROUND(B23,1)&\".\"","v":"We estimate the population mean to be about 25 with a margin of error of +/- 1.5."}]
[{"$f":"\"A reasonable range of values for the population mean is \"&ROUND($B$24,2)&\" to \"&ROUND($B$25,2)&\".\"","v":"A reasonable range of values for the population mean is 23.45 to 26.55."}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Mew","Xbar","P(Xbar)"]
[null,null,21.8,null,null,null,21.8]
[null,null,21.900000000000002,null,null,null,28.1]
[null,null,22]
[null,null,22.1]
[null,null,22.2]
[null,null,22.3]
[null,null,22.400000000000002]
[null,null,22.5]
[null,null,22.6]
[null,null,22.7]
[null,null,22.8]
[null,null,22.900000000000002]
[null,null,23]
[null,null,23.1]
[null,null,23.2]
[null,null,23.3]
[null,null,23.400000000000002]
[null,null,23.5]
[null,null,23.6]
[null,null,23.7]
[null,null,23.8]
[null,null,23.900000000000002]
[null,null,24]
[null,null,24.1]
[null,null,24.200000000000003]
[null,null,24.3]
[null,null,24.400000000000002]
[null,null,24.5]
[null,null,24.6]
[null,null,24.700000000000003]
[null,null,24.8]
[null,null,24.900000000000002]
[null,null,25]
[null,null,25.1]
[null,null,25.200000000000003]
[null,null,25.3]
[null,null,25.400000000000002]
[null,null,25.5]
[null,null,25.6]
[null,null,25.700000000000003]
[null,null,25.8]
[null,null,25.900000000000002]
[null,null,26]
[null,null,26.1]
[null,null,26.200000000000003]
[null,null,26.3]
[null,null,26.400000000000002]
[null,null,26.5]
[null,null,26.6]
[null,null,26.700000000000003]
[null,null,26.8]
[null,null,26.900000000000002]
[null,null,27]
[null,null,27.1]
[null,null,27.200000000000003]
[null,null,27.3]
[null,null,27.400000000000002]
[null,null,27.5]
[null,null,27.6]
[null,null,27.700000000000003]
[null,null,27.8]
[null,null,27.900000000000002]
[null,null,28]
[null,null,28.1]

{"sheet":"(2)","index":2,"n_rows":23,"n_cols":4,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["n",50,null,"Method 1:"]
["Xbar",32]
["Sigma",6]
["Standard Error of Mean",{"$f":"B3/SQRT(B1)","v":0.84852813742385702}]
[]
["Confidence Level",0.9,"How sure we are that pop mean is in interval"]
["Alpha",{"$f":"1-B6","v":9.9999999999999978E-2},"How sure we are that pop mean is NOT in interval. Risk we take that Pop Mean is not in interval"]
["Lower Limit",{"$f":"_xlfn.NORM.INV(B7/2,$B$2,$B$4)","v":30.604295415587991}]
["Upper Limit",{"$f":"_xlfn.NORM.INV(1-B7/2,$B$2,$B$4)","v":33.395704584412009}]
[{"$f":"\"A reasonable range of values for the population mean is \"&ROUND(B8,2)&\" to \"&ROUND(B9,2)&\".\"","v":"A reasonable range of values for the population mean is 30.6 to 33.4."}]
[{"$f":"\"We are \"&TEXT(B6,\"0%\")&\" sure that the population mean between \"&ROUND(B8,2)&\" and \"&ROUND(B9,2)&\".\"","v":"We are 90% sure that the population mean between 30.6 and 33.4."}]
["Confidence Level",0.95,"How sure we are that pop mean is in interval"]
["Alpha",{"$f":"1-B12","v":5.0000000000000044E-2},"How sure we are that pop mean is NOT in interval. Risk we take that Pop Mean is not in interval"]
["Lower Limit",{"$f":"_xlfn.NORM.INV(B13/2,$B$2,$B$4)","v":30.336915410780389}]
["Upper Limit",{"$f":"_xlfn.NORM.INV(1-B13/2,$B$2,$B$4)","v":33.663084589219615}]
[{"$f":"\"A reasonable range of values for the population mean is \"&ROUND(B14,2)&\" to \"&ROUND(B15,2)&\".\"","v":"A reasonable range of values for the population mean is 30.34 to 33.66."}]
[{"$f":"\"We are \"&TEXT(B12,\"0%\")&\" sure that the population mean between \"&ROUND(B14,2)&\" and \"&ROUND(B15,2)&\".\"","v":"We are 95% sure that the population mean between 30.34 and 33.66."}]
["Confidence Level",0.99,"How sure we are that pop mean is in interval"]
["Alpha",{"$f":"1-B18","v":1.0000000000000009E-2},"How sure we are that pop mean is NOT in interval. Risk we take that Pop Mean is not in interval"]
["Lower Limit",{"$f":"_xlfn.NORM.INV(B19/2,$B$2,$B$4)","v":29.814336358737862}]
["Upper Limit",{"$f":"_xlfn.NORM.INV(1-B19/2,$B$2,$B$4)","v":34.185663641262138}]
[{"$f":"\"A reasonable range of values for the population mean is \"&ROUND(B20,2)&\" to \"&ROUND(B21,2)&\".\"","v":"A reasonable range of values for the population mean is 29.81 to 34.19."}]
[{"$f":"\"We are \"&TEXT(B18,\"0%\")&\" sure that the population mean between \"&ROUND(B20,2)&\" and \"&ROUND(B21,2)&\".\"","v":"We are 99% sure that the population mean between 29.81 and 34.19."}]

{"sheet":"(3)","index":3,"n_rows":25,"n_cols":5,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["a","n",60,null,"Method 1:"]
[null,"Xbar",80]
[null,"Sigma",15]
[null,"Confidence Level",0.95]
[null,"Level of Significance = Alpha",{"$f":"1-C4","v":5.0000000000000044E-2}]
[null,"Alpha/2",{"$f":"C5/2","v":2.5000000000000022E-2}]
[null,"Standard Error of Mean",{"$f":"C3/SQRT(C1)","v":1.9364916731037083}]
[null,"Lower Limit",{"$f":"_xlfn.NORM.INV(C6,C2,C7)","v":76.204546064355014}]
[null,"Upper Limit",{"$f":"_xlfn.NORM.INV(1-C6,C2,C7)","v":83.795453935644986}]
[]
[null,{"$f":"\"We are about \"&TEXT(C4,\"0%\")&\" sure that the population mean lies between \"&ROUND(C8,2)&\" and \"&ROUND(C9,2)&\".\"","v":"We are about 95% sure that the population mean lies between 76.2 and 83.8."}]
[]
["b","n",120]
[null,"Xbar",80]
[null,"Sigma",15]
[null,"Confidence Level",0.95]
[null,"Level of Significance = Alpha",{"$f":"1-C16","v":5.0000000000000044E-2}]
[null,"Alpha/2",{"$f":"C17/2","v":2.5000000000000022E-2}]
[null,"Standard Error of Mean",{"$f":"C15/SQRT(C13)","v":1.3693063937629153}]
[null,"Lower Limit",{"$f":"_xlfn.NORM.INV(C18,C14,C19)","v":77.316208784424262}]
[null,"Upper Limit",{"$f":"_xlfn.NORM.INV(1-C18,C14,C19)","v":82.683791215575738}]
[]
[null,{"$f":"\"We are about \"&TEXT(C16,\"0%\")&\" sure that the population mean lies between \"&ROUND(C20,2)&\" and \"&ROUND(C21,2)&\".\"","v":"We are about 95% sure that the population mean lies between 77.32 and 82.68."}]
[]
["c","The larger sample size reduce the interval and makes our prediction of the population mean more precise"]

{"sheet":"(6)","index":4,"n_rows":301,"n_cols":11,"rows_kept":301,"cut":false,"hidden":false,"merged":[[10,2,13,3],[14,2,15,3],[16,2,20,3],[12,5,15,6],[16,5,19,6],[20,5,21,6],[22,5,26,6],[8,8,11,9],[12,8,15,9],[16,8,17,9],[18,8,22,9]]}
["Hours of TV watch between 8 PM and 11 PM",null,"Method 1: NORM.INV",null,null,"Method 2: NORM.S.INV",null,null,"Method 3: CONFIDENCE.NORM"]
[6,null,"Sigma",3.5,null,"Sigma",3.5,null,"Sigma",3.5,"hours"]
[4,null,"Confidence Level",0.95,null,"Confidence Level",0.95,null,"Confidence Level",0.95]
[9,null,"alpha",{"$f":"1-D3","v":5.0000000000000044E-2},null,"alpha",{"$f":"1-G3","v":5.0000000000000044E-2},null,"n",{"$f":"COUNT($A$2:$A$301)","v":300}]
[8,null,"alpha/2",{"$f":"D4/2","v":2.5000000000000022E-2},null,"alpha/2",{"$f":"G4/2","v":2.5000000000000022E-2},null,"Mean",{"$f":"AVERAGE($A$2:$A$301)","v":8.5}]
[19,null,"n",{"$f":"COUNT($A$2:$A$301)","v":300},null,"n",{"$f":"COUNT($A$2:$A$301)","v":300},null,"Margin of Error",{"$f":"_xlfn.CONFIDENCE.NORM(1-J3,J2,J4)","v":0.39605500692665996}]
[7,null,"Mean",{"$f":"AVERAGE($A$2:$A$301)","v":8.5},null,"Mean",{"$f":"AVERAGE($A$2:$A$301)","v":8.5},null,"Lower Limit",{"$f":"J5-J6","v":8.1039449930733394}]
[6,null,"Standard Error",{"$f":"D2/SQRT(D6)","v":0.202072594216369},null,"Standard Error",{"$f":"G2/SQRT(G6)","v":0.202072594216369},null,"Upper Limit",{"$f":"J5+J6","v":8.8960550069266606}]
[13,null,"Lower Limit",{"$f":"_xlfn.NORM.INV(D5,D7,D8)","v":8.1039449930733394},null,"Upper z value",{"$f":"_xlfn.NORM.S.INV(1-G5)","v":1.9599639845400536},null,{"$f":"\"From our sample we calculated a mean of \"&J5&\" hours, within a margin of error +/- \"&ROUND(J6,2)&\" hours.\"","v":"From our sample we calculated a mean of 8.5 hours, within a margin of error +/- 0.4 hours."}]
[10,null,"Upper Limit",{"$f":"_xlfn.NORM.INV(1-D5,D7,D8)","v":8.8960550069266606},null,"Margin of Error",{"$f":"G9*G8","v":0.39605500692665996}]
[12,null,{"$f":"\"We are \"&TEXT(D3,\"0.%\")&\" sure that the population mean TV viewing time is between \"&FIXED(D9,2)&\" hours and \"&FIXED(D10,2)&\" hours.\"","v":"We are 95.% sure that the population mean TV viewing time is between 8.10 hours and 8.90 hours."},null,null,"Lower Limit",{"$f":"G7-G10","v":8.1039449930733394}]
[5,null,null,null,null,"Upper Limit",{"$f":"G7+G10","v":8.8960550069266606}]
[6,null,null,null,null,{"$f":"\"From our sample we calculated a mean of \"&G7&\" hours, within a margin of error +/- \"&ROUND(G10,2)&\" hours.\"","v":"From our sample we calculated a mean of 8.5 hours, within a margin of error +/- 0.4 hours."},null,null,{"$f":"\"We are \"&TEXT(J3,\"0.%\")&\" sure that the population mean TV viewing time is between \"&ROUND(J7,2)&\" hours and \"&ROUND(J8,2)&\" hours.\"","v":"We are 95.% sure that the population mean TV viewing time is between 8.1 hours and 8.9 hours."}]
[9]
[0,null,{"$f":"TEXT(D4,\"0%\")&\" risk that it is not within our interval\"","v":"5% risk that it is not within our interval"}]
[6]
[7,null,"If we constructed 100 similar intervals, we would expect the population mean to lie within about 95 of the intervals.",null,null,{"$f":"\"We are \"&TEXT(G3,\"0.%\")&\" sure that the population mean TV viewing time is between \"&ROUND(G11,2)&\" hours and \"&ROUND(G12,2)&\" hours.\"","v":"We are 95.% sure that the population mean TV viewing time is between 8.1 hours and 8.9 hours."},null,null,{"$f":"TEXT(1-J3,\"0%\")&\" risk that it is not within our interval\"","v":"5% risk that it is not within our interval"}]
[4]
[13,null,null,null,null,null,null,null,"If we constructed 100 similar intervals, we would expect the population mean to lie within about 95 of the intervals."]
[5]
[14,null,null,null,null,{"$f":"TEXT(G4,\"0%\")&\" risk that it is not within our interval\"","v":"5% risk that it is not within our interval"}]
[8]
[9,null,null,null,null,"If we constructed 100 similar intervals, we would expect the population mean to lie within about 95 of the intervals."]
[9]
[6]
[8]
[12]
[6]
[7]
[5]
[7]
[9]
[16]
[8]
[9]
[10]
[11]
[4]
[10]
[5]
[9]
[6]
[9]
[9]
[7]
[5]
[11]
[8]
[12]
[4]
[11]
[12]
[9]
[10]
[5]
[12]
[3]
[13]
[10]
[12]
[8]
[13]
[8]
[9]
[9]
[11]
[4]
[4]
[10]
[7]
[9]
[14]
[13]
[6]
[5]
[6]
[7]
[9]
[9]
[10]
[12]
[8]
[4]
[10]
[12]
[10]
[7]
[5]
[4]
[7]
[9]
[12]
[7]
[12]
[14]
[6]
[7]
[2]
[9]
[9]
[16]
[11]
[9]
[5]
[9]
[10]
[7]
[9]
[10]
[4]
[11]
[13]
[10]
[3]
[8]
[9]
[17]
[7]
[9]
[9]
[4]
[7]
[12]
[4]
[9]
[7]
[8]
[12]
[4]
[8]
[14]
[5]
[5]
[5]
[13]
[3]
[6]
[10]
[4]
[15]
[4]
[7]
[3]
[4]
[7]
[12]
[13]
[10]
[10]
[12]
[8]
[6]
[18]
[8]
[12]
[5]
[8]
[12]
[7]
[10]
[3]
[4]
[9]
[7]
[4]
[4]
[10]
[4]
[13]
[7]
[7]
[10]
[11]
[1]
[7]
[4]
[11]
[12]
[7]
[8]
[12]
[9]
[11]
[10]
[7]
[7]
[9]
[4]
[13]
[7]
[0]
[12]
[3]
[10]
[4]
[10]
[7]
[4]
[4]
[8]
[13]
[17]
[16]
[8]
[12]
[4]
[7]
[7]
[4]
[9]
[9]
[9]
[4]
[6]
[18]
[4]
[16]
[10]
[9]
[5]
[9]
[12]
[7]
[6]
[7]
[4]
[10]
[8]
[10]
[6]
[13]
[8]
[12]
[9]
[7]
[4]
[7]
[4]
[9]
[7]
[7]
[12]
[12]
[8]
[7]
[4]
[6]
[10]
[9]
[9]
[12]
[14]
[9]
[13]
[10]
[9]
[4]
[15]
[9]
[4]
[8]
[4]
[5]
[5]
[7]
[7]
[13]
[9]
[6]
[4]
[13]
[9]
[8]
[6]
[7]
[9]
[4]
[12]
[14]
[12]
[12]
[9]
[8]
[8]
[13]
[10]
[9]
[8]
[4]
[12]
[10]
[9]
[12]
[20]
[11]
[6]
[16]
[7]
[7]
[10]
[11]

{"sheet":"(9)","index":5,"n_rows":41,"n_cols":7,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
["Return Preparation Time(Hours)",null,"Sigma",9,"hours",null,"Method 3:"]
[35.299999999999997,null,"Confidence Level",0.95]
[30.5,null,"n",{"$f":"COUNT(A2:A41)","v":40}]
[37.4,null,"Mean",{"$f":"ROUND(AVERAGE(A2:A41),1)","v":33.5}]
[26.5,null,"Margin of Error",{"$f":"ROUND(_xlfn.CONFIDENCE.NORM(1-D2,D1,D3),1)","v":2.8}]
[13,null,"Lower Limit",{"$f":"$D$4-$D$5","v":30.7}]
[49.9,null,"Upper Limit",{"$f":"$D$4+$D$5","v":36.299999999999997}]
[28.8,null,{"$f":"\"From our sample we calculated a mean of \"&D4&\" hours, within a margin of error +/- \"&D5&\" hours.\"","v":"From our sample we calculated a mean of 33.5 hours, within a margin of error +/- 2.8 hours."}]
[44,null,{"$f":"\"We are \"&TEXT(D2,\"0.%\")&\" sure that the population mean time to complete tax return is between \"&D6&\" hours and \"&D7&\" hours.\"","v":"We are 95.% sure that the population mean time to complete tax return is between 30.7 hours and 36.3 hours."}]
[61.6,null,"5% risk that it is not within our interval"]
[0.5,null,"If we constructed 100 similar intervals, we would expect the population mean to lie within about 95 of the intervals."]
[40.5]
[34.9]
[47.9]
[36.6]
[24.1]
[39.799999999999997]
[47.8]
[18.5]
[36.6]
[39.200000000000003]
[14.5]
[37.299999999999997]
[40.5]
[49.3]
[45.5]
[28.3]
[19.5]
[5.6]
[52.6]
[41.4]
[45.3]
[39]
[33.700000000000003]
[29.4]
[14.5]
[40.1]
[33.700000000000003]
[36.9]
[5.6]
[33.700000000000003]

{"sheet":"(11)","index":6,"n_rows":26,"n_cols":6,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["Find Probability"]
[null,"df",16,null,null,"Right"]
[null,null,null,null,null,"Left"]
["a","t",2.12,null,null,"Between"]
[null,"Area:","Right"]
[null,{"$f":"\"P(t>=\"&C4&\") =\"","v":"P(t>=2.12) ="},{"$f":"_xlfn.T.DIST.RT(C4,$C$2)","v":2.4995464356552179E-2},{"$f":"1-_xlfn.T.DIST(C4,$C$2,1)","v":2.4995464356552199E-2}]
[]
["b","t",1.337]
[null,"Area:","Left"]
[null,{"$f":"\"P(t<=\"&C8&\") =\"","v":"P(t<=1.337) ="},{"$f":"_xlfn.T.DIST(C8,$C$2,1)","v":0.90003877322102799}]
[]
["c","t",-1.746]
[null,"Area:","Left"]
[null,{"$f":"\"P(t<=\"&C12&\") =\"","v":"P(t<=-1.746) ="},{"$f":"_xlfn.T.DIST(C12,$C$2,1)","v":4.9989623846903301E-2}]
[]
["d","t",2.5830000000000002]
[null,"Area:","Right"]
[null,{"$f":"\"P(t>=\"&C16&\") =\"","v":"P(t>=2.583) ="},{"$f":"_xlfn.T.DIST.RT(C16,$C$2)","v":1.0009885354016477E-2},{"$f":"1-_xlfn.T.DIST(C16,$C$2,1)","v":1.0009885354016479E-2}]
[]
["e","t",2.12," +/-"]
[null,"Area:","Between"]
[null,{"$f":"\"P(-\"&C20&\" <= t <= \"&C20&\")\"","v":"P(-2.12 <= t <= 2.12)"},{"$f":"_xlfn.T.DIST(C20,$C$2,1)-_xlfn.T.DIST(-C20,$C$2,1)","v":0.9500090712868956}]
[]
["f","t",1.746," +/-"]
[null,"Area:","Between"]
[null,{"$f":"\"P(-\"&C24&\" <= t <= \"&C24&\")\"","v":"P(-1.746 <= t <= 1.746)"},{"$f":"_xlfn.T.DIST(C24,$C$2,1)-_xlfn.T.DIST(-C24,$C$2,1)","v":0.90002075230619338}]

{"sheet":"(12)","index":7,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Find T values",null,null,null,null,null,null,null,"Upper Tail Area"]
[null,null,null,null,null,null,null,null,"Lower Tail Area"]
["a","Probability in","Probability","df","t",null,null,null,"Between two t values"]
[null,"Upper Tail Area",2.5000000000000001E-2,12,{"$f":"_xlfn.T.INV(1-C4,D4)","v":2.178812829667228}]
[]
["b","Probability in","Probability","df","t"]
[null,"Lower Tail Area",0.05,50,{"$f":"_xlfn.T.INV(C7,D7)","v":-1.6759050251630967}]
[]
["c","Probability in","Probability","df","t"]
[null,"Upper Tail Area",0.01,30,{"$f":"_xlfn.T.INV(1-C10,D10)","v":2.4572615424005915}]
[]
["d","Probability in","Probability","alpha","alpha/2","df"," +/- t",null,"t lower","t upper"]
[null,"Between two t values",0.9,{"$f":"1-C13","v":9.9999999999999978E-2},{"$f":"D13/2","v":4.9999999999999989E-2},25,{"$f":"_xlfn.T.INV.2T(D13,F13)","v":1.7081407612518986},null,{"$f":"_xlfn.T.INV(E13,F13)","v":-1.7081407612518986},{"$f":"_xlfn.T.INV(C13+E13,F13)","v":1.7081407612518986}]
[]
["e","Probability in","Probability","alpha","alpha/2","df"," +/- t",null,"t lower","t upper"]
[null,"Between two t values",0.95,{"$f":"1-C16","v":5.0000000000000044E-2},{"$f":"D16/2","v":2.5000000000000022E-2},45,{"$f":"_xlfn.T.INV.2T(D16,F16)","v":2.0141033888808457},null,{"$f":"_xlfn.T.INV(E16,F16)","v":-2.0141033888808457},{"$f":"_xlfn.T.INV(C16+E16,F16)","v":2.0141033888808457}]

{"sheet":"(13)","index":8,"n_rows":40,"n_cols":12,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
["Sample",null,null,"Method 2:",null,null,null,null,null,null,"Min",{"$f":"MIN(A2:A9)","v":5}]
[10,null,null,"Sample size = n",{"$f":"COUNT(A2:A9)","v":8},null,null,null,null,null,"Max",{"$f":"MAX(A2:A9)","v":15}]
[8,null,"a","Point Estimate = Xbar",{"$f":"AVERAGE(A2:A9)","v":10},null,null,null,null,null,"Category","Frequency"]
[12,null,"b","Point Estimate = s",{"$f":"_xlfn.STDEV.S(A2:A9)","v":3.4641016151377544},null,null,null,null,null,5,{"$f":"COUNTIF($A$2:$A$9,K4)","v":1}]
[15,null,null,"Confidence Level",0.95,null,null,null,null,null,6,1]
[13,null,null,"alpha",{"$f":"1-E5","v":5.0000000000000044E-2},null,null,null,null,null,7,0]
[11,null,"c","Margin of Error",{"$f":"_xlfn.CONFIDENCE.T(E6,E4,E2)","v":2.8960614249064376},null,null,null,null,null,8,1]
[6,null,null,"Lower Limit",{"$f":"$E$3-$E$7","v":7.1039385750935624},null,null,null,null,null,9,0]
[5,null,null,"Upper Limit",{"$f":"$E$3+$E$7","v":12.896061424906438},null,null,null,null,null,10,1]
[null,null,"d",{"$f":"\"We are \"&TEXT(E5,\"0%\")&\" sure that the pop mean lies between \"&ROUND(E8,2)&\" and \"&ROUND(E9,2)&\".\"","v":"We are 95% sure that the pop mean lies between 7.1 and 12.9."},null,null,null,null,null,null,11,1]
[null,null,null,{"$f":"\"We estimate the population mean to be about \"&E3&\" with a margin of error of +/-\"&ROUND(E7,1)","v":"We estimate the population mean to be about 10 with a margin of error of +/-2.9"},null,null,null,null,null,null,12,1]
[null,null,null,"Method 1:",null,null,null,null,null,null,13,1]
[null,null,null,"alpha/2",{"$f":"E6/2","v":2.5000000000000022E-2},null,null,null,null,null,14,0]
[null,null,null,"df",{"$f":"E2-1","v":7},null,null,null,null,null,15,1]
[null,null,null,"Standard Error",{"$f":"E4/SQRT(E2)","v":1.2247448713915889}]
[null,null,null,"t lower",{"$f":"_xlfn.T.INV(E13,E14)","v":-2.3646242515927849}]
[null,null,null,"t upper",{"$f":"_xlfn.T.INV(E5+E13,E14)","v":2.3646242515927849},{"$f":"_xlfn.T.INV.2T(E6,E14)","v":2.3646242515927849}]
[null,null,null,"Lower Limit",{"$f":"$E$3+E16","v":7.6353757484072151}]
[null,null,null,"Upper Limit",{"$f":"$E$3+F17","v":12.364624251592785}]
[]
[null,null,null,"Method 3:"]
[null,null,null,"Sample"]
[]
[null,null,null,"Mean",10]
[null,null,null,"Standard Error",1.2247448713915889]
[null,null,null,"Median",10.5]
[null,null,null,"Mode",{"$error":"#N/A"}]
[null,null,null,"Standard Deviation",3.4641016151377544]
[null,null,null,"Sample Variance",12]
[null,null,null,"Kurtosis",-1.0428571428571409]
[null,null,null,"Skewness",-0.1649572197684647]
[null,null,null,"Range",10]
[null,null,null,"Minimum",5]
[null,null,null,"Maximum",15]
[null,null,null,"Sum",80]
[null,null,null,"Count",8]
[null,null,null,"Confidence Level(95.0%)",2.8960614249064376]
[]
[null,null,null,"Lower Xbar",{"$f":"$E$24-$E$37","v":7.1039385750935624}]
[null,null,null,"Upper Xbar",{"$f":"$E$24+$E$37","v":12.896061424906438}]

{"sheet":"(14)","index":9,"n_rows":32,"n_cols":4,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["All done with Method 2"]
[null,"n",54]
[null,"Xbar",22.5]
[null,"s",4.4000000000000004]
[]
["a","Confidence Level",0.9,"How sure we are that Pop Mean lies in interval"]
[null,"Alpha",{"$f":"1-C6","v":9.9999999999999978E-2},"risk that pop mean is not in interval"]
[null,"Margin of Error",{"$f":"_xlfn.CONFIDENCE.T(C7,$C$4,$C$2)","v":1.0024008011186931}]
[null,"Lower Limit",{"$f":"$C$3-C8","v":21.497599198881307}]
[null,"Upper Limit",{"$f":"$C$3+C8","v":23.502400801118693}]
[null,"Confidence Interval",{"$f":"\"We are \"&TEXT(C6,\"0%\")&\" sure that the pop mean lies between \"&ROUND(C9,2)&\" and \"&ROUND(C10,2)&\".\"","v":"We are 90% sure that the pop mean lies between 21.5 and 23.5."}]
[null,null,{"$f":"\"There is a \"&TEXT(C7,\"0%\")&\" risk that the pop mean does not lie within our interval.\"","v":"There is a 10% risk that the pop mean does not lie within our interval."}]
[]
["b","Confidence Level",0.95,"How sure we are that Pop Mean lies in interval"]
[null,"Alpha",{"$f":"1-C14","v":5.0000000000000044E-2},"risk that pop mean is not in interval"]
[null,"Margin of Error",{"$f":"_xlfn.CONFIDENCE.T(C15,$C$4,$C$2)","v":1.2009688147501143}]
[null,"Lower Limit",{"$f":"$C$3-C16","v":21.299031185249884}]
[null,"Upper Limit",{"$f":"$C$3+C16","v":23.700968814750116}]
[null,"Confidence Interval",{"$f":"\"We are \"&TEXT(C14,\"0%\")&\" sure that the pop mean lies between \"&ROUND(C17,2)&\" and \"&ROUND(C18,2)&\".\"","v":"We are 95% sure that the pop mean lies between 21.3 and 23.7."}]
[null,null,{"$f":"\"There is a \"&TEXT(C15,\"0%\")&\" risk that the pop mean does not lie within our interval.\"","v":"There is a 5% risk that the pop mean does not lie within our interval."}]
[]
["c","Confidence Level",0.99,"How sure we are that Pop Mean lies in interval"]
[null,"Alpha",{"$f":"1-C22","v":1.0000000000000009E-2},"risk that pop mean is not in interval"]
[null,"Margin of Error",{"$f":"_xlfn.CONFIDENCE.T(C23,$C$4,$C$2)","v":1.5997916347131276}]
[null,"Lower Limit",{"$f":"$C$3-C24","v":20.900208365286872}]
[null,"Upper Limit",{"$f":"$C$3+C24","v":24.099791634713128}]
[null,"Confidence Interval",{"$f":"\"We are \"&TEXT(C22,\"0%\")&\" sure that the pop mean lies between \"&ROUND(C25,2)&\" and \"&ROUND(C26,2)&\".\"","v":"We are 99% sure that the pop mean lies between 20.9 and 24.1."}]
[null,null,{"$f":"\"There is a \"&TEXT(C23,\"0%\")&\" risk that the pop mean does not lie within our interval.\"","v":"There is a 1% risk that the pop mean does not lie within our interval."}]
[]
["d","The margin of error and width of the confidence interval increase as the alpha decreases."]
[null,"This makes sense because as we take less risk that the pop mean is not within our interval,"]
[null,"the confidence interval should expand to include more values."]

{"sheet":"(17)","index":10,"n_rows":51,"n_cols":10,"rows_kept":51,"cut":false,"hidden":false,"merged":[[26,8,28,9],[10,5,14,6],[14,2,18,3],[21,8,25,9],[19,2,21,3],[15,5,17,6]]}
["Rating for Miami International Airport",null,"Method 1: T.INV",null,null,"Method 2: CONFIDENCE.T",null,null,"Method 3: Data Analysis: Descriptive Statistics"]
[6]
[4,null,"n",{"$f":"COUNT(A2:A51)","v":50},null,"n",{"$f":"COUNT(A2:A51)","v":50},null,"Rating for Miami International Airport"]
[6,null,"Xbar",{"$f":"AVERAGE(A2:A51)","v":6.34},null,"Xbar",{"$f":"AVERAGE(A2:A51)","v":6.34}]
[8,null,"s",{"$f":"_xlfn.STDEV.S(A2:A51)","v":2.1628590300048383},null,"s",{"$f":"_xlfn.STDEV.S(A2:A51)","v":2.1628590300048383},null,"Mean",6.34]
[7,null,"Cofidence Level",0.95,null,"Cofidence Level",0.95,null,"Standard Error",0.30587445737339591]
[7,null,"Alpha",{"$f":"1-D6","v":5.0000000000000044E-2},null,"Alpha",{"$f":"1-G6","v":5.0000000000000044E-2},null,"Median",6.5]
[6,null,"Alpha/2",{"$f":"D7/2","v":2.5000000000000022E-2},null,"Margin of Error",{"$f":"_xlfn.CONFIDENCE.T(G7,G5,G3)","v":0.61467773520791935},null,"Mode",8]
[3,null,"df",{"$f":"D3-1","v":49},null,"Lower Limit",{"$f":"$G$4-$G$8","v":5.7253222647920801},null,"Standard Deviation",2.1628590300048383]
[3,null,"Upper t",{"$f":"_xlfn.T.INV(1-D8,D9)","v":2.0095752371292388},null,"Upper Limit",{"$f":"$G$4+$G$8","v":6.9546777352079197},null,"Sample Variance",4.6779591836734697]
[8,null,"Standard Error",{"$f":"D5/SQRT(D3)","v":0.30587445737339591},null,{"$f":"\"We are \"&TEXT(G6,\"0%\")&\" sure the pop mean for \"&A1&\" lies between \"&FIXED(G9,2)&\" and \"&FIXED(G10,2)&\".\"","v":"We are 95% sure the pop mean for Rating for Miami International Airport lies between 5.73 and 6.95."},null,null,"Kurtosis",-1.180629819065778]
[10,null,"Margin of Error",{"$f":"D10*D11","v":0.61467773520791935},null,null,null,null,"Skewness",-0.1444922463709003]
[4,null,"Lower Limit",{"$f":"$D$4-$D$12","v":5.7253222647920801},null,null,null,null,"Range",8]
[8,null,"Upper Limit",{"$f":"$D$4+$D$12","v":6.9546777352079197},null,null,null,null,"Minimum",2]
[7,null,{"$f":"\"We are \"&TEXT(D6,\"0%\")&\" the pop mean for \"&J5&\" lies between \"&FIXED(D13,2)&\" and \"&FIXED(D14,2)&\".\"","v":"We are 95% the pop mean for 6.34 lies between 5.73 and 6.95."},null,null,null,null,null,"Maximum",10]
[8,null,null,null,null,{"$f":"\"We estimate the population mean to be about \"&G4&\" with a margin of error of +/-\"&ROUND(G8,2)","v":"We estimate the population mean to be about 6.34 with a margin of error of +/-0.61"},null,null,"Sum",317]
[7,null,null,null,null,null,null,null,"Count",50]
[5,null,null,null,null,null,null,null,"Confidence Level(95.0%)",0.61467773520791935]
[9]
[5,null,{"$f":"\"We estimate the population mean to be about \"&D4&\" with a margin of error of +/-\"&ROUND(D12,2)","v":"We estimate the population mean to be about 6.34 with a margin of error of +/-0.61"},null,null,null,null,null,"Lower Limit",{"$f":"J5-J18","v":5.7253222647920801}]
[8,null,null,null,null,null,null,null,"Upper Limit",{"$f":"J5+J18","v":6.9546777352079197}]
[4,null,null,null,null,null,null,null,{"$f":"\"We are \"&MID(I18,SEARCH(\"(\",I18)+1,5)&\" sure the pop mean for \"&A1&\" lies between \"&FIXED(J20,2)&\" and \"&FIXED(J21,2)&\".\"","v":"We are 95.0% sure the pop mean for Rating for Miami International Airport lies between 5.73 and 6.95."}]
[3]
[8]
[5]
[5]
[4,null,null,null,null,null,null,null,{"$f":"\"We estimate the population mean to be about \"&J5&\" with a margin of error of +/-\"&ROUND(J18,2)","v":"We estimate the population mean to be about 6.34 with a margin of error of +/-0.61"}]
[4]
[4]
[8]
[4]
[5]
[6]
[2]
[5]
[9]
[9]
[8]
[4]
[8]
[9]
[9]
[5]
[9]
[7]
[8]
[3]
[10]
[8]
[9]
[6]

{"sheet":"(18)","index":11,"n_rows":41,"n_cols":6,"rows_kept":41,"cut":false,"hidden":false,"merged":[[21,3,22,9],[23,3,24,9]]}
["Job Search Time (Weeks)",null,"Job Search Time (Weeks)",null,null,"Method 3:"]
[21]
[14,null,"Mean",22]
[51,null,"Standard Error",1.8793752371602861]
[16,null,"Median",20]
[17,null,"Mode",17]
[14,null,"Standard Deviation",11.886212655091246]
[16,null,"Sample Variance",141.28205128205127]
[12,null,"Kurtosis",0.90295558149164057]
[48,null,"Skewness",1.0061978446889506]
[0,null,"Range",52]
[27,null,"Minimum",0]
[17,null,"Maximum",52]
[32,null,"Sum",880]
[24,null,"Count",40]
[12,null,"Confidence Level(95.0%)",3.8013952275460423]
[10]
[52,null,"a",{"$f":"C3","v":"Mean"},{"$f":"D3","v":22}]
[21,null,"b","Margin of Error",{"$f":"D16","v":3.8013952275460423}]
[26,null,null,"Lower Limit",{"$f":"E18-E19","v":18.198604772453958}]
[14,null,null,"Upper Limit",{"$f":"E18+E19","v":25.801395227546042}]
[13,null,"c",{"$f":"\"We are 95% sure that the population mean job search time for workers 55 or older is between \"&ROUND(E20,2)&\" and \"&ROUND(E21,2)&\" weeks.\"","v":"We are 95% sure that the population mean job search time for workers 55 or older is between 18.2 and 25.8 weeks."}]
[24]
[19,null,"d","The descriptive statistics output shows that the skewness is 1.0062. There is a moderate  positive skewness in this data set. This can be expected to exist in a population such as this. While the above results are acceptable, considering a slightly larger sample next time would be a good strategy."]
[28]
[26]
[26]
[10]
[21]
[44]
[36]
[22]
[39]
[17]
[17]
[10]
[19]
[16]
[22]
[5]
[22]

{"sheet":"(20)","index":12,"n_rows":21,"n_cols":4,"rows_kept":21,"cut":false,"hidden":false,"merged":[[19,2,22,4]]}
["Program Minutes",null,"Program Minutes"]
[21.06]
[21.66,null,"Mean",21.999999999999996]
[23.82,null,"Standard Error",0.25024619456594505]
[21.52,null,"Median",22.05]
[20.02,null,"Mode",21.52]
[22.37,null,"Standard Deviation",1.1191350043201833]
[23.36,null,"Sample Variance",1.2524631578947369]
[22.24,null,"Kurtosis",-0.71170512198555036]
[21.23,null,"Skewness",9.1838719364052232E-2]
[20.3,null,"Range",3.84]
[21.91,null,"Minimum",20.02]
[22.2,null,"Maximum",23.86]
[22.19,null,"Sum",439.99999999999994]
[23.44,null,"Count",20]
[20.62,null,"Confidence Level(95.0%)",0.5237713047506648]
[23.86]
[21.52,null,"Lower Limit",{"$f":"D3-D16","v":21.476228695249333}]
[23.14,null,"Upper Limit",{"$f":"D3+D16","v":22.52377130475066}]
[21.2,null,{"$f":"\"We are 95% sure that the population mean number of programming minutes in a 1/2 hour sitcom lies between \"&ROUND(D18,2)&\" and \"&ROUND(D19,2)&\" minutes.\"","v":"We are 95% sure that the population mean number of programming minutes in a 1/2 hour sitcom lies between 21.48 and 22.52 minutes."}]
[22.34]

{"sheet":"(21)","index":13,"n_rows":21,"n_cols":4,"rows_kept":21,"cut":false,"hidden":false,"merged":[[19,2,22,4]]}
["Annual Consumption (in liters)",null,"Annual Consumption (in liters)"]
[266]
[170,null,"Mean",130]
[164,null,"Standard Error",14.621901381147392]
[93,null,"Median",122.5]
[82,null,"Mode",93]
[222,null,"Standard Deviation",65.391130897087265]
[102,null,"Sample Variance",4276]
[0,null,"Kurtosis",0.53641523667739666]
[199,null,"Skewness",-0.15491239611388019]
[115,null,"Range",266]
[113,null,"Minimum",0]
[93,null,"Maximum",266]
[174,null,"Sum",2600]
[130,null,"Count",20]
[171,null,"Confidence Level(95.0%)",30.603991311927565]
[110]
[97,null,"Lower Limit",{"$f":"D3-D16","v":99.396008688072442}]
[169,null,"Upper Limit",{"$f":"D3+D16","v":160.60399131192756}]
[0,null,{"$f":"\"We are 95% sure that the population mean for annual consumption of alcoholic beverages by young women of drinking age in the UK lies between \"&ROUND(D18,2)&\" and \"&ROUND(D19,2)&\" liters.\"","v":"We are 95% sure that the population mean for annual consumption of alcoholic beverages by young women of drinking age in the UK lies between 99.4 and 160.6 liters."}]
[130]

{"sheet":"(22)","index":14,"n_rows":29,"n_cols":5,"rows_kept":29,"cut":false,"hidden":false,"merged":[[19,3,22,5]]}
["Ticket Sales ($)",null,"Ticket Sales ($)"]
[20200]
[8350,null,"Mean",10905]
[10750,null,"Standard Error",792.42286690882406]
[13900,null,"Median",10750]
[{"$f":"13650-465","v":13185},null,"Mode",{"$error":"#N/A"}]
[10150,null,"Standard Deviation",3962.1143345441205]
[7300,null,"Sample Variance",15698350]
[6240,null,"Kurtosis",1.6567064716838455]
[4200,null,"Skewness",1.0147276489001247]
[9200,null,"Range",17200]
[13000,null,"Minimum",4200]
[14000,null,"Maximum",21400]
[12700,null,"Sum",272625]
[6750,null,"Count",25]
[21400,null,"Confidence Level(95.0%)",1635.4804152142783]
[11320]
[9940,null,null,"Lower Limit",{"$f":"D3-D16","v":9269.5195847857212}]
[7430,null,null,"Upper Limit",{"$f":"D3+D16","v":12540.480415214279}]
[6700,null,null,{"$f":"\"We are 95% sure that the population mean three-day ticket sales revenue per theater is between  \"&DOLLAR(E18,2)&\" and \"&DOLLAR(E19,2)&\".\"","v":"We are 95% sure that the population mean three-day ticket sales revenue per theater is between  $9,269.52 and $12,540.48."}]
[11380]
[9700]
[11200,null,"a"]
[13500]
[9330,null,null,"Ticket price =",7.16]
[10800,null,"b","Est. # customers per Theater",{"$f":"ROUND(D3/E25,0)","v":1523}]
[null,null,null,"# theaters",3118]
[null,null,"c","Est. # customersover weekend",{"$f":"E27*E26","v":4748714}]
[null,null,null,"Total Revenue",{"$f":"E28*E25","v":34000792.240000002}]

{"sheet":"(23)","index":15,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["C L",0.95]
["E",10]
["Sigma",40]
["Alpha",{"$f":"1-B1","v":5.0000000000000044E-2}]
["Alpha/2",{"$f":"B4/2","v":2.5000000000000022E-2}]
["z",{"$f":"_xlfn.NORM.S.INV(1-B5)","v":1.9599639845400536}]
["n",{"$f":"ROUNDUP((B6*B3/B2)^2,0)","v":62}]

{"sheet":"(26)","index":16,"n_rows":7,"n_cols":8,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Xbar",2.41,null,"Xbar",2.41,null,"Xbar",2.41]
["Sigma",0.15,null,"Sigma",0.15,null,"Sigma",0.15]
["C L",0.95,null,"C L",0.95,null,"C L",0.95]
["Alpha/2",{"$f":"(1-B3)/2","v":2.5000000000000022E-2},null,"Alpha/2",{"$f":"(1-E3)/2","v":2.5000000000000022E-2},null,"Alpha/2",{"$f":"(1-H3)/2","v":2.5000000000000022E-2}]
["E",7.0000000000000007E-2,null,"E",0.05,null,"E",0.03]
["z",{"$f":"_xlfn.NORM.S.INV(1-B4)","v":1.9599639845400536},null,"z",{"$f":"_xlfn.NORM.S.INV(1-E4)","v":1.9599639845400536},null,"z",{"$f":"_xlfn.NORM.S.INV(1-H4)","v":1.9599639845400536}]
["n",{"$f":"ROUNDUP((B6*B2/B5)^2,0)","v":18},null,"n",{"$f":"ROUNDUP((E6*E2/E5)^2,0)","v":35},null,"n",{"$f":"ROUNDUP((H6*H2/H5)^2,0)","v":97}]

{"sheet":"(37)","index":17,"n_rows":1109,"n_cols":9,"rows_kept":1109,"cut":false,"hidden":false,"merged":[]}
["Binomial Tests"]
["Experiment consists of a sequence of n identical trials. Random Variable counts the number of successes in a Fixed number of trials, n. - Fixed # of Identical Trials = n",null,null,null,null,"Yes"]
["Only 2 outcomes are possible on each identical trial. Success or Failure. - Each trial only results in S or F",null,null,null,null,"Yes"]
["Probability of Success = p = (π \"pi\"). Probability of Failure = 1-p. Probability remains the same on each trial. - p remains the same for each trial",null,null,null,null,"Yes"]
["The trials are independent (one does not affect the next) - All events are independent",null,null,null,null,"Yes"]
[]
[]
[]
["Response",null,"Sample Size = n",{"$f":"COUNTA(A10:A1109)","v":1100},null,null,null,null," =COUNTA(A10:A1109)"]
["Yes",null,{"$f":"\"Count of \"&E10","v":"Count of Yes"},{"$f":"COUNTIF($A$10:$A$1109,E10)","v":473},"Yes","Strongly dislike current working conditions",null,null," =COUNTIF($A$10:$A$1109,F10)"]
["No",null,{"$f":"\"Count of \"&E11","v":"Count of No"},{"$f":"COUNTIF($A$10:$A$1109,E11)","v":627},"No",null,null,null," =COUNTIF($A$10:$A$1109,F11)"]
["Yes",null,{"$f":"\"P(\"&E10&\")\"","v":"P(Yes)"},{"$f":"D10/$D$9","v":0.43},"sample proportion = Point Estimate","p","Proportion of workers Strongly dislike current working conditions",null," =D10/$D$9"]
["No",null,{"$f":"\"P(\"&E11&\")\"","v":"P(No)"},{"$f":"D11/$D$9","v":0.56999999999999995},null,null,null,null," =D11/$D$9"]
["Yes",null,"n*p>5",{"$f":"D9*D12","v":473},{"$f":"IF(D14=\"\",\"\",D14>5)","v":true},"Can we use Normal Curve?",null,null," =D9*D12"]
["Yes",null,"n*(1-p)>5",{"$f":"D9*D13","v":627},{"$f":"IF(D15=\"\",\"\",D15>5)","v":true},null,null,null," =D9*D13"]
["No",null,"Confidence Level",0.95,null,null,null,null," 0.95"]
["No",null,"Significance Level",{"$f":"1-D16","v":5.0000000000000044E-2},"alpha",null,null,null," =1-D16"]
["Yes",null,"alpha/2",{"$f":"D17/2","v":2.5000000000000022E-2},null,null,null,null," =D17/2"]
["Yes",null,"z upper",{"$f":"_xlfn.NORM.S.INV(1-D18)","v":1.9599639845400536},null,null,null,null," =NORM.S.INV(1-D18)"]
["Yes",null,"Standard Error",{"$f":"SQRT(D12*D13/D9)","v":1.4927095558687289E-2},"SQRT(p*(1-p)/n)",null,null,null," =SQRT(D12*D13/D9)"]
["Yes",null,"Margin of error",{"$f":"D20*D19","v":2.9256569688814876E-2},null,null,null,null," =D20*D19"]
["No",null,"Lower Limit",{"$f":"$D$12-$D$21","v":0.40074343031118509},null,null,null,null," =$D$12-$D$21"]
["No",null,"Upper Limit",{"$f":"$D$12+$D$21","v":0.4592565696888149},null,null,null,null," =$D$12+$D$21"]
["No",null,"Conclusion:"]
["No",null,{"$f":"IF(D23=\"\",\"\",\"The \"&TEXT(D16,\"0.00%\")&\" confidence interval for the \"&LOWER(G12)&\" is \"&TEXT(D22,\"0.0000\")&\" to \"&TEXT(D23,\"0.0000\")&\".\")","v":"The 95.00% confidence interval for the proportion of workers strongly dislike current working conditions is 0.4007 to 0.4593."}]
["Yes",null,"So, since this company hires people on the spot if they know their field and they know Excel, be sure to study both in school!"]
["No"]
["No"]
["No"]
["No"]
["No"]
["Yes"]
["No"]
["No"]
["Yes"]
["No"]
["No"]
["No"]
["Yes"]
["No"]
["No"]
["No"]
["No"]
["Yes"]
["No"]
["No"]
["No"]
["No"]
["Yes"]
["No"]
["No"]
["No"]
["Yes"]
["No"]
["No"]
["Yes"]
["Yes"]
["Yes"]
["No"]
["No"]
["Yes"]
["Yes"]
["No"]
["Yes"]
["Yes"]
["No"]
["No"]
["No"]
["No"]
["No"]
["Yes"]
["Yes"]
["No"]
["Yes"]
["Yes"]
["No"]
["Yes"]
["No"]
["Yes"]
["Yes"]
["No"]
["No"]
["No"]
["Yes"]
["No"]
["Yes"]
["No"]
["Yes"]
["No"]
["No"]
["No"]
["No"]
["No"]
["Yes"]
["No"]
["Yes"]
["No"]
["Yes"]
["Yes"]
["Yes"]
["Yes"]
["No"]
["No"]
["No"]
["Yes"]
["Yes"]
["Yes"]
["Yes"]
["No"]
["Yes"]
["Yes"]
["No"]
["No"]
["No"]
["No"]
["Yes"]
["No"]
["No"]
["No"]
["Yes"]
["Yes"]
["No"]
["No"]
["No"]
["No"]
["No"]
["Yes"]
["No"]
["Yes"]
["No"]
["No"]
["No"]
["No"]
["No"]
["Yes"]
["No"]
["No"]
["No"]
["No"]
["No"]
["Yes"]
["Yes"]
["No"]
["Yes"]
["No"]
["No"]
["No"]
["Yes"]
["No"]
["No"]
["Yes"]
["Yes"]
["No"]
["No"]
["No"]
["Yes"]
["Yes"]
["Yes"]
["Yes"]
["No"]
["Yes"]
["Yes"]
["Yes"]
["Yes"]
["Yes"]
["Yes"]
["No"]
["Yes"]
["No"]
["No"]
["Yes"]
["Yes"]
["Yes"]
["No"]
["No"]
["No"]
["No"]
["No"]
["No"]
["No"]
["No"]
["No"]
["No"]
["Yes"]
["No"]
["Yes"]
["Yes"]
["Yes"]
["Yes"]
["No"]
["No"]
["Yes"]
["No"]
["No"]
["No"]
["No"]
["No"]
["Yes"]
["Yes"]
["No"]
["No"]
["No"]
["Yes"]
["Yes"]
["No"]
["Yes"]
["Yes"]
["Yes"]
["No"]
["No"]
["Yes"]
["Yes"]
["No"]
["No"]
["No"]
["No"]
["Yes"]
["No"]
["No"]
["No"]
["Yes"]
["No"]
["No"]
["Yes"]
["Yes"]
["No"]
["Yes"]
["Yes"]
["No"]
["Yes"]
["No"]
["No"]
["No"]
["No"]
["No"]
["No"]
["Yes"]
["No"]
["Yes"]
["No"]
["Yes"]
["Yes"]
["Yes"]
["No"]
["No"]
["No"]
["No"]
["No"]
["Yes"]
["Yes"]
["Yes"]
["No"]
["No"]
["No"]
["Yes"]
["Yes"]
["Yes"]
["No"]
["Yes"]
["Yes"]
["No"]
["No"]
["Yes"]
["Yes"]
["No"]
["No"]
["No"]
["No"]
["Yes"]
["No"]
["Yes"]
["No"]
["No"]
["No"]
["No"]
["No"]
["Yes"]
["No"]
["Yes"]
["Yes"]
["No"]
["Yes"]
["Yes"]
["No"]
["No"]
["Yes"]
["No"]
["Yes"]
["Yes"]
["Yes"]
["No"]
["No"]
["Yes"]
["No"]
["No"]
["Yes"]
["Yes"]
["Yes"]
["Yes"]
["No"]
["No"]
["No"]
["No"]
["Yes"]
["No"]
["No"]
["Yes"]
["Yes"]
["No"]
["No"]
["No"]
["No"]
["Yes"]
["No"]
["No"]
["No"]
["No"]
["No"]
["No"]
["Yes"]
["No"]
["Yes"]
["No"]
["No"]
["Yes"]
["No"]
["No"]
["Yes"]
["No"]
["No"]
["Yes"]
["Yes"]
["No"]
["Yes"]
["No"]
["No"]
["Yes"]
["Yes"]
["No"]
["No"]
["Yes"]
["No"]
["No"]
["No"]
["Yes"]
["Yes"]
["Yes"]
["Yes"]
["No"]
["Yes"]
["No"]
["No"]
["No"]
["No"]
["Yes"]
["No"]
["Yes"]
["No"]
["Yes"]
["No"]
["Yes"]
["No"]
["Yes"]
["No"]
["Yes"]
["Yes"]
["No"]
["No"]
["Yes"]
["No"]
["No"]
["No"]
["Yes"]
["Yes"]
["No"]
["No"]
["No"]
["Yes"]
["No"]
["No"]
["No"]
["No"]
["No"]
["Yes"]
["Yes"]
["Yes"]
["No"]
["Yes"]
["No"]
["No"]
["No"]
["Yes"]
["No"]
["Yes"]
["Yes"]
["Yes"]
["No"]
["No"]
["No"]
["No"]
["Yes"]
["Yes"]
["No"]
["No"]
["Yes"]
["Yes"]
["No"]
["Yes"]
["No"]
["Yes"]
["Yes"]
["Yes"]
["Yes"]
["Yes"]
["Yes"]
["Yes"]
["Yes"]
["No"]
["No"]
["No"]
["No"]
["No"]
["No"]
["No"]
["No"]
["No"]
["Yes"]
["No"]
["Yes"]
["No"]
["Yes"]
["No"]
["Yes"]
["No"]
["Yes"]
["No"]
["No"]
["Yes"]
["Yes"]
["No"]
["No"]
["Yes"]
["Yes"]
["No"]
["No"]
["Yes"]
["No"]
["Yes"]
["No"]
["No"]
["Yes"]
["Yes"]
["No"]
["Yes"]
["Yes"]
["Yes"]
["No"]
["No"]
["No"]
["No"]
["Yes"]
["No"]
["No"]
["No"]
["No"]
["Yes"]
["Yes"]
["No"]
["Yes"]
["No"]
["Yes"]
["Yes"]
["No"]
["Yes"]
["No"]
["Yes"]
["No"]
["Yes"]
["No"]
["No"]
["No"]
["Yes"]
["Yes"]
["Yes"]
["Yes"]
["Yes"]
["Yes"]
["Yes"]
["No"]
["Yes"]
["Yes"]
["Yes"]
["Yes"]
["No"]
["No"]
["No"]
["No"]
["No"]
["No"]
["Yes"]
["Yes"]
["No"]
["No"]
["Yes"]
["No"]
["No"]
["No"]
["Yes"]
["Yes"]
["Yes"]
["No"]
["Yes"]
["No"]
["Yes"]
["No"]
["No"]
["Yes"]
["No"]
["Yes"]
["Yes"]
["Yes"]
["No"]
["No"]
["No"]
["No"]
["No"]
["No"]
["No"]
["No"]
["No"]
["Yes"]
["Yes"]
["No"]
["No"]
["Yes"]
["No"]
["Yes"]
["Yes"]
["No"]
["Yes"]
["No"]
["Yes"]
["No"]
["Yes"]
["Yes"]
["Yes"]
["No"]
["No"]
["No"]
["No"]
["Yes"]
["Yes"]
["No"]
["No"]
["Yes"]
["No"]
["No"]
["No"]
["No"]
["No"]
["No"]
["Yes"]
["Yes"]
["Yes"]
["Yes"]
["Yes"]
["Yes"]
["No"]
["No"]
["No"]
["Yes"]
["No"]
["No"]
["Yes"]
["Yes"]
["No"]
["Yes"]
["No"]
["Yes"]
["No"]
["Yes"]
["No"]
["No"]
["Yes"]
["No"]
["No"]
["No"]
["Yes"]
["Yes"]
["No"]
["No"]
["No"]
["No"]
["Yes"]
["No"]
["No"]
["Yes"]
["No"]
["No"]
["No"]
["No"]
["Yes"]
["No"]
["Yes"]
["Yes"]
["No"]
["No"]
["No"]
["Yes"]
["No"]
["No"]
["No"]
["No"]
["Yes"]
["No"]
["No"]
["No"]
["No"]
["No"]
["Yes"]
["No"]
["No"]
["No"]
["Yes"]
["Yes"]
["Yes"]
["Yes"]
["Yes"]
["No"]
["No"]
["Yes"]
["No"]
["No"]
["Yes"]
["Yes"]
["Yes"]
["No"]
["No"]
["Yes"]
["No"]
["Yes"]
["No"]
["Yes"]
["No"]
["Yes"]
["No"]
["Yes"]
["Yes"]
["Yes"]
["Yes"]
["No"]
["No"]
["No"]
["Yes"]
["Yes"]
["Yes"]
["No"]
["No"]
["No"]
["No"]
["Yes"]
["No"]
["No"]
["No"]
["No"]
["No"]
["Yes"]
["Yes"]
["No"]
["Yes"]
["No"]
["No"]
["No"]
["Yes"]
["No"]
["No"]
["Yes"]
["No"]
["No"]
["No"]
["No"]
["Yes"]
["No"]
["No"]
["No"]
["No"]
["Yes"]
["No"]
["No"]
["Yes"]
["No"]
["Yes"]
["No"]
["No"]
["No"]
["No"]
["No"]
["No"]
["No"]
["No"]
["No"]
["No"]
["Yes"]
["No"]
["No"]
["No"]
["Yes"]
["Yes"]
["Yes"]
["Yes"]
["Yes"]
["No"]
["Yes"]
["No"]
["No"]
["No"]
["No"]
["Yes"]
["No"]
["No"]
["No"]
["Yes"]
["Yes"]
["No"]
["No"]
["No"]
["No"]
["No"]
["No"]
["No"]
["No"]
["Yes"]
["No"]
["No"]
["Yes"]
["Yes"]
["No"]
["Yes"]
["Yes"]
["No"]
["Yes"]
["Yes"]
["No"]
["Yes"]
["No"]
["No"]
["No"]
["Yes"]
["Yes"]
["Yes"]
["No"]
["No"]
["Yes"]
["No"]
["Yes"]
["Yes"]
["Yes"]
["No"]
["Yes"]
["No"]
["Yes"]
["Yes"]
["Yes"]
["Yes"]
["No"]
["Yes"]
["Yes"]
["No"]
["Yes"]
["Yes"]
["Yes"]
["Yes"]
["Yes"]
["No"]
["Yes"]
["No"]
["No"]
["No"]
["Yes"]
["Yes"]
["Yes"]
["No"]
["Yes"]
["No"]
["Yes"]
["Yes"]
["No"]
["No"]
["Yes"]
["Yes"]
["No"]
["Yes"]
["No"]
["No"]
["Yes"]
["No"]
["No"]
["Yes"]
["No"]
["No"]
["No"]
["No"]
["Yes"]
["No"]
["Yes"]
["No"]
["No"]
["No"]
["No"]
["No"]
["Yes"]
["Yes"]
["No"]
["No"]
["No"]
["Yes"]
["No"]
["No"]
["No"]
["No"]
["Yes"]
["No"]
["Yes"]
["Yes"]
["Yes"]
["Yes"]
["No"]
["No"]
["No"]
["No"]
["No"]
["Yes"]
["Yes"]
["Yes"]
["Yes"]
["Yes"]
["Yes"]
["Yes"]
["No"]
["Yes"]
["Yes"]
["Yes"]
["Yes"]
["No"]
["Yes"]
["Yes"]
["No"]
["No"]
["No"]
["No"]
["Yes"]
["Yes"]
["No"]
["Yes"]
["No"]
["Yes"]
["Yes"]
["No"]
["Yes"]
["Yes"]
["No"]
["No"]
["Yes"]
["No"]
["No"]
["Yes"]
["No"]
["No"]
["Yes"]
["No"]
["Yes"]
["Yes"]
["Yes"]
["No"]
["Yes"]
["Yes"]
["Yes"]
["No"]
["Yes"]
["Yes"]
["No"]
["No"]
["No"]
["Yes"]
["Yes"]
["No"]
["Yes"]
["No"]
["No"]
["No"]
["No"]
["No"]
["No"]
["Yes"]
["No"]
["No"]
["No"]
["Yes"]
["Yes"]
["Yes"]
["Yes"]
["No"]
["No"]
["Yes"]
["No"]
["Yes"]
["Yes"]
["No"]
["No"]
["Yes"]
["No"]
["Yes"]
["No"]
["No"]
["Yes"]
["No"]
["Yes"]
["Yes"]
["No"]
["Yes"]
["Yes"]
["No"]
["Yes"]
["Yes"]
["Yes"]
["Yes"]
["No"]
["No"]
["Yes"]
["No"]
["Yes"]
["No"]
["No"]
["Yes"]
["No"]
["No"]
["Yes"]
["No"]
["No"]
["Yes"]
["No"]
["No"]
["No"]
["No"]
["Yes"]
["Yes"]
["Yes"]
["No"]
["Yes"]
["Yes"]
["Yes"]
["No"]
["Yes"]
["No"]
["No"]
["Yes"]
["No"]
["No"]
["Yes"]
["No"]
["No"]
["No"]
["No"]
["No"]
["Yes"]
["Yes"]
["No"]
["Yes"]
["Yes"]
["Yes"]
["No"]
["No"]
["No"]
["No"]
["No"]
["No"]
["No"]
["No"]
["No"]
["No"]
["No"]
["No"]
["No"]
["No"]
["Yes"]
["Yes"]
["No"]
["Yes"]
["No"]
["No"]
["Yes"]
["No"]
["No"]
["No"]
["No"]
["No"]
["No"]
["No"]
["Yes"]
["No"]
["Yes"]
["No"]
["Yes"]
["Yes"]
["No"]
["No"]
["Yes"]
["Yes"]
["No"]
["Yes"]
["Yes"]
["No"]
["No"]
["Yes"]
["No"]
["Yes"]
["No"]
["No"]
["No"]
["Yes"]
["Yes"]
["Yes"]
["No"]
["No"]
["Yes"]
["Yes"]
["Yes"]
["Yes"]
["Yes"]
["No"]
["No"]
["No"]
["Yes"]
["Yes"]
["No"]
["Yes"]
["No"]
["Yes"]
["No"]
["No"]
["No"]
["No"]
["No"]
["No"]
["No"]
["Yes"]
["Yes"]
["Yes"]
["Yes"]
["No"]
["Yes"]
["No"]
["No"]
["No"]
["No"]
["No"]
["Yes"]
["No"]
["Yes"]
["No"]
["Yes"]
["Yes"]
["Yes"]
["No"]
["No"]
["Yes"]
["No"]
["Yes"]
["Yes"]
["Yes"]
["No"]
["No"]
["Yes"]
["No"]
["No"]
["No"]
["No"]
["Yes"]
["Yes"]
["No"]
["Yes"]
["No"]
["No"]
["No"]
["Yes"]
["No"]
["No"]
["No"]
["Yes"]
["Yes"]
["Yes"]
["Yes"]
["No"]
["No"]
["Yes"]
["Yes"]
["No"]
["No"]
["No"]
["No"]
["Yes"]
["No"]
["No"]
["No"]
["No"]
["Yes"]
["No"]
["No"]
["Yes"]

{"sheet":"(38)","index":18,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[[11,3,13,7]]}
[null,"Beat Estimate",104]
[null,"Matched Estimate",29]
[null,"Fell short",29]
[null,{"$f":"\"P(\"&B1&\")\"","v":"P(Beat Estimate)"},{"$f":"C1/SUM($C$1:$C$3)","v":0.64197530864197527}]
[null,{"$f":"\"P(\"&B2&\")\"","v":"P(Matched Estimate)"},{"$f":"C2/SUM($C$1:$C$3)","v":0.17901234567901234}]
["a",{"$f":"\"P(\"&B3&\")\"","v":"P(Fell short)"},{"$f":"C3/SUM($C$1:$C$3)","v":0.17901234567901234}]
[null,"C L",0.95]
[null,"z",{"$f":"_xlfn.NORM.S.INV(1-(1-C7)/2)","v":1.9599639845400536}," <<== not rounded, like book"]
[null,"Standard Error",{"$f":"SQRT(C4*(1-C4)/SUM(C1:C3))","v":3.7666749568576081E-2},"SQRT(p*(1-p)/n)"]
["b","Margin of Error",{"$f":"C8*C9","v":7.3825472569098716E-2}]
[null,"Lower Limit",{"$f":"$C$4-$C$10","v":0.5681498360728765}]
[null,"Upper Limit",{"$f":"$C$4+$C$10","v":0.71580078121107404},{"$f":"\"We are 95% sure that the proportion of companies that beat the estimate is between \"&ROUND(C11,4)&\" and \"&ROUND(C12,4)","v":"We are 95% sure that the proportion of companies that beat the estimate is between 0.5681 and 0.7158"}]
[]
[]
[null,"E",0.05]
["c","n",{"$f":"ROUNDUP(C4*(1-C4)*(C8/C15)^2,0)","v":354}]

{"sheet":"(55)","index":19,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["n",1677,"US Internet users"]
["pbar",0.74,"ave age 22 said hard to give up computer"]
[null,0.48,"ave age 22 said hard to give up TV"]
[]
["a","C L",0.95]
[null,"z",{"$f":"_xlfn.NORM.S.INV(1-(1-C5)/2)","v":1.9599639845400536}]
[null,"Standard Error",{"$f":"SQRT(B2*(1-B2)/B1)","v":1.0711147565529225E-2},"SQRT(p*(1-p)/n)"]
[null,"Margin of Error",{"$f":"C7*C6","v":2.0993463461531154E-2}]
[null,"Lower Limit",{"$f":"$B$2-$C$8","v":0.7190065365384688}]
[null,"Upper Limit",{"$f":"$B$2+$C$8","v":0.76099346346153118}]
[null,{"$f":"\"We are \"&TEXT(C5,\"0%\")&\" sure that the pop proportion lies between \"&ROUND(C9,3)&\" and \"&ROUND(C10,3)","v":"We are 95% sure that the pop proportion lies between 0.719 and 0.761"}]
[]
["a","C L",0.99]
[null,"z",{"$f":"_xlfn.NORM.S.INV(1-(1-C13)/2)","v":2.5758293035488999}]
[null,"Standard Error",{"$f":"SQRT(B3*(1-B3)/B1)","v":1.2199885626608373E-2},"SQRT(p*(1-p)/n)"]
[null,"Margin of Error",{"$f":"C15*C14","v":3.1424822896962884E-2}]
[null,"Lower Limit",{"$f":"$B$3-$C$16","v":0.44857517710303707}]
[null,"Upper Limit",{"$f":"$B$3+$C$16","v":0.51142482289696289}]
[null,{"$f":"\"We are \"&TEXT(C13,\"0%\")&\" sure that the pop proportion lies between \"&ROUND(C17,3)&\" and \"&ROUND(C18,3)","v":"We are 99% sure that the pop proportion lies between 0.449 and 0.511"}]

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

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

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