C02_CIs - Chem 227F 2010 C2: Confidence Limits Due...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Chem 227–F 2010 C2: Confidence Limits Due Thursday, September 9 Objective: Solidify your understanding of how Student’s t values and degrees of freedom are used to determine confidence intervals at specific levels of confidence. Also, learn how to use the lookup function in Excel. Data for this assignment are in the file Balance_test.xls ; it contains data from the calibration of a balance and the t-table from the textbook. From the data for the 50-g standard, calculate the mean and standard deviation, then use the function LOOKUP to get t values from the table and calculate the 50%, 90%, 95%, 98%, 99%, 99.5% and 99.9% confidence intervals. Present your results in a table. (Data are also given for a 0.1000 g weight; you do not need to do the same calculations for these data—they are used in question 2 below.) You must do this assignment with the LOOKUP function, but you may find it interesting to compare your results with other functions for calculating confidence intervals.
Background image of page 1
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.

Ask a homework question - tutors are online