ࡱ> !# }[@ bjbj44 /ViVi9tttt  (888` f $! D F F F F F F ${Rj 5 W @ 5 5 j tt8`    5 tR8(`D  5 D    " ` Pv# ( 0  0  w w ttttw 5 5  5 5 5 5 5 j j D Chm 1112 Using Microsoft EXCEL for graphing. This was created for users who have not used EXCEL or its components before. Data will be generated in this class that requires interpretation and extrapolation that can be aided with EXCEL. If you have difficulties with using the program after reading through this sheet and practicing see your instructor for further assistance. SPREAD SHEETS EXCEL is a spread sheet design program with a few database abilities. What that means is it is primarily designed to arrange and display data. This data can be in the in the form of words, letter, or numbers. EXCEL is capable arranging this data in an easy readable manner. It has also been made with the ability to perform complex calculations. There are several mathematical functions available to process you data. The data in entered into small boxes call CELLs. Each CELL is recognized by the program and is able to be manipulated to create the desired output. WITH YOUR COMPUTER Open EXCEL (double click on the icon on the desktop/single click on the icon on the START BAR/single click on the icon under START>Programs) You will see a spread sheet with no data in the cells. You can click on any cell and use the arrow keys to navigate around the sheet. To enter data simply begin typing, and the highlighted CELL will store you data. When you are done entering data into a CELL you may move to the next CELL using the arrow keys, hitting the RETURN/ENTER key, or by clicking on a new cell. Since we will be graphing the data try entering these values and we will create a couple of graphs then extrapolate.  EMBED Excel.Sheet.8  Simply type these data into the cells as seen. Once completed, with your mouse click in the upper left most CELL and hold. Then drag down to the lower right corner CELL. You have now highlighted the CELLs with your data. To graph this data go to INSERT>Chart and select the XY (SCATTER). This will create a Cartesian Plot of your data. You will next be able to choose several styles, select the one that has small boxes with rounded lines connecting them. This graph will create a smooth curve of your data points. Select next, and you will see a small preview of your graph. EXCEL at this window wants to know if you want to plot the column with time verses the column with temperature, or if you would rather plot each row individually. You want to compare columns, so make sure that columns are selected and then click on next. The next window will help you to label each of the charts components. It is always helpful to insert a title that is very descriptive like, Time vs. Temperature plot of Experiment 15. It is also very useful to label both the X and Y axis, like: X= time(minutes) and Y= temperature(Celsuis). Click next again and now you are ready to create a full version of this graph. You have two options. First is to create the graph as an object in the graph. This will create a little mini graph in the spread sheet. This small chart can be moved, copied, and pasted. Second you can create a separate individual sheet by slecting As A New Sheet and you may now rename the sheet on the adjacent box. If your chart does not look like mine and you have entered all of the correct data values, try again or see your instructor. ANALYSIS When these graphs are created we need to utilize the data for further analysis. You are able to click on the elements inside each chart you create. One important EXCEL funciton we need to use is the addition of a trend line also called a best-fit line or a least-squares-fit line. Begin by graphing the following data on a separate sheet titled GRAPH 1.  EMBED Excel.Sheet.8  When the graph is created simply RIGHT click on one of the data points on the graph and a menu will appear. Select Add a Trendline, and then a menu of trend line types will appear. We will be using the linear trend line for our plots. Near the top click on the tab labeled options. This window wil give you a list of possible options, including show the equation of the trend line, and forecast/extrapolate in front and behind your data set. The graph of the preceding data with linear trend line and equaiton should appear as follows.   EMBED Excel.Sheet.8   EMBED Excel.Sheet.8  5 x hiûjVhLUj1> hLUVj^hLU j{1> hLUVmHnHuj]hLU jm{1> hLUVmHnHu j8q1> hLUVmHnHujhLU hL6CJhL hL5CJ56 : ; x y   gh$^a$^ & F78`a & F$^a$^/ =!"#$%`!REӌ ^#9@!<4]`ZjxZkhUw;3wvv7IӪ]uSLS6iG#GKB$GI6 Kk-K*hQ,l+RMm=31I;;7ߜs,FBB&jGfH,RhO~fL{pf1= Ġь,(y~Em5އRaγΓiQ#Hsǒb랡dxr eyZ"]OLLVsB2Њ5ㇱo~dMi#yˌQmʭ_+^ڕ1&MI/jTRU/ *cj^TQ랪 9Ufo&/U6OF|rPRuPH>cFTm3f3F6*xEo6T5McWp{AG]/U\5%Q`鏪qSeh0VɧL/UZydnkeTU{^ic=Ub S+>N[R2tN{:ieܞI펧;foC̞I[|Kp71vUGT)F㴲1ůaK@Y1:䗹kePr/Um7m񠼚RUb? Z/t>wX* J)wZҀ}A[K9s.U腎"`̽.N?{?_^H\p?#x9^:^ZG<QTɲ躸z!ѻgfӭf捀9,獈y~3)ۄBqܹ~ YC_h1`!<&Dޑ{"Q3 \PPn xY}TU?fvgFWUpev]BY,% &]sѤmE?ꏨ rC$6[k-S2A`Hv5޽8Y7wsǻ YEh)OP\a8JQ@h(`ug2#% T*<ٸm#lmM^!A gAҟY8~[!﵂LTiɫI^g3+9*Z*ZYb+{,]v>J)Q؅sFXҪ\kǠ\T:eu46 Cc=1X $%Icq j0c\VoeqY.d%hsVw9=h\zGƪ%R]K)Ǜh[T'(oLh`eF`7XLh,nZ j07 ~z0m 6dИI,aYc&>[%aT-gk׹f@c2'`֊x|oϘvF;nE˙ABb]'w7|F1DP8C'p~tcYOŷX>xцWq!yēxe TxBP!`|}ӯ⺀k4R+T j1Խb9z2>AOQz*>d&v'l27vjݛʦS 2%DM3J~z=/(IZbI)Qq~D}G4VdXuNJpqCR)>1X-@ !-Z-Ƶ͈a+V2V V!1{>O U1?eHW&*)fF?V|)T:$b?V Q jXXx_R\Ɂʗǿ{Qg~E>r|rUKs-P' uinmouE7]]Rtf u]چ(E)bG$,-wzA;u$V^\l:ȿ@NXxVÍj]C!]p kkB8X=69X<]{ȃ=` +D /5ȠB>,x|ܔ5S8sG1d;~Ι0 09EHiyzv$8#_P7^O\”=TYBͩtΗ5'9y/לdzd4~ͲNfvB9wrtz3%5qLz$Znj OW/ O{(lvwp~OG:ы7_v},ɵ}2ہrԌF;GRG{ݣβ" O_᜜[9uv @RL IP NS ZT% ,ЌΦ ifZm[[%+e23F3\-Bn5͆[ h6tOd#wj0*4lff4bՀf['~\H3ͭzAhn-ȺE˅43Ylf#ffC7on#H-˅4e^emXuJɇdYt(pzao;utxio:=Gd"ZE*:V2kVj@Z jbcjV۱zhXX}wZ81ZǬuX'h։cuZuk]8ZWuX1Z1kŎU**qVJUEZUǪUgc5jVӱ""֊VZ4MsFkk+ԖkG*X.Dd:~,<  C A? 2h&Dޑ{"Q3D`!<&Dޑ{"Q3 \PPn xY}TU?fvgFWUpev]BY,% &]sѤmE?ꏨ rC$6[k-S2A`Hv5޽8Y7wsǻ YEh)OP\a8JQ@h(`ug2#% T*<ٸm#lmM^!A gAҟY8~[!﵂LTiɫI^g3+9*Z*ZYb+{,]v>J)Q؅sFXҪ\kǠ\T:eu46 Cc=1X $%Icq j0c\VoeqY.d%hsVw9=h\zGƪ%R]K)Ǜh[T'(oLh`eF`7XLh,nZ j07 ~z0m 6dИI,aYc&>[%aT-gk׹f@c2'`֊x|oϘvF;nE˙ABb]'w7|F1DP8C'p~tcYOŷX>xцWq!yēxe TxBP!`|}ӯ⺀k4R+T j1Խb9z2>AOQz*>d&v'l27vjݛʦS 2%DM3J~z=/(IZbI)Qq~D}G4VdXuNJpqCR)>1X-@ !-Z-Ƶ͈a+V2V V!1{>O U1?eHW&*)fF?V|)T:$b?V Q jXXx_R\Ɂʗǿ{Qg~E>r|rUKs-P' uinmouE7]]Rtf u]چ(E)bG$,-wzA;u$V^\l:ȿ@NXxVÍj]C!]p kkB8X=69X<]{ȃ=` +D /5ȠB@6789:;<=?^PBCDEFGHIJKLMNO`RSTUVWXYZ[\_va{cdefghijklmnopqrstuw|yzRoot Entry$ F`<#$*Data WordDocument#/ObjectPool&#`<#_1043427640 F##Ole PRINTXCompObjf  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKMNOQRSTUVYZ[\]^_`abcdefghijkmpqrtuvwxy|% '   ''  ' ' Arial- 2 'time (minutes)G.G...*'2 utemperature (Celsius).G.....<.*.* 2 p0. 2 p20.. 2 1. 2 25.. 2 >2. 2 >27.. 2 3. 2 29.. 2 4. 2 35.. 2 s5. 2 s43.. 2 6. 2 56.. 2 A7. 2 A58.. 2 8. 2 60.. 2 9. 2 65.. 2 v10.. 2 v68..' FMicrosoft Excel WorksheetBiff8Excel.Sheet.89q  A\pWil and Dan Seyer Ba=f =--<X@"1Arial1Arial1Arial1ObjInfo WorkbookSummaryInformation( LDocumentSummaryInformation8PArial"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)                + ) , *  " ` Sheet11time (minutes)temperature (Celsius)x 0o0@bb$b@ 0b.db10dbXbMbఁԉ@ Nbb0b1.0F^0<6b WXb(AbLbVl]i Ir0FbbFbb&:O|bPS0Dbt006b>N^n00b 00Ԣ0bbb0bPbtb0bbPercent0]db|0\e0\ZT00ZT0_T0=l0Te0T0T|?b 0|)bb@NJT0e0YT0L0YT0LNJT0bbk0 $bȆ04bbbC0bbbbc0G0  A  dMbP?_*+%MCompaq A1500` odXX D Compaq A1500USB-Compaq_A1500X"dXX??U} }  T0bbbb  N   4@?9@@;@@=@@A@@E@@L@@M@  @N@ "@@P@ $@Q@>@  ZOh+'08@\x Wil and Dan SeyereWil and Dan SeyereMicrosoft Excel@Z՜.+,D՜.+, PXt | personal use itemsh  Sheet1  Worksheets 6> _PID_GUIDAN{404F46BE-DB62-4300-9DC5-182C6AF1DC74}_1043430253 F#Pv#Ole WPRINT XCompObjlf% z'   ''  ' ' Arial- 2 (time (seconds)G.*.*...*'2 Temperature (Celsius)4.G.....<.*.* 2 p"0. 2 p20.. 2 "5. 2 21.. 2 > 10.. 2 >20.. 2  15.. 2 23.. 2  20.. 2 65.. 2 s 25.. 2 s29.. 2  30.. 2 28.. 2 A 35.. 2 A26.. 2  40.. 2 35.. 2  45.. 2 39.. 2 v 50.. 2 v12.. 2  55.. 2 37.. 2 D 60.. 2 D88.. 2  65.. 2 46.. 2  70.. 2 47.. 2 y 75.. 2 y48.. 2  80.. 2 49.. 2 G 85.. 2 G25.. 2  90.. 2 76.. 2  95.. 2 88.. 2 |100... 2 |90..' FMicrosoft Excel WorksheetBiff8Excel.Sheet.89qZOh+'08ObjInfonWorkbook5?SummaryInformation(oDocumentSummaryInformation8s  A\pWil and Dan Seyer Ba=f=--{ <X@"1Arial1Arial1Arial1Arial"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)                + ) , *  " ` Sheet11time (seconds)Temperature (Celsius)x 0T0bb & bbb  0T0   bbIr0 bb  0 0|b6( S0Dbt00+^n00b 00Ԣ0bbb0b( btb0bbPercent0]db|0|0dbax0\XT0\e0\ZT00ZT0_T0=l0Te0T0T|?b 0|)bb@NJT0e0YT0L0YT0LNJT0bbk0 $bȆ04b4b4bC0(bbb趉bc0趉G04  A  dMbP?_*+%MCompaq A1500` odXX D Compaq A1500USB-Compaq_A1500X"dXX??U} I } $T0bbbb   T0   bb 0 0  4@@5@$@4@.@7@4@@P@9@=@>@<@A@:@ D@A@ F@C@ I@(@ K@B@ N@V@@P@G@Q@G@R@H@T@H@@U@9@V@S@W@V@Y@V@0>@ @\x Wil and Dan SeyereWil and Dan SeyereMicrosoft Excel@t/Z՜.+,D՜.+, PXt | personal use itemsh  Sheet1  Worksheets 6> _PID_GUIDAN{ED0673D6-810E-4A0F-9D9A-038AD5F88EB5} FMicrosoft Excel WorksheetBiff8Excel.Sheet.89qZOh+'08@\x Wil and _1043430166  FPv#Pv#Ole zPRINTA CompObj{f h{N  H   ''  Arial---Arial-Arial----------------"System-'- -'- - "-  $gg "- "---'--- g Y"  g  g9 9 ge e ggggg---'---  Y"  "- gg---'---  "- -  9 9 e e g    uugg---'--- is!!---'--- ---'--- } - "-  %    I x p T F : . 5# % 5# M d |    ! P   %    ; j     } s 'h % 'h ?\ VO n@ 1 !    B qx O % O &  - \ t z b I /    0% % 1 < H ` nw E    l B 4 @ K W c o z   y*% y o e \ U N H = 6 07 ,N *e (} ( & % #  % 9 h    % < T k   %      |l?Lo+ %+ZhFXuG - $  "   ---'---  }# 5 $5 J# 58 # 5 ---'---  }  $     ---'---  }h ' $'S <h '} h 'S ---'---  }O  $: O d O : ---'---  }  $ .    ---'---  }y  $ d y } y d---'---  }  $   0  ---'---  }  $   n  ---'---  } $---'---  }Gu $u2Gu\`Gu2---'---  }---'---  ---'---  ------'---  )i+  H2 9+Time vs. Temperature plot of Experiment 15 =Y868=8Y=8'8!='8==!=!C8=8'Y8=!88----'---  ---'---  ----'---    2 ~D03 2 1033 2 2033 2  3033 2 / 4033 2 [5033 2 6033 2 7033 2 8033---'---  ---'---    2 03 2 23 2 43 2 y 63 2 j 83 2 B1033 2 41233---'---  ------'---  & I  2 V time (minutes)R3R8833----'---  -----'---  L d Arial-2 ? ytemperature (Celsius)-----'---  - "- -   Y" ---'---  X# ---'---  X#  "- g  g g Y- $YR ng Y| Dg YR  '2 4 temperature (Celsius)3M33333B3.3.---'---   X# ---'---  ---'---  -- '  '  'ObjInfo}WorkbookQSummaryInformation(~DocumentSummaryInformation8  A\pWil and Dan Seyer Ba=f =#<X@"1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)                + ) , *  " ` J Sheet\Sheet11time (minutes)temperature (Celsius) GXHGbb9u0  b 0nbTbܸAnbpbܸAAhb[Ir0bbbܸAAb[DS0Dbt00(bdbT0^n00b 00Ԣ0bbb0bDbtb0bpbPercent0]b0bb bΝ0\b0ZT0_T0=l0Te0T0T|?b 0|)bb@NJT0e0YT0L0YT0LNJT0bbk0 $bȆ04bE=s0{=s0:0b 02 w0 hbb b0bb0  AMCompaq A1500` odXX D Compaq A1500USB-Compaq_A1500X"dXX??3` 4#` 4#` 4#` 4#t}93;dd  3Q: .temperature (Celsius)Q ; Q ; Q3_4E4D $% M 3O&Q4$% M 3O&Q4FA+0 D 3Os T 3*#M43*#M! M4% M3O=&Q  time (minutes)'4% 6mMZ3O]&Q .temperature (Celsius)'4523  O43d"  3O % M3OQ443_ M NM ] MM<444% QM03O&Q Z+Time vs. Temperature plot of Experiment 15 '44 e?@@@@@@ @ "@ $@e4@9@;@=@A@E@L@M@N@ @P@ Q@e> ;d  A  dMbP?_*+%"??U} }  T0bbbb   T0  4@?9@@;@@=@@A@@E@@L@@M@  @N@ "@@P@ $@Q@>@  Dan SeyereWil and Dan SeyereMicrosoft Excel@Z՜.+,D՜.+,8 PXt | personal use itemsh  Sheet1Sheet  WorksheetsCharts 6> _PID_GUIDAN{F910A1EB-3F13-42FB-BA78-475260D53431} FMicrosoft Excel ChartBiff8Excel.Sheet.89qZOh+'08@\x Wil and _1043434468 FPv#Pv#Ole CompObj bObjInfoWorkbook!b'SummaryInformation("DocumentSummaryInformation81Table~  ABa=f#=hL,8X1zArial1zArial1zArial1zArial1zArial1zArial1zArial1zArial1zArial1zArial1zArial1zArial"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)                + ) , *  " 3 GRAPH1Sheet1 SheetZtime (minutes)temperature (Celsius)time (seconds)Temperature (Celsius)  b0Ir0bbS0Lbt00^n00b 00Ԣ0bbb0bbtb0bpbPercent0] bΝ0\b0ZT0_T0=l0Te0T0T|?b 0|)bb@NJT0e0YT0L0YT0LNJT0bbk0 $bȆ0& Q  time(seconds)'4% 4hOMZ3O_& Q .temperature (Celcius)'4523  O43d" 3_ M MM  MM<444% MYM03O& Q \,Time vs. Temperature plot with Best Fit Line'4% @M 3O~&WQ'44e@$@.@4@9@>@A@D@ F@ I@ K@ N@ @P@Q@R@T@@U@V@W@Y@e4@5@4@7@@P@=@<@:@A@ C@ (@ B@ V@ G@G@H@H@9@S@V@V@e>   A  dMbP?_*+%"??U} } $lԋbbbbbbbb   b0bbblbtime (minutes)temperature (Celsius)4@?9@@;@@=@@A@@E@@L@@M@  @N@ "@@P@ $@Q@time (seconds)Temperature (Celsius)4@@5@$@tur D~ 4@.@ D~ 7@4@ D~ @P@9@ D~ =@>@ D~ <@A@ D~ :@D@ D~ A@F@ D~ C@I@ D~ (@K@ D~ B@N@ D~ V@@P@ D~ G@Q@ D~ G@R@ D~ H@T@ D~ H@@D==11111111111111 lԋ!"b#b @U@! D~ 9@!V@" D ~ !S@"W@# D!~ "V@#Y@ D"~ #V@ <111> @#  AMCompaq A1500` odXX D Compaq A1500USB-Compaq_A1500X"dXX??3` 4#` 4#` 4#` 4#0 0 3d  3Q: .temperature (Celsius)Q ; Q ; Q3_4E4D$% M 3O&Q4$% M 3O&Q4FA7 3O  3*#M43*#M! M4% M3O@&Q  time (minutes)'4% 4hOMZ3O_&Q .temperature (Celsius)'4523  O43d"  3O % M3OQ443_ M MM ] MM<444% MEM03O&Q Z+Time vs. Temperature plot of Experiment 15 '44 e?@@@@@@ @ "@ $@e4@9@;@=@A@E@L@M@N@ @P@ Q@e>  Dan SeyereWil and Dan SeyereMicrosoft Excel@Z՜.+,D՜.+,D PXt | personal use itemsh  Sheet1GRAPH1Sheet  WorksheetsCharts 6> _PID_GUIDAN{F910A1EB-3F13-42FB-BA78-475260D53431}Oh+'0 , H T ` lx#Using Microsoft EXCEL for graphingrsinWil and Dan SeyerCEil Normal Sandhya Gavvaye2ndMicrosoft Word 10.0@RaγΓiQ#Hsǒb랡dxr eyZ"]OLLVsB2Њ5ㇱo~dMi#yˌQmʭ_+^ڕ1&MI/jTRU/ *cj^TQ랪 9Ufo&/U6OF|rPRuPH>cFTm3f3F6*xEo6T5McWp{AG]/U\5%Q`鏪qSeh0VɧL/UZydnkeTU{^ic=Ub S+>N[R2tN{:ieܞI펧;foC̞I[|Kp71vUGT)F㴲1ůaK@Y1:䗹kePr/Um7m񠼚RUb? Z/t>wX* J)wZҀ}A[K9s.U腎"`̽.N?{?_^H\p?#x9^:^ZG<QTɲ躸z!ѻgfӭf捀9,獈y~3)ۄBqܹ~ YC_h1SummaryInformation(%DocumentSummaryInformation8LCompObjj@r5<@` #@` #C՜.+,0 hp  personal use itemf{ #Using Microsoft EXCEL for graphing Title8@8 Normal_HmH sH tH DAD Default Paragraph FontVi@V  Table Normal :V 44 la (k@(No List DC@D Body Text Indent ^88;"56:;xygh      78`a0000 000000000000000000000000000 0<;0<;0<;0<;0<;0<;0<;0<;0<;0<;0<;0<;0<;0<<;0p <;0 h::35;::/X2$REӌ ^#9"2$&Dޑ{"Q3D(@N(    V  C A ?"V  C A ?"B S  ? s+(48u&Y4 _1043427640 _1043430228 _1043430253 _1043430166@@@@ %ejMR @ H $3U33Wil and Dan SeyerWil and Dan Seyer UT DALLAS Sandhya Gavva:Bu 0^`0o(.:Buf=L@`@UnknownGz Times New Roman5Symbol3& z Arial"1hlJ&lJ&cR&CCY243H?f="Using Microsoft EXCEL for graphingWil and Dan Seyer Sandhya Gavva   FMicrosoft Word Document MSWordDocWord.Document.89q