{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Data"],"not_rendered":{"charts":1,"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":"Data","index":0,"n_rows":178,"n_cols":12,"rows_kept":178,"cut":false,"hidden":false,"merged":[[6,5,6,8],[6,10,6,11],[13,6,13,8],[170,0,170,2],[171,4,171,5]]}
["x","y"]
[3,2.5499999999999998]
[3,2.5499999999999998]
[3.47,1.95]
[3.14,1.89]
[3.46,2.2400000000000002]
[3.59,2.31,null,null,null,"Excel LINEST Results",null,null,null,null,"VBA Code Results"]
[1.75,1.74,null,null,null,"Slope = ",{"$f":"LINEST($B$2:$B$170,$A$2:$A$170,,TRUE)","v":0.26948015436884487},1.3783200687860326,"= Intercept",null,{"$f":"regression(A2:A170,B2:B170)","v":"Slope = "},0.26948015436884981]
[3.03,1.87,null,null,null,null,0.10930658602056477,0.32963597260633126,null,null,"Intercept = ",1.3783200687860182]
[3.18,0.83,null,null,null,"R-squared = ",3.5117131901197661E-2,0.8326512502743455,null,null,"R-squared = ",3.5117131901197952E-2]
[2.77,1.25,null,null,null,null,6.0780030627505024,167]
[1.87,2,null,null,null,null,4.2139287830878374,115.78245346543292]
[3.25,2.62]
[3.5,2.6,null,null,null,null,"Differences between VBA code and Excel results"]
[2.7,2.2599999999999998,null,null,null,null,null,"Absolute","Relative"]
[3.18,1.78,null,null,null,null,"Slope difference",{"$f":"ABS(G8-L8)","v":4.9404924595819466E-15},{"$f":"H16/G8","v":1.8333418544876441E-14}]
[3.55,2.4,null,null,null,null,"Intercept difference",{"$f":"ABS(H8-L9)","v":1.4432899320127035E-14},{"$f":"H17/H8","v":1.0471369928494864E-14}]
[3.88,2.87,null,null,null,null,"R-squared difference",{"$f":"ABS(G10-L10)","v":2.9143354396410359E-16},{"$f":"H18/G10","v":8.2988993743581987E-15}]
[4,2.02]
[3.3,1.28]
[3.12,2.21]
[3.35,2.14]
[2.4,3.07]
[3.65,2.89]
[3.3,2.2999999999999998]
[2.52,2.6]
[3.21,2.7]
[1.87,1.07]
[4,3]
[3.59,0]
[3.4,2.19]
[3,2.27]
[3.08,1.82]
[2.27,2.09]
[3.16,1.06]
[3.5,1.34]
[3.12,2.41]
[3.57,3.1]
[0,2.7]
[3.09,1.4]
[2.48,0.14000000000000001]
[2.27,1.27]
[2.93,2.11]
[2.2999999999999998,3.57]
[2.93,2.5]
[3.27,3.24]
[2.71,3.37]
[3.15,1.81]
[2.85,2.2400000000000002]
[3,2.38]
[0,2.4300000000000002]
[3.68,2.57]
[1.72,1.35]
[3.07,2.41]
[3.45,2.4300000000000002]
[3.25,2.0499999999999998]
[3,2.33]
[2.64,3]
[2.62,0.14000000000000001]
[3.71,2.2400000000000002]
[1.84,0.88]
[3.34,2.0499999999999998]
[2.52,3.08]
[3.62,2.78]
[2.96,2]
[4,3.53]
[3.17,0.43]
[2.96,1.67]
[2.8,3.74]
[2.94,2.63]
[3.17,3.08]
[3.5,1.35]
[3.12,2]
[2.98,2.83]
[3.1,2.57]
[2.4300000000000002,1.38]
[2.48,3.5]
[2.4,1]
[2.38,1.2]
[3.14,1.72]
[2.52,1.9]
[3.38,2.09]
[2.85,2.71]
[3.64,3.03]
[2.96,1.1100000000000001]
[2.5499999999999998,0.5]
[3.63,3.55]
[3.4,3.77]
[3,2.04]
[3.62,3.76]
[3.38,2.87]
[2.92,1.1499999999999999]
[3.25,0.77]
[3.55,3.01]
[3.81,2.35]
[3.29,2.38]
[2.92,2.72]
[2.72,1.83]
[3.13,1.82]
[3.14,1.86]
[2.84,3.22]
[3.8,3.57]
[2.42,2]
[2.7,2.65]
[3.23,2.8]
[3.53,2.56]
[3,1.48]
[3.17,2.04]
[3.09,2.4]
[3.23,1.73]
[3.31,2.42]
[2.5499999999999998,2.14]
[2.81,2.65]
[2.8,3.2]
[2.8,2]
[1.74,1.64]
[2.1,1.1399999999999999]
[2.91,2.42]
[2.36,2.13]
[2.0499999999999998,0.85]
[2.67,2.13]
[2.65,2.87]
[2.75,2.23]
[2.65,1.77]
[3.04,0.85]
[3,3.03]
[2.12,1.74]
[2.6,2.64]
[3.39,2.89]
[2.19,2]
[2.79,0.7]
[3.22,3.88]
[3.25,2.23]
[2.36,3.37]
[2.93,2.73]
[2.34,1.68]
[3.05,3.05]
[2.77,1.23]
[3.5,3]
[2.88,2.59]
[2.74,1.9]
[3.8,3.2]
[3.44,1]
[3.21,2]
[2.57,0.93]
[3.3,2.41]
[3.1,0.9]
[2.16,2.1]
[2.4500000000000002,3.7]
[3.04,1.93]
[3.49,0.14000000000000001]
[2.61,2.5299999999999998]
[3.1,1]
[2.9,2.54]
[2.77,2.13]
[3.93,3.18]
[3.14,3.54]
[3.85,2.16]
[3.62,2.15]
[2.3199999999999998,1.33]
[3.22,0.83]
[2.5,3]
[2.67,3.75]
[2.88,1.88]
[2.19,1.08]
[3.56,3.7]
[3.45,2]
[2.82,2.15]
[2.95,0.5]
[3.21,2.76]
["Cell Formulas Calculation"]
[{"$f":"SUM(A2:A170)","v":499.94000000000028},{"$f":"SUM(B2:B170)","v":367.65999999999991},{"$f":"COUNT(B2:B170)","v":169},null,"VBA Results"]
[{"$f":"SUMSQ(A2:A170)","v":1536.962400000001},{"$f":"SUMSQ(B2:B170)","v":919.84179999999969},{"$f":"SUMPRODUCT(A2:A170,B2:B170)","v":1103.2582000000004},null,{"$f":"regression(A2:A170,B2:B170)","v":"Slope = "},0.26948015436884981]
[{"$f":"A172/$C$172","v":2.9582248520710075},{"$f":"B172/$C$172","v":2.1755029585798811},null,null,"Intercept = ",1.3783200687860182]
["b","a",null,null,"R-squared = ",3.5117131901197952E-2]
[{"$f":"(C173-C172*A174*B174)/(A173-C172*A174^2)","v":0.26948015436884898},{"$f":"B174-A176*A174","v":1.3783200687860204}]
["b","a"]
[{"$f":"(C173-A172*B172/C172)/(A173-A172^2/C172)","v":0.26948015436885003},{"$f":"(B172-A178*A172)/C172","v":1.3783200687860175}]