<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<font face="Times New Roman">I'm still getting questions about doing
the data tables<br>
in Excel and the data tables (used to be referred to as report<br>
sheets) from the manual and what to do with each. Here's<br>
two scenarios and what to do in each case. I sent something<br>
out which was similar to this but here it goes again since I'm<br>
still getting questions.<br>
<br>
1) You use Excel to make the data tables and do the calculations
<br>
in the tables (and graphs when necessary). If you make
the <br>
Excel sheets look like the report template data tables
(headings,<br>
units, correct s.f., readable, etc.) you can simply
transfer them into<br>
your Word document from the template. There is no need<br>
to copy all the data over to the data tables in the
manual.<br>
You are just wasting time. Then delete the blank data
table in<br>
the template.<br>
<br>
It's easy enough to make your Excel sheet look like the
data<br>
tables in the report template by simply copying the
headings<br>
from the tables in the template into Excel.<br>
<br>
2) You use Excel to simply do the calculations and/or the graphs
<br>
but transfer all the data to the report template data
tables because<br>
you don't want to bother making the Excel sheets look like
the <br>
template data tables or bother with setting the proper
s.f. in Excel.<br>
In this case you can copy and paste the data from Excel
one<br>
piece at a time to the template data tables or simply type
them in.<br>
<br>
You do not have to use Excel (or similar program) for graphs.
However, <br>
if you don't, you need to use actual graph paper with lots of grid
lines. <br>
The notebook pages won't suffice. Doing it "freehand" on a piece
of <br>
printer paper will receive zero points. If doing it on graph
paper you will <br>
need to use a ruler if making a linear best-fit line. If you need
the slope <br>
you will need to do calculations by hand for each and every
best-fit line <br>
using points from the line and show those calculations. Then of
course<br>
you would need to scan this graph (or take a picture) and include
it in<br>
your Word doc.<br>
<br>
When using Excel to do best-fit lines (curves) you should print
the equation<br>
for the line and the R<sup class="moz-txt-sup"><span
style="display:inline-block; width:0; height:0;
overflow:hidden">^</span>2</sup> (correlation coefficient)
values. If it is a linear fit and<br>
you need the slope you will use the slope produced by Excel.
However, <br>
you need to show a sample calculation for slope using points from
one <br>
of the best-fit lines. <br>
<br>
I will warn you now about exp 3 (DRL). If you don't use Excel or
a similar<br>
program it will take you a very long time to process the data.
You will<br>
have 3 data tables with at least 15 time and absorbance data
pairs. Then<br>
you will have at least 60 calculations for each solution (at least
180 total<br>
calculations). This will produce a table with 90 data values for
each solution<br>
(at least 270 total values). For exp 3 you have to make the data
tables using<br>
Excel anyway. Also, if you make a calculation error (which you
don't often<br>
realize until you do the second graph, the zero-order graph) it is
much easier<br>
to fix it using Excel (assuming you've programed your Excel tables
to do the<br>
calculations) than to redo all the calculations by hand. <br>
<br>
Dr. Zellmer </font>
</body>
</html>