Exp 1 help, graphs, etc.

[robert zellmer]

*Exp 1 (SOL) - 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.  Look
at my "exp 14" example to see how to do some things or watch the
video for the pre-lab again.  Plus, you went over how to use Excel
in lab last week so much of this should simply be a reminder.
Please note a couple of things:

     1) You can use Excel to do the calculations and make the data
          tables.  Program in the proper equations and let Excel do the
          calculations for you (of course you can do them by hand and
          just input the values).  You can then import the tables into
          the Word doc you get from the template on Carmen.

     2) Part A data (obtained in lab) and Day 2 data (given to you) 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 
for the
         mixed solvent).

         Part B is a separate set of data and should be a separate 
line.  Again,
         use a non-linear best-fit line.

         You can make your table look like the ones you used during lab, 
rather
         than the ones in my example.  Set your s.f. in the table first 
before doing
         the graphs and the axes should then have the correct s.f.

     3) 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 for 
this exp.  Look
         at the curve I used for the fit.  If you have good data it 
should look something
         like the data and lines on my example so an exponential fit 
like what
         I used should work.  If a different type of best-fit curve work 
better
         use it, as long is it gives a nice "smooth" fit (doesn't appear 
"wavy").

     4) If you have a point which seems to be out of place you should 
include
         it on the graph but not in 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.

     5) 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 9.  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 1 
Help File"
about this section.

Dr. Zellmer
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osu.edu/pipermail/cbc-chem1220/attachments/20180618/f3798df3/attachment.html>