{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Title","Adjusted R2","Adjusted R2-A"],"not_rendered":{"charts":0,"images":5,"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 13"]
[]
[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":"Adjusted R2","index":1,"n_rows":24,"n_cols":3,"rows_kept":24,"cut":false,"hidden":false,"merged":[[2,1,2,5],[0,1,0,5]]}
[null,"PRACTICE CALCULATING ADJUSTED R2\n(MULTIPLE LINEAR REGRESSION)"]
[]
[null,"Use the unadjusted R2 statistic in the yellow highlighted cell, along with the number of cases and \nnumber of independent variables in the regression to calculate the adjusted R2 statistic. \nKeep three decimal places throughout your calculations.\nTo check your answer, click on the 'Show Answer' button."]
[]
[null,"Multiple Linear Regression Information"]
[null,"Unadjusted R2:",0.55700000000000005]
[null,"Number of Cases (n):",96]
[null,"Number of Independent Variables (k):",5]
[null,"Adjusted R2:","hidden"]
[]
[null,"Need some help?"]
[]
[null,"ADJUSTED R2 CALCULATIONS"]
[null,"Adjusted R2 Fraction Numerator"]
[null,null,"= (1 - 0.557) x (96 - 1)"]
[null,null,"= ? x ?"]
[null,null,"= ?"]
[null,"Adjusted R2 Fraction Denominator"]
[null,null,"= 96 - 5 - 1"]
[null,null,"= ?"]
[null,"Adjusted R2"]
[null,null,"= 1 - (42.085 ÷ 90)"]
[null,null,"= ? - ?"]
[null,null,"= ?"]

{"sheet":"Adjusted R2-A","index":2,"n_rows":24,"n_cols":7,"rows_kept":24,"cut":false,"hidden":true,"merged":[[0,1,0,5],[2,1,2,5]]}
[null,"PRACTICE CALCULATING ADJUSTED R2\n(MULTIPLE LINEAR REGRESSION)"]
[]
[]
[]
[null,"Multiple Linear Regression Information"]
[{"$f":"RANDBETWEEN(1,999)/1000","v":0.39700000000000002},"Unadjusted R2",0.55700000000000005]
[{"$f":"RANDBETWEEN(2,10)","v":8},"Number of Independent Variables (k)",5]
[{"$f":"RANDBETWEEN(50,200)","v":75},"Number of Cases (n)",96]
[]
[null,"Adjusted R2",{"$f":"F24","v":0.53200000000000003}]
[]
[]
[null,"ADJUSTED R2 CALCULATIONS"]
[null,"Adjusted R2 Fraction Numerator"]
[null,null,{"$f":"CONCATENATE(\"'= (1 - \",C6,\") x (\",C8,\" - 1)\")","v":"'= (1 - 0.557) x (96 - 1)"}]
[null,null,{"$f":"CONCATENATE(\"'= \",F16,\" x \",G16)","v":"'= 0.443 x 95"},null,null,{"$f":"1-C6","v":0.44299999999999995},{"$f":"C8-1","v":95}]
[null,null,{"$f":"CONCATENATE(\"'= \",F17)","v":"'= 42.085"},null,null,{"$f":"ROUND(F16*G16,3)","v":42.085000000000001}]
[null,"Adjusted R2 Fraction Denominator"]
[null,null,{"$f":"CONCATENATE(\"'= \",C8,\" - \",C7,\" - 1\")","v":"'= 96 - 5 - 1"}]
[null,null,{"$f":"CONCATENATE(\"'= \",F20)","v":"'= 90"},null,null,{"$f":"C8-C7-1","v":90}]
[null,"Adjusted R2"," "]
[null,null,{"$f":"CONCATENATE(\"'= 1 - (\",F17,\" ÷ \",F20,\")\")","v":"'= 1 - (42.085 ÷ 90)"}]
[null,null,{"$f":"CONCATENATE(\"'= 1 - \",F23)","v":"'= 1 - 0.468"},null,null,{"$f":"ROUND(F17/F20,3)","v":0.46800000000000003}]
[null,null,{"$f":"CONCATENATE(\"'= \",F24)","v":"'= 0.532"},null,null,{"$f":"ROUND(1-F23,3)","v":0.53200000000000003}]