ࡱ> Root Entry F`t't1Table;U/WordDocumentSummaryInformation(@B  !"#$%&'()*+,-./0123456789\S<=>?@ADKREFGHIJMNOPQUTCbVWXY]^_:deghijkuopqrsnvwxyz{|c  ՜.+,D՜.+,, hp|       Title 8@ _PID_GUIDAN{35B66800-52E6-11D5-BC74-EC5246957944}. A!"#$%niO1#^RJ*(PNG  IHDR X'gAMA IDATx_4;^w3=H8NXݳM$ΊÙӹPo=ڒJ%TURzN*T]]kI%5]׉ܚdͭ&9&9&9,mkkfLիWIm~臄0t]yuDjq7X ~+7Ms^?Äȭt2` QCV{xxH[V'#ǦiT] =|ڶbcrBN'zQ_7Vҗd,79s_ַBVic _/f~꧄'OOw=k~s\)m}N`c^t*i^ ջiD׉Yq^eu^ q[lJ71V`tնe@FVBc~2Ao^;b݋N+Io"%c| WVK_ Y_e,U՗%Osg~g7 PR-AX8Qq/|?/|TMj岲*l볟OO%'~'g_aXJ4K]ek2GNt1-ڶD*Ҳ-=?BW@Z[c՗y "-lɸJulE3绁MH C+Wk,R}P-Wݭdh5FEZvEtXFyFi $?|+_W>,y`ɺ+Jo~SoH\:Bo۟?>2 ]TOO?ϪJFTWhꀤ>df1wc,6Ko KXzVBZqUvFU=`&BUÒp/gV(k9Nz/[3z޵k/&7&ӛj0lLPRΈJYkYb/Fv{$5x]tȮ/r*PT?_elZ7d/+g7,8XzxַU:+rL,[o{Tv~71jw}Nun@m[cN{ͼv {v%+&O7[w9>1ʅ/ՃV2z9XM#WqvM#0tc=eaNEskn|1?ͨB-yȳ'qׯ5H11r!ˈJnb}h]u=K>c]'eo`rwMnbɀ&*fC b cn(뢞QZ>ᴥ=<ޏ-_J^=)+V_$dU ;_([.(cKcekd1h3$nXwV ?/>KoTh%VXKHjȸ\=0nKKԋiT_ leo5)~yԾi'g2:Cė8`!mѾy.wc5Xσ'3zχl/aԁL-/gnsbL i; **]#VrJ8LQ,bkT5AEuKQ%hf`d*,9ߪ\K+)WA^fkb+g 0 6K>7۲>6)%3=$ZV06׸B1{&ˮEűɷ9]Uⱹ:Pű<*0~89mA,Γr;IQWM.S5X62 w"TY@2֧ uzZ_^b{Bt]{+w/d{b^t]`UVmy]wa-cِj{\z + E9f}msv9Ͻlm8XҚT^,}[*䶷~6V ;*CTʯopp\yrE0<.G>y"\![M`齃d|J2!;s+g ֻad=X۶(X 0 u_O-k*`jzxi)ڜ۷3r Ӑw(v,TtRO'j,ֹX žRɥ+9oQu&/PfQ,e.B2*~A]Ό` (K"rL۶ZFiv@,;H rssA~tF32yH~)O|75<_j[=c[ӟh&V:`+!d<fvz:5zEG A/1iG /c"gR _2Gl #W{seJi"?w /U׎+:#t2RZorܝ3ِѰ<+6v4^OEtu!T(sIړ+ǒR3 Utr䋛]? gMee|ϳZM]^Ow:B-\x Q!:!QmO'FZ 'ì<}£/4dR2U ˈo7~m3-?*WiנisUVBtר_ Q:tF߄e B9O'%wy.Mʿl0ƒIgg|pBnԜ\ѕJS;.m, /S}{v?;!JxvжCk5VF,区lALjmnMʾa KhЙѕqV^צw7¦.0Wv=+*Gvo~ZoSZVa[~W{1<3$N9`|4iXFtMi]-W2aVs B ~=jM箦 U^ v\_zc_ ߞ1ը/݊=TTN&TڜQFc{ ڼzX}QRUb^ Pw_:6{r^6d4Bk|RGNlK.~;ט1{Xn~EybGJVUYVNd\].&"riXed63xu ٻzv=s/ΝFzOam!:!ηFam 8&eԁ?nT.+ikHw{] UkcK\9i5XMs{G*R 6\gNʷb7Zs*s*Jn_&uu| l+c,`tޝEe;Ѡu_S?I]܆f?qףCC *iO`Z:4yU۶ ڶ׷l ѕpD!K+D]"}vB\pRqsoIs/I7O T̈e.W ~j,t;VޔKL0<­^QuxN*[`xp,ƿwcU`Z $3>hWB\tmѮYY2N{py~觑 ˬD`-ˆaY?BX[,2 cG}+zJ]T?,놮F$8Ft%K_4X{_%;ϼroGHNS\L^Jhv7g&_(F˵"*L /rȷu)MnLQ)b8}2v}FFWFUP٣@^Y ur5PƱXȸ^u<0ByuLܟZjޯEb_4N>Zg=+£+aX*&G9+V an+?tEuk,(ӝ܉R#3T-|$9+~p}p}[9Nrrb8: }(C]rdf'wjJ;XTTDe *Q!?nV鸿@Dw&eJGmPS}wݲuvnj='23Ǟ٘i[_fTV]sؓ+&o-Xumv躥bDIDQX;W"@ ۻ4fIٌ԰Wղ贳>s<Y*<#cQ^Q񢾕|/!: OYq&o.uX axEDW3nW7xW}3%N0*6T)u'"洿\."$)9Iy* QQ]^=cVY-R?XYTTݟY3Y;,\2C7ƌڶ"W)Y}%֯IJ GU 0^UVMxQZPZtFZ"Fi8i?C{ JMOjJR/#-HZa2!j;%U4Bt0?z>[}Vw!fjV쀳Ad a偿KRU0TT}CB"^JݞUM!YkT|Vu!{vJe^ NV(FRQ{g.ԱxrN k_u:,dRm;KV@^6AV/Ii "5WoZ o23g&tU۳|Ng,,jo'$hT~t%{3^OfɳUx"zjz)[?|Qll"8EJr ߋ]}%#1ׯV=`cV?*ݯ+ )ö}_5XE+nR[ujQx:FItv bx5suT"Jk]&ܸߦ>E~k^Wx !AsJދ]&B*J`UC><-jÛqs`S}%J8+)f1Gn!X~Tt"U9:‚'~ OfUi$NDƒ )0 M?st%x CbW_)LpVi&U/5+˽(s*-ԽpN5X:=x1'ɤ/ՄLjT F VjGWG <‚'4e;c85Yb92{='s_a$˴gM,>m:\ia\U\52,g}}.{@AR6ѕ}J#i $j.ӆS娸ag|G`_郵T9x+!֣ha9ÌZWGi+b̒3ٙ5X~*g!#eHK"E6`;F!> %>YoT]wdL(|Ql3FXt$OA|23!a &%>ṩ<М f0>Lٵӧ<ݾ`}WU{Ej V)<]@]n[) G T1 Cu9Eu}6!Pm^׭Q߼y\~ 0 %LH@F+>d5*=ʯ+)B2+it4Zf PR,EKV9sm9XEY"%6^WY&N籷ahE5ͭ9嵈j LEWB5f|4|\r%8fuvWB}\Å~mmMmf׻>XLcPV(t YμWtr;ȯwj>އߓK |X-2`|q"ԕyY4V6TW g*~gsܙbo]B,yt DqMtDmX2l9S)R?w=*H K30儳ɢtX} Uz;}Fk5T>}Ư 8J+1{䅌5XeRh!kЃч sD|Jq)BG smQOO`Mk,l 6@q$?Eh`})K~GK@`+ [X5X  IDATaHWSB:l%4:?ȃ 1ꎏ Z:, އkS+*^;z=2+˨t;^5!8nbR|g׿i j"+N)r՞A6l Um;s^WqU=g"5X`?{zzʘ ,rPV-k$>*v?%ZgGEE\C  sϘvs.t:Sn!4$ Unٝ۶[rqCV>띮e=ָ/RM*z,Ѱl_[ƶ %2IvaĹwPX'$'$nOIǒ= GI}=NܿSρh=jHɱ5d!8kjZ'+)2}4)rߚ{eùyxq&Ky%:Qe=&|[b4 =Bt:Q?8eM'k~t5x2Ys`7yDNKɉÓO'{lr>ٱ83&ƏS;Y[=y]I2/$,{hu lc I L&"ܓ I V)nT~&7o238<%M^H:3H^MmvU/t]7cݢg+X l9[[18{jS7B3:P4UlcGBq 9)-͛m GaM o=hL[;鰐>1x%粵#腧{%ٳ7'3#%0V,'ٙX鳦<0c]<{O.'']G(o8֥:c=[ doc;glۅ-*7+m<DUB3;φ9R&WK;o%69͙QƀL 3hB:fs/Q^f;NUu;}l.kffCNc 0+5Ύ4vsui>>>>>x' OG`U {~oi5X$TŔɞkizdx4sᜌb`/ ,׍伩 ?d43G"%7,WWV ;&bZmkdGG1WdRu]%]a+}^UL\t\wmۮnvUtF:`EePhZ}s;(]pҿ/vU}{ʓBTkz.cy\y@\>TJFW?9(҅X3*qn%*ww5ï]Aߵ mVcIM~=+eo}!de>W+$*GWz`ߋB"Tq1ƪVsG2=Uc)Oѳ-Ugqw=kFe2yZtXahV~ ѕ`5V3d\3K^x]16+P%j\jũ%(Ju}k 4K>XeQբ`/w~7W{O/!藋\Huu]'Dw>wvtXOX̟1b9];&0J6 XyZ kwoV[Jrd_u"(z]&B Sa59w]Hq8 g[EUZ 5!9Q Q4BEadhNvi MGW"Aբb͍?+!_!RO~[/izΤ&w2cG#jC~Jz~P11`)} 3ja:!u0KBNT98,} Ǡ|,S8ڶ^}Xr>BXy/KJQ^d{xޚxj/VO;He"~ݜ>XcF1csZ#?NR\.(JEe'۪=BmU},}||sg[e=.H^%uV럑}TMqO2(,imV y4s (Y`aH:z%VD Ge(su?sFdT%&Bqa-QDض NjMzlM-!{͞6# gDW+O"4:&5X6|m_sDmbWg/౛D*#Izټ`Q} O0AXI&)xO{+(A OOOS Vx3SlcoG=ʛѠI@vd!JXA!Y-l8Eiqb[ eVBg|=`]@^]LC&DMi{\7Yx~ p ОϷOsumH]Dk oRkNv _3jTBM~Fm[s5v#b, vku&QYL^!8 ={o0oE=V-,9)r1Ou]ש:-\ei>X%Ή*GFWz> ldt`E(VæM MrH+b` !EWB4B u]H:tUZj4^.gUi[O]w a0{ꄿh9riOtO9} LeUi[_<&83p`pb,ڶ~h[tն] @&Cm ɁګbF+X"|.B}ְPlyP]<7cl"/bhA\Om{MT)VaOe4v\<:%9;Mu]5B\2|i"|ǾpqP.bLm;wՉd'xɞR}g}Qmv0W rB4?i^X`lkˀ٭{ؽDMGDmXz*ThՋ+&PY[1Nw0%QP0 SIzMض90?܅;lh63G}dѕyrݰkݹXK<1 {~:, j"ic$wJ#Iz l" T] ԛs1ҾV]} (Jzt%*ꃵ,3{{7"S扮mP~9`~v<ޭyŖs|}񿈐K5sYF!cMED8nSg"%p+UEǚL=S=e@E9+0ܙYkMmضv՜~,(߼|ߚ*'9,uNӉV>3ƴ9sFꅬ*veaώNjNjǰͳQGʹфy放ﰿS<.:;ʫlgQ{j?8gZ ѕ`iki=ʣ6,=R=GKJVcno? Ze9j;!א] 9zu*.X(:ؾ[o+AƵ'N˳gJg<)QiCB-ϥkH\a*1V]KMu?a+`Þ]v V8XW_-WFiy+DgVhtWXsloQH(;P¼I9W08Dک\uN>kWblnfoA`9ٷ Gg:ڌOS& 'ϾQnWD$X~0~NrG9k8ρjigfpkYB(sB_rLAWpV#%{70ci5~j!=U@W!>dRײcWm%'%l28SBe/ vs!Rzd7vrb9=w=*N(| 6 G_8?ɱI<`m>BP5/ywYxIdrj߂9ْ{}zZT]& O99?&B25m\.S+aGyU,j/;VǶ;Jy[u>stʕrYgGyU,j/;VǶ=Jy[\YHVC6,7i \B_?r!?{MڿB0u)7VҐ"㨤dc'Z_~&uvclb:2dڜE[3 ™O .]`_3W#jG{2V]}+3{ <*XJޝey0>UXeTw WHAQңk>VkI v%hM`ΩlBINJv3=OHCdfX+px{-͜Z:O$V=ۿXP\~St*G8|s#yMalu3:4n8gj-_*2pvug5[!'yU:33'cXcokoe" cLrUG«4޵jglls5mUp˕&Nl7qu}POn㜽"zDXr ]0e,{šFWJ%z,oz%BFO*rSnG=j7 N6+8Jnmg89Vӷ52wMsǧ\uK=ij%>ݩ?߼y+o>.KJQ^f;˾\J s?NR\.(JEe_4](@X\ցBp{hkƖhxo IMdl Y.&rDvTu>5?]Q}g.W?}Vۗ2n .;N5ǣ2f[mEVʳɆ>)t_/WnG~_&oU˘eje,pfYbKmDTiK GoU_%'#ZV7BT4 {ԯ;!D_O_0ߚ,{zzR[냵k*&Xk/} yͫ_B\?5 >ڴ?Եݟa=۶ڶ<[ָ~1|W5XcF(Bܗw,ZfY}ҍ@*P/e!Dׄ׿e!D!%ΫBO_/Ue[Lyo !>?§B|v:+_|oễϽB|Z_u۟o 8IYR1Vѕ ˩4:U/~+O~EoU7~&{_]~7nEXtɿO/AՏ֫dhߪ??BO߹ !>{\eP^B[BϊJEZP V.?`- ֨?-RzWyqdռn%l>/qJI~70=|Q`+>zُOBǡ7c`p-)y`z4e@W?sB]W^ IDATHKV_ 1꫱u^j1JFHzl+,<Ɗk"T-m%-7Bů +2Y!\^w?7&BGUYzM@]4?t E0ywU]y2jaE`IF&/K%UW[Sz]?'N~׿eOX~>쬻>uWw?e'?{r?{U,D(dO~dW_#S}ȡykƤ5cW?BW?5ܖ'i֏1٭.Aл߹-y~PZNdFN^ } -@ʏf"Jͦ9prɘZ ;ʫlgQ{ٗB)zVp 甾N}ߟN\y\.uvW΢/9M:?rq jW(} Cu~1=sMX9EmΑ&Jj+F~vV:L`]-΅ڊ]t`9j/p\jd2 ewv/rRDW+:.+P:> gۺLXAw˩ ڤ:*,zsF+ ,3~W IF$XfEկ,q_au: ^ " ev῔JVhө(-cMl5 ͎Oi `9:\zIξcUdR'nƨ :ë+:Qg|xxX*7= a;*nLN.!hK7ś7}i,T9RNJ=$l)BDTGJucs0f0ɒ9<6$[Gm[!ywq^BGdV*}@lgQ{ٗ]j/:.z"񓾚'ZˮOڿb(Y?w l?_rX^iNSuSEa p-GPUO/_*yGmMa=pN'. 'ݿܱ=V Y!K]mj\ _wN5`b&XRDφAo.wf>mxno]GЎoՖh^E!Nm+Ҷ&$ "'4GD,eudO\^.~sqS9[me,'.վM^{=Us!>ɦp7`r`kw zkxNg.A`ތedqc~ۛs2>fܤgϭftsg+Uw5MS `*+%H\+: .ȲǸ/m{\&@V8ϺTB向OU!$"!xbMy |˺)틙MiUdǠK839+>cHUyzz: G}.*tcs^K-Z0nF|e\ 3uF>Fsigԑ,$NZ=6kP/̾ ګK&oۿZ2-7$WٛgvQrbS~~{ %.kj"u& U]LkVz W uzן,,\|U|H0*k kX7H3΅B 2,cyMFEsX\_g,Tyr͛7]x>y3v30MnAbBqtabXU7X`aRej~}?4mdz{a-+YѐIw>Xkt9(''Ycm`*VT7Hz~+oW;+^U,j/r[(e/sk"X:3J^.4Y^E9؃nƟ|`^`is{j F}NI7ě>\N3=yrCa;"cPM]H:!c/tF[hKCBرkj)e$+t.̾댌b2:-X;NԸ2"J/RÅmT7ަM),3Z|ٹ, Y3!?w `]6 vP߰'#Qɶl}%FIͳg8E(Ê9:4v_9Ki11JuF8W&%XnKXހ26,V$6_Qg^[TJ+]SsnJZ@3bϏ *zW0 xǝI3V}UZgktʘ%+fV%eOkgt״3xz `<T#f|۳R͍u{ `??c{A'[?sǨ`YKCK7dž dIT;8kʸsX݀=m:V1XԧS]0d 5qâ;@fXݚ6&MT,j/r[(enVq?NR\.(JEe_4 X-^lzcBcuFrW}9RE\srK464-`&񗗳i+{qs[tȓD19(Q _%뮎p63F"Ʋ0"cGjlM.9.?G*u&3\]f:TaqXin}xx: =^BE%*9 /KXCYz8[fhB(ʛ7f4  v>#0 4JzP,FuCz_%la7)`H=-dWm+DiEmX{?iiU9Jsf&˹SCN4rcLt!ܫ0v:֢9%DB%PCu?k{5-din1׫ش 4`g'j 0YʻX: 9㌮굪tҗ+  hQuV',Ma44pd&IveO.G\uXXNF:gd ޢPp~BV\˥m g,cAXy?~pƣlgQ{ٗ]ca.p1V7sa?"Ju lO} P ;ʫlgQ{9=TMأ:W["Y`!3 RaʚƾIaG[U{ppc(8qe/ɛ,`5lDhGE%.p?2`6aЈaذM.{c:ל:@Q+bJGVT=z7`'GE}Ԩ{GC|clNA`CM QwJc91Pc,"*@[a[`dDhϯ77;0`1?@2cgiTؘ2̸t 6vn]ig:N߾r}/#-,HMg`rmORRiщ~ à,|y۶}|,a(@Z:*Dw9WRx}"Җ;D#s9ۆrx$.^===mVE\#㆕#zMXפ ?߹<1yޚ/sV^u8 5fw~VI!p =Iv3/C.WAL`88O@l\YNՁMy^h[͸ dIL0"'+7a d"uuݯ3*J*'28X9UY3-zQƮU }ej_("\`3d¾E`0 } M@vDWطKod@ ę+{nA m:d¾1!`KGW;kUl `6B C`卋WȭƸlgQ{ٗB)eZ})o@|>Ju*f+}lgQ{n~j胅}X5]ah*bF8$urO,I˹(e`qC.1Pӹpv>XԐhIXN-ѕ=$yPq(I%z&*c 1`6PEtG`n`N6z44]+-M{KEPu5XDW%XeX_Hf/z`qPZt%w=O:jr⪪g*5M!%MC{&V5V/v+'fӇ0-z@D[ʧpE@s( D2soB_JEe_.www i>XUԁsX9W}߯S[iq΢/t>-]5MDw/ףlIbg`^5X/i`.BU{ c FGoccF˔8|%oQϱ[6S#*sTo f6u bM~B:U$1n kUL>诂4<:6@ VT_+=rviWPKvH ]XUգٚYFl ,Do[_1`][k79$X@ uf{NtXHl  (? yڟ"g;\{b!!46Plt5iPOE]+G-z;EMׁEYFi5Ɓ*v}-2P_8#mV {>!/B!_qJ+4Y^E{(ҫ&_O#Xlbsh(nN,?ބH`9`d,A84KTgt 4 O¤p3kTrDV{ɽ^F,f 4.ڤp`S{y,Y3Fi9·F`ډ>X1ֆѕ('TJ^Ӏ Pcm]]ROOO[g2F9@y3c +S*-+:P9` PuziO3jb,+@: tClLR=XřrD8Xyf, 'g}jdƊ3u1LPaJUzpƼΡVklLtXEJ+sVl8Bp**@|ͤ~RW۽lgQ{ٗ]&L{R]TY !GX }΄G˥ƙ*v}f WcSn?@R9;U6`Pc.]k,i;>.2`nV yX +p[`J`bwcQ;|ubiUdձqW IDAT/Cѩrgw R`,*@'E'wLt]\&+(C6KxY^rBtc>X aXa/!""!:iEH.b)Q9FrKwE+ NӜyɢaSclk,:OXr5Xv M[=ji)BbE`&,+o{_8(JEe'"""Jv sO4Y^v---OFyr2ZJ|9@%[z,#3Ш.5 -={PXFm'X+j|Q%}Qͭ6k4+Pt'wf'x|| 7e|fQs.cm۾}6|7oDMyz_g/ua۷oea^U$~BVN끛@Z|*ʸ"HmV`5M3h'Tva؄JEv]x|D0 McEmceA=:#>+ɾ^Xd}_xpQՕ,pd%"wv/,u;\yfj0vYJmF^d8= S4&˛ rU_"FZ .)4L \9üO)I|ǹG/]=t%NfټOGo=,%q3Xds݈.Si|4r+'JYfH1>$,0z N̼dՎ?liT_edy\;'F_zbZ+Po髩Fخ׬"ځb];:1BpXEWj1Vx:굞qKоEEZ[?M6Hc9%:f^y&#Qǟඟ^bRA[K#ڇb]V`-] sXCX%VO(@H;z arT VvĶ*iHv~i|Loӆau('!k>[ Y}5\DJEvg B.W{g.[_~ VUcIu3k"U.:R]vXd`suZh:w1V*ksc Vz&XKSN,ix\/d_+F&nZ?$ƪ] .u` ]1}+s}GvqҖx8 ]2h=lu_?WjEtOֳ8I]駣[ TB֏Q .kvM ӰD\t5x; i/zrOSiC$b*0*iT|y ?Eglr_[҉^c!QV%<<=)!Qsfjp>E18b]yp 57ݳ%R_TZ죱Uj۶ƏceA <Solver> and fill the values as shown. Then press Solve.  [$@$NormalmH <A@<Default Paragraph Font l,b$O1#^RJ*(i @t(  <  # AB S  ?p T4 keith gregsonqC:\Our Documents\Keith's Files\Teaching Stuff\Courses\Computing Techniques\Curve fitting with the Solver tool.doc@ vu@@GTimes New Roman5Symbol3& Arial"hQUUU"r0 keith gregson keith gregson"v$v8w>wwwwwxxxxxx$y&y0y2y@{B{L{N{P{R{||~ ~~n@BF&*CJH*6CJCJ55CJ jU*1do this choose <Tools> <Solver>2 2)Computing Techniques K Gregson  [$@$NormalmH 4`4 Heading 1$@&5CJ4`4 Heading 2$@&5CJ<A@<Default Paragraph Font1 /0*+30000000000n~Unknown keith gregsonl,b$O1#^RJ*(i @t(  <  # AB S  ?01H!p43`)3 keith gregsonqC:\Our Documents\Keith's Files\Teaching Stuff\Courses\Computing Techniques\Curve fitting with the Solver tool.doc keith gregsonKC:\WINDOWS\TEMP\AutoRecovery save of Curve fitting with the Solver tool.asd keith gregsonKC:\WINDOWS\TEMP\AutoRecovery save of Curve fitting with the Solver tool.asd@u5CJGCJmH ,F5CJGCJmH 0J G 5CJmH 0J p ./01?KMP`bdein `djqr}~Adi  )*NS011u1u1v1v0 v0"v1@1$v1@v1Xv1\v1bv1v1v1v1v1v1v1v1"w1$w06w1>w1w1w1w1w1w1x1x1x1x1x1x1~1~1~1~1~1x1y1"y1$y1&y10y12y1by0dy1y1Bz1z1z1z1:{1@{1B{1L{1N{1R{1{1{1{1{0|0|1 ~0^|0|1~0~0~1~0@GTimes New Roman5Symbol3& Arial"hQU^ Vt""v$v8w:wwfy||||~~DFHvxz$$ & F r4d= keith gregson keith gregson [$@$NormalmH 4`4 Heading 1$@&5CJ4`4 Heading 2$@&5CJ<A@<Default Paragraph Font,@,Header  9r , @,Footer  9r <C`<Body Text Indent V[  [/0'(|}~7LN\r r r r v:r r r r r r r v:r v:r v:r v:r v:r v:r v:/0'(|}~7LMNX\0000000000 0@"""%Unknown keith gregsonl,b$O1#^RJ*(i @t(  <  # AB S  ?0[H!p47\.97\ keith gregsonqC:\Our Documents\Keith's Files\Teaching Stuff\Courses\Computing Techniques\Curve fitting with the Solver tool.doc keith gregsonKC:\WINDOWS\TEMP\AutoRecovery save of Cu [#]. [##] # To name a cell first select it, then <Insert> <Name> <Define> ## If the Solver tool is not in your toolbox select <Tools> <Add-Ins> and tick the Solver selection button.calculat,accomplishk in order to e the contents of D17carri outmaking successively better guessesautomates the process and hence In order tenterThe exponential function is used here as an illustration but the same process may be used to fit other functionsrve fitting with the Solver tool.asd keith gregsonKC:\WINDOWS\TEMP\AutoRecovery save of Curve fitting with the Solver tool.asdkd hho()kd@Єu5CJGCJmH  & F?h & FC$ GmH 3F5CJGCJmH 0J G 5CJmH 0J GmH 0 ./01?KMP`bdein `dekrs~>af &'+KL{|}~$%/67KLMNWXYZ[1u1u1v1v0 v0"v1@1$v1@v1Xv1\v1bv1v1v1v1v1v1v1v1"w1$w06w1>w1w1w1w1w1w1x11x1x1x1x1x1~1x1y1"y1$y1&y10y12y1by0dy1y1Bz1z1z1z1:{1@{1B{1L{1N{1R{1{1{1{1{0|0|11~1^|0B0D0|0|1~0F0~1H11~1L1^11`0@ 1L0t0v0x1z0000@ GTimes New Roman5Symbol3& Arial"qhQUdV]V%o">4d7 keith gregson keith gregsonhho()kd@||Єu|{5CJGCJmH  & F?h & FC$G Dbjbjَ 7#]&&&&&V<"<"<"8t" " j M,"""""?$?$?$p'r'r'r'r'r'r'$-.^'&?$$"?$?$?$'$&&""S"2$$$?$&"&"p':H&&&&?$p'$n$&P'&&p'"" @ģj <"[$4h'HvceKJa?d Ik|Θ.^_*|dLt:m @ Vl2M8XPVC,VݚYt_WI9EKh`ؚ30M9,Vn &>>&o G!M`]eϭϊgW Z꺜|= ˿f\,=9WW)%`Xvݻ^^ &SRj(n ;9F#;1@f}VTpX]c =VPtZ"Y,:ϻ,Vn Kr,,Z-tY|_[XS^zwTf.IENDB`Curve Fitting using the  SOLVER tool in Excel The following illustrates an Excel spreadsheet being used to fit an exponential decay curve through the experimental points in A7 to B15. The fitted values for the curve are entered in C7:C15 by entering the formula =A*exp(-k*A7) in C7 and then copying it down through C8 to C15. It is convenient to name cells G7 as A and G8 as k. ). It will be necessary to set initial values in A and k by guesswork or wisdom! In order to perform a least squares fit to the data the squares of the differences are calculated in D7 to D8 and the sum of squares in D17. The best fit can then be calculated by minimising the contents of D17 by changing the values of A and k..This process can of course be accomplished by hand, but the  Solver tool makes life muRoot Entry F@ģt1Table;U/WordDocumentZSummaryInformation(@  !"#$%&'()*+,-./0123456789\S<=>?@ADLEFGHIJMNOPQUCVWXY[]^_:~ghijkuopqrslnvwxyz{|}. 24d7 keith gregson keith gregson [$@$NormalmH 4`4 Heading 1$@&5CJ4`4 Heading 2$@&5CJ<A@<Default Paragraph Font,@,Header  9r , @,Footer  9r <C`<Body Text Indent V /0qABC 000000000 000@@@@@ """%Unknown keith gregsonl,b$O1#^RJ*(i @t(   [$@$NormalmH 4`4 Heading 1$@&5CJ4`4 Heading 2$@&5CJ<A@<Default Paragraph Font /0*+~||Unknown keith gregsonl,b$O1#^RJ*(i @t(  <  # AB S  ?0H!p4 ~1< keith gregsonqC:\Our Documents\Keith's Files\Teaching Stuff\Courses\Computing Techniques\Curve fitting with the Solver tool.doc keith gregsonKC:\WINDOWS\TEMP\AutoRecovery save of Curve fitting with the Solver tool.asd keith gregsonKC:\WINDOWS\TEMP\AutoRecovery save of Curve fitting with the Solver tool.asd@}}t}}5CJGCJmH ,F5CJGCJmH 0J G 5CJmH 0J  ./01?KMP`bdein `djqr}~@ch  )*~1u1u1v1v0 v0"v1@1$v1@v1Xv1\v1bv1v1v1v1v1v1v1v1"w1$w06w1>w1w1w1w1w1w1x1x1x1x1x1x1x1x1x1x1y1"y1$y1&y10y12y1by0dy1y1Bz1z1z1z1:{1@{1B{1L{1N{1P{1R{1{1{1{1{0|0|0|0@GTimes New Roman5Symbol3& Arial"qhQUN V" ՜.+,D՜.+,, hp|   7   Title 6> _PID_GUIDAN{35B66800-52E6-11D5-BC74-EC5246957944}||Unknown keith gregsonl,b$O1#^RJ*(i @t(  <  # AB S  ?0H!p4 ~1< keith gregsonqC:\Our Documents\Keith's Files\Teaching Stuff\Courses\Computing Techniques\Curve fitting with the Solver tool.doc keith gregsonKC:\WINDOWS\TEMP\AutoRecovery save of Curve fitting with the Solver tool.asd keith gregsonKC:\WINDOWS\TEMP\AutoRecovery save of Curve fitting with the Solver tool.asd@}}t}}5CJGCJmH ,F5CJGCJmH 0J G 5CJmH 0J  ./01?KMP`bdein `djqr}~@ch  )*~1u1u1v1v0 v0"v1@1$v1@v1Xv1\v1bv1v1v1v1v1v1v1v1"w1$w06w1>w1w1w1w1w1w1x1x1x1x1x1x1x1x1x1x1y1"y1$y1&y10y12y1by0dy1y1Bz1z1z1z1:{1@{1B{1L{1N{1P{1R{1{1{1{1{0|0|0|0@GTimes New Roman5Symbol3& Arial"qhQUN V"24 keith gregson keith gregson  FMicrosoft Word Document MSWordDocWord.Document.89q [$@$NormalmH 4`4 Heading 1$@&5CJ4`4 Heading 2$@&5CJ<A@<Default Paragraph Font /0*+~24 keith gregson keith gregson [$@$NormalmH 4`4 Heading 1$@&5CJ4`4 Heading 2$@&5CJ<A@<Default Paragraph Font,@,Header  9r , @,Footer  9r N /0'(|}~*?@KO0000000000 00@@@ """%Unknown keith gregsonl,b$O1#^RJ*(i @t(  <  # AB S  ?0NH!p4*LO.9*LO keith gregsonqC:\Our Documents\Keith's Files\Teaching Stuff\Courses\Computing Techniques\Curve fitting with the Solver tool.doc keith gregsonKC:\WINDOWS\TEMP\AutoRecovery save of Curve fitting with the Solver tool.asd keith gregsonKC:\WINDOWS\TEMP\AutoRecovery save of Curve fitting with the Solver tool.asdkd hho()kd@||Єu|{5CJGCJmH  & F?h & FC$,F5CJGCJmH 0J G 5CJmH 0J  ./01?KMP`bdein `dekrs~>af &'+KL{|}~)*>?@AJKLMN1u1u1v1v0 v0"v1@1$v1@v1Xv1\v1bv1v1v1v1v1v1v1v1"w1$w06w1>w1w1w1w1w1w1x11x1x1x1x1x1~1x1y1"y1$y1&y10y12y1by0dy1y1Bz1z1z1z1:{1@{1B{1L{1N{1R{1{1{1{1{0|0|11~1^|0B0D0|0|1~0F0~1H1~0@1L0t0v0x1z0000@GTimes New Roman5Symbol3& Arial"qhQU^V]V#o"24d7 keith gregson keith gregsonDocumentSummaryInformation88CompObjj0Tablef09:;<=>?<  # AB S  ?0H!p4   keith gregsonqC:\Our Documents\Keith's Files\Teaching Stuff\Courses\Computing Techniques\Curve fitting with the Solver tool.doc keith gregsonKC:\WINDOWS\TEMP\AutoRecovery save of Curve fitting with the Solver tool.asd keith gregsonKC:\WINDOWS\TEMP\AutoRecovery save of Curve fitting with the Solver tool.asd keith gregsonKC:\WINDOWS\TEMP\AutoRecovery save of Curve fitting with the Solver tool.asdkd hho()kd@@@Єu@5CJGCJmH C$Eƀb' & F?h & FC$ GmH 3F5CJGCJmH 0J G 5CJmH 0J GmH   Oh+'0t  $ 0 < HT\dlsskeith gregsonoeitNormalrkeith gregsono5itMicrosoft Word 8.0@9+@ާ@=@5o./01?KMP`bdeincghnuvBejz!+-239Ypq{}@ABC1u1u1v1v0 v0"v1@1$v1@v1Xv1\v1bv1v1v1v1v1v1v1v1"w1$w06w1>w11w1w1w1w1w1w1x11x1x1x1x1x1~1x1y1"y1$y1&y10y12y1by0dy11y1y1Bz1z1z11z1z1 {1:{1@{1B{1&1*1.1z1B1D1N{1R{1l1{1v1{1~111{1{1{1{1{1„1{0|11|11~1^|11n|0B1 1R1X10D0|0|1~0F0~1H 11~ 1L 1^ 11` 0@ 1L0t0v0x1z0000@ GTimes New Roman5Symbol3& Arial"hQUwV]V2"24d  keith gregson keith gregsonzt E PM y t U R3E x(t M (QU z0t E 0P M ytPU PM Q4RE H,QU B$PM QRE H QU B PMQu U BEE xtPM RE H4QU B,PM Q$RE HQU BPM QREPu M AEU ztPE QU B4PM Q,RE HQU BPM QRE H QUREu E @EM y tPU PM Q4RE H,QG Tbjbjَ #]0 8 ~-8!8!8!8!8!"""&&&&&&&$4.(0^&""""""&"8!8!S!2""""8!8!&"&"""&r&&8! ze ":&Root Entry Fzet1Table;U/WordDocumentSummaryInformation(@B  !"#$%&'()*+,-./0123456789\S<=>?@ADKREFGHIJMNOPQUTCbVWXY]^_:deghijkuopqrsnvwxyz{|cDocumentSummaryInformation88CompObjj0Tablef0 ՜.+,D՜.+,, hp|       Title 6> _PID_GUIDAN{35B66800-52E6-11D5-BC74-EC5246957944} Oh+'0t  $ 0 < HT\dlsskeith gregsonoeitNormalrkeith gregsono6itMicrosoft Word 8.0@#@ާ@=@I