{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Interpolation Practice","Interpolation","Regression","Finite Differences","Finite Differences (x = 1)","Sheet3"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Interpolation Practice","index":0,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["Interpolation Data"]
["x","y"]
[805,0.71]
[825,0.76300000000000001]
[845,0.90700000000000003]
[865,1.3360000000000001]
[885,2.169]
[905,1.5980000000000001]
[925,0.91600000000000004]
[945,0.67200000000000004]
[965,0.61499999999999999]
[985,0.60599999999999998]

{"sheet":"Interpolation","index":1,"n_rows":15,"n_cols":10,"rows_kept":15,"cut":false,"hidden":false,"merged":[[5,3,6,3],[3,5,3,8],[3,3,4,4],[9,4,9,7],[0,0,0,1]]}
["Interpolation Data"]
["x","y"]
[805,0.71]
[825,0.76300000000000001,null,"Interpolation poly-nomial Results",null,"Polynomials Used"]
[845,0.90700000000000003,null,null,null,"Linear","Quadratic","Quadratic2","Cubic"]
[865,1.3360000000000001,null,"Interpolation\nx Values",853,{"$f":"newton($A$5:$A$6,$B$5:$B$6,$E6)","v":1.0786},{"$f":"newton($A$4:$A$6,$B$4:$B$6,$E6)","v":1.0444},{"$f":"newton($A$5:$A$7,$B$5:$B$7,$E6)","v":1.0301199999999999},{"$f":"newton($A$3:$A$7,$B$3:$B$7,$E6)","v":1.0360560000000001}]
[885,2.169,null,null,962,{"$f":"newton($A$10:$A$11,$B$10:$B$11,$E7)","v":0.62355000000000005},{"$f":"newton($A$10:$A$12,$B$10:$B$12,$E7)","v":0.6204900000000001},{"$f":"newton($A$9:$A$11,$B$9:$B$11,$E7)","v":0.61162875000000005},{"$f":"newton($A$9:$A$12,$B$9:$B$12,$E7)","v":0.61709318750000008}]
[905,1.5980000000000001]
[925,0.91600000000000004]
[945,0.67200000000000004,null,"Point","Possible choices for quadratic polynomial",null,null,null,"|x - xstart|","|x - xend|"]
[965,0.61499999999999999,null,853,825,845,865,885,{"$f":"ABS($D11-E11)","v":28},{"$f":"ABS($D11-H11)","v":32}]
[985,0.60599999999999998,null,962,925,945,965,985,{"$f":"ABS($D12-E12)","v":37},{"$f":"ABS($D12-H12)","v":23}]
[null,null,null,null,"Actual choices in bold based on minimum of (|x - xstart|, |x - xend|)"]
[null,null,null,null,"Quadratic column in table above uses these bold choices."]
[null,null,null,null,"Quadratic2 column in table above uses alternative set of three data points."]

{"sheet":"Regression","index":2,"n_rows":170,"n_cols":14,"rows_kept":170,"cut":false,"hidden":false,"merged":[[2,10,2,12],[1,9,1,13],[9,8,9,13],[14,10,14,13]]}
["y","x1","x2","x3","yHat","y - yHat","y-yMean"]
[2.5499999999999998,3,440,500,{"$f":"$N$4+$M$4*B2+$L$4*C2+$K$4*D2","v":2.2078119049568872},{"$f":"A2-E2","v":0.34218809504311265},{"$f":"A2-$L$11","v":0.37449704142011875},null,null,"LINEST Function Results"]
[2.5499999999999998,3,440,500,{"$f":"$N$4+$M$4*B3+$L$4*C3+$K$4*D3","v":2.2078119049568872},{"$f":"A3-E3","v":0.34218809504311265},0.37449704142011875,null,null,null,"Slopes",null,null,"Intercept"]
[1.95,3.47,350,400,2.2432841153889589,-0.29328411538895893,-0.22550295857988112,null,null,null,{"$f":"LINEST(A2:A170,B2:D170,,TRUE)","v":6.5434188506157493E-4},9.03317606108678E-5,0.2319920370068245,1.1449188767368441]
[1.89,3.14,440,540,2.2664644655403055,-0.37646446554030555,-0.28550295857988117,null,null,"Standard Errors",8.2600083985879277E-4,7.7123058945362569E-4,0.11703834846971546,0.41973342230647093]
[2.2400000000000002,3.46,350,370,2.2213339384670436,1.8666061532956579E-2,6.4497041420119139E-2,null,null,"R2 and sy|x values",4.0550432096997352E-2,0.83532057754027766,{"$error":"#N/A"},{"$error":"#N/A"}]
[2.31,3.59,450,480,2.3325036866957904,-2.2503686695790392E-2,0.13449704142011898,null,null,"F statistic and degrees of freedom",2.324534649809054,165,{"$error":"#N/A"},{"$error":"#N/A"}]
[1.74,1.75,200,320,1.7783606968406644,-3.8360696840664454E-2,-0.43550295857988108,null,null,"Sums of squares",4.8659051502539796,115.13047709826678,{"$error":"#N/A"},{"$error":"#N/A"}]
[1.87,3.03,310,470,2.1833982806358314,-0.31339828063583131,-0.30550295857988097]
[0.83,3.18,290,400,2.1705865190203277,-1.3405865190203277,-1.345502958579881,null,"Other Calculated Results"]
[1.25,2.77,470,530,2.1767939458154908,-0.92679394581549079,-0.92550295857988107,null,null,null,"Mean value of y, yMean",{"$f":"AVERAGE(A2:A170)","v":2.1755029585798811}]
[2,1.87,230,320,1.8089096940998095,0.19109030590019049,-0.17550295857988107,null,null,null,"Calculated R2",{"$f":"1-SUMPRODUCT(F2:F170,F2:F170)/SUMPRODUCT(G2:G170,G2:G170)","v":4.0550432096998046E-2}]
[2.62,3.25,420,560,2.3032637921000703,0.31673620789992984,0.44449704142011903,null,null,null,"Confidence Level",0.95]
[2.6,3.5,310,490,2.3055213757302706,0.29447862426972948,0.42449704142011901,null,null,null,"Two-sided t-test value",{"$f":"TINV(1-L13,L7)","v":1.9744456300923821}]
[2.2599999999999998,2.7,520,610,2.2174184420604823,4.2581557939517456E-2,8.4497041420118713E-2,null,null,null,"Uncertainty range for fitted values"]
[1.78,3.18,410,310,2.1225355606380902,-0.34253556063809021,-0.39550295857988105,null,null,null,"x3 Slope","x2 Slope","x1 Slope","Intercept"]
[2.4,3.55,470,540,2.364291153531429,3.5708846468570865E-2,0.22449704142011884,null,null,null,{"$f":"$L$14*K4","v":1.2919624755462383E-3},{"$f":"$L$14*L4","v":1.7835514999667908E-4},{"$f":"$L$14*M4","v":0.4580556636843548},{"$f":"$L$14*N4","v":2.2605800729833403}]
[2.87,3.88,640,630,2.5150956947030707,0.3549043052969294,0.69449704142011903]
[2.02,4,410,440,2.3978334760416908,-0.37783347604169082,-0.15550295857988106]
[1.28,3.3,440,620,2.3559305422663233,-1.0759305422663232,-0.89550295857988105]
[2.21,3.12,200,610,2.2859489342078709,-7.5948934207870966E-2,3.449704142011889E-2]
[2.14,3.35,210,390,2.1962552056120028,-5.6255205612002701E-2,-3.550295857988095E-2]
[3.07,2.4,280,440,2.014903087951359,1.0550969120486409,0.89449704142011877]
[2.89,3.65,310,510,2.3534070189825256,0.53659298101747455,0.71449704142011905]
[2.2999999999999998,3.3,420,460,2.2494292054442537,5.057079455574609E-2,0.12449704142011875]
[2.6,2.52,200,320,1.9569945653359193,0.64300543466408078,0.42449704142011901]
[2.7,3.21,390,390,2.1800360373410035,0.51996396265899669,0.5244970414201191]
[1.07,1.87,420,360,1.8522464040183375,-0.78224640401833745,-1.105502958579881]
[3,4,430,500,2.4389006243576024,0.56109937564239765,0.82449704142011893]
[0,3.59,270,420,2.2769834566821396,-2.2769834566821396,-2.1755029585798811]
[2.19,3.4,290,370,2.2019945106099819,-1.1994510609981912E-2,1.4497041420118872E-2]
[2.27,3,280,500,2.1933588232591483,7.6641176740851691E-2,9.4497041420118943E-2]
[1.82,3.08,360,560,2.2584052401722579,-0.43840524017225779,-0.35550295857988101]
[2.09,2.27,270,310,1.8987763604763583,0.19122363952364152,{"$f":"A34-$L$11","v":-8.5502958579881216E-2}]
[1.06,3.16,450,580,2.2981812992890132,-1.2381812992890131,-1.115502958579881]
[1.34,3.5,380,510,2.3249314366742628,-0.98493143667426275,-0.83550295857988099]
[2.41,3.12,470,660,2.3430556038258841,6.6944396174116072E-2,0.23449704142011907]
[3.1,3.57,330,470,2.3104806158317341,0.78951938416826595,0.92449704142011901]
[2.7,0,380,360,1.414808024391141,1.2851919756088592,0.5244970414201191]
[1.4,3.09,260,460,2.1862577959750817,-0.78625779597508183,-0.77550295857988116]
[0.14000000000000001,2.48,360,540,2.1061231802669318,-1.9661231802669317,-2.0355029585798809]
[1.27,2.27,250,310,1.8969697252641409,-0.62696972526414085,-0.90550295857988106]
[2.11,2.93,290,420,2.1256753474698531,-1.5675347469853218E-2,-6.5502958579881199E-2]
[3.57,2.2999999999999998,360,430,1.9923870062489299,1.5776129937510699,1.3944970414201188]
[2.5,2.93,360,520,2.1974327592187715,0.30256724078122854,0.32449704142011893]
[3.24,3.27,320,550,2.2923270379285041,0.94767296207149609,1.0644970414201191]
[3.37,2.71,400,560,2.1761814569041675,1.1938185430958326,1.194497041420119]
[1.81,3.15,380,530,2.2568210614231061,-0.44682106142310607,-0.36550295857988102]
[2.2400000000000002,2.85,380,410,2.1087024241136696,0.13129757588633062,6.4497041420119139E-2]
[2.38,3,390,520,2.216382154627575,0.16361784537242485,0.20449704142011882]
[2.4300000000000002,0,460,520,1.5267292668498624,0.90327073315013773,0.25449704142011909]
[2.57,3.68,320,590,2.4136174485037651,0.1563825514962347,0.39449704142011877]
[1.35,1.72,360,420,1.8512882059343561,-0.50128820593435597,-0.82550295857988099]
[2.41,3.07,250,600,2.2723225015374569,0.13767749846254329,0.23449704142011907]
[2.4300000000000002,3.45,390,510,2.3142351524300304,0.11576484756996974,0.25449704142011909]
[2.0499999999999998,3.25,200,430,2.1983263597076745,-0.14832635970767472,-0.12550295857988125]
[2.33,3,350,600,2.2651162350080662,6.4883764991933823E-2,0.154497041420119]
[3,2.64,300,410,2.052757555493367,0.94724244450663297,0.82449704142011893]
[0.14000000000000001,2.62,380,560,2.1534955383613363,-2.0134955383613362,-2.0355029585798809]
[2.2400000000000002,3.71,290,440,2.3197159740364079,-7.9715974036407733E-2,6.4497041420119139E-2]
[0.88,1.84,420,390,1.8649168994599798,-0.98491689945997984,-1.2955029585798812]
[2.0499999999999998,3.34,270,370,2.186268353177355,-0.13626835317735519,-0.12550295857988125]
[3.08,2.52,300,420,2.0314619299031635,1.0485380700968365,0.904497041420119]
[2.78,3.62,450,580,2.4048976363121528,0.375102363687847,0.60449704142011873]
[2,2.96,450,500,2.1994355410827224,-0.19943554108272243,-0.17550295857988107]
[3.53,4,520,530,2.4666607393644284,1.0633392606355714,{"$f":"A66-$L$11","v":1.3544970414201187}]
[0.43,3.17,230,430,{"$f":"$N$4+$M$4*B67+$L$4*C67+$K$4*D67","v":2.1824769495654546},{"$f":"A67-E67","v":-1.7524769495654546},-1.7455029585798811]
[1.67,2.96,220,350,2.0805079533829867,-0.41050795338298673,-0.50550295857988115]
[3.74,2.8,390,500,2.1568969095249786,1.5831030904750216,1.5644970414201191]
[2.63,2.94,500,450,2.1665951941200507,0.46340480587994914,0.45449704142011882]
[3.08,3.17,300,520,2.2476909424637572,0.83230905753624285,0.904497041420119]
[1.35,3.5,380,520,2.3314748555248785,-0.98147485552487845,-0.82550295857988099]
[2,3.12,320,480,2.2117243004231701,-0.21172430042317014,-0.17550295857988107]
[2.83,2.98,360,530,2.2155757799197282,0.61442422008027187,0.654497041420119]
[2.57,3.1,220,360,2.1195302574145582,0.45046974258544159,0.39449704142011877]
[1.38,2.4300000000000002,610,600,2.1563670316730019,-0.77636703167300203,-0.79550295857988118]
[3.5,2.48,450,500,2.088079363319447,1.411920636680553,1.3244970414201189]
[1,2.4,390,520,2.0771869324234804,-1.0771869324234804,-1.1755029585798811]
[1.2,2.38,200,340,1.9376025178561955,-0.73760251785619557,-0.97550295857988112]
[1.72,3.14,550,530,2.2698575403568855,-0.5498575403568855,-0.4555029585798811]
[1.9,2.52,350,470,2.0686956121867857,-0.16869561218678575,-0.27550295857988116]
[2.09,3.38,380,460,2.2643752979803651,-0.17437529798036522,-8.5502958579881216E-2]
[2.71,2.85,430,560,2.2113702949034493,0.49862970509655069,0.53449704142011889]
[3.03,3.64,370,560,2.3892240985021886,0.64077590149781116,0.85449704142011873]
[1.1100000000000001,2.96,200,330,2.065614480469538,-0.9556144804695379,-1.065502958579881]
[0.5,2.5499999999999998,390,370,2.0138344552152678,-1.5138344552152678,-1.6755029585798811]
[3.55,3.63,660,610,2.4458174829623505,1.1041825170376494,1.3744970414201187]
[3.77,3.4,320,470,2.2701386519344653,1.4998613480655347,1.5944970414201189]
[2.04,3,420,430,2.1602013377903595,-0.12020133779035946,-0.13550295857988104]
[3.76,3.62,370,400,2.2798895561521997,1.4801104438478001,1.5844970414201187]
[2.87,3.38,200,360,2.1826813925642514,0.68731860743574869,0.69449704142011903]
[1.1499999999999999,2.92,300,350,2.0784548127515832,-0.92845481275158326,-1.0255029585798812]
[0.77,3.25,370,420,2.2071393401609063,-1.4371393401609063,-1.4055029585798811]
[3.01,3.55,530,430,2.2977334518113084,0.7122665481886914,0.83449704142011871]
[2.35,3.81,390,550,2.4239259611549504,-7.3925961154950315E-2,0.17449704142011901]
[2.38,3.29,220,580,2.3075639591594013,7.2436040840598626E-2,0.20449704142011882]
[2.72,2.92,330,430,2.1335121163748352,0.58648788362516502,0.54449704142011912]
[1.83,2.72,390,590,2.1972283162199746,-0.36722831621997454,{"$f":"A98-$L$11","v":-0.345502958579881}]
[1.82,3.13,310,440,2.1869672277846668,-0.36696722778466673,-0.35550295857988101]
[1.86,3.14,200,390,2.1466335602344611,-0.28663356023446096,-0.31550295857988098]
[3.22,2.84,210,420,2.0975695232903693,1.1224304767096309,1.0444970414201191]
[3.57,3.8,510,680,2.5175102971161909,1.0524897028838089,1.3944970414201188]
[2,2.42,310,240,1.8913845044975064,0.10861549550249361,-0.17550295857988107]
[2.65,2.7,410,340,2.0308096394266615,0.61919036057333843,0.47449704142011884]
[2.8,3.23,360,410,2.1950527629640453,0.60494723703595454,0.62449704142011875]
[2.56,3.53,410,570,2.3738616637064882,0.18613833629351184,0.38449704142011898]
[1.48,3,330,590,2.2567661809452333,-0.77676618094523331,-0.69550295857988109]
[2.04,3.17,430,570,2.2921511655962488,-0.25215116559624873,-0.13550295857988104]
[2.4,3.09,450,410,2.1707037362380679,0.22929626376193202,0.22449704142011884]
[1.73,3.23,340,520,2.2652237351086013,-0.53522373510860133,-0.44550295857988109]
[2.42,3.31,370,550,2.3061233074393206,0.11387669256067934,0.24449704142011885]
[2.14,2.5499999999999998,310,460,2.0654986840219403,7.4501315978059868E-2,-3.550295857988095E-2]
[2.65,2.81,350,330,2.0443654390101442,0.60563456098985569,0.47449704142011884]
[3.2,2.8,250,370,2.0591860179814523,1.1408139820185479,1.0244970414201191]
[2,2.8,310,370,2.0646059236181045,-6.4605923618104466E-2,-0.17550295857988107]
[1.64,1.74,260,300,1.7683738444060171,-0.12837384440601718,-0.53550295857988117]
[1.1399999999999999,2.1,600,590,2.0723629230040252,-0.93236292300402535,-1.0355029585798812]
[2.42,2.91,270,740,2.3286182747372033,9.1381725262796643E-2,0.24449704142011885]
[2.13,2.36,540,410,2.0094794076780644,0.12052059232193546,-4.5502958579881181E-2]
[0.85,2.0499999999999998,340,360,1.8867784298306964,-1.0367784298306963,-1.325502958579881]
[2.13,2.67,410,390,2.0565669725695352,7.3433027430464648E-2,-4.5502958579881181E-2]
[2.87,2.65,330,470,2.0970479417854557,0.77295205821454438,0.69449704142011903]
[2.23,2.75,360,410,2.0836965852007694,0.14630341479923059,5.4497041420118908E-2]
[1.77,2.65,260,440,2.0710944619908478,-0.30109446199084777,-0.40550295857988106]
[0.85,3.04,380,460,2.1854980053980451,-1.335498005398045,-1.325502958579881]
[3.03,3,420,570,2.2518092016989799,0.77819079830101989,0.85449704142011873]
[1.74,2.12,220,330,1.8725478045960227,-0.13254780459602267,-0.43550295857988108]
[2.64,2.6,380,390,2.0376175771607317,0.60238242283926846,0.46449704142011905]
[2.89,3.39,430,630,2.3824499268414447,0.50755007315855538,0.71449704142011905]
[2,2.19,370,470,1.993944875186751,6.055124813248991E-3,{"$f":"A130-$L$11","v":-0.17550295857988107}]
[0.7,2.79,580,590,{"$f":"$N$4+$M$4*B131+$L$4*C131+$K$4*D131","v":2.230630793326517},{"$f":"A131-E131","v":-1.5306307933265171},-1.4755029585798811]
[3.88,3.22,360,500,2.251623612249519,1.6283763877504809,1.7044970414201188]
[2.23,3.25,430,390,2.1929289892457113,3.7071010754288647E-2,5.4497041420118908E-2]
[3.37,2.36,390,410,1.995929643586434,1.3740703564135661,1.194497041420119]
[2.73,2.93,350,570,2.2292465358657414,0.50075346413425859,0.55449704142011891]
[1.68,2.34,330,360,1.9531528029565668,-0.27315280295656685,-0.49550295857988114]
[3.05,3.05,520,630,2.3117024927141023,0.73829750728589749,0.87449704142011875]
[1.23,2.77,370,550,2.1808476074556351,-0.95084760745563512,-0.94550295857988109]
[3,3.5,310,520,2.3251516322821177,0.67484836771788226,0.82449704142011893]
[2.59,2.88,430,610,2.2510471502667326,0.33895284973326723,0.41449704142011878]
[1.9,2.74,300,510,2.1413909477002067,-0.24139094770020675,-0.27550295857988116]
[3.2,3.8,240,410,2.3164484127846316,0.88355158721536853,1.0244970414201191]
[1,3.44,480,470,2.2938714151124771,-1.2938714151124771,-1.1755029585798811]
[2,3.21,270,480,2.228086995723241,-0.22808699572324098,-0.17550295857988107]
[0.93,2.57,370,420,2.0493847549962654,-1.1193847549962652,-1.2455029585798809]
[2.41,3.3,240,440,2.2200826508330662,0.18991734916693392,0.23449704142011907]
[0.9,3.1,340,510,2.2285213514470983,-1.3285213514470984,-1.2755029585798812]
[2.1,2.16,360,400,1.9402778645161276,0.15972213548387248,-7.5502958579880985E-2]
[3.7,2.4500000000000002,390,450,2.0429826023195115,1.6570173976804887,1.5244970414201191]
[1.93,3.04,400,330,2.1022401955522576,-0.17224019555225767,-0.24550295857988114]
[0.14000000000000001,3.49,360,580,2.3666088130462875,-2.2266088130462873,-2.0355029585798809]
[2.5299999999999998,2.61,350,510,2.1157485709198629,0.4142514290801369,0.35449704142011873]
[1,3.1,400,470,2.2077675816812876,-1.2077675816812876,-1.1755029585798811]
[2.54,2.9,310,550,2.2055866666298707,0.33441333337012935,0.36449704142011896]
[2.13,2.77,330,440,2.1052567296744273,2.4743270325572553E-2,-4.5502958579881181E-2]
[3.18,3.93,430,630,2.5077256268251293,0.67227437317487082,1.0044970414201191]
[3.54,3.14,290,480,2.2136541883449805,1.3263458116550195,1.364497041420119]
[2.16,3.85,370,640,2.4902897770785475,-0.33028977707854734,-1.5502958579880932E-2]
[2.15,3.62,490,570,2.401967487885972,-0.25196748788597212,-2.5502958579881163E-2]
[1.33,2.3199999999999998,290,490,2.0299641368500003,-0.69996413685000025,-0.845502958579881]
[0.83,3.22,630,700,2.4068815646267683,-1.5768815646267682,-1.345502958579881]
[3,2.5,290,530,2.097896378913692,0.90210362108630804,{"$f":"A162-$L$11","v":0.82449704142011893}]
[3.75,2.67,440,520,2.1443413704458663,1.6056586295541337,1.5744970414201189]
[1.88,2.88,530,510,2.1946461378216617,-0.31464613782166184,-0.29550295857988118]
[1.08,2.19,350,310,1.8874435383646817,-0.80744353836468163,-1.095502958579881]
[3.7,3.56,460,570,2.3853380128472366,1.3146619871527636,1.5244970414201191]
[2,3.45,390,470,2.2880614770275676,-0.28806147702756757,-0.17550295857988107]
[2.15,2.82,280,550,2.1843173508509985,-3.4317350850998629E-2,-2.5502958579881163E-2]
[0.5,2.95,280,460,2.1555855460063436,-1.6555855460063436,-1.6755029585798811]
[2.76,3.21,310,400,2.1793529153427498,0.58064708465725001,0.58449704142011871]

{"sheet":"Finite Differences","index":3,"n_rows":20,"n_cols":9,"rows_kept":20,"cut":false,"hidden":false,"merged":[[3,1,3,2],[3,3,3,4],[2,1,2,4],[2,5,2,8],[3,5,3,6],[3,7,3,8]]}
[1,"¬ Value of x at which derivatives are computed entered here"]
[]
[null,"Derivative Values",null,null,null,"Errors Values"]
["Step size","First Derivatives",null,"Second Derivatives",null,"First Derivatives",null,"Second Derivatives"]
[null,"2nd Order","4th Order","2nd Order","4th Order","2nd Order","4th Order","2nd Order","4th Order"]
[1E-10,{"$f":"(COS($A$1+$A6)-COS($A$1-$A6))/(2*$A6)","v":-0.84147078194263258},{"$f":"(COS($A$1-2*$A6)+8*COS($A$1+$A6)-(8*COS($A$1-$A6)+COS($A$1+2*$A6)))/(12*$A6)","v":-0.84147059690546178},{"$f":"(COS($A$1+$A6)+COS($A$1-$A6)-2*COS($A$1))/($A6^2)","v":0},{"$f":"(16*COS($A$1+$A6)+16*COS($A$1-$A6)-(COS($A$1-2*$A6)+COS($A$1+2*$A6)+30*COS($A$1)))/(12*$A6^2)","v":0},{"$f":"ABS(B6+SIN($A$1))","v":2.0286526392077064E-7},{"$f":"ABS(C6+SIN($A$1))","v":3.879024347286375E-7},{"$f":"ABS(D6+COS($A$1))","v":0.54030230586813977},{"$f":"ABS(E6+COS($A$1))","v":0.54030230586813977}]
[{"$f":"10*A6","v":1.0000000000000001E-9},{"$f":"(COS($A$1+$A7)-COS($A$1-$A7))/(2*$A7)","v":-0.84147100398723751},{"$f":"(COS($A$1-2*$A7)+8*COS($A$1+$A7)-(8*COS($A$1-$A7)+COS($A$1+2*$A7)))/(12*$A7)","v":-0.84147096697980328},-222.04460492503128,{"$f":"(16*COS($A$1+$A7)+16*COS($A$1-$A7)-(COS($A$1-2*$A7)+COS($A$1+2*$A7)+30*COS($A$1)))/(12*$A7^2)","v":-296.05947323337506},{"$f":"ABS(B7+SIN($A$1))","v":1.9179341004260664E-8},{"$f":"ABS(C7+SIN($A$1))","v":1.7828093223926089E-8},{"$f":"ABS(D7+COS($A$1))","v":221.50430261916313},{"$f":"ABS(E7+COS($A$1))","v":295.51917092750693}]
[{"$f":"10*A7","v":1E-8},-0.84147098178277702,-0.84147098178277691,0,0,3.025119488242467E-9,3.0251195992647695E-9,0.54030230586813977,0.54030230586813977]
[9.9999999999999995E-8,-0.84147098511344609,-0.84147098548352051,-0.55511151231257838,-0.56251299914341268,3.0554958563300261E-10,6.7562400118958976E-10,1.4809206444438616E-2,2.2210693275272919E-2]
[9.9999999999999995E-7,-0.84147098478037918,-0.84147098474337167,-0.54023452378260117,-0.54001247917767614,2.7517321754544355E-11,6.4524829923584548E-11,6.778208553859244E-5,2.8982669046362375E-4]
[9.9999999999999991E-6,-0.84147098479703264,-0.84147098480998517,-0.54030557805617729,-0.54030557805617729,1.0863865362864544E-11,2.088662576227307E-12,3.2721880375286005E-6,3.2721880375286005E-6]
[9.9999999999999991E-5,-0.84147098340536808,-0.84147098480776472,-0.54030233620494539,-0.54030235100791901,1.4025284267304983E-9,1.3178347302300608E-13,3.0336805623143448E-8,4.5139779247804768E-8]
[1E-3,-0.84147084456270838,-0.84147098480783866,-0.5403022607097796,-0.5403023057108195,1.4024518812938425E-7,5.7842619582970656E-14,4.5158360162389499E-8,1.5732026792392162E-10]
[0.01,-0.84145696036160289,-0.8414709845274112,-0.54029780336417588,-0.54030230580851912,1.4024446293614545E-5,2.8048530165136754E-10,4.5025039638879605E-6,5.9620641756907844E-11]
[0.1,-0.84006923422543534,{"$f":"(COS($A$1-2*$A15)+8*COS($A$1+$A15)-(8*COS($A$1-$A15)+COS($A$1+2*$A15)))/(12*$A15)","v":-0.84146818324183714},{"$f":"(COS($A$1+$A15)+COS($A$1-$A15)-2*COS($A$1))/($A15^2)","v":-0.53985220400378775},-0.54030170606805439,1.4017505824611698E-3,2.80156605936277E-6,4.5010186435201494E-4,5.9980008537685592E-7]
[]
[]
[]
[]
[null,null,{"$f":"\"Finite-Difference Errors for cos(x) Derivatives at x = \" & TEXT(A1,\"#0.0#######\")","v":"Finite-Difference Errors for cos(x) Derivatives at x = 1.0"}]

{"sheet":"Finite Differences (x = 1)","index":4,"n_rows":23,"n_cols":9,"rows_kept":23,"cut":false,"hidden":false,"merged":[[2,1,2,4],[2,5,2,8],[3,1,3,2],[3,3,3,4],[3,5,3,6],[3,7,3,8]]}
[1,"¬ Insert x value at which function is computed here"]
[]
[null,"Derivative Values",null,null,null,"Errors Values"]
["Step size","First Derivatives",null,"Second Derivatives",null,"First Derivatives",null,"Second Derivatives"]
[null,"2nd Order","4th Order","2nd Order","4th Order","2nd Order","4th Order","2nd Order","4th Order"]
[1E-10,{"$f":"(COS($A$1+$A6)-COS($A$1-$A6))/(2*$A6)","v":-0.84147078194263258},{"$f":"(COS($A$1-2*$A6)+8*COS($A$1+$A6)-(8*COS($A$1-$A6)+COS($A$1+2*$A6)))/(12*$A6)","v":-0.84147059690546178},{"$f":"(COS($A$1+$A6)+COS($A$1-$A6)-2*COS($A$1))/($A6^2)","v":0},{"$f":"(16*COS($A$1+$A6)+16*COS($A$1-$A6)-(COS($A$1-2*$A6)+COS($A$1+2*$A6)+30*COS($A$1)))/(12*$A6^2)","v":0},{"$f":"ABS(B6+SIN($A$1))","v":2.0286526392077064E-7},{"$f":"ABS(C6+SIN($A$1))","v":3.879024347286375E-7},{"$f":"ABS(D6+COS($A$1))","v":0.54030230586813977},{"$f":"ABS(E6+COS($A$1))","v":0.54030230586813977}]
[{"$f":"10*A6","v":1.0000000000000001E-9},{"$f":"(COS($A$1+$A7)-COS($A$1-$A7))/(2*$A7)","v":-0.84147100398723751},{"$f":"(COS($A$1-2*$A7)+8*COS($A$1+$A7)-(8*COS($A$1-$A7)+COS($A$1+2*$A7)))/(12*$A7)","v":-0.84147096697980328},-222.04460492503128,{"$f":"(16*COS($A$1+$A7)+16*COS($A$1-$A7)-(COS($A$1-2*$A7)+COS($A$1+2*$A7)+30*COS($A$1)))/(12*$A7^2)","v":-296.05947323337506},{"$f":"ABS(B7+SIN($A$1))","v":1.9179341004260664E-8},1.7828093223926089E-8,{"$f":"ABS(D7+COS($A$1))","v":221.50430261916313},295.51917092750693]
[{"$f":"10*A7","v":1E-8},-0.84147098178277702,-0.84147098178277691,0,0,3.025119488242467E-9,3.0251195992647695E-9,0.54030230586813977,0.54030230586813977]
[9.9999999999999995E-8,-0.84147098511344609,-0.84147098548352051,-0.55511151231257838,-0.56251299914341268,3.0554958563300261E-10,6.7562400118958976E-10,1.4809206444438616E-2,2.2210693275272919E-2]
[9.9999999999999995E-7,-0.84147098478037918,-0.84147098474337167,-0.54023452378260117,-0.54001247917767614,2.7517321754544355E-11,6.4524829923584548E-11,6.778208553859244E-5,2.8982669046362375E-4]
[9.9999999999999991E-6,-0.84147098479703264,-0.84147098480998517,-0.54030557805617729,-0.54030557805617729,1.0863865362864544E-11,2.088662576227307E-12,3.2721880375286005E-6,3.2721880375286005E-6]
[9.9999999999999991E-5,-0.84147098340536808,-0.84147098480776472,-0.54030233620494539,-0.54030235100791901,1.4025284267304983E-9,1.3178347302300608E-13,3.0336805623143448E-8,4.5139779247804768E-8]
[1E-3,-0.84147084456270838,-0.84147098480783866,-0.5403022607097796,-0.5403023057108195,1.4024518812938425E-7,5.7842619582970656E-14,4.5158360162389499E-8,1.5732026792392162E-10]
[0.01,-0.84145696036160289,-0.8414709845274112,-0.54029780336417588,-0.54030230580851912,1.4024446293614545E-5,2.8048530165136754E-10,4.5025039638879605E-6,5.9620641756907844E-11]
[0.1,-0.84006923422543534,{"$f":"(COS($A$1-2*$A15)+8*COS($A$1+$A15)-(8*COS($A$1-$A15)+COS($A$1+2*$A15)))/(12*$A15)","v":-0.84146818324183714},{"$f":"(COS($A$1+$A15)+COS($A$1-$A15)-2*COS($A$1))/($A15^2)","v":-0.53985220400378775},-0.54030170606805439,1.4017505824611698E-3,2.80156605936277E-6,4.5010186435201494E-4,5.9980008537685592E-7]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"\"Finite-Difference Errors for cos(x) at x = \"&TEXT(A1, \"#.00\")","v":"Finite-Difference Errors for cos(x) at x = 1.00"}]

