Fwd: Exp 15 help, graphs, etc. - Reminder
robert zellmer
zellmer.1 at osu.edu
Sun Jan 25 15:08:07 EST 2015
I sent the following out this past Thursday. I'm still getting questions
which the e-mail or the links provided answered.
-------- Forwarded Message --------
Subject: Exp 15 help, graphs, etc.
Date: Thu, 22 Jan 2015 01:30:47 -0500
From: robert zellmer <zellmer.1 at osu.edu>
To: chem1220 at chemistry.ohio-state.edu
CC: chem1220-ta at chemistry.ohio-state.edu
I guess some of you have started your reports for exp 15 since
I've received questions about it.
I have a help file. You will find it by going to the following link,
*Helpful Tidbits for 1220*
<http://www.chemistry.ohio-state.edu/%7Erzellmer/chem1220/faq/faq_1220.htm>
and then clicking on the link for exp 15,
*Exp 15 - Help for Exp 15*
<http://chemistry.osu.edu/%7Erzellmer/chem1220/faq/exp15.txt>
I also have an example of the data tables and graphs for exp 15,
*Exp 15 - Example of Data Tables and Graphs Using MS Excel*
<http://chemistry.osu.edu/%7Erzellmer/chem1220/lab/exp15.pdf>
These are simply examples. It doesn't show how to do them. Please
note a couple of things:
1) *Parts A *and *B *are both in H2O as solvent and are graphed as
*ONE *set of data. Make them *ONE SET *of data in Excel. There
should be a smooth curve fit. It shouldn't be a straight line in
this case (or that for the mixed solvent).
*Part C *is a *separate *set of *data *and should be a *separate line*.
Again,
use a non-linear best-fit line.
2) Do *NOT *draw the lines by hand. There is NO need to. If you have
decent data *Excel *should be able to do a pretty good job at
putting
a smooth curve "through" your points. You should NOT have a wavy
line. You should use a "scatter" graph with no lines and then
fit the
points with a trend line. Use a *non-linear *best-fit line.
*Look at the**
** curve I used for the fit.**
***
3) If you have a point which seems to be out of place you should
include
it on the graph but not the trend line fit. You do this by
plotting all the
"good" points as one set of data and the "bad" point as a
separate data
set. Then you can have Excel draw the trend line for the
"good" points.
4) Note what is plotted on the x and y axes on graph 2 and the
direction
of curvature for the 2nd graph in my example. You should have that
same curvature. If you don't (it looks more like graph 1)
you've likely
graphed mole fraction on the y-axis vs. temp. on the x-axis
(reversed
from what you should have).
Also, someone asked about the "Points to Consider" on page 23. These
are there to help you with some of the things you should discuss in the
Results/Discussion section. I've also got some things in the "Exp 15
Help File"
about this section.
Dr. Zellmer
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.osu.edu/mailman/private/cbc-chem1220/attachments/20150125/a948ed91/attachment.html>
More information about the cbc-chem1220
mailing list