{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Regression","Sheet2"],"not_rendered":{"charts":1,"images":1,"macros":0,"external_links":0,"defined_names":12,"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":"Regression","index":0,"n_rows":52,"n_cols":14,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
["     Linear Regression: The Best Linear Fit",null,null,null,null,null,null,null,null,null,null,"Enter the data values in the cells below:"]
[null,null,null,null,null,null,null,null,null,null,null,null,"x","y"]
[null,"        This DIGMath module lets you find the",null,null,null,null,null,null,null,null,null,1,0,2]
[null,"         best linear fit -- the regression line --",null,null,null,null,null,null,null,null,null,2,1,7]
[null,null,"     to fit a set of (x,  y) data",null,null,null,null,null,null,null,null,3,2,12]
[null,null,"using the least-squares approach.",null,null,null,null,null,null,null,null,4,4,22]
[null,null,null,null,null,null,null,null,null,null,null,5,5,17]
["How many data points, n, between 2 and 50?",null,null,null,null,null,null,null,null,null,null,6,74,25]
[null,"   n =",{"$f":"E9","v":5},null,5,null,null,null,null,null,null,7,91,29]
[null,null,null,null,null,null,null,null,null,null,null,8,105,31]
["Based on your data, the equation",null,null,null,null,null,null,null,null,null,null,9,121,27]
["      of the linear regression function is",null,null,null,null,null,null,null,null,null,null,10,135,37]
[null,null,null,null,null,null,null,null,null,null,null,11,152,41]
[null,"      y =",{"$f":"a","v":3.4883720930232553},"x ",{"$f":"IF(b>=0,\"+\",\"-\")","v":"+"},{"$f":"ABS(b)","v":3.6279069767441872},null,null,null,null,null,12,196,48]
[null,null,null,null,null,null,null,null,null,null,null,13,213,55]
["       The correlation coefficient r =",null,null,null,null,null,{"$f":"CORREL(Sheet2!B2:B51,Sheet2!C2:C51)","v":0.91499142199562788},null,null,null,null,14,227,51]
[null,null,null,null,null,null,null,null,null,null,null,15,244,63]
["       and the Sum of the Squares =",null,null,null,null,null,{"$f":"sss","v":12},null,null,null,null,16,258,69]
[null,null,null,null,null,null,null,null,null,null,null,17,274,75]
[null,null,null,null,null,null,null,null,null,null,null,18,288,80]
[null,null,null,null,null,null,null,null,null,null,null,19,305,88]
[null,null,null,null,null,null,null,null,null,null,null,20,319,93]
[null,null,null,null,null,null,null,null,null,null,null,21,335,97]
[null,null,null,null,null,null,null,null,null,null,null,22,349,103]
[null,null,null,null,null,null,null,null,null,null,null,23]
[null,null,null,null,null,null,null,null,null,null,null,24]
[null,null,null,null,null,null,null,null,null,null,null,25]
[null,null,null,null,null,null,null,null,null,null,null,26]
[null,null,null,null,null,null,null,null,null,null,null,27]
[null,null,null,null,null,null,null,null,null,null,null,28]
[null,null,null,null,null,null,null,null,null,null,null,29]
[null,null,null,null,null,null,null,null,null,null,null,30]
[null,null,null,null,null,null,null,null,null,null,null,31]
[null,null,null,null,null,null,null,null,null,null,null,32]
[null,null,null,null,null,null,null,null,null,null,null,33]
[null,null,null,null,null,null,null,null,null,null,null,34]
[null,null,null,null,null,null,null,null,null,null,null,35]
[null,null,null,null,null,null,null,null,null,null,null,36]
["Click each item below for suggestions and investigations",null,null,null,null,null,null,null,null,null,null,37]
[null,null,"   Item 1",null,null,null,null,null,null,null,null,38]
[null,null,"   Item 2",null,null,null,null,null,null,null,null,39]
[null,null,null,null,null,null,null,null,null,null,null,40]
[null,null,null,null,null,null,null,null,null,null,null,41]
[null,null,null,null,null,null,null,null,null,null,null,42]
[null,null,null,null,null,null,null,null,null,null,null,43]
[null,"Created by:  Sheldon P. Gordon",null,null,null,null,null,null,null,null,null,44]
[null,"                     Farmingdale StateCollege",null,null,null,null,null,null,null,null,null,45]
[null,"Development of this module was supported by the ",null,null,null,null,null,null,null,null,null,46]
[null,"NSF's Division of Undergraduate Education  ",null,null,null,null,null,null,null,null,null,47]
[null,"under grants DUE-0310123 and DUE-0442160.",null,null,null,null,null,null,null,null,null,48]
[null,null,null,null,null,null,null,null,null,null,null,49]
[null,null,null,null,null,null,null,null,null,null,null,50]

{"sheet":"Sheet2","index":1,"n_rows":54,"n_cols":15,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
["n","x","y","predicted","diff","      plotting points"]
[1,{"$f":"IF(A2<=nn,Regression!M3,\"\")","v":0},{"$f":"IF($A2<=nn,Regression!N3,\"\")","v":2},{"$f":"a*B2+b","v":3.6279069767441872},{"$f":"D2-C2","v":1.6279069767441872},{"$f":"B2","v":0},{"$f":"C2","v":2}]
[2,{"$f":"IF(A3<=nn,Regression!M4,\"\")","v":1},{"$f":"IF($A3<=nn,Regression!N4,\"\")","v":7},7.1162790697674421,{"$f":"D3-C3","v":0.11627906976744207},{"$f":"B3","v":1},{"$f":"C3","v":7},null,"Linear"]
[3,{"$f":"IF(A4<=nn,Regression!M5,\"\")","v":2},{"$f":"IF($A4<=nn,Regression!N5,\"\")","v":12},10.604651162790699,{"$f":"D4-C4","v":-1.3953488372093013},{"$f":"IF($A4<=nn,B4,x0)","v":2},{"$f":"IF($A4<=nn,C4,y0)","v":12},"a =",{"$f":"SLOPE(C2:C51,B2:B51)","v":3.4883720930232553},"b  =",{"$f":"INTERCEPT(C2:C51,B2:B51)","v":3.6279069767441872}]
[4,{"$f":"IF(A5<=nn,Regression!M6,\"\")","v":4},{"$f":"IF($A5<=nn,Regression!N6,\"\")","v":22},17.581395348837209,-4.4186046511627914,4,22]
[5,{"$f":"IF(A6<=nn,Regression!M7,\"\")","v":5},{"$f":"IF($A6<=nn,Regression!N7,\"\")","v":17},21.069767441860463,4.0697674418604635,5,17]
[6,{"$f":"IF(A7<=nn,Regression!M8,\"\")","v":""},{"$f":"IF($A7<=nn,Regression!N8,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,2,"xMin =",{"$f":"MIN(B2:B51)","v":0},"xMax =",{"$f":"MAX(B2:B51)","v":5},null,null,null,{"$f":"CORREL(B2:B51,C2:C51)","v":0.91499142199562788}]
[7,{"$f":"IF(A8<=nn,Regression!M9,\"\")","v":""},{"$f":"IF($A8<=nn,Regression!N9,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,2]
[8,{"$f":"IF(A9<=nn,Regression!M10,\"\")","v":""},{"$f":"IF($A9<=nn,Regression!N10,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,2,null,{"$f":"I7","v":0},{"$f":"a*I9+b","v":3.6279069767441872}]
[9,{"$f":"IF(A10<=nn,Regression!M11,\"\")","v":""},{"$f":"IF($A10<=nn,Regression!N11,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,2,null,{"$f":"K7","v":5},{"$f":"a*I10+b","v":21.069767441860463}]
[10,{"$f":"IF(A11<=nn,Regression!M12,\"\")","v":""},{"$f":"IF($A11<=nn,Regression!N12,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,2]
[11,{"$f":"IF(A12<=nn,Regression!M13,\"\")","v":""},{"$f":"IF($A12<=nn,Regression!N13,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,2]
[12,{"$f":"IF(A13<=nn,Regression!M14,\"\")","v":""},{"$f":"IF($A13<=nn,Regression!N14,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,2]
[13,{"$f":"IF(A14<=nn,Regression!M15,\"\")","v":""},{"$f":"IF($A14<=nn,Regression!N15,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,2]
[14,{"$f":"IF(A15<=nn,Regression!M16,\"\")","v":""},{"$f":"IF($A15<=nn,Regression!N16,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,2]
[15,{"$f":"IF(A16<=nn,Regression!M17,\"\")","v":""},{"$f":"IF($A16<=nn,Regression!N17,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,2]
[16,{"$f":"IF(A17<=nn,Regression!M18,\"\")","v":""},{"$f":"IF($A17<=nn,Regression!N18,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,2]
[17,{"$f":"IF(A18<=nn,Regression!M19,\"\")","v":""},{"$f":"IF($A18<=nn,Regression!N19,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,2]
[18,{"$f":"IF(A19<=nn,Regression!M20,\"\")","v":""},{"$f":"IF($A19<=nn,Regression!N20,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,2]
[19,{"$f":"IF(A20<=nn,Regression!M21,\"\")","v":""},{"$f":"IF($A20<=nn,Regression!N21,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,2]
[20,{"$f":"IF(A21<=nn,Regression!M22,\"\")","v":""},{"$f":"IF($A21<=nn,Regression!N22,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,2]
[21,{"$f":"IF(A22<=nn,Regression!M23,\"\")","v":""},{"$f":"IF($A22<=nn,Regression!N23,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,2]
[22,{"$f":"IF(A23<=nn,Regression!M24,\"\")","v":""},{"$f":"IF($A23<=nn,Regression!N24,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,2]
[23,{"$f":"IF(A24<=nn,Regression!M25,\"\")","v":""},{"$f":"IF($A24<=nn,Regression!N25,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,2]
[24,{"$f":"IF(A25<=nn,Regression!M26,\"\")","v":""},{"$f":"IF($A25<=nn,Regression!N26,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,2]
[25,{"$f":"IF(A26<=nn,Regression!M27,\"\")","v":""},{"$f":"IF($A26<=nn,Regression!N27,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,2]
[26,{"$f":"IF(A27<=nn,Regression!M28,\"\")","v":""},{"$f":"IF($A27<=nn,Regression!N28,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,2]
[27,{"$f":"IF(A28<=nn,Regression!M29,\"\")","v":""},{"$f":"IF($A28<=nn,Regression!N29,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,2]
[28,{"$f":"IF(A29<=nn,Regression!M30,\"\")","v":""},{"$f":"IF($A29<=nn,Regression!N30,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,2]
[29,{"$f":"IF(A30<=nn,Regression!M31,\"\")","v":""},{"$f":"IF($A30<=nn,Regression!N31,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,2]
[30,{"$f":"IF(A31<=nn,Regression!M32,\"\")","v":""},{"$f":"IF($A31<=nn,Regression!N32,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,2]
[31,{"$f":"IF(A32<=nn,Regression!M33,\"\")","v":""},{"$f":"IF($A32<=nn,Regression!N33,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,2]
[32,{"$f":"IF(A33<=nn,Regression!M34,\"\")","v":""},{"$f":"IF($A33<=nn,Regression!N34,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,2]
[33,{"$f":"IF(A34<=nn,Regression!M35,\"\")","v":""},{"$f":"IF($A34<=nn,Regression!N35,\"\")","v":""},{"$f":"a*B34+b","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},0,2]
[34,{"$f":"IF(A35<=nn,Regression!M36,\"\")","v":""},{"$f":"IF($A35<=nn,Regression!N36,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,2]
[35,{"$f":"IF(A36<=nn,Regression!M37,\"\")","v":""},{"$f":"IF($A36<=nn,Regression!N37,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,2]
[36,{"$f":"IF(A37<=nn,Regression!M38,\"\")","v":""},{"$f":"IF($A37<=nn,Regression!N38,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,2]
[37,{"$f":"IF(A38<=nn,Regression!M39,\"\")","v":""},{"$f":"IF($A38<=nn,Regression!N39,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,2]
[38,{"$f":"IF(A39<=nn,Regression!M40,\"\")","v":""},{"$f":"IF($A39<=nn,Regression!N40,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,2]
[39,{"$f":"IF(A40<=nn,Regression!M41,\"\")","v":""},{"$f":"IF($A40<=nn,Regression!N41,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,2]
[40,{"$f":"IF(A41<=nn,Regression!M42,\"\")","v":""},{"$f":"IF($A41<=nn,Regression!N42,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,2]
[41,{"$f":"IF(A42<=nn,Regression!M43,\"\")","v":""},{"$f":"IF($A42<=nn,Regression!N43,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,2]
[42,{"$f":"IF(A43<=nn,Regression!M44,\"\")","v":""},{"$f":"IF($A43<=nn,Regression!N44,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,2]
[43,{"$f":"IF(A44<=nn,Regression!M45,\"\")","v":""},{"$f":"IF($A44<=nn,Regression!N45,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,2]
[44,{"$f":"IF(A45<=nn,Regression!M46,\"\")","v":""},{"$f":"IF($A45<=nn,Regression!N46,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,2]
[45,{"$f":"IF(A46<=nn,Regression!M47,\"\")","v":""},{"$f":"IF($A46<=nn,Regression!N47,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,2]
[46,{"$f":"IF(A47<=nn,Regression!M48,\"\")","v":""},{"$f":"IF($A47<=nn,Regression!N48,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,2]
[47,{"$f":"IF(A48<=nn,Regression!M49,\"\")","v":""},{"$f":"IF($A48<=nn,Regression!N49,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,2]
[48,{"$f":"IF(A49<=nn,Regression!M50,\"\")","v":""},{"$f":"IF($A49<=nn,Regression!N50,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,2]
[49,{"$f":"IF(A50<=nn,Regression!M51,\"\")","v":""},{"$f":"IF($A50<=nn,Regression!N51,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,2]
[50,{"$f":"IF(A51<=nn,Regression!M52,\"\")","v":""},{"$f":"IF($A51<=nn,Regression!N52,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,2]
[]
[null,null,null,null,null,{"$f":"SUM(F2:F51)","v":12}]
[null,null,null,null,null,"sum squares"]