{"sheet":"Sheet3","index":5,"n_rows":16,"n_cols":11,"rows_kept":16,"cut":false,"hidden":true,"merged":[[3,7,3,10],[4,7,4,8],[4,9,4,10],[3,3,3,6],[2,2,2,10],[3,2,5,2],[4,3,4,4],[4,5,4,6]]}
[]
[]
[null,null,"Error Results for Cosine Derivatives"]
[null,null,"Step size","Errors Values at x = p/2",null,null,null,"Errors Values at x = 1"]
[null,null,null,"First Derivatives",null,"Second Derivatives",null,"First Derivatives",null,"Second Derivatives"]
[null,null,null,"2nd Order","4th Order","2nd Order","4th Order","2nd Order","4th Order","2nd Order","4th Order"]
[null,null,1E-10,8.2740370999090374E-8,8.2740370999090374E-8,6.1257422745431001E-17,6.1257422745431001E-17,2.0286526392077064E-7,3.879024347286375E-7,0.54030230586813977,0.54030230586813977]
[null,null,{"$f":"10*C7","v":1.0000000000000001E-9},8.2740370999090374E-8,1.1974780500523252E-7,6.1257422745431001E-17,6.1257422745431001E-17,1.9179341004260664E-8,1.7828093223926089E-8,221.50430261916313,295.51917092750693]
[null,null,{"$f":"10*C8","v":1E-8},6.0774709709221497E-9,9.778214571376509E-9,6.1257422745431001E-17,6.1257422745431001E-17,3.025119488242467E-9,3.0251195992647695E-9,0.54030230586813977,0.54030230586813977]
[null,null,9.9999999999999995E-8,5.8386540047195012E-10,9.5394159238537668E-10,6.1257422745431001E-17,6.1257422745431001E-17,3.0554958563300261E-10,6.7562400118958976E-10,1.4809206444438616E-2,2.2210693275272919E-2]
[null,null,9.9999999999999995E-7,8.2433282422300636E-11,1.1927414611534459E-10,6.1257422745431001E-17,6.1257422745431001E-17,2.7517321754544355E-11,6.4524829923584548E-11,6.778208553859244E-5,2.8982669046362375E-4]
[null,null,9.9999999999999991E-6,1.0115464021964726E-11,1.0252021453993621E-11,6.1257422745431001E-17,6.1257422745431001E-17,1.0863865362864544E-11,2.088662576227307E-12,3.2721880375286005E-6,3.2721880375286005E-6]
[null,null,9.9999999999999991E-5,1.6667767166467229E-9,1.1002310174035301E-13,6.1257422745431001E-17,6.1257422745431001E-17,1.4025284267304983E-9,1.3178347302300608E-13,3.0336805623143448E-8,4.5139779247804768E-8]
[null,null,1E-3,1.6666676849741435E-7,1.8041124150158794E-13,6.1257422745431001E-17,1.8008778785346309E-14,1.4024518812938425E-7,5.7842619582970656E-14,4.5158360162389499E-8,1.5732026792392162E-10]
[null,null,0.01,1.6666583332658469E-5,3.3332836490984619E-10,6.5664704576584576E-15,6.7471708197393747E-15,1.4024446293614545E-5,2.8048530165136754E-10,4.5025039638879605E-6,5.9620641756907844E-11]
[null,null,0.1,1.6658335317176753E-3,3.3293673921130917E-6,2.9978190069224193E-16,2.4376478844715755E-16,1.4017505824611698E-3,2.80156605936277E-6,4.5010186435201494E-4,5.9980008537685592E-7]