This preview shows page 1. Sign up to view the full content.
Chem 227–F 2010
C5: The tTest
Due Tuesday, October 5
Objective:
Learn to use the ttest to compare the means of two data sets.
You will use two files for this assignment.
One is called
t_table.csv
and the other
is called
compare_means.csv
.
The first file contains Table 42 from the textbook in
comma separated values format.
The second contains two columns of numbers.
Load
both files into your spreadsheet.
Calculate the mean and standard deviation for both columns of data in the
compare_means.csv
file.
Next, determine the highest confidence interval for which the
means of the two columns of data statistically disagree with each other. (This is just what
you will need to do for Lab 3 in testing for drift in your voltage measurements.)
This will
require that you calculate s
pooled
and t
calculated
, and then compare your t
calculated
value with
the ttable.
You may, if you wish, take on the challenge of programming your spreadsheet to
automatically determine the highest CL for disagreement of the values.
However, this is
This is the end of the preview. Sign up
to
access the rest of the document.
This note was uploaded on 03/15/2012 for the course CHEM 227 taught by Professor Stevengoates during the Fall '10 term at BYU.
 Fall '10
 StevenGoates

Click to edit the document details