{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["LinesOfFit","samples","Sheet4"],"not_rendered":{"charts":2,"images":2,"macros":1,"defined_names":17,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"LinesOfFit","index":0,"n_rows":37,"n_cols":18,"rows_kept":37}
[null,null,"   Comparing Lines that Fit Data"]
[]
[null,null," This program lets you compare three different"]
[null,null,"     regression lines -- the least squares line, "]
[null,null,"                  the median-median line,"]
[null,null,"           and the quartile-quartile line --"]
[null,null,"  based on a random sample from a population. "]
[]
[]
[]
["How many random points n (4-40)?",null,null,11,10]
[]
["The regression line for the "]
[null,"underlying bivariate population is:",null,null,"y =","1.5x- 0.60"]
[]
[{"$nulls":9},"The least squares line is y =",{"$nulls":3},{"$f":"samples!H55","v":{"v":1.5108532474244754,"d":"1.51"}},{"$f":"IF(samples!H56>=0,\"x  + \",\"x  - \")","v":"x  + "},{"$f":"ABS(samples!H56)","v":{"v":0.08013169898263393,"d":"0.08"}},"R2 =",{"$f":"samples!M56","v":{"v":0.854648396984354,"d":"0.855"}}]
[{"$nulls":3},0]
[{"$nulls":3},-1,{"$nulls":5},"The quartile-quartile line is y = ",{"$nulls":3},{"$f":"mQQ","v":{"v":1.237681806797632,"d":"1.24"}},{"$f":"IF(samples!F68>=0,\"x  + \",\"x  - \")","v":"x  + "},{"$f":"ABS(samples!F68)","v":{"v":2.0440698262514854,"d":"2.04"}},"R2 =",{"$f":"IF(samples!P56>=0,samples!P56,0)","v":{"v":0.8197817404814832,"d":"0.820"}}]
[]
[{"$nulls":9},"The median- median line is y =",{"$nulls":3},{"$f":"mMed","v":{"v":1.7261688631310956,"d":"1.73"}},{"$f":"IF(samples!I82>=0,\"x  + \",\"x  - \")","v":"x  - "},{"$f":"ABS(samples!I82)","v":{"v":0.86502901532441,"d":"0.87"}},"R2 =",{"$f":"IF(samples!S56>=0,samples!S56,0)","v":{"v":0.8293242296526169,"d":"0.829"}}]
["Click each item below for suggestions and investigations"]
[null,null,"   Item 1"]
[null,null,"   Item 2"]
[null,null,"   Item 3"]
[null,null,"   Item 4"]
[null,null,"   Item 5"]
[]
[]
[]
["To access/download all the DIGMath Apps for Precalculus and College Algebra"]
["Click this link:",null,"we-dig-math.org/dynamicprecalculus"]
[]
["Created by:  Sheldon P. Gordon   &   Florence S. Gordon"]
["                  Farmingdale State College      NYIT",{"$nulls":8},"The underlying population and its regression line"]
["Development of this module was supported by the "]
["NSF's Division of Undergraduate Education  "]
["under grants DUE-0310123 and DUE-0442160."]

{"sheet":"samples","index":1,"n_rows":503,"n_cols":20,"rows_kept":503}
[null,"x-y data",null,"sample","x","y","x*y","x^2",null,"x","y",null,"R^2 for least squares",null,null,"R^2 for Q-Q",null,null,"R^2 for M-M"]
[1,9.09214193,9.22605615,{"$f":"IF($A2<=n,INT(501*RAND()+1),\"\")","v":320},{"$f":"IF(D2<>\"\",INDEX($B$2:$B$502,D2),\"\")","v":8.687714618260546},{"$f":"IF(D2<>\"\",INDEX($C$2:$C$502,D2),\"\")","v":15.233535264352582},{"$f":"IF(D2<>\"\",E2*F2,\"\")","v":132.34460700390346},{"$f":"IF(D2<>\"\",E2^2,\"\")","v":75.476385288338},null,{"$f":"E2","v":8.687714618260546},{"$f":"F2","v":15.233535264352582},null,{"$f":"(F2-a*E2-b)^2","v":4.110925433128427},{"$f":"(F2-AVERAGE(F2:F53))^2","v":41.86746352278466},null,{"$f":"($F2-aa*$E2-bb)^2","v":5.938184859869524},{"$f":"($F2-AVERAGE($F2:$F53))^2","v":41.86746352278466},null,{"$f":"($F2-aaa*$E2-bbb)^2","v":0.9444572264756491},{"$f":"($F2-AVERAGE($F2:$F53))^2","v":41.86746352278466}]
[2,7.73094449,8.6631947,301,{"$f":"IF(D3<>\"\",INDEX($B$2:$B$502,D3),\"\")","v":1.4880319609982529},{"$f":"IF(D3<>\"\",INDEX($C$2:$C$502,D3),\"\")","v":1.0816092435081188},{"$f":"IF(D3<>\"\",E3*F3,\"\")","v":1.6094691236512229},{"$f":"IF(D3<>\"\",E3^2,\"\")","v":2.214239116952306},null,{"$f":"E3","v":1.4880319609982529},{"$f":"F3","v":1.0816092435081188},null,{"$f":"(F3-a*E3-b)^2","v":1.5543116959837882},{"$f":"(F3-AVERAGE(F$2:F$53))^2","v":59.00419498543812},null,{"$f":"($F3-aa*$E3-bb)^2","v":7.8633731397824},{"$f":"($F3-AVERAGE($F2:$F53))^2","v":59.00419498543812},null,{"$f":"($F3-aaa*$E3-bbb)^2","v":0.565844107578165},{"$f":"($F3-AVERAGE($F2:$F53))^2","v":59.00419498543812}]
[3,7.96784314,7.84023659,271,{"$f":"IF(A4<=n,IF(D4<>\"\",INDEX($B$2:$B$502,D4),E3))","v":9.500293656745802},{"$f":"IF(A4<=n,IF(D4<>\"\",INDEX($C$2:$C$502,D4),F3))","v":15.38973157899776},146.20696929897298,90.25557956440451,null,{"$f":"IF($A4<=n,E4,\"\")","v":9.500293656745802},{"$f":"IF($A4<=n,F4,\"\")","v":15.38973157899776},null,{"$f":"IF($A4<=n,(F4-a*E4-b)^2,0)","v":0.914032285568382},{"$f":"IF($A4<=n,(F4-AVERAGE(F$2:F$53))^2,0)","v":43.91319957089798},null,{"$f":"IF($A4<=n,($F4-aa*$E4-bb)^2,0)","v":2.5195883842114726},{"$f":"IF($A4<=n,($F4-AVERAGE($F$2:$F$53))^2,0)","v":43.91319957089798},null,{"$f":"IF($A4<=n,($F4-aaa*$E4-bbb)^2,0)","v":0.0754163796588857},{"$f":"IF($A4<=n,($F4-AVERAGE($F$2:$F$53))^2,0)","v":43.91319957089798}]
[4,6.21715943,9.71304483,197,3.0020486930644386,4.451151680514537,13.362574085120244,9.012296355529903,null,3.0020486930644386,4.451151680514537,null,0.027104694851823433,18.59227788450544,null,1.7121701466219976,18.59227788450544,null,1.4959834193889413E-5,18.59227788450544]
[5,7.80181084,8.84088725,266,7.2161926911738306,9.885922997306373,71.33872527866954,52.07343695615061,null,7.2161926911738306,9.885922997306373,null,1.2030072313494482,1.260893047379192,null,1.187004229772747,1.260893047379192,null,3.369739577124586,1.260893047379192]
[6,9.53953478,13.2443258,312,5.41607617010079,7.098110857880524,38.44390907010038,29.33388108033364,null,5.41607617010079,7.098110857880524,null,1.3570318754940722,2.7719492793106872,null,2.720315535870563,2.7719492793106872,null,2.298838465150157,2.7719492793106872]
[7,5.57186894,3.42029568,395,7.826619216503234,10.134721442862574,79.3206055986156,61.25596836013769,null,7.826619216503234,10.134721442862574,null,3.133903017947664,1.8815427453242977,null,2.5478946528667668,1.8815427453242977,null,6.972693677193212,1.8815427453242977]
[8,2.1716921,4.08450283,274,3.0262558719003962,9.169401729152689,27.748955824661973,9.158224602211627,null,3.0262558719003962,9.169401729152689,null,20.403664080502825,0.1651395615685199,null,11.422980900612146,0.1651395615685199,null,21.905509172433714,0.1651395615685199]
[9,4.55813861,7.46997257,229,9.402733102567202,14.3929087483101,135.33267952996445,88.41138979811305,null,9.402733102567202,14.3929087483101,null,0.011369361197597126,31.695556600459657,null,0.5058726176837993,31.695556600459657,null,1.2166912148830773,31.695556600459657]
[10,4.30812811,4.96796458,239,1.6871419809884225,2.169797272745749,3.6607560690835395,2.8464480640135386,null,1.6871419809884225,2.169797272745749,null,0.21101010940585763,43.470692172009784,null,3.8510824005821096,43.470692172009784,null,5.9839336775530166E-5,43.470692172009784]
[11,0.983887791,-0.190496477,398,5.964057635337272,7.38641780934344,44.05302153360595,35.56998347762482,null,5.964057635337272,7.38641780934344,null,2.9054216202784007,1.8950557734460793,null,4.15857175026676,1.8950557734460793,null,4.725378985603685,1.8950557734460793]
[12,9.19486152,11.0320721,"",false,false,"","",null,"","",null,0,0,null,0,0,null,0,0]
[13,5.69596444,8.77827914,"",false,false,"","",null,"","",null,0,0,null,0,0,null,0,0]
[14,2.35391531,1.08322714,"",false,false,"","",null,"","",null,0,0,null,0,0,null,0,0]
[15,0.741468446,-3.10509067,"",false,false,"","",null,"","",null,0,0,null,0,0,null,0,0]
[16,1.20622191,-1.56819643,"",false,false,"","",null,"","",null,0,0,null,0,0,null,0,0]
[17,2.13610764,4.70049726,"",false,false,"","",null,"","",null,0,0,null,0,0,null,0,0]
[18,6.2052832,8.9630256,"",false,false,"","",null,"","",null,0,0,null,0,0,null,0,0]
[19,5.95518034,4.7732746,"",false,false,"","",null,"","",null,0,0,null,0,0,null,0,0]
[20,8.97702256,12.3319163,"",false,false,"","",null,"","",null,0,0,null,0,0,null,0,0]
[21,9.6300482,11.9626183,"",false,false,"","",null,"","",null,0,0,null,0,0,null,0,0]
[22,8.10172595,12.6793998,"",false,false,"","",null,"","",null,0,0,null,0,0,null,0,0]
[23,4.51350669,4.25871039,"",false,false,"","",null,"","",null,0,0,null,0,0,null,0,0]
[24,9.69084598,12.1507546,"",false,false,"","",null,"","",null,0,0,null,0,0,null,0,0]
[25,3.27332773,2.7018407,"",false,false,"","",null,"","",null,0,0,null,0,0,null,0,0]
[26,8.43104463,11.3286742,"",false,false,"","",null,"","",null,0,0,null,0,0,null,0,0]
[27,6.06165876,5.55362394,"",false,false,"","",null,"","",null,0,0,null,0,0,null,0,0]
[28,4.49460797,7.05270137,"",false,false,"","",null,"","",null,0,0,null,0,0,null,0,0]
[29,4.60908685,2.60411558,"",false,false,"","",null,"","",null,0,0,null,0,0,null,0,0]
[30,3.60214925,6.04667724,"",false,false,"","",null,"","",null,0,0,null,0,0,null,0,0]
[31,5.68477606,4.15507128,"",false,false,"","",null,"","",null,0,0,null,0,0,null,0,0]
[32,4.66966127,5.38860315,"",false,false,"","",null,"","",null,0,0,null,0,0,null,0,0]
[33,2.44821177,-1.09291696,{"$f":"IF($A34<=n,INT(501*RAND()+1),\"\")","v":""},false,false,"","",null,"","",null,0,0,null,0,0,null,0,0]
[34,6.75089173,6.68082052,"",false,false,"","",null,"","",null,0,0,null,0,0,null,0,0]
[35,1.7000925,-2.08932327,"",{"$f":"IF(A36<=n,IF(D36<>\"\",INDEX($B$2:$B$502,D36),E35))","v":false},{"$f":"IF(A36<=n,IF(D36<>\"\",INDEX($C$2:$C$502,D36),F35))","v":false},"","",null,{"$f":"IF($A36<=n,E36,\"\")","v":""},{"$f":"IF($A36<=n,F36,\"\")","v":""},null,{"$f":"IF($A36<=n,(F36-a*E36-b)^2,0)","v":0},{"$f":"IF($A36<=n,(F36-AVERAGE(F$2:F$53))^2,0)","v":0},null,{"$f":"IF($A36<=n,($F36-aa*$E36-bb)^2,0)","v":0},{"$f":"IF($A36<=n,($F36-AVERAGE($F$2:$F$53))^2,0)","v":0},null,{"$f":"IF($A36<=n,($F36-aaa*$E36-bbb)^2,0)","v":0},{"$f":"IF($A36<=n,($F36-AVERAGE($F$2:$F$53))^2,0)","v":0}]
[36,1.66489539,1.82337856,"",false,false,"","",null,"","",null,0,0,null,0,0,null,0,0]
[37,3.92028448,2.04055271,"",false,false,"","",null,"","",null,0,0,null,0,0,null,0,0]
[38,5.18673108,5.84375759,"",false,false,"","",null,"","",null,0,0,null,0,0,null,0,0]
[39,2.77939124,5.31050283,"",false,false,"","",null,"","",null,0,0,null,0,0,null,0,0]
[40,8.07864525,8.03795487,"",false,false,"","",null,"","",null,0,0,null,0,0,null,0,0]
[41,2.3735837,-1.59270459,"",false,false,"","",null,"","",null,0,0,null,0,0,null,0,0]
[42,7.55933738,12.6835751,"",false,false,"","",null,"","",null,0,0,null,0,0,null,0,0]
[43,5.13345519,8.29723619,"",false,false,"","",null,"","",null,0,0,null,0,0,null,0,0]
[44,2.51870786,3.95381,"",false,false,"","",null,"","",null,0,0,null,0,0,null,0,0]
[45,9.37237474,9.61764637,"",false,false,"","",null,"","",null,0,0,null,0,0,null,0,0]
[46,6.94092202,6.74365555,"",false,false,"","",null,"","",null,0,0,null,0,0,null,0,0]
[47,3.47347018,0.356953922,"",false,false,"","",null,"","",null,0,0,null,0,0,null,0,0]
[48,1.16874791,-3.10672775,"",false,false,"","",null,"","",null,0,0,null,0,0,null,0,0]
[49,1.22022199,-2.85875217,"",false,false,"","",null,"","",null,0,0,null,0,0,null,0,0]
[50,3.33730571,0.911521898,"",false,false,"","",null,"","",null,0,0,null,0,0,null,0,0]
[51,9.91048198,11.89212396,"",false,false,"","",null,"","",null,0,0,null,0,0,null,0,0]
[52,8.42129982,10.24603712,"",false,false,"","",null,"","",null,0,0,null,0,0,null,0,0]
[53,0.206671698,-0.791170175,"sums",{"$f":"SUM(E2:E53)","v":63.21716559764018},{"$f":"SUM(F2:F53)","v":96.39330862497447},{"$f":"SUM(G2:G53)","v":693.4222724163493},{"$f":"SUM(H2:H53)","v":455.6078326638097},{"$nulls":3},"Sums =",{"$f":"SUM(M2:M53)","v":35.831781405708284},{"$f":"SUM(N2:N53)","v":246.51796514312446},"Sums =",{"$f":"SUM(P2:P53)","v":44.42703861814028},{"$f":"SUM(Q2:Q53)","v":246.51796514312446},"Sums =",{"$f":"SUM(S2:S53)","v":42.0746436052721},{"$f":"SUM(T2:T53)","v":246.51796514312446}]
[54,6.4843481,10.3540317,{"$nulls":3},"a=",{"$f":"(n*G54-E54*F54)/(n*H54-E54^2)","v":1.5108532474244754}]
[55,9.14722657,9.71488637,{"$nulls":3},"b=",{"$f":"(F54-H55*E54)/n","v":0.08013169898263393},{"$nulls":3},"R^2 =",{"$f":"1-M54/N54","v":0.854648396984354},null,"R^2 =",{"$f":"1-P54/Q54","v":0.8197817404814832},null,"R^2 =",{"$f":"1-S54/T54","v":0.8293242296526169}]
[56,0.84874672,0.715629715,null,null,"xl,xr=",0,14]
[57,4.4389659,2.81245038,null,null,"yl,yr=",{"$f":"H56","v":0.08013169898263393},{"$f":"H56+14*H55","v":21.23207716292529}]
[58,5.9462981,9.71863808]
[59,0.119493964,-4.58243463]
[60,4.51046758,6.96945848]
[61,5.68622801,9.69014381]
[62,6.53330364,9.85792786,"Quartiles:"]
[63,5.24469467,7.8713711,"x's",{"$f":"QUARTILE(E2:E52,1)","v":3.014152282482417},"y's",{"$f":"QUARTILE(F2:F52,1)","v":5.77463126919753},"delta y =",{"$f":"G65-G64","v":6.489183826388808}]
[64,2.33171315,3.9683671,null,{"$f":"QUARTILE(E2:E52,3)","v":8.257166917381891},null,{"$f":"QUARTILE(F2:F52,3)","v":12.263815095586338}]
[65,2.17258428,-0.318387121]
[66,1.1164724,-0.078287546,null,"slope =",{"$f":"IF(H55>=0,I64/(E65-E64),-I64/(E65-E64))","v":1.237681806797632}]
[67,8.53363023,11.8219133,null,"b =",{"$f":"G64-mQQ*E64","v":2.0440698262514854}]
[68,4.59207945,2.43433646,null,null,"xl,xr=",0,14]
[69,9.3413851,14.2098571,null,null,"yl,yr=",{"$f":"F68","v":2.0440698262514854},{"$f":"F68+14*mQQ","v":19.371615121418337}]
[70,1.423125,0.646345121]
[71,5.25211799,8.95341605,{"$nulls":6},"nX1 =",{"$f":"INT((n+2)/3+0.3)","v":4}]
[72,8.44975986,10.1485986,"Medians",null,"x ","y",null,null,"nX2 =",{"$f":"INT((n+2)/3+0.3)","v":4}]
[73,6.30581833,5.82147702,null,"1st",{"$f":"PERCENTILE(J2:J53,1/6)","v":2.5637464557057665},{"$f":"PERCENTILE(K2:K53,1/6)","v":3.6907002112582736},null,null,"nX3 =",{"$f":"n-2*_nX1","v":3}]
[74,3.13065817,3.63331936,null,"3rd",{"$f":"PERCENTILE(J2:J53,5/6)","v":8.926054113029432},{"$f":"PERCENTILE(K2:K53,5/6)","v":14.673117586990928}]
[75,4.48220544,4.67629661,null,"middle",{"$f":"MEDIAN(J2:J53)","v":5.964057635337272},{"$f":"MEDIAN(K2:K53)","v":9.169401729152689}]
[76,4.3412922,4.0240331,{"$nulls":4},"Line through Middle Point"]
[77,2.62332655,4.44153764,null,"slope =",{"$f":"(G75-G74)/(F75-F74)","v":1.7261688631310956},null,"slope =",{"$f":"mMed","v":1.7261688631310956}]
[78,5.7589141,6.31902082,null,"b =",{"$f":"G74-mMed*F74","v":-0.7347590935437252},null,"b =",{"$f":"G76-I78*F76","v":-1.1255688588857797}]
[79,1.39826337,1.12138749]
[80,8.34654802,10.0915653,null,"distance =",{"$f":"ABS(mMed*F76-G76+F79)/SQRT(F79^2+1)","v":0.31493668189758245},null,"Line 1/3 of way"]
[81,5.5414156,8.21511411,{"$nulls":4},"b =",{"$f":"$F79+($I79-$F79)/3","v":-0.86502901532441}]
[82,5.18564613,7.96590089]
[83,2.31240365,2.11440066,null,"Graphing points"]
[84,8.61456682,11.9266656,null,{"$f":"0","v":0},{"$f":"I82","v":-0.86502901532441}]
[85,1.82822638,-2.92768506,null,10,{"$f":"10*I78+I82","v":16.396659615986547}]
[86,1.25997063,0.880998895]
[87,5.98353379,6.75417693]
[88,8.87683015,11.8436226]
[89,2.35202778,-0.517630912]
[90,6.60656315,9.51956445]
[91,4.4224596,7.08149033]
[92,8.05066739,11.5738894]
[93,9.77137147,11.31715752]
[94,6.26208838,10.6125892]
[95,7.44459369,10.1652119]
[96,4.82454293,3.85889457]
[97,5.57222481,7.54623243]
[98,4.41793735,3.44458382]
[99,8.498654960692358,15.265962912187948]
[100,5.163454744566504,8.38742789886806]
[101,5.445845676247458,6.668110029361347]
[102,3.4094557169609363,3.6520829590804085]
[103,5.089872537316094,7.352982530693758]
[104,2.796236799336622,3.8294492481387614]
[105,3.3553365657520917,3.6434025574784514]
[106,5.573966050809718,10.5968462948077]
[107,1.1405256196458247,1.0120546091450575]
[108,6.002723661364393,7.872636575142415]
[109,4.247385374711667,5.531413809269662]
[110,2.5899652593558353,2.941322045225987]
[111,3.856389470348711,4.925754380390249]
[112,4.3293947390416765,5.482066263058712]
[113,9.488624038798692,13.332107472922251]
[114,1.252853786427286,1.0100640028655623]
[115,5.792104739013508,6.937223923415807]
[116,5.325049374947747,11.2900628245365]
[117,1.6340339228916534,3.020722199310383]
[118,7.94593131922432,12.86608568888203]
[119,4.166126749997048,7.437545505312155]
[120,0.35354353741588795,-1.0731643416126662]
[121,4.272841113160187,5.220618264712168]
[122,7.182313270619229,9.864613996322797]
[123,8.355378690008521,12.244021405653474]
[124,9.594377652420633,14.97374558135565]
[125,2.4221504716819453,2.138771277199983]
[126,8.834973267652773,11.917701081681987]
[127,6.346243302467851,11.0887658263538]
[128,9.117770125778462,11.88939036479898]
[129,3.402149060258597,7.329144140692634]
[130,5.006036796009923,5.953308078529974]
[131,6.886491298998352,9.410603282295412]
[132,2.365753917343598,1.900883604051348]
[133,2.68301960259252,3.0389984183887524]
[134,9.150091433767296,14.553313377781]
[135,1.144664187281501,3.1697184174253565]
[136,1.8514183165426168,2.2694190174681865]
[137,8.866205409435848,15.395163428346962]
[138,7.241567808026197,9.575507064973262]
[139,3.5467090203525475,8.8908244024619]
[140,0.7627152341766408,0.2338329209201615]
[141,4.800506311563257,5.610688637116287]
[142,9.91122221451099,14.010701314914378]
[143,3.1298162215125824,4.067824526570923]
[144,6.618233797602377,10.934469818299988]
[145,0.8525446832435013,2.9996479371763423]
[146,8.09190796640454,12.022468542541647]
[147,5.446111591751139,7.140385257717964]
[148,1.1377542072032565,4.1653095983967]
[149,8.090021662643325,10.603349573558262]
[150,6.823624893396789,12.354040682638]
[151,5.339735175272047,7.17793373615302]
[152,6.920232629388831,8.974504091533777]
[153,3.2384547362536154,4.35444130359969]
[154,9.8373755329407,15.801176329166585]
[155,4.8256411591609805,6.160031288259679]
[156,7.522274138583249,10.398178080808218]
[157,7.281089292552458,9.735038871832746]
[158,6.576493162966495,13.21882269359742]
[159,7.143261879921159,9.249714155907242]
[160,2.379058155796603,5.635721577613695]
[161,4.382051538519313,4.936514722976774]
[162,1.7286565252373598,1.4654855864438978]
[163,5.49323553058448,8.865620796165201]
[164,9.965606270602416,13.997749013626128]
[165,3.040116361729548,3.58337054419421]
[166,8.690891498105863,15.6037894634612]
[167,5.6949934178282025,7.587259180790649]
[168,5.710377020342401,7.239777269464573]
[169,7.8580010287960045,12.828081007665793]
[170,3.744694891336273,4.464181773559366]
[171,8.778074624569214,13.506420648081406]
[172,7.310312849675357,10.56882331609917]
[173,4.285620539617804,5.710111432454411]
[174,6.322354733436741,8.213277335890698]
[175,2.2315282967237082,2.4042547655017708]
[176,3.50680669059515,4.916780199020998]
[177,5.367929196264796,6.510966796248922]
[178,7.251810583574567,11.875647018657912]
[179,0.032648962740822185,0.14112108804542]
[180,3.12141324390635,3.8316182739838296]
[181,6.289004382690813,12.751292336237183]
[182,1.3086412443964068,3.6081103627702]
[183,2.3217560734071774,2.924827134565465]
[184,0.14145823444282613,-0.836719462300577]
[185,8.169997320603745,11.341782431199082]
[186,8.005788583368625,10.376369834430827]
[187,6.519533521942888,9.254708349873745]
[188,0.09134565557880059,-1.4671504185821658]
[189,1.101807709501168,0.46254609360549703]
[190,3.60999913618806,5.909913366443419]
[191,8.862057695934995,12.368626358792984]
[192,6.637214147233665,9.038105489790638]
[193,7.323838367739111,9.84866860173513]
[194,3.6183896033488883,4.398756259779468]
[195,7.8962395661564555,10.467689897148318]
[196,0.7680377098806024,-0.17529515458519196]
[197,3.0020486930644386,4.451151680514537]
[198,6.017878140233099,7.387096473214833]
[199,1.6954447009960338,1.7662608069999726]
[200,4.007136932686035,5.814902586284511]
[201,1.9686569618121053,1.9841783753660602]
[202,6.996969959662005,8.805367962088983]
[203,5.9881481452474805,8.730859766740313]
[204,3.308265585188872,6.837932727622842]
[205,9.041516206091643,12.043639779605522]
[206,6.572777827128213,8.747598582824184]
[207,0.3880344278604042,-0.8436550680423495]
[208,1.5051788029239521,4.9638057506063475]
[209,5.4429712832420085,7.625845857234053]
[210,9.490853698167179,13.202516086178253]
[211,4.968910102839397,6.51615162136162]
[212,5.365483177132733,6.462492918648564]
[213,6.698350043859149,10.792994407672209]
[214,1.6941838803347231,0.8329451764326543]
[215,4.484493400009644,10.4970684035772]
[216,7.8903828523821495,6.7415408013276]
[217,8.77379721576282,11.901876569481338]
[218,9.176660730311417,13.3242806178202]
[219,1.4135924929262988,3.7481662616878935]
[220,4.377394823056315,7.335011065144073]
[221,4.243818768274341,6.28389121820601]
[222,2.9012296601372434,7.5231318089898]
[223,1.4677999427926225,1.3276112265289484]
[224,8.850093267965422,12.105880499957472]
[225,4.79274557029203,7.82741515961016]
[226,9.250060212297361,11.3512083995308]
[227,3.6739445272245197,4.1937702660508]
[228,2.5634850895736427,2.476851699042742]
[229,9.402733102567202,14.3929087483101]
[230,8.73580173724072,13.50414249039948]
[231,6.589376395927491,8.971115924241138]
[232,5.216003403953611,11.532730797797036]
[233,7.9848542353849306,10.790153830847302]
[234,1.1330083820892867,3.9329833082832204]
[235,0.6789448919147967,0.5089704513720485]
[236,6.76901909780738,9.226531169968315]
[237,6.486293914793655,13.6128537938733]
[238,8.978948917083578,14.57182859908777]
[239,1.6871419809884225,2.169797272745749]
[240,3.4208672870853274,8.92788445299879]
[241,1.4419552557102744,1.2654029560604627]
[242,2.787355814897108,3.260033911253919]
[243,7.372356743053304,14.15401139120323]
[244,1.7375385257517406,1.3274580924991946]
[245,7.971972342946636,14.077036682687522]
[246,2.596367964512105,8.6568750385048]
[247,3.9683628429778928,4.562253890437488]
[248,3.941254589416827,6.282762401322367]
[249,9.801917640355775,16.65592597297271]
[250,0.055203368538556674,0.01948726888043173]
[251,7.658241522449291,10.144178208610738]
[252,2.6702250271780237,2.925908317102361]
[253,2.7270468586034036,1.18287008341857]
[254,1.1419442312216033,1.5742783532651146]
[255,4.5506393858648675,5.838884714126932]
[256,0.060503575811612365,-0.8821582164023676]
[257,0.0486711432149628,0.35667577297134]
[258,1.2394882492330073,0.7335566460101843]
[259,6.523956286768479,8.54700404349764]
[260,0.7940843459245972,0.11729142010121]
[261,9.007457762033344,13.25375121610501]
[262,1.8314434350190556,1.9047131476628156]
[263,6.577134573709362,10.129726947775568]
[264,0.38670715099446085,1.534111384119754]
[265,0.36522624383226177,-0.19922227605221843]
[266,7.2161926911738306,9.885922997306373]
[267,6.511081730778585,13.800060184140401]
[268,4.8050001233502115,6.1785477163141]
[269,3.666581661681152,5.385328591488283]
[270,4.892477198378646,9.44914202206532]
[271,9.500293656745802,15.38973157899776]
[272,2.900179275751844,3.381056319385708]
[273,1.881556294340525,1.750412100965411]
[274,3.0262558719003962,9.169401729152689]
[275,7.337435298616812,9.574814402456791]
[276,4.038188422603977,5.3857284288438505]
[277,5.220468369479347,8.113977016098778]
[278,0.19869643820853655,-1.548675626708963]
[279,3.741235828069547,4.434798090082648]
[280,4.696012251729433,6.3431212890244]
[281,1.477663452221547,3.0510870667526055]
[282,7.393460080311087,12.654889585788244]
[283,6.184272520014773,7.808466476660179]
[284,7.818623012144597,14.288010440950092]
[285,6.662071448294973,9.632167558527163]
[286,0.15446583210299014,-0.8391181197015869]
[287,7.7959736246489175,11.006525900573429]
[288,3.678738949751592,5.42291418947621]
[289,9.155854658878164,13.345455166555794]
[290,3.582628109470438,4.30831352958017]
[291,9.318861730780855,15.1632824539856]
[292,3.0610660275056034,8.188867168382277]
[293,1.5675344209138453,1.7533965630004673]
[294,5.350264980326102,9.399215377629908]
[295,5.360451803999268,8.172456846756795]
[296,8.233341992061245,13.716824070049993]
[297,4.810584176066772,5.724291400066047]
[298,8.717201180054435,10.1909323143341]
[299,6.897112034607266,10.373914010326741]
[300,6.9525604667211205,8.837411445457564]
[301,1.4880319609982529,1.0816092435081188]
[302,1.7599831210840322,1.5909511216843224]
[303,8.55288406126471,11.935414601761497]
[304,7.95256046672112,9.83741144545756]
[305,5.474790082807369,7.246591395750953]
[306,0.9621403479040769,0.8049534492581749]
[307,5.957347780291551,7.914266872225301]
[308,0.8614081391967865,2.89773468996069]
[309,0.25699945148575987,1.59382960362792]
[310,7.147907389820912,9.169635586569077]
[311,9.873277628986488,13.39935789623949]
[312,5.41607617010079,7.098110857880524]
[313,1.620383073816658,2.216690288933506]
[314,3.893708046172286,4.034337709574205]
[315,8.935524660310525,15.393548209679764]
[316,8.141106430121285,13.610480114295285]
[317,4.941073579261861,6.3327469760680835]
[318,3.832366124554163,4.900589814933751]
[319,0.5659222877529402,0.9882044618155552]
[320,8.687714618260546,15.233535264352582]
[321,8.643298308397656,11.795238857365748]
[322,0.15103619558535009,0.7485558619350456]
[323,6.840311798890026,8.832776868455136]
[324,4.355816874263483,7.801517982897999]
[325,5.172426329099169,6.221846780454958]
[326,0.7666741114258446,2.1630137371862332]
[327,9.039115292345361,12.357589907902458]
[328,2.0438486082449536,1.771787990984288]
[329,6.0537901132036875,7.981768234942673]
[330,2.8377527642991263,3.333338781213002]
[331,1.3243081533701484,1.0602961618497493]
[332,0.6180184208151829,1.24240196304826]
[333,6.9817304993047475,8.979745073768191]
[334,0.1426316554836049,-0.7878630769317425]
[335,3.6499905948580413,7.825033330792496]
[336,1.870541375343342,1.1805516340269766]
[337,6.900886764361925,10.204409107974497]
[338,6.1399117043838665,8.221082624229577]
[339,6.261276544240646,9.013125262301655]
[340,1.7998922865176414,1.8595912072524055]
[341,9.976123291926005,13.980574358054476]
[342,6.114036448093778,7.669303551206056]
[343,5.150367067779449,6.738228966505095]
[344,1.5135708129106806,4.658768124304992]
[345,7.107225211921291,9.733400636868918]
[346,1.191561255378697,2.269256354030322]
[347,6.3247959995675895,7.868572821658879]
[348,6.227747288821486,7.93555521051997]
[349,4.996689189595296,6.064861197109102]
[350,7.76762289708544,10.420430228595862]
[351,7.29359583717625,9.629381537637475]
[352,3.2542346853922854,3.928344730496949]
[353,5.644777953613076,8.6480184410304]
[354,1.4703597302266935,0.7711012920115737]
[355,4.273809141498184,5.536209812857873]
[356,1.493317659874993,2.1275883997256515]
[357,6.490032108341328,13.120219713956633]
[358,6.864464443411881,9.277522810363012]
[359,5.163693113362529,7.3496835595638865]
[360,4.894750060679698,7.704533946427829]
[361,7.710401940816054,11.2357860627386]
[362,7.053309402165786,9.505158259584714]
[363,8.890395842884192,12.042877971650041]
[364,2.674927641791407,4.836107233428173]
[365,8.878200110343881,12.349001526138636]
[366,7.659032899708286,9.98938098620591]
[367,5.760370768110601,7.791472067093649]
[368,4.420517322396433,5.404310703761789]
[369,6.9658494743887545,9.49829591083481]
[370,4.421525079147708,10.527068064918168]
[371,6.752381468413975,9.856969303071757]
[372,0.4149404452256755,0.4724075273102091]
[373,7.45918544635127,10.320616227050698]
[374,7.957446025172699,16.222075355994896]
[375,4.391145187522589,5.019223424003405]
[376,0.46505274619487835,-0.2259309195869872]
[377,3.040897535869007,2.66025053253502]
[378,8.374748085333223,10.5106509112695]
[379,2.483427613021556,4.839969021517559]
[380,7.858917858929308,10.051016488601196]
[381,9.131934317233073,12.55291319143432]
[382,3.940599548789676,6.6048693588312615]
[383,3.7772115049966803,4.8172249658671555]
[384,5.476693426323937,7.128083543065535]
[385,5.9208963748429255,8.406240255950461]
[386,1.0073275699233375,3.0485049962051756]
[387,9.500443150162996,12.75987320728431]
[388,3.013659548942229,2.8531384179154013]
[389,7.33430548869606,9.743790495905488]
[390,9.47464226683632,13.830945987610692]
[391,6.558558767928568,8.634685594095052]
[392,7.86422782451675,10.69512537033945]
[393,1.8554865276435994,1.8222645960802755]
[394,3.764890110705994,7.021718767608318]
[395,7.826619216503234,10.134721442862574]
[396,8.227863763036645,11.785310894543299]
[397,0.06730846132008583,-0.5970273583408492]
[398,5.964057635337272,7.38641780934344]
[399,4.1082974447572695,5.285397350209207]
[400,1.3928145321172103,4.642694218398474]
[401,2.487477644680025,2.5548488822556337]
[402,0.6384557253794987,-0.5952878399468224]
[403,6.12679599225471,11.9121473681452]
[404,6.686552734226209,9.184761681616543]
[405,6.308263957102995,8.417126502794247]
[406,6.11742432896917,11.635918876811942]
[407,9.457898032157402,13.162653526693784]
[408,4.568184900713526,5.960812925576907]
[409,9.85035968240136,13.656028266075758]
[410,1.4768568736947074,1.3799032819796315]
[411,4.5011269504434015,7.939067025109429]
[412,7.832014880922973,14.43572556356969]
[413,9.777377063391432,13.805124819802874]
[414,2.7950537847837964,4.507392891546809]
[415,9.709467597597492,13.896482453995]
[416,4.8823991410948615,6.436020675682628]
[417,7.338660302193611,15.295872075750442]
[418,9.610171677365802,14.488520415201176]
[419,8.195668396095847,11.4569459956063]
[420,6.569000716891928,8.167703691354259]
[421,0.5466026594795093,-0.1865322591204509]
[422,8.900442607690513,12.35432214856479]
[423,4.749420421826036,6.856950393358698]
[424,8.071995394347908,11.164053202561197]
[425,1.8070864517549978,1.7416110390058728]
[426,4.532618449841454,7.265817564372688]
[427,6.988534875958424,9.345507758184548]
[428,4.325001095251368,5.07087025545622]
[429,0.8415084967900022,1.0462541563059669]
[430,4.023100063815193,4.593234866161474]
[431,0.12732263727994741,-1.6605184319212518]
[432,0.8076230621333469,0.33078967169907747]
[433,3.27441585738101,6.784316826661682]
[434,3.53998169826256,4.284114897886108]
[435,3.864226179427366,9.279665255171551]
[436,4.082080539699486,8.754425988344352]
[437,5.393602691616081,7.526930780469809]
[438,4.3215582402596375,5.556161810312443]
[439,3.9366875209881425,4.356405707121375]
[440,9.908334402883092,14.03019626076139]
[441,9.35487844257467,16.689508933402745]
[442,2.5956425287846496,2.7804630136276995]
[443,9.640023233991048,14.714347343605308]
[444,4.582912704512099,9.718835999558275]
[445,6.911595517920666,9.49892238672988]
[446,1.7654113582191089,2.141253773149888]
[447,1.7217897250392489,1.4757734328180563]
[448,4.993158857624014,7.267460033866503]
[449,4.3506429977654015,5.655058357458918]
[450,2.4393816677299007,2.6588761359742747]
[451,9.655504892810324,13.602996726514972]
[452,6.64793771308636,10.67406086654605]
[453,0.33555610413936954,-0.4537530917722499]
[454,5.9778139928798435,8.931188696029263]
[455,6.075263980189149,11.282461750971585]
[456,9.057933881101201,14.2420592442154]
[457,7.717987013813447,10.458313363579663]
[458,1.3578284498681548,2.5379222086592796]
[459,3.6068105942080053,4.098366811197073]
[460,5.371909194400768,7.1325663265933885]
[461,4.8845852752784396,6.634864362270783]
[462,1.0059581562211317,0.12797791593396501]
[463,8.858391482561345,12.013535616745314]
[464,1.4581096815090877,0.6503997955210497]
[465,3.9416342223019907,5.536921984303949]
[466,2.2721212362698306,2.413936039581454]
[467,3.8746898569702637,5.137450000889624]
[468,2.121102408831459,2.606792530372414]
[469,9.41315923751115,13.251051764366048]
[470,3.2534896362086507,3.2825058166553216]
[471,5.974281387129139,7.870514320009943]
[472,1.4233334082712767,0.4477294041232561]
[473,8.810645421713662,12.313253000955346]
[474,6.176780383218636,11.11810266507796]
[475,7.913844215095356,10.703020787632038]
[476,4.76923728814028,5.3629003049054]
[477,3.1588429852097644,4.968486671974643]
[478,0.41872762724397994,-0.6333903862108826]
[479,8.462811050415155,9.64098752446]
[480,8.279630606137921,11.034225795616823]
[481,4.579150759928716,6.437017194679134]
[482,5.814914670611184,7.78950536979365]
[483,9.738703079673058,13.476781084329959]
[484,4.004509414904502,5.725778105214591]
[485,2.8795624536466757,5.363452295876244]
[486,6.569418469958492,13.472349693690731]
[487,6.039849046914359,8.00193117490468]
[488,1.429231249359415,3.53817994206118]
[489,2.3562173660461116,3.38680392569938]
[490,0.7545066175506077,-0.12200500735643094]
[491,5.400268075270818,9.329220909924175]
[492,6.532434169354158,13.285598183869865]
[493,2.4976878149009263,2.8511708533162654]
[494,1.2218721087191309,2.230447020653355]
[495,5.6670881206542045,8.747440497231663]
[496,4.5326842345820495,5.173349814898818]
[497,0.2208640331872136,-1.3690361231285952]
[498,9.791089032228633,13.160044791377686]
[499,6.162694315484676,9.958051254260248]
[500,3.9061874613272463,5.3176122982893]
[501,2.0269028791192145,1.7832891667725619]
[502,2.3519795632531726,1.695250613489883]

{"sheet":"Sheet4","index":2,"n_rows":202,"n_cols":5,"rows_kept":202}
[null,"x's",-1,11]
[null,"y's",{"$f":"1.5003*C1-0.5874","v":-2.0877},{"$f":"1.5003*D1-0.5874","v":15.915899999999999}]
[null,null,-1,11]
[null,null,{"$f":"C2-4.69","v":-6.7777},{"$f":"D2-4.69","v":11.2259}]
[null,null,-1,11]
[null,null,{"$f":"C2+4.69","v":2.6023000000000005},{"$f":"D2+4.69","v":20.6059}]
[null,null,-1,11,"sample 1"]
[null,null,{"$f":"samples!G58","v":0.08013169898263393},{"$f":"samples!H58","v":21.23207716292529}]
[null,"series 5",-1,11,2]
[null,null,{"$f":"samples!L58","v":0},{"$f":"samples!M58","v":0}]
[null,16,-1,11,3]
[null,null,{"$f":"samples!Q$58","v":0},{"$f":"samples!R$58","v":0}]
[null,18,-1,11,4]
[null,null,{"$f":"samples!V$58","v":0},{"$f":"samples!W$58","v":0}]
[null,20,-1,11,5]
[null,null,{"$f":"samples!AA$58","v":0},{"$f":"samples!AB$58","v":0}]
{"$rows_empty":142}
["center circle"]
{"$rows_empty":41}
[null,null,{"$f":"LinesOfFit!#REF!","v":{"$error":"#REF!"}},{"$f":"LinesOfFit!#REF!","v":{"$error":"#REF!"}}]
[null,null,{"v":0,"d":"0.00"},1]