{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["CORREL","Formula","VBA "],"not_rendered":{"charts":0,"images":0,"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":"CORREL","index":0,"n_rows":11,"n_cols":17,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,6],[10,1,10,4],[10,5,10,6],[1,11,1,16],[10,11,10,14],[10,15,10,16]]}
[]
[null,"Utilizing CORREL Function",null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Sudent Name","CGPA","SAT Score","Assessment","Residual-1","Residual-2",null,null,null,null,"Sudent Name","CGPA","SAT Score","Assessment","Residual-1","Residual-2"]
[null,"Andy Teal",3.56,1250,80,{"$f":"D5-(INTERCEPT($D$5:$D$9,$C$5:$C$9)+SLOPE($E$5:$E$9,$C$5:$C$9)*C5)","v":-851.35844177510853},{"$f":"E5-(INTERCEPT($E$5:$E$9,$C$5:$C$9)+SLOPE($E$5:$E$9,$C$5:$C$9)*C5)","v":9.7128378378378386},null,null,null,null,"Andy Teal",3.56,1250,80,{"$f":"N5-(INTERCEPT($D$5:$D$9,$C$5:$C$9)+SLOPE($E$5:$E$9,$C$5:$C$9)*M5)","v":-851.35844177510853},{"$f":"O5-(INTERCEPT($E$5:$E$9,$C$5:$C$9)+SLOPE($E$5:$E$9,$C$5:$C$9)*M5)","v":9.7128378378378386}]
[null,"Kim Ralls",2.89,1300,65,{"$f":"D6-(INTERCEPT($D$5:$D$9,$C$5:$C$9)+SLOPE($E$5:$E$9,$C$5:$C$9)*C6)","v":-806.26272105438784},{"$f":"E6-(INTERCEPT($E$5:$E$9,$C$5:$C$9)+SLOPE($E$5:$E$9,$C$5:$C$9)*C6)","v":-10.191441441441441},null,null,null,null,"Kim Ralls",2.89,1300,65,{"$f":"N6-(INTERCEPT($D$5:$D$9,$C$5:$C$9)+SLOPE($E$5:$E$9,$C$5:$C$9)*M6)","v":-806.26272105438784},{"$f":"O6-(INTERCEPT($E$5:$E$9,$C$5:$C$9)+SLOPE($E$5:$E$9,$C$5:$C$9)*M6)","v":-10.191441441441441}]
[null,"Susan W. Eaton",3.7,1100,60,-1000.3336670003337,-9.2623873873873919,null,null,null,null,"Susan W. Eaton",3.7,1100,60,-1000.3336670003337,-9.2623873873873919]
[null,"Robert Walters",3.04,1400,85,-705.16474808141493,10.906531531531527,null,null,null,null,"Robert Walters",3.04,1400,85,-705.16474808141493,10.906531531531527]
[null,"Kathie Flood",3.44,1200,70,-902.23682015348686,-1.1655405405405475,null,null,null,null,"Kathie Flood",3.44,1200,70,-902.23682015348686,-1.1655405405405475]
[]
[null,"Partial Correlation",null,null,null,{"$f":"CORREL(F5:F9,G5:G9)","v":0.5832497293741572},null,null,null,null,null,"Partial Correlation",null,null,null,{"$f":"CORREL(P5:P9,Q5:Q9)","v":0.5832497293741572}]

{"sheet":"Formula","index":1,"n_rows":15,"n_cols":13,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,9,1,12],[10,9,10,11],[11,9,11,11],[12,9,12,11],[14,9,14,11],[10,1,10,3],[11,1,11,3],[12,1,12,3],[14,1,14,3],[1,1,1,4]]}
[]
[null,"Use of Dynamic Correlation Equation",null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Sudent Name","CGPA","SAT Score","Assessment",null,null,null,null,"Sudent Name","CGPA","SAT Score","Assessment"]
[null,"Andy Teal",3.56,1250,80,null,null,null,null,"Andy Teal",3.56,1250,80]
[null,"Kim Ralls",2.89,1300,65,null,null,null,null,"Kim Ralls",2.89,1300,65]
[null,"Susan W. Eaton",3.7,1100,60,null,null,null,null,"Susan W. Eaton",3.7,1100,60]
[null,"Robert Walters",3.04,1400,85,null,null,null,null,"Robert Walters",3.04,1400,85]
[null,"Kathie Flood",3.44,1200,70,null,null,null,null,"Kathie Flood",3.44,1200,70]
[]
[null,"Correlation (SAT, Assessment)",null,null,{"$f":"CORREL(D5:D9,E5:E9)","v":0.75482941242406887},null,null,null,null,"Correlation (SAT, Assessment)",null,null,{"$f":"CORREL(L5:L9,M5:M9)","v":0.75482941242406887}]
[null,"Correlation (SAT, CGPA)",null,null,{"$f":"CORREL(D5:D9,C5:C9)","v":-0.81696257228295233},null,null,null,null,"Correlation (SAT, CGPA)",null,null,{"$f":"CORREL(L5:L9,K5:K9)","v":-0.81696257228295233}]
[null,"Correlation (Assessment, CGPA)",null,null,{"$f":"CORREL(E5:E9,C5:C9)","v":-0.24443845264990144},null,null,null,null,"Correlation (Assessment, CGPA)",null,null,{"$f":"CORREL(M5:M9,K5:K9)","v":-0.24443845264990144}]
[]
[null,"Partial Correlation",null,null,{"$f":"(E11-E12*E13)/(SQRT(1-E12^2)*SQRT(1-E13^2))","v":0.99273184927290758},null,null,null,null,"Partial Correlation",null,null,{"$f":"(M11-M12*M13)/(SQRT(1-M12^2)*SQRT(1-M13^2))","v":0.99273184927290758}]

{"sheet":"VBA ","index":2,"n_rows":15,"n_cols":12,"rows_kept":15,"cut":false,"hidden":false,"merged":[[11,1,11,3],[12,1,12,3],[14,1,14,3],[1,8,1,11],[10,8,10,10],[11,8,11,10],[12,8,12,10],[14,8,14,10],[1,1,1,4],[10,1,10,3]]}
[]
[null,"Running a VBA Code",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Sudent Name","CGPA","SAT Score","Assessment",null,null,null,"Sudent Name","CGPA","SAT Score","Assessment"]
[null,"Andy Teal",3.56,1250,80,null,null,null,"Andy Teal",3.56,1250,80]
[null,"Kim Ralls",2.89,1300,65,null,null,null,"Kim Ralls",2.89,1300,65]
[null,"Susan W. Eaton",3.7,1100,60,null,null,null,"Susan W. Eaton",3.7,1100,60]
[null,"Robert Walters",3.04,1400,85,null,null,null,"Robert Walters",3.04,1400,85]
[null,"Kathie Flood",3.44,1200,70,null,null,null,"Kathie Flood",3.44,1200,70]
[]
[null,"Correlation (SAT, Assessment)",null,null,{"$f":"CORREL(D5:D9,E5:E9)","v":0.75482941242406887},null,null,null,"Correlation (SAT, Assessment)",null,null,{"$f":"CORREL(K5:K9,L5:L9)","v":0.75482941242406887}]
[null,"Correlation (SAT, CGPA)",null,null,{"$f":"CORREL(D5:D9,C5:C9)","v":-0.81696257228295233},null,null,null,"Correlation (SAT, CGPA)",null,null,{"$f":"CORREL(K5:K9,J5:J9)","v":-0.81696257228295233}]
[null,"Correlation (Assessment, CGPA)",null,null,{"$f":"CORREL(E5:E9,C5:C9)","v":-0.24443845264990144},null,null,null,"Correlation (Assessment, CGPA)",null,null,{"$f":"CORREL(L5:L9,J5:J9)","v":-0.24443845264990144}]
[]
[null,"Partial Correlation",null,null,{"$f":"(E11-E12*E13)/(SQRT(1-E12^2)*SQRT(1-E13^2))","v":0.99273184927290758},null,null,null,"Partial Correlation",null,null,{"$f":"(L11-L12*L13)/(SQRT(1-L12^2)*SQRT(1-L13^2))","v":0.99273184927290758}]