<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<a
href="http://chemistry.osu.edu/%7Erzellmer/chem1220/lab/exp15.pdf"><b>Exp
1 (SOL) - Example of Data Tables and Graphs Using MS Excel</b></a><br>
<br>
These are simply examples. It doesn't show how to do them. Look<br>
at my "exp 14" example to see how to do some things or watch the<br>
video for the pre-lab again. Plus, you went over how to use Excel<br>
in lab last week so much of this should simply be a reminder.<br>
Please note a couple of things:<br>
<br>
1) You can use Excel to do the calculations and make the data<br>
tables. Program in the proper equations and let Excel do
the<br>
calculations for you (of course you can do them by hand and<br>
just input the values). You can then import the tables
into<br>
the Word doc you get from the template on Carmen.<br>
<br>
2) Part A data (obtained in lab) and Day 2 data (given to you)
are<br>
both in H2O as solvent and are graphed as <b>ONE </b>set
of data.<br>
Make them one set of data in Excel. There should be a
smooth<br>
curve fit. It shouldn't be a straight line in this case (or
for the<br>
mixed solvent). <br>
<br>
Part B is a separate set of data and should be a separate
line. Again,<br>
use a non-linear best-fit line.<br>
<br>
You can make your table look like the ones you used during
lab, rather<br>
than the ones in my example. Set your s.f. in the table
first before doing<br>
the graphs and the axes should then have the correct s.f.<br>
<br>
3) Do <b>NOT </b>draw the lines by hand. There is NO need
to. If you have<br>
decent data <b>Excel </b>should be able to do a pretty
good job at putting<br>
a smooth curve "through" your points. You should NOT have a
wavy<br>
line. You should use a "scatter" graph with no lines and
then fit the<br>
points with a trend line. Use a non-linear best-fit line
for this exp. Look<br>
at the curve I used for the fit. If you have good data it
should look something<br>
like the data and lines on my example so an exponential fit
like what<br>
I used should work. If a different type of best-fit curve
work better<br>
use it, as long is it gives a nice "smooth" fit (doesn't
appear "wavy").<br>
<br>
4) If you have a point which seems to be out of place you should
include<br>
it on the graph but not in the trend line fit. You do this
by plotting all the<br>
"good" points as one set of data and the "bad" point as a
separate data<br>
set. Then you can have Excel draw the trend line for the
"good" points.<br>
<br>
5) Note what is plotted on the x and y axes on graph 2 and the
direction<br>
of curvature for the 2nd graph in my example. You should
have that<br>
same curvature. If you don't (it looks more like graph 1)
you've likely<br>
graphed mole fraction on the y-axis vs. temp. on the x-axis
(reversed<br>
from what you should have).<br>
<br>
Also, someone asked about the "Points to Consider" on page 9. These
<br>
are there to help you with some of the things you should discuss in
the<br>
Results/Discussion section. I've also got some things in the "Exp 1
Help File"<br>
about this section.<br>
<br>
Dr. Zellmer
</body>
</html>