{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":6,"images":0,"macros":0,"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":"Sheet1","index":0,"n_rows":68,"n_cols":18,"rows_kept":68,"cut":false,"hidden":false,"merged":[]}
["        Fitting Functions to Data",null,null,null,null,null,"x","y","log(x)","log(y)"]
[null,null,null,null,null,null,1,2,{"$f":"LOG(G2)","v":0},0.3010299956639812]
[" This DIGMath module demonstrates the process",null,null,null,null,null,2,5,0.3010299956639812,0.69897000433601886]
["of fitting linear, exponential and power functions",null,null,null,null,null,3,8,0.47712125471966244,0.90308998699194354]
[null,null,"to a set of data",null,null,null,4,14,0.6020599913279624,1.146128035678238]
[null,null,null,null,null,null,5,21,0.69897000433601886,1.3222192947339193,null,null,null,null,null,null,"Correlation coefficient"]
[null,null,null,null,null,null,6,29,{"$f":"IF(G7=\"\",\"\",LOG(G7))","v":0.77815125038364363},{"$f":"IF(H7=\"\",\"\",LOG(H7))","v":1.4623979978989561},null,null,null,null,null,null,"r =",{"$f":"CORREL(G2:G31,H2:H31)","v":0.9482963942542264}]
["How many data points, n, between 2 and 50?",null,null,null,null,null,7,39,0.84509804001425681,1.5910646070264991]
[null,"   n =",{"$f":"E9","v":0},null,null,null,8,52,0.90308998699194354,1.7160033436347992]
[null,null,null,null,null,null,9,67,0.95424250943932487,1.8260748027008264,null,null,null,null,null,null,"Sum of the Squares"]
[null,null,null,null,null,null,10,88,1,1.9444826721501687,null,null,null,null,null,null,"=",{"$f":"Sheet2!K32","v":12245.313235294121}]
[null,null,null,null,null,null,11,107,1.0413926851582251,2.0293837776852097]
[null,null,null,null,null,null,12,133,1.0791812460476249,2.1238516409670858]
[null,null,null,null,null,null,13,177,1.1139433523068367,2.2479732663618068]
[null,null,null,null,null,null,14,218,1.146128035678238,2.3384564936046046]
[null,null,null,null,null,null,15,245,1.1760912590556813,2.3891660843645326]
[null,null,null,null,null,null,16,266,{"$f":"IF(G17=\"\",\"\",LOG(G17))","v":1.2041199826559248},2.424881636631067]
[null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,"Correlation coefficient"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"r =",{"$f":"CORREL(G2:G31,J2:J31)","v":0.97477228064882748}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sum of the Squares"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"=",{"$f":"Sheet2!O32","v":35330.94553089104}]
[]
[null,null,null,null,null,null,"Created by:  Sheldon P. Gordon"]
[null,null,null,null,null,null,"                     Farmingdale StateCollege"]
[null,null,null,null,null,null,"Development of this module was supported by the "]
[null,null,null,null,null,null,"NSF's Division of Undergraduate Education  "]
[null,null,null,null,null,null,"under grants DUE-0310123 and DUE-0442160."]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Correlation coefficient"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"r =",{"$f":"CORREL(I2:I31,J2:J31)","v":0.9905723557953372}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sum of the Squares"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"=",{"$f":"Sheet2!S32","v":7906.2078919726855}]

{"sheet":"Sheet2","index":1,"n_rows":51,"n_cols":19,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
["x","y","log(x)","log(y)",null,null,null,null,"Linear","y-y","(y-y)^2","Expo","y calc","y-y","(y-y)^2","Power","y calc","y - y","(y - y)^2"]
[{"$f":"Sheet1!G2","v":1},{"$f":"Sheet1!H2","v":2},{"$f":"LOG(A2)","v":0},0.3010299956639812,null,"Linear",null,null,null,{"$f":"($F$3*A2+$H$3)-B2","v":-44.544117647058819},{"$f":"J2^2","v":1984.1784169550169},null,{"$f":"$F$10*$H$10^A2","v":4.6856747559237171},{"$f":"M2-B2","v":2.6856747559237171},{"$f":"N2^2","v":7.2128488946059175},null,{"$f":"$F$17*A2^$H$17","v":1.2978770199595582},{"$f":"Q2-B2","v":-0.70212298004044182},{"$f":"R2^2","v":0.49297667910087067}]
[{"$f":"Sheet1!G3","v":2},{"$f":"Sheet1!H3","v":5},0.3010299956639812,0.69897000433601886,"a=",{"$f":"SLOPE(B2:B31,A2:A31)","v":17.930882352941175},"b=",{"$f":"INTERCEPT(B2:B31,A2:A31)","v":-60.474999999999994},null,{"$f":"($F$3*A3+$H$3)-B3","v":-29.613235294117644},{"$f":"J3^2","v":876.94370458477488},null,{"$f":"$F$10*$H$10^A3","v":6.3369308528066179},{"$f":"M3-B3","v":1.3369308528066179},{"$f":"N3^2","v":1.7873841051862307},null,{"$f":"$F$17*A3^$H$17","v":4.6813551763871741},{"$f":"Q3-B3","v":-0.31864482361282587},{"$f":"R3^2","v":0.10153452361524891}]
[{"$f":"Sheet1!G4","v":3},{"$f":"Sheet1!H4","v":8},0.47712125471966244,0.90308998699194354,null,null,null,null,null,{"$f":"($F$3*A4+$H$3)-B4","v":-14.682352941176468},{"$f":"J4^2","v":215.57148788927327},null,{"$f":"$F$10*$H$10^A4","v":8.5700981662215412},{"$f":"M4-B4","v":0.57009816622154119},{"$f":"N4^2","v":0.325011919129164},null,{"$f":"$F$17*A4^$H$17","v":9.9146288038292791},{"$f":"Q4-B4","v":1.9146288038292791},{"$f":"R4^2","v":3.6658034564527364}]
[{"$f":"Sheet1!G5","v":4},{"$f":"Sheet1!H5","v":14},0.6020599913279624,1.146128035678238,null,null,null,null,null,{"$f":"($F$3*A5+$H$3)-B5","v":-2.7514705882352928},{"$f":"J5^2","v":7.5705903979238682},null,{"$f":"$F$10*$H$10^A5","v":11.590245228278674},{"$f":"M5-B5","v":-2.4097547717213263},{"$f":"N5^2","v":5.806918059833702},null,{"$f":"$F$17*A5^$H$17","v":16.885333471864588},{"$f":"Q5-B5","v":2.8853334718645876},{"$f":"R5^2","v":8.325149243862155}]
[{"$f":"Sheet1!G6","v":5},{"$f":"Sheet1!H6","v":21},0.69897000433601886,1.3222192947339193,null,null,null,null,null,{"$f":"IF(A6=\"\",\"\",($F$3*A6+$H$3)-B6)","v":8.1794117647058897},{"$f":"IF(A6=\"\",\"\",J6^2)","v":66.902776816609119},null,{"$f":"$F$10*$H$10^A6","v":15.674707785857583},{"$f":"M6-B6","v":-5.3252922141424168},{"$f":"N6^2","v":28.358737166005845},null,{"$f":"$F$17*A6^$H$17","v":25.519257427259969},{"$f":"Q6-B6","v":4.5192574272599693},{"$f":"R6^2","v":20.423687693844396}]
[{"$f":"IF(Sheet1!G7=\"\",\"\",Sheet1!G7)","v":6},{"$f":"IF(Sheet1!H7=\"\",\"\",Sheet1!H7)","v":29},{"$f":"IF(Sheet1!G7=\"\",\"\",LOG(A7))","v":0.77815125038364363},{"$f":"IF(Sheet1!H7=\"\",\"\",LOG(B7))","v":1.4623979978989561},null,"Expo",null,null,null,{"$f":"IF(A7=\"\",\"\",($F$3*A7+$H$3)-B7)","v":18.110294117647058},{"$f":"IF(A7=\"\",\"\",J7^2)","v":327.98275302768161},null,{"$f":"IF(A7=\"\",\"\",$F$10*$H$10^A7)","v":21.198556142069993},{"$f":"IF(A7=\"\",\"\",(M7-B7))","v":-7.8014438579300069},{"$f":"IF(A7=\"\",\"\",N7^2)","v":60.862526268433832},null,{"$f":"IF(A7=\"\",\"\",$F$17*A7^$H$17)","v":35.761399700419851},{"$f":"IF(A7=\"\",\"\",Q7-B7)","v":6.7613997004198509},{"$f":"IF(A7=\"\",\"\",R7^2)","v":45.716525908837653}]
[{"$f":"IF(Sheet1!G8=\"\",\"\",Sheet1!G8)","v":7},{"$f":"IF(Sheet1!H8=\"\",\"\",Sheet1!H8)","v":39},{"$f":"IF(Sheet1!G8=\"\",\"\",LOG(A8))","v":0.84509804001425681},{"$f":"IF(Sheet1!H8=\"\",\"\",LOG(B8))","v":1.5910646070264991},"A=",{"$f":"SLOPE(D1:D31,A1:A31)","v":0.13110682835407178},"B=",{"$f":"INTERCEPT(D2:D31,A2:A31)","v":0.5396653115172434},null,26.041176470588226,678.14287197231783,null,{"$f":"IF(A8=\"\",\"\",$F$10*$H$10^A8)","v":28.669037320998289},{"$f":"IF(A8=\"\",\"\",(M8-B8))","v":-10.330962679001711},{"$f":"IF(A8=\"\",\"\",N8^2)","v":106.72878987492622},null,{"$f":"IF(A8=\"\",\"\",$F$17*A8^$H$17)","v":47.568317277950925},{"$f":"IF(A8=\"\",\"\",Q8-B8)","v":8.5683172779509249},{"$f":"IF(A8=\"\",\"\",R8^2)","v":73.416060975632348}]
[{"$f":"IF(Sheet1!G9=\"\",\"\",Sheet1!G9)","v":8},{"$f":"IF(Sheet1!H9=\"\",\"\",Sheet1!H9)","v":52},{"$f":"IF(Sheet1!G9=\"\",\"\",LOG(A9))","v":0.90308998699194354},{"$f":"IF(Sheet1!H9=\"\",\"\",LOG(B9))","v":1.7160033436347992},"In y = a*b^x",null,null,null,null,30.972058823529409,959.26842776816591,null,38.772154830000339,-13.227845169999661,174.97588784148337,null,60.904262913908418,8.9042629139084184,79.285898040004838]
[{"$f":"IF(Sheet1!G10=\"\",\"\",Sheet1!G10)","v":9},{"$f":"IF(Sheet1!H10=\"\",\"\",Sheet1!H10)","v":67},{"$f":"IF(Sheet1!G10=\"\",\"\",LOG(A10))","v":0.95424250943932487},{"$f":"IF(Sheet1!H10=\"\",\"\",LOG(B10))","v":1.8260748027008264},"a=",{"$f":"10^H8","v":3.4646974108257313},"b=",{"$f":"10^F8","v":1.352405188771447},null,33.902941176470591,1149.4094204152252,null,52.435663371942383,-14.564336628057617,212.11990141538072,null,75.738966640139935,8.7389666401399353,76.369537937478668]
[{"$f":"IF(Sheet1!G11=\"\",\"\",Sheet1!G11)","v":10},{"$f":"IF(Sheet1!H11=\"\",\"\",Sheet1!H11)","v":88},{"$f":"IF(Sheet1!G11=\"\",\"\",LOG(A11))","v":1},{"$f":"IF(Sheet1!H11=\"\",\"\",LOG(B11))","v":1.9444826721501687},null,null,null,null,null,30.833823529411774,950.72467344290715,null,70.914263220887776,-17.085736779112224,291.92240128510815,null,92.046246306435819,4.046246306435819,16.372109172345507]
[{"$f":"IF(Sheet1!G12=\"\",\"\",Sheet1!G12)","v":11},{"$f":"IF(Sheet1!H12=\"\",\"\",Sheet1!H12)","v":107},{"$f":"IF(Sheet1!G12=\"\",\"\",LOG(A12))","v":1.0413926851582251},{"$f":"IF(Sheet1!H12=\"\",\"\",LOG(B12))","v":2.0293837776852097},null,null,null,null,null,29.764705882352928,885.93771626297496,null,95.904817537832827,-11.095182462167173,123.10307386878202,null,109.80308129859738,2.8030812985973768,7.857264766546356]
[{"$f":"IF(Sheet1!G13=\"\",\"\",Sheet1!G13)","v":12},{"$f":"IF(Sheet1!H13=\"\",\"\",Sheet1!H13)","v":133},{"$f":"IF(Sheet1!G13=\"\",\"\",LOG(A13))","v":1.0791812460476249},{"$f":"IF(Sheet1!H13=\"\",\"\",LOG(B13))","v":2.1238516409670858},null,null,null,null,null,21.69558823529411,470.69854887543221,null,129.70217286634397,-3.2978271336560283,10.875663803477936,null,128.98896507746761,-4.0110349225323887,16.088401149774405]
[{"$f":"IF(Sheet1!G14=\"\",\"\",Sheet1!G14)","v":13},{"$f":"IF(Sheet1!H14=\"\",\"\",Sheet1!H14)","v":177},{"$f":"IF(Sheet1!G14=\"\",\"\",LOG(A14))","v":1.1139433523068367},{"$f":"IF(Sheet1!H14=\"\",\"\",LOG(B14))","v":2.2479732663618068},null,"Power",null,null,null,-4.3735294117647072,19.127759515570947,null,175.40989157937477,-1.5901084206252278,2.5284447893432564,null,149.58543542522617,-27.414564574773834,751.55835082444446]
[{"$f":"IF(Sheet1!G15=\"\",\"\",Sheet1!G15)","v":14},{"$f":"IF(Sheet1!H15=\"\",\"\",Sheet1!H15)","v":218},{"$f":"IF(Sheet1!G15=\"\",\"\",LOG(A15))","v":1.146128035678238},{"$f":"IF(Sheet1!H15=\"\",\"\",LOG(B15))","v":2.3384564936046046},"A=",{"$f":"SLOPE(D2:D31,C2:C31)","v":1.8507725395079164},"B=",{"$f":"INTERCEPT(D2:D31,C2:C31)","v":0.11323354293948662},null,-27.442647058823553,753.09887759515698,null,237.22524753378335,19.225247533783346,369.61014273524262,null,171.57572319764299,-46.424276802357014,2155.2134766218637]
[{"$f":"IF(Sheet1!G16=\"\",\"\",Sheet1!G16)","v":15},{"$f":"IF(Sheet1!H16=\"\",\"\",Sheet1!H16)","v":245},{"$f":"IF(Sheet1!G16=\"\",\"\",LOG(A16))","v":1.1760912590556813},{"$f":"IF(Sheet1!H16=\"\",\"\",LOG(B16))","v":2.3891660843645326},"In y = a * x^b",null,null,null,null,-36.511764705882371,1333.1089619377176,null,320.82465567227956,75.824655672279562,5749.3784078197568,null,194.94448306707034,-50.055516932929663,2505.5547754228082]
[{"$f":"IF(Sheet1!G17=\"\",\"\",Sheet1!G17)","v":16},{"$f":"IF(Sheet1!H17=\"\",\"\",Sheet1!H17)","v":266},{"$f":"IF(Sheet1!G17=\"\",\"\",LOG(A17))","v":1.2041199826559248},{"$f":"IF(Sheet1!H17=\"\",\"\",LOG(B17))","v":2.424881636631067},"a =",{"$f":"10^H15","v":1.2978770199595582},"b =",{"$f":"F15","v":1.8507725395079164},null,-39.580882352941188,1566.6462478373712,null,433.88492901700363,167.88492901700363,28185.349391044347,null,219.67758275352986,-46.322417246470138,2145.7663395560739]
[{"$f":"IF(Sheet1!G18=\"\",\"\",Sheet1!G18)","v":""},{"$f":"IF(Sheet1!H18=\"\",\"\",Sheet1!H18)","v":""},{"$f":"IF(Sheet1!G18=\"\",\"\",LOG(A18))","v":""},{"$f":"IF(Sheet1!H18=\"\",\"\",LOG(B18))","v":""},null,null,null,null,null,"","",null,"","","",null,"","",""]
[{"$f":"IF(Sheet1!G19=\"\",\"\",Sheet1!G19)","v":""},{"$f":"IF(Sheet1!H19=\"\",\"\",Sheet1!H19)","v":""},{"$f":"IF(Sheet1!G19=\"\",\"\",LOG(A19))","v":""},{"$f":"IF(Sheet1!H19=\"\",\"\",LOG(B19))","v":""},null,null,null,null,null,"","",null,"","","",null,"","",""]
[{"$f":"IF(Sheet1!G20=\"\",\"\",Sheet1!G20)","v":""},{"$f":"IF(Sheet1!H20=\"\",\"\",Sheet1!H20)","v":""},{"$f":"IF(Sheet1!G20=\"\",\"\",LOG(A20))","v":""},{"$f":"IF(Sheet1!H20=\"\",\"\",LOG(B20))","v":""},null,null,null,null,null,"","",null,"","","",null,"","",""]
[{"$f":"IF(Sheet1!G21=\"\",\"\",Sheet1!G21)","v":""},{"$f":"IF(Sheet1!H21=\"\",\"\",Sheet1!H21)","v":""},{"$f":"IF(Sheet1!G21=\"\",\"\",LOG(A21))","v":""},{"$f":"IF(Sheet1!H21=\"\",\"\",LOG(B21))","v":""},null,null,null,null,null,"","",null,"","","",null,"","",""]
[{"$f":"IF(Sheet1!G22=\"\",\"\",Sheet1!G22)","v":""},{"$f":"IF(Sheet1!H22=\"\",\"\",Sheet1!H22)","v":""},{"$f":"IF(Sheet1!G22=\"\",\"\",LOG(A22))","v":""},{"$f":"IF(Sheet1!H22=\"\",\"\",LOG(B22))","v":""},null,null,null,null,null,"","",null,"","","",null,"","",""]
[{"$f":"IF(Sheet1!G23=\"\",\"\",Sheet1!G23)","v":""},{"$f":"IF(Sheet1!H23=\"\",\"\",Sheet1!H23)","v":""},{"$f":"IF(Sheet1!G23=\"\",\"\",LOG(A23))","v":""},{"$f":"IF(Sheet1!H23=\"\",\"\",LOG(B23))","v":""},null,null,null,null,null,"","",null,"","","",null,"","",""]
[{"$f":"IF(Sheet1!G24=\"\",\"\",Sheet1!G24)","v":""},{"$f":"IF(Sheet1!H24=\"\",\"\",Sheet1!H24)","v":""},{"$f":"IF(Sheet1!G24=\"\",\"\",LOG(A24))","v":""},{"$f":"IF(Sheet1!H24=\"\",\"\",LOG(B24))","v":""},null,null,null,null,null,"","",null,"","","",null,"","",""]
[{"$f":"IF(Sheet1!G25=\"\",\"\",Sheet1!G25)","v":""},{"$f":"IF(Sheet1!H25=\"\",\"\",Sheet1!H25)","v":""},{"$f":"IF(Sheet1!G25=\"\",\"\",LOG(A25))","v":""},{"$f":"IF(Sheet1!H25=\"\",\"\",LOG(B25))","v":""},null,null,null,null,null,"","",null,"","","",null,"","",""]
[{"$f":"IF(Sheet1!G26=\"\",\"\",Sheet1!G26)","v":""},{"$f":"IF(Sheet1!H26=\"\",\"\",Sheet1!H26)","v":""},{"$f":"IF(Sheet1!G26=\"\",\"\",LOG(A26))","v":""},{"$f":"IF(Sheet1!H26=\"\",\"\",LOG(B26))","v":""},null,null,null,null,null,"","",null,"","","",null,"","",""]
[{"$f":"IF(Sheet1!G27=\"\",\"\",Sheet1!G27)","v":""},{"$f":"IF(Sheet1!H27=\"\",\"\",Sheet1!H27)","v":""},{"$f":"IF(Sheet1!G27=\"\",\"\",LOG(A27))","v":""},{"$f":"IF(Sheet1!H27=\"\",\"\",LOG(B27))","v":""},null,null,null,null,null,"","",null,"","","",null,"","",""]
[{"$f":"IF(Sheet1!G28=\"\",\"\",Sheet1!G28)","v":""},{"$f":"IF(Sheet1!H28=\"\",\"\",Sheet1!H28)","v":""},{"$f":"IF(Sheet1!G28=\"\",\"\",LOG(A28))","v":""},{"$f":"IF(Sheet1!H28=\"\",\"\",LOG(B28))","v":""},null,null,null,null,null,"","",null,"","","",null,"","",""]
[{"$f":"IF(Sheet1!G29=\"\",\"\",Sheet1!G29)","v":""},{"$f":"IF(Sheet1!H29=\"\",\"\",Sheet1!H29)","v":""},{"$f":"IF(Sheet1!G29=\"\",\"\",LOG(A29))","v":""},{"$f":"IF(Sheet1!H29=\"\",\"\",LOG(B29))","v":""},null,null,null,null,null,"","",null,"","","",null,"","",""]
[{"$f":"IF(Sheet1!G30=\"\",\"\",Sheet1!G30)","v":""},{"$f":"IF(Sheet1!H30=\"\",\"\",Sheet1!H30)","v":""},{"$f":"IF(Sheet1!G30=\"\",\"\",LOG(A30))","v":""},{"$f":"IF(Sheet1!H30=\"\",\"\",LOG(B30))","v":""},null,null,null,null,null,"","",null,"","","",null,"","",""]
[{"$f":"IF(Sheet1!G31=\"\",\"\",Sheet1!G31)","v":""},{"$f":"IF(Sheet1!H31=\"\",\"\",Sheet1!H31)","v":""},{"$f":"IF(Sheet1!G31=\"\",\"\",LOG(A31))","v":""},{"$f":"IF(Sheet1!H31=\"\",\"\",LOG(B31))","v":""},null,null,null,null,null,null,null,null,"",{"$f":"IF(A31=\"\",\"\",(M31-C31))","v":""},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,"Sum =",{"$f":"SUM(K2:K31)","v":12245.313235294121},null,null,"Sum =",{"$f":"SUM(O2:O31)","v":35330.94553089104},null,null,"Sum =",{"$f":"SUM(S2:S31)","v":7906.2078919726855}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Correlation coefficient"]
[null,null,null,null,null,null,null,null,null,null,"r =",0.98862925791167833]

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