{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Title","Std Error & 95% CIs-means","Std Error & 95% CIs-proportions","Std Error & 95% CIs-means-A","Std Error & 95% CIs-prop-A"],"not_rendered":{"charts":0,"images":15,"macros":1,"external_links":0,"defined_names":0,"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":"Title","index":0,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[null,null,"Calculation practice activities to accompany\nCHAPTER 6"]
[]
[null,null,"Social Statistics in Action: A Canadian Introduction"]
[null,null,"Andrea M. Noack"]
[]
[null,null,"Oxford University Press, 2018"]
[]
[null,null,"For more information, visit: "]
[null,null,"https://www.oupcanada.com/catalog/9780199015214.html"]

{"sheet":"Std Error & 95% CIs-means","index":1,"n_rows":40,"n_cols":6,"rows_kept":40,"cut":false,"hidden":false,"merged":[[5,4,5,5],[10,4,10,5],[2,1,2,7],[0,1,0,7],[5,1,6,1],[5,2,6,2]]}
[null,"PRACTICE CALCULATING STANDARD ERRORS AND 95% CONFIDENCE INTERVALS (MEANS)"]
[]
[null,"Calculate the standard error of the mean and upper/lower bounds of the 95% confidence interval for the mean of the cases in the yellow highlighted cells.\nKeep two decimal places throughout your calculations. \nTo check your answers, click on the 'Show Answers' button."]
[]
[]
[null,"Case #","Value on \nVariable X",null,"Sample Statistics"]
[null,null,null,null,"Sample Mean (x-bar):",9.25]
[null,1,17,null,"Sample Standard Deviation (s):",6.54]
[null,2,18,null,"Number of Cases (n):",12]
[null,3,12]
[null,4,8,null,"Population Parameters"]
[null,5,4,null,"Standard Error of the Mean: ","hidden"]
[null,6,3,null,"Lower bound of 95% CI for the mean:","hidden"]
[null,7,13,null,"Upper bound of 95% CI for the mean:","hidden"]
[null,8,1]
[null,9,18]
[null,10,3,null,"Need some help?"]
[null,11,12]
[null,12,2]
[]
[null,"STANDARD ERROR OF THE MEAN CALCULATIONS"]
[null,"Numerator"]
[null,null,"= 6.54"]
[null,"Denominator"]
[null,null,"= square root of 12"]
[null,null,"= ?"]
[null,"Standard Error"]
[null,null,"= 6.54 ÷ 3.46"]
[null,null,"= ?"]
[]
[null,"95% CONFIDENCE INTERVAL FOR THE MEAN CALCULATIONS"]
[null,"1.96 x Std. Error"]
[null,null,"= 1.96 x 1.89"]
[null,null,"= ?"]
[null,"Lower bound"]
[null,null,"= 9.25 - 3.7"]
[null,null,"= ?"]
[null,"Upper bound"]
[null,null,"= 9.25 + 3.7"]
[null,null,"= ?"]

{"sheet":"Std Error & 95% CIs-proportions","index":2,"n_rows":42,"n_cols":6,"rows_kept":42,"cut":false,"hidden":false,"merged":[[0,1,0,7],[2,1,2,7],[5,4,5,5],[9,4,9,5],[5,1,6,1],[5,2,6,2]]}
[null,"PRACTICE CALCULATING STANDARD ERRORS AND 95% CONFIDENCE INTERVALS (PROPORTIONS)"]
[]
[null,"You have been given the proportion of the cases in the yellow highlighted cells that have a \"1\" value.  \nCalculate the standard error of the proportion and upper/lower bounds of the 95% confidence interval for the proportion. \nKeep four decimal places throughout your calculations. \nTo check your answers, click on the 'Show Answers' button."]
[]
[]
[null,"Case #","Value on \nVariable X",null,"Sample Statistics"]
[null,null,null,null,"Proportion of Cases with a \"1\" Value (p):",0.75]
[null,1,1,null,"Number of Cases (n):",12]
[null,2,1]
[null,3,0,null,"Population Parameters"]
[null,4,1,null,"Standard Error of the Proportion:","hidden"]
[null,5,1,null,"Lower bound of 95% CI for the proportion:","hidden"]
[null,6,1,null,"Upper bound of 95% CI for the proportion:","hidden"]
[null,7,1]
[null,8,1]
[null,9,1]
[null,10,0,null,"Need some help?"]
[null,11,1]
[null,12,0]
[]
[null,"STANDARD ERROR OF A PROPORTION CALCULATIONS"]
[null,"Numerator"]
[null,null,"= 0.75 x (1 - 0.75)"]
[null,null,"= ? x ?"]
[null,null,"= ?"]
[null,"Denominator"]
[null,null,"= 12"]
[null,"Standard Error"]
[null,null,"= square root of (0.1875 ÷ 12)"]
[null,null,"= square root of ?"]
[null,null,"= ?"]
[]
[null,"95% CONFIDENCE INTERVAL FOR A PROPORTION CALCULATIONS"]
[null,"1.96 x Std. Error"]
[null,null,"= 1.96 x 0.1249"]
[null,null,"= ?"]
[null,"Lower bound"]
[null,null,"= 0.75 - 0.2448"]
[null,null,"= ?"]
[null,"Upper bound"]
[null,null,"= 0.75 + 0.2448"]
[null,null,"= ?"]

{"sheet":"Std Error & 95% CIs-means-A","index":3,"n_rows":40,"n_cols":12,"rows_kept":40,"cut":false,"hidden":true,"merged":[[0,1,0,7],[2,1,2,7],[5,4,5,5],[10,4,10,5]]}
[null,"PRACTICE CALCULATING STANDARD ERROR AND 95% CONFIDENCE INTERVALS"]
[]
[]
[]
[]
[null,"Case #","Value",null,"Sample Statistics"]
[{"$f":"RANDBETWEEN(1,20)","v":8},1,17,null,"Sample Mean",{"$f":"ROUND(AVERAGE(C7:C18),2)","v":9.25},null,null,{"$f":"C7-$F$7","v":7.75},{"$f":"ROUND(I7^2,2)","v":60.06},{"$f":"ROUND(SUM(J7:J18),2)","v":470.22}]
[{"$f":"RANDBETWEEN(1,20)","v":10},2,18,null,"Sample Standard Deviation",{"$f":"K9","v":6.54},null,null,{"$f":"C8-$F$7","v":8.75},{"$f":"ROUND(I8^2,2)","v":76.56},{"$f":"ROUND(K7/L8,2)","v":42.75},{"$f":"F9-1","v":11}]
[13,3,12,null,"Number of Cases",{"$f":"COUNT(C7:C18)","v":12},null,null,2.75,7.56,{"$f":"ROUND(SQRT(K8),2)","v":6.54}]
[5,4,8,null,null,null,null,null,-1.25,1.56]
[5,5,4,null,"Population Parameters",null,null,null,-5.25,27.56]
[15,6,3,null,"Standard Error of the Mean",{"$f":"F29","v":1.89},null,null,-6.25,39.06]
[4,7,13,null,"Lower bound of 95% CI for the mean",{"$f":"F37","v":5.55},null,null,3.75,14.06]
[17,8,1,null,"Upper bound of 95% CI for the mean",{"$f":"F40","v":12.95},null,null,-8.25,68.06]
[12,9,18,null,null,null,null,null,8.75,76.56]
[2,10,3,null,"Need help?",null,null,null,-6.25,39.06]
[15,11,12,null,null,null,null,null,2.75,7.56]
[20,12,2,null,null,null,null,null,-7.25,52.56]
[]
[]
[null,"STANDARD ERROR OF THE MEAN CALCULATIONS"]
[null,"Numerator:"]
[null,null,{"$f":"CONCATENATE(\"'= \",F8)","v":"'= 6.54"}]
[null,"Denominator:"]
[null,null,{"$f":"CONCATENATE(\"'= square root of \",F25)","v":"'= square root of 12"},null,null,12]
[null,null,{"$f":"CONCATENATE(\"'= \",F26)","v":"'= 3.46"},null,null,{"$f":"ROUND(SQRT(12),2)","v":3.46}]
[null,"Standard error:"]
[null,null,{"$f":"CONCATENATE(\"'= \",F8,\" ÷ \",F26)","v":"'= 6.54 ÷ 3.46"}]
[null,null,{"$f":"CONCATENATE(\"'= \",F29)","v":"'= 1.89"},null,null,{"$f":"ROUND(F8/F26,2)","v":1.89}]
[]
[null,"CONFIDENCE INTERVAL CALCULATIONS"]
[null,"1.96 x SE:"]
[null,null,{"$f":"CONCATENATE(\"'= 1.96 x \",F29,)","v":"'= 1.96 x 1.89"}]
[null,null,{"$f":"CONCATENATE(\"'= \",F34)","v":"'= 3.7"},null,null,{"$f":"ROUND(1.96*F29,2)","v":3.7}]
[null,"Lower bound: "]
[null,null,{"$f":"CONCATENATE(\"'= \",$F$7,\" - \",$F$34)","v":"'= 9.25 - 3.7"}]
[null,null,{"$f":"CONCATENATE(\"'= \",F37)","v":"'= 5.55"},null,null,{"$f":"ROUND($F$7-$F$34,2)","v":5.55}]
[null,"Upper bound:"]
[null,null,{"$f":"CONCATENATE(\"'= \",$F$7,\" + \",$F$34)","v":"'= 9.25 + 3.7"}]
[null,null,{"$f":"CONCATENATE(\"'= \",F40)","v":"'= 12.95"},null,null,{"$f":"ROUND($F$7+$F$34,2)","v":12.95}]

{"sheet":"Std Error & 95% CIs-prop-A","index":4,"n_rows":42,"n_cols":7,"rows_kept":42,"cut":false,"hidden":true,"merged":[[0,1,0,7],[2,1,2,7],[5,4,5,5],[9,4,9,5]]}
[null,"PRACTICE CALCULATING STANDARD ERRORS AND 95% CONFIDENCE INTERVALS (PROPORTIONS)"]
[]
[null,"You have been given the proportion of the cases in the yellow highlighted cells that have a \"1\" value.  \nCalculate the standard error of the proportion and upper/lower bounds of the 95% confidence interval for the proportion. \nKeep four decimal places in your calculations. \nTo check your answers, click on the 'Show Answers' button."]
[]
[]
[null,"Case #","Value",null,"Sample Statistics"]
[{"$f":"RANDBETWEEN(0,1)","v":1},1,1,null,"Proportion of Cases with a \"1\" Value",{"$f":"ROUND(G7/12,4)","v":0.75},{"$f":"COUNTIF(C7:C18,1)","v":9}]
[{"$f":"RANDBETWEEN(0,1)","v":1},2,1,null,"Number of Cases",12]
[0,3,0]
[1,4,1,null,"Population Parameters"]
[1,5,1,null,"Standard Error of the Proportion",{"$f":"F31","v":0.1249}]
[1,6,1,null,"Lower bound of 95% CI for the proportion",{"$f":"F39","v":0.50519999999999998}]
[0,7,1,null,"Upper bound of 95% CI for the proportion",{"$f":"F42","v":0.99480000000000002}]
[0,8,1]
[0,9,1,null,"Need some help?"]
[0,10,0]
[1,11,1]
[0,12,0]
[]
[]
[null,"STANDARD ERROR OF A PROPORTION CALCULATIONS"]
[null,"Numerator"]
[null,null,{"$f":"CONCATENATE(\"'= \",F7,\" x (1 - \",F7,\")\")","v":"'= 0.75 x (1 - 0.75)"}]
[null,null,{"$f":"CONCATENATE(\"'= \",F7,\" x \",F24)","v":"'= 0.75 x 0.25"},null,null,{"$f":"ROUND(1-F7,4)","v":0.25}]
[null,null,{"$f":"CONCATENATE(\"'= \",F25)","v":"'= 0.1875"},null,null,{"$f":"ROUND(F7*F24,4)","v":0.1875}]
[null,"Denominator"]
[null,null,"= 12"]
[null,"Standard Error"]
[null,null,{"$f":"CONCATENATE(\"'= square root of (\",F25,\" ÷ 12)\")","v":"'= square root of (0.1875 ÷ 12)"}]
[null,null,{"$f":"CONCATENATE(\"'= square root of \",F30)","v":"'= square root of 0.0156"},null,null,{"$f":"ROUND(F25/12,4)","v":1.5599999999999999E-2}]
[null,null,{"$f":"CONCATENATE(\"'= \",F31)","v":"'= 0.1249"},null,null,{"$f":"ROUND(SQRT(F30),4)","v":0.1249}]
[]
[null,"95% CONFIDENCE INTERVAL FOR THE PROPORTION CALCULATIONS"]
[null,"1.96 x Std. Error"]
[null,null,{"$f":"CONCATENATE(\"'= 1.96 x \",F31)","v":"'= 1.96 x 0.1249"}]
[null,null,{"$f":"CONCATENATE(\"'= \",F36)","v":"'= 0.2448"},null,null,{"$f":"ROUND(1.96*F31,4)","v":0.24479999999999999}]
[null,"Lower bound"]
[null,null,{"$f":"CONCATENATE(\"'= \",$F$7,\" - \",$F$36)","v":"'= 0.75 - 0.2448"}]
[null,null,{"$f":"CONCATENATE(\"'= \",F39)","v":"'= 0.5052"},null,null,{"$f":"ROUND(F7-F36,4)","v":0.50519999999999998}]
[null,"Upper bound"]
[null,null,{"$f":"CONCATENATE(\"'= \",$F$7,\" + \",$F$36)","v":"'= 0.75 + 0.2448"}]
[null,null,{"$f":"CONCATENATE(\"'= \",F42)","v":"'= 0.9948"},null,null,{"$f":"ROUND(F7+F36,4)","v":0.99480000000000002}]