> @B?#`
bjbj5G5G 8(W-W-
V4< $kh!$$9eee4eee:v<.2
ZO0<R"9"""e$$[
d $:RPreLab: Spectrophotometry and Data Analysis Beers Law
Hopefully HYPERLINK "copper%20prelab07.doc" here for the Pre-Lab
Name(Print then sign): ___________________________________________________
Lab Day: ___________________Section: ________TA__________________________
This assignment must be completed individually and turned in to your TA at the beginning of lab. You will not be allowed to begin the lab until you have completed this assignment.
In many of the experiments that you will do throughout the duration of this course you will be asked to analyze your data by making plots and calculating the best fit line through your data. One program commonly used to analyze data in this fashion is Microsoft Excel . The following exercise will help you through the process used to obtain a plot and linear regression for a set of data.
Suppose you go for a 5 mile run and you tabulate the after each mile as in the following table.
Distance Traveled (miles)Time (sec)151021026315484207752612Questions:
Plot the distance traveled in miles vs. the time in seconds.
Use linear regression to obtain a trendline and give the equation obtained in terms of the variables distance traveled and time and the R-squared value. Comment on the meaning of the R-squared value and its significance when doing data analysis.
Using the equation you obtained by doing linear regression, estimate how long the 6th mile will take you to run.
Assuming this linear trend persists, how far have you run if you finish in 2900 sec.
EXCEL INSTRUCTIONS:
In order to plot this data in excel, you should enter the data exactly as above in to column A (rows 1-6) and column B (rows 1-6).
To plot the data you will need to go to Insert on the tool bar and then click Chart. A Chart Wizard will appear. Select XY(Scatter) as the Chart type and choose the sub-type that does not have any lines connecting the points, then click next.
On Step 2, click on the series tab near the top of the screen and click Add.
You do not need to name the series unless you have multiple plots on one graph, but you can type in a name if you wish.
To insert the X data, click on the icon at the far left of the x series box.
Select the x values by clicking on the first one and while the left mouse button is down dragging the mouse down to the last value.
When the values have been selected click the icon again and repeat for the y values. You may also manually enter the values by separating them with a comma. Dont forget you need to remember what units you are using when answering questions.
Click next when you have x and y values entered correctly.
The next step is just entering title information and changing the appearance of your plot; click next when finished.
Choose your chart location and then finish. You now need to place a linear regression line on your plot.
Right click on a data point and pick add trendline.
Choose linear as the type and click the options tab.
Check the boxes to get the equation and R-squared value and click ok.
:DEhijno B
D
#%
ƿhSbhSd0>*\hohSd00JhSd0H*\hSd0B*\phhSd0CJaJhSd0CJ\aJ hSd0\h.hSd0h.hSd05\hSd00J5\!jhhSd05U\jhSd05U\hSd05\hSd0): Sl|kd$$IfTl0 B
t0644
laytSd0T$$Ifa$gdSd0gdSd0gdSd0
vj$$Ifa$gdSd0|kdJ$$IfTl0 B
t0644
laytSd0T$$Ifa$gdSd0vj$$Ifa$gdSd0$$Ifa$gdSd0|kd$$IfTl0 B
t0644
laytSd0Tvj$$Ifa$gdSd0$$Ifa$gdSd0|kdD$$IfTl0 B
t0644
laytSd0Tvj$$Ifa$gdSd0$$Ifa$gdSd0|kd$$IfTl0 B
t0644
laytSd0TJKC
D
%}ululugugggdSd0^gdSd0
&FgdSd0gdSd0|kd>$$IfTl0 B
t0644
laytSd0T%g<2oR
gdSd0gdSd0
&FgdSd06&P1h:pSd0/ =!"#$%DyKFDC:\Documents and Settings\nduval\Local Settings\copper prelab07.docu$$If!vh5 5B#v #vB:Vl
t65 5B/aytSd0T{$$If!vh5 5B#v #vB:Vl
t6,5 5B/aytSd0T{$$If!vh5 5B#v #vB:Vl
t6,5 5B/aytSd0T{$$If!vh5 5B#v #vB:Vl
t6,5 5B/aytSd0T{$$If!vh5 5B#v #vB:Vl
t6,5 5B/aytSd0T{$$If!vh5 5B#v #vB:Vl
t6,5 5B/aytSd0T@`@Sd0NormalCJ_HaJmH sH tH Z`ZSd0 Heading 1$<@&5CJ KH OJQJ\^JaJ V`VSd0 Heading 3$<@&5CJOJQJ\^JaJDA@DDefault Paragraph FontRi@RTable Normal4
l4a(k(No List6U`6Sd0 Hyperlink>*B*phB^`BSd0Normal (Web)dd[$\$t`tSd0
Table GridA:V0a^o!^Sd0Heading 3 Char*5CJOJQJ\^J_HaJmH sH tH ZY@2ZSd0Document Map-D M
CJOJQJ^JaJ
( z z
Y:SJKCD%g< 2
o
R !!!!!!!:v:jv:u::v:jv:u::v:jv:u::v:jv:u::v:jv:u::v:jv:u:!!!!!!!!!!!Ճ!b0!H!Ճ!H!Ճ!
!H!Ճ!Ճ!H!H!H!!!:SJKCD%g< 2
o
R 0000000000 000 000 000 000 000 (0 00 00 00 000 0 0 0 0 0 0 0 0 0 0 0
0 0000 @0@0
@0@0
00
%
Din
X8@0(
B
S ?mv{#&_ d :::%k4)b2;c/Kf^`OJQJo(hH
^`hH.
pp^p`hH.
@@^@`hH.
^`hH.
^`hH.
^`hH.
^`hH.
PP^P`hH.^`phhH.
^`hH.
pp^p`hH.
@@^@`hH.
^`hH.
^`hH.
^`hH.
^`hH.
PP^P`hH.c/
8+ k4) / 0@@00@@0 r -,-qCC:| 5le( @
qe
\r}P
f
`FR],~
y}2H%?N
| IZxHg'&dqrt6 !X!2$
/%''( ()P)[,mp,J/<20Sd012^2k2h3}3N5;57;-8R18~9-8:;;ZA>iM>?!@&AB0B\BWCW^CKDLuDy4EFrFF/FXFHU&I)J9JK*KdMiM?OVOP(PkP#R0*R]JUj
V3V.WxWeYiYjZ&Z^\^3]`l]s]X^@e_F`a-.cke8fBf\fjgKugX1hbhZi<jj+>jFjE kHkpVmsn`#no'oAoPo\pWp!p&
qAtqy;u.vx)7yUyIzizc||e|88n06F/^ZBk&bsSb/%oXX\T.&UOa-OKYt4xBr^B` O].?,SCw-Y[<Xu&5:J:[_a)@j$xbr~-CGIW!Cq asty.B9d(rwy?l(4AN8~g;B]{-U4>LXBRtP&Fi7
\&@8v{HZ@, !L~i{F*DWyw
rY{%?L_t3`+k8J@ lE
@@UnknownGz Times New Roman5Symbol3&z Arial5&zaTahoma"ph/0>
>
$24d 3QHX)?Sd029PreLab: Spectrophotometry and Data Analysis Beer s Law mmchale mmchaleOh+'0( <H
ht
<PreLab: Spectrophotometry and Data Analysis Beers Law mmchaleNormal.dot mmchale1Microsoft Office Word@F#@B\w@>
՜.+,D՜.+,h$hp
Rice:PreLab: Spectrophotometry and Data Analysis Beers Law Title 8@_PID_HLINKSA+=DC:\Documents and Settings\nduval\Local Settings\copper prelab07.doc
!"#$%&'()*+,-.012345689:;<=>ARoot Entry FCData
1Table"WordDocument8(SummaryInformation(/DocumentSummaryInformation87CompObjq
FMicrosoft Office Word Document
MSWordDocWord.Document.89q