{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Regression","Sheet2"],"not_rendered":{"charts":1,"images":1,"macros":0,"external_links":0,"defined_names":14,"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":"Regression","index":0,"n_rows":52,"n_cols":14,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
[null,"         Power Regression: ",null,null,null,null,null,null,null,null,"Enter the data values in the cells below:"]
["         The Best Power Function Fit",null,null,null,null,null,null,null,null,null,null,"x","y"]
[null,null,null,null,null,null,null,null,null,null,1,1,1,{"$f":"IF(OR(L3<=0,M3<=0),\"All x- and y-values MUST be positive\",\"\")","v":""}]
[null,"        This DIGMath module lets you find",null,null,null,null,null,null,null,null,2,2,2,{"$f":"IF(OR(L4<=0,M4<=0),\"All x- and y-values MUST be positive\",\"\")","v":""}]
[null,"              the best power function fit",null,null,null,null,null,null,null,null,3,3,6,{"$f":"IF(OR(AND(L5<=0,L5<>\"\"),(AND(M5<=0,M5<>\"\"))),\"All x- and y-values MUST be positive\",\"\")","v":""}]
[null,null,"     to fit a set of (x,  y) data",null,null,null,null,null,null,null,4,4,22,{"$f":"IF(OR(AND(L6<=0,L6<>\"\"),(AND(M6<=0,M6<>\"\"))),\"All x- and y-values MUST be positive\",\"\")","v":""}]
[null,null,"using the least-squares approach.",null,null,null,null,null,null,null,5,5,17,""]
[null,null,null,null,null,null,null,null,null,null,6,74,25,""]
["How many data points, n, between 2 and 50?",null,null,null,null,null,null,null,null,null,7,91,29,""]
[null,"  n =",{"$f":"E10","v":3},null,3,null,null,null,null,null,8,105,31,""]
[null,null,null,null,null,null,null,null,null,null,9,121,27,""]
["Based on your data, the equation",null,null,null,null,null,null,null,null,null,10,135,37,""]
["      of the power regression function is",null,null,null,null,null,null,null,null,null,11,152,41,""]
[null,null,null,null,null,null,null,null,null,null,12,196,48,""]
[null,"  y =",{"$f":"bb","v":0.90014585621552912},"x",{"$f":"aa","v":1.5629899530962328},null,null,null,null,null,13,213,55,""]
[null,null,null,null,null,null,null,null,null,null,14,227,51,""]
[" The associated correlation coefficient r =",null,null,null,null,null,null,{"$f":"CORREL(Sheet2!D2:D51,Sheet2!E2:E51)","v":0.96106550022113979},null,null,15,244,63,""]
[null,null,null,null,null,null,null,null,null,null,16,258,69,""]
["       and the Sum of the Squares =",null,null,null,null,null,{"$f":"sss","v":1.4203584633423845},null,null,null,17,274,75,""]
[null,null,null,null,null,null,null,null,null,null,18,288,80,""]
[null,null,null,null,null,null,null,null,null,null,19,305,88,""]
[null,null,null,null,null,null,null,null,null,null,20,319,93,""]
[null,null,null,null,null,null,null,null,null,null,21,335,97,""]
[null,null,null,null,null,null,null,null,null,null,22,349,103,""]
[null,null,null,null,null,null,null,null,null,null,23,null,null,""]
[null,null,null,null,null,null,null,null,null,null,24,null,null,""]
[null,null,null,null,null,null,null,null,null,null,25,null,null,""]
[null,null,null,null,null,null,null,null,null,null,26,null,null,""]
[null,null,null,null,null,null,null,null,null,null,27,null,null,""]
[null,null,null,null,null,null,null,null,null,null,28,null,null,""]
[null,null,null,null,null,null,null,null,null,null,29,null,null,""]
[null,null,null,null,null,null,null,null,null,null,30,null,null,""]
[null,null,null,null,null,null,null,null,null,null,31,null,null,""]
[null,null,null,null,null,null,null,null,null,null,32,null,null,""]
[null,null,null,null,null,null,null,null,null,null,33,null,null,""]
[null,null,null,null,null,null,null,null,null,null,34,null,null,""]
[null,null,null,null,null,null,null,null,null,null,35,null,null,""]
[null,null,null,null,null,null,null,null,null,null,36,null,null,""]
[null,null,null,null,null,null,null,null,null,null,37,null,null,""]
["Click each item below for suggestions and investigations",null,null,null,null,null,null,null,null,null,38,null,null,""]
[null,null,"   Item 1",null,null,null,null,null,null,null,39,null,null,""]
[null,null,"   Item 2",null,null,null,null,null,null,null,40,null,null,""]
[null,null,"   Item 3",null,null,null,null,null,null,null,41,null,null,""]
[null,null,null,null,null,null,null,null,null,null,42,null,null,""]
[null,null,null,null,null,null,null,null,null,null,43,null,null,""]
[null,null,null,null,null,null,null,null,null,null,44,null,null,""]
[null,"Created by:  Sheldon P. Gordon",null,null,null,null,null,null,null,null,45,null,null,""]
[null,"                     Farmingdale StateCollege",null,null,null,null,null,null,null,null,46,null,null,""]
[null,"Development of this module was supported by the ",null,null,null,null,null,null,null,null,47,null,null,""]
[null,"NSF's Division of Undergraduate Education  ",null,null,null,null,null,null,null,null,48,null,null,""]
[null,"under grants DUE-0310123 and DUE-0442160.",null,null,null,null,null,null,null,null,49,null,null,""]
[null,null,null,null,null,null,null,null,null,null,50,null,null,""]

{"sheet":"Sheet2","index":1,"n_rows":54,"n_cols":14,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
["n","x","y","log x","log y","predicted","diff","squares","      plotting points"]
[1,{"$f":"IF(A2<=nn,Regression!L3,\"\")","v":1},{"$f":"IF($A2<=nn,Regression!M3,\"\")","v":1},{"$f":"LOG(B2)","v":0},{"$f":"LOG(C2)","v":0},{"$f":"bb*B2^aa","v":0.90014585621552912},{"$f":"F2-C2","v":-9.9854143784470883E-2},{"$f":"G2^2","v":9.9708500309297846E-3},{"$f":"B2","v":1},{"$f":"C2","v":1}]
[2,{"$f":"IF(A3<=nn,Regression!L4,\"\")","v":2},{"$f":"IF($A3<=nn,Regression!M4,\"\")","v":2},{"$f":"LOG(B3)","v":0.3010299956639812},{"$f":"LOG(C3)","v":0.3010299956639812},2.6596209507070006,{"$f":"F3-C3","v":0.65962095070700055},{"$f":"G3^2","v":0.43509979861160725},{"$f":"B3","v":2},{"$f":"C3","v":2},null,"Linear"]
[3,{"$f":"IF(A4<=nn,Regression!L5,\"\")","v":3},{"$f":"IF($A4<=nn,Regression!M5,\"\")","v":6},{"$f":"IF(AND(A4<=nn,B4>0), LOG(B4),\"\")","v":0.47712125471966244},{"$f":"IF(AND(A4<=nn,C4>0), LOG(C4),\"\")","v":0.77815125038364363},5.0124333872088185,{"$f":"F4-C4","v":-0.98756661279118152},{"$f":"IF(A4<=nn,G4^2,\"\")","v":0.97528781469984749},{"$f":"IF($A4<=nn,B4,x0)","v":3},{"$f":"IF($A4<=nn,C4,y0)","v":6},"a =",{"$f":"SLOPE(E2:E51,D2:D51)","v":1.5629899530962328},"b  =",{"$f":"INTERCEPT(E2:E51,D2:D51)","v":-4.5687113430427084E-2}]
[4,{"$f":"IF(A5<=nn,Regression!L6,\"\")","v":""},{"$f":"IF($A5<=nn,Regression!M6,\"\")","v":""},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",1,1]
[5,{"$f":"IF(A6<=nn,Regression!L7,\"\")","v":""},{"$f":"IF($A6<=nn,Regression!M7,\"\")","v":""},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",1,1,null,"Power"]
[6,{"$f":"IF(A7<=nn,Regression!L8,\"\")","v":""},{"$f":"IF($A7<=nn,Regression!M8,\"\")","v":""},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",1,1,"power",{"$f":"a","v":1.5629899530962328},"coef =",{"$f":"10^b","v":0.90014585621552912}]
[7,{"$f":"IF(A8<=nn,Regression!L9,\"\")","v":""},{"$f":"IF($A8<=nn,Regression!M9,\"\")","v":""},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",1,1]
[8,{"$f":"IF(A9<=nn,Regression!L10,\"\")","v":""},{"$f":"IF($A9<=nn,Regression!M10,\"\")","v":""},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",1,1]
[9,{"$f":"IF(A10<=nn,Regression!L11,\"\")","v":""},{"$f":"IF($A10<=nn,Regression!M11,\"\")","v":""},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",1,1,"xMin =",{"$f":"MIN(B2:B51)","v":1},"xMax =",{"$f":"MAX(B2:B51)","v":3}]
[10,{"$f":"IF(A11<=nn,Regression!L12,\"\")","v":""},{"$f":"IF($A11<=nn,Regression!M12,\"\")","v":""},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",1,1]
[11,{"$f":"IF(A12<=nn,Regression!L13,\"\")","v":""},{"$f":"IF($A12<=nn,Regression!M13,\"\")","v":""},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",1,1,null,{"$f":"L10","v":1},{"$f":"bb*L12^aa","v":0.90014585621552912}]
[12,{"$f":"IF(A13<=nn,Regression!L14,\"\")","v":""},{"$f":"IF($A13<=nn,Regression!M14,\"\")","v":""},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",1,1,null,{"$f":"N10","v":3},{"$f":"bb*L13^aa","v":5.0124333872088185}]
[13,{"$f":"IF(A14<=nn,Regression!L15,\"\")","v":""},{"$f":"IF($A14<=nn,Regression!M15,\"\")","v":""},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",1,1]
[14,{"$f":"IF(A15<=nn,Regression!L16,\"\")","v":""},{"$f":"IF($A15<=nn,Regression!M16,\"\")","v":""},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",1,1]
[15,{"$f":"IF(A16<=nn,Regression!L17,\"\")","v":""},{"$f":"IF($A16<=nn,Regression!M17,\"\")","v":""},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",1,1]
[16,{"$f":"IF(A17<=nn,Regression!L18,\"\")","v":""},{"$f":"IF($A17<=nn,Regression!M18,\"\")","v":""},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",1,1]
[17,{"$f":"IF(A18<=nn,Regression!L19,\"\")","v":""},{"$f":"IF($A18<=nn,Regression!M19,\"\")","v":""},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",1,1]
[18,{"$f":"IF(A19<=nn,Regression!L20,\"\")","v":""},{"$f":"IF($A19<=nn,Regression!M20,\"\")","v":""},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",1,1]
[19,{"$f":"IF(A20<=nn,Regression!L21,\"\")","v":""},{"$f":"IF($A20<=nn,Regression!M21,\"\")","v":""},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",1,1]
[20,{"$f":"IF(A21<=nn,Regression!L22,\"\")","v":""},{"$f":"IF($A21<=nn,Regression!M22,\"\")","v":""},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",1,1]
[21,{"$f":"IF(A22<=nn,Regression!L23,\"\")","v":""},{"$f":"IF($A22<=nn,Regression!M23,\"\")","v":""},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",1,1]
[22,{"$f":"IF(A23<=nn,Regression!L24,\"\")","v":""},{"$f":"IF($A23<=nn,Regression!M24,\"\")","v":""},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",1,1]
[23,{"$f":"IF(A24<=nn,Regression!L25,\"\")","v":""},{"$f":"IF($A24<=nn,Regression!M25,\"\")","v":""},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",1,1]
[24,{"$f":"IF(A25<=nn,Regression!L26,\"\")","v":""},{"$f":"IF($A25<=nn,Regression!M26,\"\")","v":""},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",1,1]
[25,{"$f":"IF(A26<=nn,Regression!L27,\"\")","v":""},{"$f":"IF($A26<=nn,Regression!M27,\"\")","v":""},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",1,1]
[26,{"$f":"IF(A27<=nn,Regression!L28,\"\")","v":""},{"$f":"IF($A27<=nn,Regression!M28,\"\")","v":""},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",1,1]
[27,{"$f":"IF(A28<=nn,Regression!L29,\"\")","v":""},{"$f":"IF($A28<=nn,Regression!M29,\"\")","v":""},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",1,1]
[28,{"$f":"IF(A29<=nn,Regression!L30,\"\")","v":""},{"$f":"IF($A29<=nn,Regression!M30,\"\")","v":""},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",1,1]
[29,{"$f":"IF(A30<=nn,Regression!L31,\"\")","v":""},{"$f":"IF($A30<=nn,Regression!M31,\"\")","v":""},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",1,1]
[30,{"$f":"IF(A31<=nn,Regression!L32,\"\")","v":""},{"$f":"IF($A31<=nn,Regression!M32,\"\")","v":""},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",1,1]
[31,{"$f":"IF(A32<=nn,Regression!L33,\"\")","v":""},{"$f":"IF($A32<=nn,Regression!M33,\"\")","v":""},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",1,1]
[32,{"$f":"IF(A33<=nn,Regression!L34,\"\")","v":""},{"$f":"IF($A33<=nn,Regression!M34,\"\")","v":""},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",1,1]
[33,{"$f":"IF(A34<=nn,Regression!L35,\"\")","v":""},{"$f":"IF($A34<=nn,Regression!M35,\"\")","v":""},"","",{"$f":"bb*B34^aa","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},"",1,1]
[34,{"$f":"IF(A35<=nn,Regression!L36,\"\")","v":""},{"$f":"IF($A35<=nn,Regression!M36,\"\")","v":""},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",1,1]
[35,{"$f":"IF(A36<=nn,Regression!L37,\"\")","v":""},{"$f":"IF($A36<=nn,Regression!M37,\"\")","v":""},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",1,1]
[36,{"$f":"IF(A37<=nn,Regression!L38,\"\")","v":""},{"$f":"IF($A37<=nn,Regression!M38,\"\")","v":""},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",1,1]
[37,{"$f":"IF(A38<=nn,Regression!L39,\"\")","v":""},{"$f":"IF($A38<=nn,Regression!M39,\"\")","v":""},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",1,1]
[38,{"$f":"IF(A39<=nn,Regression!L40,\"\")","v":""},{"$f":"IF($A39<=nn,Regression!M40,\"\")","v":""},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",1,1]
[39,{"$f":"IF(A40<=nn,Regression!L41,\"\")","v":""},{"$f":"IF($A40<=nn,Regression!M41,\"\")","v":""},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",1,1]
[40,{"$f":"IF(A41<=nn,Regression!L42,\"\")","v":""},{"$f":"IF($A41<=nn,Regression!M42,\"\")","v":""},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",1,1]
[41,{"$f":"IF(A42<=nn,Regression!L43,\"\")","v":""},{"$f":"IF($A42<=nn,Regression!M43,\"\")","v":""},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",1,1]
[42,{"$f":"IF(A43<=nn,Regression!L44,\"\")","v":""},{"$f":"IF($A43<=nn,Regression!M44,\"\")","v":""},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",1,1]
[43,{"$f":"IF(A44<=nn,Regression!L45,\"\")","v":""},{"$f":"IF($A44<=nn,Regression!M45,\"\")","v":""},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",1,1]
[44,{"$f":"IF(A45<=nn,Regression!L46,\"\")","v":""},{"$f":"IF($A45<=nn,Regression!M46,\"\")","v":""},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",1,1]
[45,{"$f":"IF(A46<=nn,Regression!L47,\"\")","v":""},{"$f":"IF($A46<=nn,Regression!M47,\"\")","v":""},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",1,1]
[46,{"$f":"IF(A47<=nn,Regression!L48,\"\")","v":""},{"$f":"IF($A47<=nn,Regression!M48,\"\")","v":""},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",1,1]
[47,{"$f":"IF(A48<=nn,Regression!L49,\"\")","v":""},{"$f":"IF($A48<=nn,Regression!M49,\"\")","v":""},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",1,1]
[48,{"$f":"IF(A49<=nn,Regression!L50,\"\")","v":""},{"$f":"IF($A49<=nn,Regression!M50,\"\")","v":""},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",1,1]
[49,{"$f":"IF(A50<=nn,Regression!L51,\"\")","v":""},{"$f":"IF($A50<=nn,Regression!M51,\"\")","v":""},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",1,1]
[50,{"$f":"IF(A51<=nn,Regression!L52,\"\")","v":""},{"$f":"IF($A51<=nn,Regression!M52,\"\")","v":""},"","",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",1,1]
[]
[null,null,null,null,null,null,null,{"$f":"SUM(H2:H51)","v":1.4203584633423845}]
[null,null,null,null,null,null,null,"sum squares"]