{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["LinesOfFit","samples","Sheet4"],"not_rendered":{"charts":2,"images":2,"macros":1,"external_links":0,"defined_names":17,"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":"LinesOfFit","index":0,"n_rows":34,"n_cols":18,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[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"]
[]
[null,null,null,null,null,null,null,null,null,"The least squares line is y =",null,null,null,{"$f":"samples!H55","v":1.3819762917181628},{"$f":"IF(samples!H56>=0,\"x  + \",\"x  - \")","v":"x  - "},{"$f":"ABS(samples!H56)","v":0.61075506774301269},"R2 =",{"$f":"samples!M56","v":0.9156861486083554}]
[null,null,null,0]
[null,null,null,-1,null,null,null,null,null,"The quartile-quartile line is y = ",null,null,null,{"$f":"mQQ","v":1.1890996273342034},{"$f":"IF(samples!F68>=0,\"x  + \",\"x  - \")","v":"x  + "},{"$f":"ABS(samples!F68)","v":0.33270775148422871},"R2 =",{"$f":"IF(samples!P56>=0,samples!P56,0)","v":0.89652672866166105}]
[]
[null,null,null,null,null,null,null,null,null,"The median- median line is y =",null,null,null,{"$f":"mMed","v":1.4329976546147409},{"$f":"IF(samples!I82>=0,\"x  + \",\"x  - \")","v":"x  - "},{"$f":"ABS(samples!I82)","v":0.92520366242019003},"R2 =",{"$f":"IF(samples!S56>=0,samples!S56,0)","v":0.89000667747657558}]
["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"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"The underlying population and its regression line"]

{"sheet":"samples","index":1,"n_rows":503,"n_cols":20,"rows_kept":503,"cut":false,"hidden":false,"merged":[]}
[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.0921419300000004,9.2260561499999998,{"$f":"IF($A2<=n,INT(501*RAND()+1),\"\")","v":253},{"$f":"IF(D2<>\"\",INDEX($B$2:$B$502,D2),\"\")","v":2.7270468586034036},{"$f":"IF(D2<>\"\",INDEX($C$2:$C$502,D2),\"\")","v":1.1828700834185699},{"$f":"IF(D2<>\"\",E2*F2,\"\")","v":3.225742145122557},{"$f":"IF(D2<>\"\",E2^2,\"\")","v":7.436784569018692},null,{"$f":"E2","v":2.7270468586034036},{"$f":"F2","v":1.1828700834185699},null,{"$f":"(F2-a*E2-b)^2","v":3.9009763755524016},{"$f":"(F2-AVERAGE(F2:F53))^2","v":36.985118439673251},null,{"$f":"($F2-aa*$E2-bb)^2","v":5.7243819760620074},{"$f":"($F2-AVERAGE($F2:$F53))^2","v":36.985118439673251},null,{"$f":"($F2-aaa*$E2-bbb)^2","v":1.3332825378948114},{"$f":"($F2-AVERAGE($F2:$F53))^2","v":36.985118439673251}]
[2,7.7309444899999997,8.6631947,251,{"$f":"IF(D3<>\"\",INDEX($B$2:$B$502,D3),\"\")","v":7.6582415224492912},{"$f":"IF(D3<>\"\",INDEX($C$2:$C$502,D3),\"\")","v":10.144178208610738},{"$f":"IF(D3<>\"\",E3*F3,\"\")","v":77.686566768308026},{"$f":"IF(D3<>\"\",E3^2,\"\")","v":58.64866321616644},null,{"$f":"E3","v":7.6582415224492912},{"$f":"F3","v":10.144178208610738},null,{"$f":"(F3-a*E3-b)^2","v":2.93865498510783E-2},{"$f":"(F3-AVERAGE(F$2:F$53))^2","v":8.2930693473112065},null,{"$f":"($F3-aa*$E3-bb)^2","v":0.49710723001373902},{"$f":"($F3-AVERAGE($F2:$F53))^2","v":8.2930693473112065},null,{"$f":"($F3-aaa*$E3-bbb)^2","v":0.54795406485578679},{"$f":"($F3-AVERAGE($F2:$F53))^2","v":8.2930693473112065}]
[3,7.9678431400000003,7.8402365899999999,239,{"$f":"IF(A4<=n,IF(D4<>\"\",INDEX($B$2:$B$502,D4),E3))","v":1.6871419809884225},{"$f":"IF(A4<=n,IF(D4<>\"\",INDEX($C$2:$C$502,D4),F3))","v":2.1697972727457491},3.6607560690835395,2.8464480640135386,null,{"$f":"IF($A4<=n,E4,\"\")","v":1.6871419809884225},{"$f":"IF($A4<=n,F4,\"\")","v":2.1697972727457491},null,{"$f":"IF($A4<=n,(F4-a*E4-b)^2,0)","v":0.20156698699105408},{"$f":"IF($A4<=n,(F4-AVERAGE(F$2:F$53))^2,0)","v":25.955071035435342},null,{"$f":"IF($A4<=n,($F4-aa*$E4-bb)^2,0)","v":2.8591556470465958E-2},{"$f":"IF($A4<=n,($F4-AVERAGE($F$2:$F$53))^2,0)","v":25.955071035435342},null,{"$f":"IF($A4<=n,($F4-aaa*$E4-bbb)^2,0)","v":1.7488208321413938},{"$f":"IF($A4<=n,($F4-AVERAGE($F$2:$F$53))^2,0)","v":25.955071035435342}]
[4,6.2171594299999997,9.7130448299999994,424,8.0719953943479084,11.164053202561197,90.116186033329001,65.15710964637384,null,8.0719953943479084,11.164053202561197,null,0.38378273848250311,15.207223081780318,null,1.5201379262717696,15.207223081780318,null,1.3623695202826507,15.207223081780318]
[5,7.8018108399999999,8.8408872499999998,454,5.9778139928798435,8.9311886960292632,53.388984760174012,35.734260133470059,null,5.9778139928798435,8.9311886960292632,null,1.640311723572665,2.7781537751471044,null,2.2208884389369796,2.7781537751471044,null,3.7453798598623327,2.7781537751471044]
[6,9.5395347800000003,13.2443258,1,9.0921419300000004,9.2260561499999998,83.884611969949376,82.667044875264125,null,9.0921419300000004,9.2260561499999998,null,7.44369384739593,3.8480586231753495,null,3.67916201563804,3.8480586231753495,null,4.9847652512621332,3.8480586231753495]
[7,5.5718689399999999,3.4202956800000002,310,7.1479073898209116,9.1696355865690773,65.543705971201916,51.092580053456395,null,7.1479073898209116,9.1696355865690773,null,9.5742103245140264E-3,3.6298874546431703,null,0.11380760096796423,3.6298874546431703,null,0.24701316233016637,3.6298874546431703]
[8,2.1716921,4.0845028299999999,453,0.33555610413936954,-0.45375309177224987,-0.15225961971628998,0.11259789902519142,null,0.33555610413936954,-0.45375309177224987,null,9.4082436813092488E-2,59.570029686486009,null,1.4053402628357903,59.570029686486009,null,0.40411312183400505,59.570029686486009]
[9,4.5581386100000003,7.4699725700000004,384,5.4766934263239371,7.1280835430655349,39.038328282594854,29.994170885939827,null,5.4766934263239371,7.1280835430655349,null,2.8960598864220338E-2,1.8584694000208617E-2,null,8.0112592229925728E-2,1.8584694000208617E-2,null,0.72300640647836267,1.8584694000208617E-2]
[10,4.3081281100000002,4.9679645800000003,426,4.5326184498414541,7.2658175643726883,32.933178745457745,20.544630011843147,null,4.5326184498414541,7.2658175643726883,null,2.6004832592542519,1.9833945269703103E-6,null,2.3820060922407778,1.9833945269703103E-6,null,5.4797616959651538,1.9833945269703103E-6]
[11,0.98388779100000001,-0.190496477,341,9.9761232919260046,13.980574358054476,139.47193348789071,99.523035935708549,null,9.9761232919260046,13.980574358054476,null,0.64732251097431814,45.106873973986922,null,3.1871608296122513,45.106873973986922,null,1.5753166867029502,45.106873973986922]
[12,9.1948615199999999,11.032072100000001,"",false,false,"","",null,"","",null,0,0,null,0,0,null,0,0]
[13,5.69596444,8.7782791400000004,"",false,false,"","",null,"","",null,0,0,null,0,0,null,0,0]
[14,2.3539153100000001,1.08322714,"",false,false,"","",null,"","",null,0,0,null,0,0,null,0,0]
[15,0.74146844599999995,-3.1050906700000001,"",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.1361076400000001,4.7004972599999997,"",false,false,"","",null,"","",null,0,0,null,0,0,null,0,0]
[18,6.2052832000000002,8.9630255999999999,"",false,false,"","",null,"","",null,0,0,null,0,0,null,0,0]
[19,5.9551803400000001,4.7732745999999997,"",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.6300481999999992,11.962618300000001,"",false,false,"","",null,"","",null,0,0,null,0,0,null,0,0]
[22,8.1017259500000005,12.679399800000001,"",false,false,"","",null,"","",null,0,0,null,0,0,null,0,0]
[23,4.5135066899999998,4.2587103900000001,"",false,false,"","",null,"","",null,0,0,null,0,0,null,0,0]
[24,9.6908459800000006,12.150754600000001,"",false,false,"","",null,"","",null,0,0,null,0,0,null,0,0]
[25,3.2733277300000001,2.7018407,"",false,false,"","",null,"","",null,0,0,null,0,0,null,0,0]
[26,8.4310446300000006,11.3286742,"",false,false,"","",null,"","",null,0,0,null,0,0,null,0,0]
[27,6.0616587600000003,5.5536239399999996,"",false,false,"","",null,"","",null,0,0,null,0,0,null,0,0]
[28,4.4946079699999997,7.0527013700000003,"",false,false,"","",null,"","",null,0,0,null,0,0,null,0,0]
[29,4.6090868499999997,2.6041155800000002,"",false,false,"","",null,"","",null,0,0,null,0,0,null,0,0]
[30,3.6021492500000001,6.0466772400000002,"",false,false,"","",null,"","",null,0,0,null,0,0,null,0,0]
[31,5.6847760599999999,4.1550712799999996,"",false,false,"","",null,"","",null,0,0,null,0,0,null,0,0]
[32,4.6696612699999998,5.3886031499999998,"",false,false,"","",null,"","",null,0,0,null,0,0,null,0,0]
[33,2.4482117699999999,-1.0929169599999999,{"$f":"IF($A34<=n,INT(501*RAND()+1),\"\")","v":""},false,false,"","",null,"","",null,0,0,null,0,0,null,0,0]
[34,6.7508917300000002,6.6808205200000002,"",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.6648953900000001,1.8233785600000001,"",false,false,"","",null,"","",null,0,0,null,0,0,null,0,0]
[37,3.9202844799999998,2.04055271,"",false,false,"","",null,"","",null,0,0,null,0,0,null,0,0]
[38,5.1867310800000004,5.8437575900000001,"",false,false,"","",null,"","",null,0,0,null,0,0,null,0,0]
[39,2.7793912399999998,5.3105028299999999,"",false,false,"","",null,"","",null,0,0,null,0,0,null,0,0]
[40,8.0786452499999992,8.0379548700000001,"",false,false,"","",null,"","",null,0,0,null,0,0,null,0,0]
[41,2.3735837000000002,-1.5927045900000001,"",false,false,"","",null,"","",null,0,0,null,0,0,null,0,0]
[42,7.5593373799999997,12.683575100000001,"",false,false,"","",null,"","",null,0,0,null,0,0,null,0,0]
[43,5.1334551900000003,8.2972361899999996,"",false,false,"","",null,"","",null,0,0,null,0,0,null,0,0]
[44,2.5187078600000001,3.9538099999999998,"",false,false,"","",null,"","",null,0,0,null,0,0,null,0,0]
[45,9.3723747399999997,9.6176463699999992,"",false,false,"","",null,"","",null,0,0,null,0,0,null,0,0]
[46,6.9409220200000004,6.7436555499999997,"",false,false,"","",null,"","",null,0,0,null,0,0,null,0,0]
[47,3.4734701800000001,0.35695392199999998,"",false,false,"","",null,"","",null,0,0,null,0,0,null,0,0]
[48,1.16874791,-3.1067277500000001,"",false,false,"","",null,"","",null,0,0,null,0,0,null,0,0]
[49,1.22022199,-2.8587521699999998,"",false,false,"","",null,"","",null,0,0,null,0,0,null,0,0]
[50,3.3373057099999999,0.91152189800000005,"",false,false,"","",null,"","",null,0,0,null,0,0,null,0,0]
[51,9.9104819800000001,11.892123959999999,"",false,false,"","",null,"","",null,0,0,null,0,0,null,0,0]
[52,8.4212998199999998,10.24603712,"",false,false,"","",null,"","",null,0,0,null,0,0,null,0,0]
[53,0.20667169799999999,-0.79117017499999998,"sums",{"$f":"SUM(E2:E53)","v":62.68328034132054},{"$f":"SUM(F2:F53)","v":79.90850157365503},{"$f":"SUM(G2:G53)","v":588.79773461339551},{"$f":"SUM(H2:H53)","v":453.75732529027982},null,null,null,"Sums =",{"$f":"SUM(M2:M53)","v":16.98014123807603},{"$f":"SUM(N2:N53)","v":201.3920720950334},"Sums =",{"$f":"SUM(P2:P53)","v":20.838696521279708},{"$f":"SUM(Q2:Q53)","v":201.3920720950334},"Sums =",{"$f":"SUM(S2:S53)","v":22.151783139609744},{"$f":"SUM(T2:T53)","v":201.3920720950334}]
[54,6.4843481000000001,10.3540317,null,null,null,"a=",{"$f":"(n*G54-E54*F54)/(n*H54-E54^2)","v":1.3819762917181628}]
[55,9.1472265700000008,9.7148863700000003,null,null,null,"b=",{"$f":"(F54-H55*E54)/n","v":-0.61075506774301269},null,null,null,"R^2 =",{"$f":"1-M54/N54","v":0.9156861486083554},null,"R^2 =",{"$f":"1-P54/Q54","v":0.89652672866166105},null,"R^2 =",{"$f":"1-S54/T54","v":0.89000667747657558}]
[56,0.84874671999999995,0.71562971500000006,null,null,"xl,xr=",0,14]
[57,4.4389659000000004,2.81245038,null,null,"yl,yr=",{"$f":"H56","v":-0.61075506774301269},{"$f":"H56+14*H55","v":18.736913016311266}]
[58,5.9462980999999999,9.7186380799999998]
[59,0.11949396399999999,-4.5824346299999998]
[60,4.5104675800000003,6.9694584800000001]
[61,5.6862280099999998,9.6901438100000004]
[62,6.5333036399999997,9.8579278600000002,"Quartiles:"]
[63,5.2446946700000003,7.8713711000000002,"x's",{"$f":"QUARTILE(E2:E52,1)","v":3.6298326542224286},"y's",{"$f":"QUARTILE(F2:F52,1)","v":4.6489404079056413},"delta y =",{"$f":"G65-G64","v":5.0361767713997274}]
[64,2.3317131500000001,3.9683671,null,{"$f":"QUARTILE(E2:E52,3)","v":7.8651184583985998},null,{"$f":"QUARTILE(F2:F52,3)","v":9.6851171793053688}]
[65,2.1725842800000001,-0.318387121]
[66,1.1164723999999999,-7.8287546E-2,null,"slope =",{"$f":"IF(H55>=0,I64/(E65-E64),-I64/(E65-E64))","v":1.1890996273342034}]
[67,8.53363023,11.8219133,null,"b =",{"$f":"G64-mQQ*E64","v":0.33270775148422871}]
[68,4.59207945,2.4343364599999999,null,null,"xl,xr=",0,14]
[69,9.3413851000000001,14.209857100000001,null,null,"yl,yr=",{"$f":"F68","v":0.33270775148422871},{"$f":"F68+14*mQQ","v":16.980102534163077}]
[70,1.423125,0.64634512099999997]
[71,5.2521179900000003,8.9534160499999995,null,null,null,null,null,null,"nX1 =",{"$f":"INT((n+2)/3+0.3)","v":4}]
[72,8.4497598600000003,10.1485986,"Medians",null,"x ","y",null,null,"nX2 =",{"$f":"INT((n+2)/3+0.3)","v":4}]
[73,6.3058183300000001,5.8214770199999997,null,"1st",{"$f":"PERCENTILE(J2:J53,1/6)","v":2.3804118993984096},{"$f":"PERCENTILE(K2:K53,1/6)","v":1.8408215429700225},null,null,"nX3 =",{"$f":"n-2*_nX1","v":3}]
[74,3.1306581699999998,3.6333193600000002,null,"3rd",{"$f":"PERCENTILE(J2:J53,5/6)","v":8.4120442395652724},{"$f":"PERCENTILE(K2:K53,5/6)","v":10.484136539927558}]
[75,4.4822054400000004,4.6762966099999996,null,"middle",{"$f":"MEDIAN(J2:J53)","v":5.9778139928798435},{"$f":"MEDIAN(K2:K53)","v":8.9311886960292632}]
[76,4.3412921999999998,4.0240330999999996,null,null,null,null,"Line through Middle Point"]
[77,2.6233265499999998,4.44153764,null,"slope =",{"$f":"(G75-G74)/(F75-F74)","v":1.4329976546147409},null,"slope =",{"$f":"mMed","v":1.4329976546147409}]
[78,5.7589141000000001,6.3190208200000004,null,"b =",{"$f":"G74-mMed*F74","v":-1.5703031258849192},null,"b =",{"$f":"G76-I78*F76","v":0.36499526450926822}]
[79,1.39826337,1.12138749]
[80,8.3465480200000002,10.091565299999999,null,"distance =",{"$f":"ABS(mMed*F76-G76+F79)/SQRT(F79^2+1)","v":1.0395441398337049},null,"Line 1/3 of way"]
[81,5.5414155999999997,8.21511411,null,null,null,null,"b =",{"$f":"$F79+($I79-$F79)/3","v":-0.92520366242019003}]
[82,5.1856461300000003,7.9659008900000003]
[83,2.3124036499999998,2.1144006599999998,null,"Graphing points"]
[84,8.6145668200000003,11.9266656,null,{"$f":"0","v":0},{"$f":"I82","v":-0.92520366242019003}]
[85,1.82822638,-2.92768506,null,10,{"$f":"10*I78+I82","v":13.404772883727221}]
[86,1.25997063,0.88099889499999995]
[87,5.9835337900000001,6.7541769299999999]
[88,8.87683015,11.8436226]
[89,2.3520277799999998,-0.517630912]
[90,6.6065631500000004,9.5195644500000007]
[91,4.4224595999999998,7.0814903300000003]
[92,8.0506673899999992,11.573889400000001]
[93,9.7713714700000001,11.31715752]
[94,6.2620883799999998,10.6125892]
[95,7.4445936899999996,10.165211899999999]
[96,4.8245429299999998,3.8588945699999999]
[97,5.5722248099999998,7.5462324299999999]
[98,4.4179373499999999,3.4445838200000001]
[99,8.4986549606923578,15.265962912187948]
[100,5.1634547445665042,8.3874278988680597]
[101,5.4458456762474583,6.6681100293613467]
[102,3.4094557169609363,3.6520829590804085]
[103,5.0898725373160936,7.3529825306937582]
[104,2.7962367993366222,3.8294492481387614]
[105,3.3553365657520917,3.6434025574784514]
[106,5.5739660508097177,10.596846294807699]
[107,1.1405256196458247,1.0120546091450575]
[108,6.0027236613643931,7.8726365751424154]
[109,4.2473853747116674,5.5314138092696616]
[110,2.5899652593558353,2.9413220452259869]
[111,3.8563894703487112,4.9257543803902486]
[112,4.3293947390416765,5.4820662630587123]
[113,9.488624038798692,13.332107472922251]
[114,1.252853786427286,1.0100640028655623]
[115,5.7921047390135083,6.9372239234158073]
[116,5.3250493749477474,11.2900628245365]
[117,1.6340339228916534,3.020722199310383]
[118,7.9459313192243197,12.866085688882031]
[119,4.1661267499970478,7.4375455053121549]
[120,0.35354353741588795,-1.0731643416126662]
[121,4.2728411131601867,5.2206182647121677]
[122,7.182313270619229,9.864613996322797]
[123,8.3553786900085214,12.244021405653474]
[124,9.5943776524206328,14.973745581355651]
[125,2.4221504716819453,2.1387712771999832]
[126,8.8349732676527726,11.917701081681987]
[127,6.3462433024678511,11.0887658263538]
[128,9.1177701257784616,11.889390364798979]
[129,3.4021490602585969,7.3291441406926339]
[130,5.0060367960099228,5.9533080785299743]
[131,6.8864912989983518,9.410603282295412]
[132,2.3657539173435982,1.9008836040513479]
[133,2.6830196025925201,3.0389984183887524]
[134,9.1500914337672956,14.553313377781]
[135,1.1446641872815011,3.1697184174253565]
[136,1.8514183165426168,2.2694190174681865]
[137,8.8662054094358478,15.395163428346962]
[138,7.2415678080261969,9.5755070649732623]
[139,3.5467090203525475,8.8908244024619005]
[140,0.76271523417664078,0.2338329209201615]
[141,4.8005063115632574,5.6106886371162874]
[142,9.9112222145109907,14.010701314914378]
[143,3.1298162215125824,4.0678245265709227]
[144,6.6182337976023771,10.934469818299988]
[145,0.8525446832435013,2.9996479371763423]
[146,8.0919079664045395,12.022468542541647]
[147,5.4461115917511389,7.1403852577179636]
[148,1.1377542072032565,4.1653095983966999]
[149,8.0900216626433252,10.603349573558262]
[150,6.8236248933967891,12.354040682638001]
[151,5.3397351752720468,7.1779337361530198]
[152,6.9202326293888312,8.9745040915337775]
[153,3.2384547362536154,4.3544413035996898]
[154,9.8373755329406993,15.801176329166585]
[155,4.8256411591609805,6.1600312882596793]
[156,7.5222741385832492,10.398178080808218]
[157,7.2810892925524584,9.7350388718327459]
[158,6.5764931629664947,13.218822693597421]
[159,7.1432618799211589,9.2497141559072418]
[160,2.3790581557966028,5.6357215776136949]
[161,4.3820515385193133,4.9365147229767743]
[162,1.7286565252373598,1.4654855864438978]
[163,5.4932355305844798,8.8656207961652012]
[164,9.9656062706024162,13.997749013626128]
[165,3.0401163617295479,3.5833705441942101]
[166,8.6908914981058629,15.603789463461201]
[167,5.6949934178282025,7.5872591807906486]
[168,5.7103770203424009,7.2397772694645726]
[169,7.8580010287960045,12.828081007665793]
[170,3.7446948913362732,4.4641817735593659]
[171,8.7780746245692143,13.506420648081406]
[172,7.3103128496753573,10.56882331609917]
[173,4.2856205396178044,5.7101114324544113]
[174,6.3223547334367414,8.2132773358906981]
[175,2.2315282967237082,2.4042547655017708]
[176,3.50680669059515,4.9167801990209981]
[177,5.3679291962647957,6.5109667962489217]
[178,7.2518105835745672,11.875647018657912]
[179,3.2648962740822185E-2,0.14112108804542001]
[180,3.1214132439063502,3.8316182739838296]
[181,6.2890043826908126,12.751292336237183]
[182,1.3086412443964068,3.6081103627702]
[183,2.3217560734071774,2.9248271345654651]
[184,0.14145823444282613,-0.83671946230057703]
[185,8.1699973206037448,11.341782431199082]
[186,8.0057885833686253,10.376369834430827]
[187,6.519533521942888,9.254708349873745]
[188,9.1345655578800589E-2,-1.4671504185821658]
[189,1.101807709501168,0.46254609360549703]
[190,3.6099991361880601,5.9099133664434191]
[191,8.862057695934995,12.368626358792984]
[192,6.6372141472336654,9.0381054897906381]
[193,7.3238383677391106,9.8486686017351293]
[194,3.6183896033488883,4.3987562597794678]
[195,7.8962395661564555,10.467689897148318]
[196,0.76803770988060238,-0.17529515458519196]
[197,3.0020486930644386,4.4511516805145366]
[198,6.0178781402330994,7.3870964732148332]
[199,1.6954447009960338,1.7662608069999726]
[200,4.0071369326860351,5.8149025862845107]
[201,1.9686569618121053,1.9841783753660602]
[202,6.996969959662005,8.8053679620889831]
[203,5.9881481452474805,8.7308597667403127]
[204,3.308265585188872,6.8379327276228423]
[205,9.041516206091643,12.043639779605522]
[206,6.5727778271282133,8.7475985828241836]
[207,0.38803442786040421,-0.84365506804234947]
[208,1.5051788029239521,4.9638057506063475]
[209,5.4429712832420085,7.6258458572340526]
[210,9.4908536981671787,13.202516086178253]
[211,4.9689101028393967,6.5161516213616197]
[212,5.3654831771327327,6.4624929186485636]
[213,6.6983500438591488,10.792994407672209]
[214,1.6941838803347231,0.83294517643265431]
[215,4.4844934000096437,10.497068403577201]
[216,7.8903828523821495,6.7415408013276004]
[217,8.7737972157628192,11.901876569481338]
[218,9.1766607303114167,13.3242806178202]
[219,1.4135924929262988,3.7481662616878935]
[220,4.3773948230563153,7.335011065144073]
[221,4.2438187682743411,6.2838912182060103]
[222,2.9012296601372434,7.5231318089897998]
[223,1.4677999427926225,1.3276112265289484]
[224,8.8500932679654216,12.105880499957472]
[225,4.7927455702920296,7.82741515961016]
[226,9.2500602122973614,11.351208399530799]
[227,3.6739445272245197,4.1937702660507998]
[228,2.5634850895736427,2.4768516990427418]
[229,9.4027331025672023,14.3929087483101]
[230,8.7358017372407204,13.504142490399479]
[231,6.5893763959274914,8.971115924241138]
[232,5.2160034039536107,11.532730797797036]
[233,7.9848542353849306,10.790153830847302]
[234,1.1330083820892867,3.9329833082832204]
[235,0.67894489191479668,0.50897045137204855]
[236,6.7690190978073801,9.2265311699683146]
[237,6.4862939147936549,13.612853793873301]
[238,8.9789489170835779,14.57182859908777]
[239,1.6871419809884225,2.1697972727457491]
[240,3.4208672870853274,8.9278844529987893]
[241,1.4419552557102744,1.2654029560604627]
[242,2.7873558148971078,3.2600339112539189]
[243,7.3723567430533041,14.15401139120323]
[244,1.7375385257517406,1.3274580924991946]
[245,7.9719723429466356,14.077036682687522]
[246,2.5963679645121052,8.6568750385048006]
[247,3.9683628429778928,4.5622538904374883]
[248,3.9412545894168272,6.2827624013223673]
[249,9.8019176403557751,16.65592597297271]
[250,5.5203368538556674E-2,1.948726888043173E-2]
[251,7.6582415224492912,10.144178208610738]
[252,2.6702250271780237,2.925908317102361]
[253,2.7270468586034036,1.1828700834185699]
[254,1.1419442312216033,1.5742783532651146]
[255,4.5506393858648675,5.838884714126932]
[256,6.0503575811612365E-2,-0.88215821640236758]
[257,4.8671143214962798E-2,0.35667577297134001]
[258,1.2394882492330073,0.73355664601018433]
[259,6.5239562867684793,8.5470040434976404]
[260,0.7940843459245972,0.11729142010121001]
[261,9.0074577620333436,13.253751216105011]
[262,1.8314434350190556,1.9047131476628156]
[263,6.5771345737093618,10.129726947775568]
[264,0.38670715099446085,1.534111384119754]
[265,0.36522624383226177,-0.19922227605221843]
[266,7.2161926911738306,9.8859229973063734]
[267,6.5110817307785851,13.800060184140401]
[268,4.8050001233502115,6.1785477163140996]
[269,3.666581661681152,5.3853285914882827]
[270,4.8924771983786464,9.4491420220653204]
[271,9.5002936567458018,15.389731578997759]
[272,2.9001792757518441,3.3810563193857082]
[273,1.8815562943405251,1.750412100965411]
[274,3.0262558719003962,9.169401729152689]
[275,7.3374352986168123,9.5748144024567914]
[276,4.0381884226039766,5.3857284288438505]
[277,5.220468369479347,8.1139770160987776]
[278,0.19869643820853655,-1.548675626708963]
[279,3.7412358280695468,4.4347980900826478]
[280,4.6960122517294334,6.3431212890244]
[281,1.477663452221547,3.0510870667526055]
[282,7.3934600803110868,12.654889585788244]
[283,6.1842725200147726,7.808466476660179]
[284,7.818623012144597,14.288010440950092]
[285,6.6620714482949728,9.6321675585271631]
[286,0.15446583210299014,-0.8391181197015869]
[287,7.7959736246489175,11.006525900573429]
[288,3.6787389497515921,5.4229141894762103]
[289,9.1558546588781642,13.345455166555794]
[290,3.5826281094704382,4.30831352958017]
[291,9.3188617307808546,15.1632824539856]
[292,3.0610660275056034,8.1888671683822771]
[293,1.5675344209138453,1.7533965630004673]
[294,5.3502649803261022,9.3992153776299077]
[295,5.3604518039992683,8.1724568467567948]
[296,8.233341992061245,13.716824070049993]
[297,4.8105841760667722,5.724291400066047]
[298,8.7172011800544347,10.1909323143341]
[299,6.8971120346072663,10.373914010326741]
[300,6.9525604667211205,8.8374114454575636]
[301,1.4880319609982529,1.0816092435081188]
[302,1.7599831210840322,1.5909511216843224]
[303,8.5528840612647095,11.935414601761497]
[304,7.9525604667211196,9.8374114454575601]
[305,5.4747900828073686,7.2465913957509533]
[306,0.96214034790407688,0.80495344925817491]
[307,5.9573477802915509,7.9142668722253013]
[308,0.86140813919678649,2.8977346899606902]
[309,0.25699945148575987,1.59382960362792]
[310,7.1479073898209116,9.1696355865690773]
[311,9.8732776289864876,13.39935789623949]
[312,5.4160761701007898,7.0981108578805241]
[313,1.620383073816658,2.2166902889335058]
[314,3.8937080461722862,4.0343377095742046]
[315,8.9355246603105254,15.393548209679764]
[316,8.141106430121285,13.610480114295285]
[317,4.941073579261861,6.3327469760680835]
[318,3.8323661245541629,4.9005898149337508]
[319,0.56592228775294018,0.98820446181555521]
[320,8.6877146182605465,15.233535264352582]
[321,8.6432983083976556,11.795238857365748]
[322,0.15103619558535009,0.74855586193504564]
[323,6.8403117988900259,8.8327768684551362]
[324,4.3558168742634829,7.801517982897999]
[325,5.172426329099169,6.2218467804549578]
[326,0.76667411142584463,2.1630137371862332]
[327,9.039115292345361,12.357589907902458]
[328,2.0438486082449536,1.771787990984288]
[329,6.0537901132036875,7.9817682349426731]
[330,2.8377527642991263,3.3333387812130022]
[331,1.3243081533701484,1.0602961618497493]
[332,0.61801842081518288,1.2424019630482599]
[333,6.9817304993047475,8.979745073768191]
[334,0.1426316554836049,-0.78786307693174251]
[335,3.6499905948580413,7.825033330792496]
[336,1.870541375343342,1.1805516340269766]
[337,6.9008867643619247,10.204409107974497]
[338,6.1399117043838665,8.2210826242295774]
[339,6.2612765442406459,9.0131252623016547]
[340,1.7998922865176414,1.8595912072524055]
[341,9.9761232919260046,13.980574358054476]
[342,6.1140364480937777,7.6693035512060561]
[343,5.1503670677794489,6.738228966505095]
[344,1.5135708129106806,4.6587681243049923]
[345,7.1072252119212909,9.7334006368689181]
[346,1.1915612553786969,2.2692563540303219]
[347,6.3247959995675895,7.8685728216588791]
[348,6.2277472888214858,7.9355552105199703]
[349,4.9966891895952958,6.064861197109102]
[350,7.76762289708544,10.420430228595862]
[351,7.2935958371762499,9.6293815376374745]
[352,3.2542346853922854,3.9283447304969492]
[353,5.644777953613076,8.6480184410304002]
[354,1.4703597302266935,0.77110129201157374]
[355,4.2738091414981838,5.5362098128578729]
[356,1.4933176598749931,2.1275883997256515]
[357,6.4900321083413282,13.120219713956633]
[358,6.8644644434118813,9.2775228103630116]
[359,5.1636931133625286,7.3496835595638865]
[360,4.8947500606796979,7.7045339464278291]
[361,7.7104019408160536,11.235786062738599]
[362,7.0533094021657856,9.5051582595847144]
[363,8.8903958428841925,12.042877971650041]
[364,2.674927641791407,4.8361072334281729]
[365,8.8782001103438812,12.349001526138636]
[366,7.6590328997082864,9.9893809862059104]
[367,5.7603707681106009,7.7914720670936486]
[368,4.4205173223964334,5.404310703761789]
[369,6.9658494743887545,9.4982959108348108]
[370,4.4215250791477079,10.527068064918168]
[371,6.7523814684139749,9.8569693030717573]
[372,0.41494044522567552,0.47240752731020907]
[373,7.4591854463512703,10.320616227050698]
[374,7.9574460251726986,16.222075355994896]
[375,4.3911451875225893,5.019223424003405]
[376,0.46505274619487835,-0.22593091958698719]
[377,3.0408975358690071,2.6602505325350201]
[378,8.3747480853332235,10.510650911269501]
[379,2.483427613021556,4.8399690215175593]
[380,7.8589178589293081,10.051016488601196]
[381,9.1319343172330729,12.552913191434319]
[382,3.9405995487896761,6.6048693588312615]
[383,3.7772115049966803,4.8172249658671555]
[384,5.4766934263239371,7.1280835430655349]
[385,5.9208963748429255,8.4062402559504612]
[386,1.0073275699233375,3.0485049962051756]
[387,9.5004431501629956,12.75987320728431]
[388,3.0136595489422291,2.8531384179154013]
[389,7.3343054886960601,9.743790495905488]
[390,9.4746422668363195,13.830945987610692]
[391,6.5585587679285684,8.6346855940950515]
[392,7.8642278245167496,10.695125370339451]
[393,1.8554865276435994,1.8222645960802755]
[394,3.764890110705994,7.0217187676083181]
[395,7.826619216503234,10.134721442862574]
[396,8.2278637630366447,11.785310894543299]
[397,6.7308461320085833E-2,-0.59702735834084919]
[398,5.9640576353372721,7.3864178093434401]
[399,4.1082974447572695,5.2853973502092071]
[400,1.3928145321172103,4.6426942183984741]
[401,2.4874776446800251,2.5548488822556337]
[402,0.63845572537949868,-0.59528783994682244]
[403,6.1267959922547099,11.912147368145201]
[404,6.6865527342262094,9.1847616816165427]
[405,6.3082639571029953,8.4171265027942468]
[406,6.1174243289691699,11.635918876811942]
[407,9.4578980321574022,13.162653526693784]
[408,4.5681849007135256,5.9608129255769073]
[409,9.8503596824013595,13.656028266075758]
[410,1.4768568736947074,1.3799032819796315]
[411,4.5011269504434015,7.9390670251094289]
[412,7.8320148809229728,14.43572556356969]
[413,9.7773770633914321,13.805124819802874]
[414,2.7950537847837964,4.5073928915468091]
[415,9.7094675975974916,13.896482453995]
[416,4.8823991410948615,6.4360206756826281]
[417,7.3386603021936114,15.295872075750442]
[418,9.6101716773658019,14.488520415201176]
[419,8.1956683960958472,11.456945995606301]
[420,6.569000716891928,8.1677036913542587]
[421,0.54660265947950926,-0.18653225912045091]
[422,8.900442607690513,12.35432214856479]
[423,4.7494204218260361,6.8569503933586979]
[424,8.0719953943479084,11.164053202561197]
[425,1.8070864517549978,1.7416110390058728]
[426,4.5326184498414541,7.2658175643726883]
[427,6.9885348759584236,9.3455077581845476]
[428,4.325001095251368,5.0708702554562199]
[429,0.84150849679000217,1.0462541563059669]
[430,4.0231000638151926,4.5932348661614739]
[431,0.12732263727994741,-1.6605184319212518]
[432,0.80762306213334689,0.33078967169907747]
[433,3.27441585738101,6.7843168266616818]
[434,3.5399816982625598,4.2841148978861083]
[435,3.8642261794273658,9.2796652551715511]
[436,4.0820805396994864,8.7544259883443516]
[437,5.3936026916160813,7.5269307804698089]
[438,4.3215582402596375,5.5561618103124433]
[439,3.9366875209881425,4.3564057071213753]
[440,9.9083344028830922,14.030196260761389]
[441,9.3548784425746696,16.689508933402745]
[442,2.5956425287846496,2.7804630136276995]
[443,9.6400232339910481,14.714347343605308]
[444,4.5829127045120988,9.7188359995582747]
[445,6.9115955179206656,9.4989223867298804]
[446,1.7654113582191089,2.141253773149888]
[447,1.7217897250392489,1.4757734328180563]
[448,4.9931588576240138,7.2674600338665032]
[449,4.3506429977654015,5.6550583574589179]
[450,2.4393816677299007,2.6588761359742747]
[451,9.655504892810324,13.602996726514972]
[452,6.6479377130863604,10.67406086654605]
[453,0.33555610413936954,-0.45375309177224987]
[454,5.9778139928798435,8.9311886960292632]
[455,6.075263980189149,11.282461750971585]
[456,9.0579338811012011,14.242059244215399]
[457,7.7179870138134472,10.458313363579663]
[458,1.3578284498681548,2.5379222086592796]
[459,3.6068105942080053,4.0983668111970726]
[460,5.371909194400768,7.1325663265933885]
[461,4.8845852752784396,6.6348643622707826]
[462,1.0059581562211317,0.12797791593396501]
[463,8.8583914825613448,12.013535616745314]
[464,1.4581096815090877,0.65039979552104965]
[465,3.9416342223019907,5.536921984303949]
[466,2.2721212362698306,2.4139360395814542]
[467,3.8746898569702637,5.1374500008896238]
[468,2.121102408831459,2.606792530372414]
[469,9.4131592375111506,13.251051764366048]
[470,3.2534896362086507,3.2825058166553216]
[471,5.9742813871291389,7.870514320009943]
[472,1.4233334082712767,0.44772940412325613]
[473,8.8106454217136623,12.313253000955346]
[474,6.1767803832186363,11.118102665077959]
[475,7.9138442150953558,10.703020787632038]
[476,4.76923728814028,5.3629003049054003]
[477,3.1588429852097644,4.9684866719746434]
[478,0.41872762724397994,-0.63339038621088262]
[479,8.462811050415155,9.6409875244599998]
[480,8.2796306061379212,11.034225795616823]
[481,4.5791507599287158,6.4370171946791341]
[482,5.8149146706111843,7.78950536979365]
[483,9.7387030796730585,13.476781084329959]
[484,4.0045094149045024,5.7257781052145909]
[485,2.8795624536466757,5.3634522958762441]
[486,6.5694184699584923,13.472349693690731]
[487,6.0398490469143589,8.00193117490468]
[488,1.429231249359415,3.5381799420611801]
[489,2.3562173660461116,3.3868039256993798]
[490,0.75450661755060766,-0.12200500735643094]
[491,5.4002680752708176,9.3292209099241745]
[492,6.5324341693541577,13.285598183869865]
[493,2.4976878149009263,2.8511708533162654]
[494,1.2218721087191309,2.2304470206533549]
[495,5.6670881206542045,8.7474404972316631]
[496,4.5326842345820495,5.1733498148988177]
[497,0.22086403318721359,-1.3690361231285952]
[498,9.7910890322286335,13.160044791377686]
[499,6.1626943154846758,9.9580512542602477]
[500,3.9061874613272463,5.3176122982893004]
[501,2.0269028791192145,1.7832891667725619]
[502,2.3519795632531726,1.695250613489883]

{"sheet":"Sheet4","index":2,"n_rows":202,"n_cols":5,"rows_kept":202,"cut":false,"hidden":false,"merged":[]}
[null,"x's",-1,11]
[null,"y's",{"$f":"1.5003*C1-0.5874","v":-2.0876999999999999},{"$f":"1.5003*D1-0.5874","v":15.915899999999999}]
[null,null,-1,11]
[null,null,{"$f":"C2-4.69","v":-6.7777000000000003},{"$f":"D2-4.69","v":11.225899999999999}]
[null,null,-1,11]
[null,null,{"$f":"C2+4.69","v":2.6023000000000005},{"$f":"D2+4.69","v":20.605899999999998}]
[null,null,-1,11,"sample 1"]
[null,null,{"$f":"samples!G58","v":-0.61075506774301269},{"$f":"samples!H58","v":18.736913016311266}]
[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}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["center circle"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"LinesOfFit!#REF!","v":{"$error":"#REF!"}},{"$f":"LinesOfFit!#REF!","v":{"$error":"#REF!"}}]
[null,null,0,1]