{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":1,"images":1,"macros":0,"external_links":0,"defined_names":3,"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":"Sheet1","index":0,"n_rows":46,"n_cols":20,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
[null,"       The Sum of the Squares"]
[]
["                This program lets you investigate the"]
[]
[null,"                  Sum of the Squares"]
[]
[null,"      to measure how well a line captures"]
[]
[null,"              the trend in a set of data"]
[]
[null,"How many data points n (2 - 20)?",null,null,{"$f":"G11","v":13},null,13]
[]
[null,"Enter your data below"]
[]
[]
[null,"x","y"]
[1,1,2,null,null,null,null,null,null,null,"What is the slope?",null,null,8.9,null,null,null,null,null," "]
[2,2,5,null,null,null,null,null,null,null,null,"Previous value =",null,{"$f":"N17","v":8.9}]
[{"$f":"IF(Sheet2!B6<=n,A18+1,\"\")","v":3},3,8]
[{"$f":"IF(Sheet2!B7<=n,A19+1,\"\")","v":4},4,14,null,null,null,null,null,null,null,"and the vertical intercept?",null,null,-16]
[{"$f":"IF(Sheet2!B8<=n,A20+1,\"\")","v":5},5,21,null,null,null,null,null,null,null,null,"Previous value =",null,{"$f":"N20","v":-16}]
[{"$f":"IF(Sheet2!B9<=n,A21+1,\"\")","v":6},6,29]
[{"$f":"IF(Sheet2!B10<=n,A22+1,\"\")","v":7},7,39]
[{"$f":"IF(Sheet2!B11<=n,A23+1,\"\")","v":8},8,52,null,null,null,null,null,null,null,"The sum of the squares =",null,null,{"$f":"Sheet2!F26","v":426.39000000000027}]
[{"$f":"IF(Sheet2!B12<=n,A24+1,\"\")","v":9},9,59]
[{"$f":"IF(Sheet2!B13<=n,A25+1,\"\")","v":10},10,68]
[{"$f":"IF(Sheet2!B14<=n,A26+1,\"\")","v":11},11,82,null,"Click each item below for suggestions and investigations"]
[{"$f":"IF(Sheet2!B15<=n,A27+1,\"\")","v":12},12,91,null,null,null,"   Item 1"]
[{"$f":"IF(Sheet2!B16<=n,A28+1,\"\")","v":13},13,107,null,null,null,"   Item 2"]
[{"$f":"IF(Sheet2!B17<=n,A29+1,\"\")","v":""},14,120,null,null,null,"   Item 3"]
[{"$f":"IF(Sheet2!B18<=n,A30+1,\"\")","v":""}]
[{"$f":"IF(Sheet2!B19<=n,A31+1,\"\")","v":""}]
[{"$f":"IF(Sheet2!B20<=n,A32+1,\"\")","v":""}]
[{"$f":"IF(Sheet2!B21<=n,A33+1,\"\")","v":""}]
[{"$f":"IF(Sheet2!B22<=n,A34+1,\"\")","v":""}]
[{"$f":"IF(Sheet2!B23<=n,A35+1,\"\")","v":""}]
[]
[]
[]
[]
[]
["Created by:  Sheldon P. Gordon"]
["                     Farmingdale StateCollege"]
["Development of this module was supported by the "]
["NSF's Division of Undergraduate Education  "]
["under grants DUE-0310123 and DUE-0442160."]

{"sheet":"Sheet2","index":1,"n_rows":26,"n_cols":6,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"x","y","line","squares"]
[null,1,1,2,{"$f":"m*C4+b","v":-7.1},{"$f":"(D4-E4)^2","v":82.809999999999988}]
[null,2,2,5,{"$f":"m*C5+b","v":1.8000000000000007},{"$f":"(D5-E5)^2","v":10.239999999999995}]
[null,3,{"$f":"IF(B5<n,Sheet1!B19,C5)","v":3},{"$f":"IF(C5<n,Sheet1!C19,D5)","v":8},{"$f":"IF(B5<n,m*C6+b,\"\")","v":10.700000000000003},{"$f":"IF(B5<n,(D6-E6)^2,\"\")","v":7.2900000000000151}]
[null,4,{"$f":"IF(B6<n,Sheet1!B20,C6)","v":4},{"$f":"IF(C6<n,Sheet1!C20,D6)","v":14},19.600000000000001,31.360000000000017]
[null,5,{"$f":"IF(B7<n,Sheet1!B21,C7)","v":5},{"$f":"IF(C7<n,Sheet1!C21,D7)","v":21},28.5,56.25]
[null,6,{"$f":"IF(B8<n,Sheet1!B22,C8)","v":6},{"$f":"IF(C8<n,Sheet1!C22,D8)","v":29},37.400000000000006,70.560000000000102]
[null,7,{"$f":"IF(B9<n,Sheet1!B23,C9)","v":7},{"$f":"IF(C9<n,Sheet1!C23,D9)","v":39},46.300000000000004,53.290000000000063]
[null,8,{"$f":"IF(B10<n,Sheet1!B24,C10)","v":8},{"$f":"IF(C10<n,Sheet1!C24,D10)","v":52},55.2,10.240000000000018]
[null,9,{"$f":"IF(B11<n,Sheet1!B25,C11)","v":9},{"$f":"IF(C11<n,Sheet1!C25,D11)","v":59},64.100000000000009,26.010000000000087]
[null,10,{"$f":"IF(B12<n,Sheet1!B26,C12)","v":10},{"$f":"IF(C12<n,Sheet1!C26,D12)","v":68},73,25]
[null,11,{"$f":"IF(B13<n,Sheet1!B27,C13)","v":11},{"$f":"IF(C13<n,Sheet1!C27,D13)","v":82},81.900000000000006,9.999999999998864E-3]
[null,12,{"$f":"IF(B14<n,Sheet1!B28,C14)","v":12},{"$f":"IF(C14<n,Sheet1!C28,D14)","v":91},90.800000000000011,3.9999999999995456E-2]
[null,13,{"$f":"IF(B15<n,Sheet1!B29,C15)","v":13},{"$f":"IF(C15<n,Sheet1!C29,D15)","v":107},99.7,53.289999999999957]
[null,14,{"$f":"IF(B16<n,Sheet1!B30,C16)","v":13},{"$f":"IF(C16<n,Sheet1!C30,D16)","v":107},"",""]
[null,15,{"$f":"IF(B17<n,Sheet1!B31,C17)","v":13},{"$f":"IF(C17<n,Sheet1!C31,D17)","v":107},"",""]
[null,16,{"$f":"IF(B18<n,Sheet1!B32,C18)","v":13},{"$f":"IF(C18<n,Sheet1!C32,D18)","v":107},"",""]
[null,17,{"$f":"IF(B19<n,Sheet1!B33,C19)","v":13},{"$f":"IF(C19<n,Sheet1!C33,D19)","v":107},"",""]
[null,18,{"$f":"IF(B20<n,Sheet1!B34,C20)","v":13},{"$f":"IF(C20<n,Sheet1!C34,D20)","v":107},"",""]
[null,19,{"$f":"IF(B21<n,Sheet1!B35,C21)","v":13},{"$f":"IF(C21<n,Sheet1!C35,D21)","v":107},"",""]
[null,20,{"$f":"IF(B22<n,Sheet1!B36,C22)","v":13},{"$f":"IF(C22<n,Sheet1!C36,D22)","v":107},"",""]
[null,null,{"$f":"IF(B23<n,Sheet1!B37,\"\")","v":""},{"$f":"IF(C23<n,Sheet1!C37,\"\")","v":""},"",""]
[]
[null,null,null,"Sum of squares =",null,{"$f":"SUM(F4:F24)","v":426.39000000000027}]

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