Experiment0

# Experiment0 - CHEM 241L: Statistics, Data Analysis, and...

This preview shows pages 1–3. Sign up to view the full content.

CHEM 241L: Statistics, Data Analysis, and Basic Lab Skills 20 0 Experiment 0 Statistics, Data Analysis, and Basic Lab Skills Read Chapters 3 and 4 & Appendices B and C in “Quantitative Chemical Analysis”, 7 th ed. By D. C. Harris. Hereafter, this text will be simply referred to as Harris. BACKGROUND One of the skills that you will learn this semester is the application of statistics to the treatment of data. In many of the experiments performed this semester students will report the mean, standard deviation, and percent relative standard deviation (% RSD) for data that you acquired experimentally. Another tool which you will learn to use over the course of this semester is the application of spreadsheets to the analysis of experimental data. Spreadsheets are indispensable and have become an essential tool for manipulating quantitative information. We have chosen Microsoft Excel as the primary spreadsheet software program for this lab. Spreadsheets are very useful for displaying data graphically, organizing data, and performing repetitive calculations. EXPERIMENTAL EXERCISE 1: Statistical Analysis of Filter Paper This experiment involves a series of exercises designed to teach you how to statistically analyze data. In this exercise you will use a laboratory balance to record the mass of 10 different pieces of filter paper. There should be a beaker labeled Experiment 0 next to the balances containing 20 numbered pieces of folded filter paper. Make sure you use 10 different pieces of filter paper, recording the mass of each next to the number in your lab notebook. Reading Assignment

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
CHEM 241L: Statistics, Data Analysis, and Basic Lab Skills 21 DO NOT forget to tare your balance before making your measurements. • All the filter paper came from the same package and lot. For this exercise you will use Microsoft Excel to evaluate your paper data and subsequently compare your data to a population of filter paper masses provided to you. If you have never used Microsoft Excel before a tutorial has been provided below to help you set up an Excel spreadsheet and show you how to perform calculations within the spreadsheet. Open a new workbook in Excel and enter the following information in the upper left corner of the spreadsheet: Experiment 0: Statistical Treatment of Data Your Name Chemistry 241L T h e D a t e Your Section Number Your TA’s Name Enter the paper masses obtained in lab into your spreadsheet below the above personal information and calculate the average and standard deviation for the data set. For this exercise only you will not be allowed to use the standard deviation ( STDEV ) or average ( AVERAGE ) functions. Instead, you will set up your spreadsheet such that you can report the values obtained from each of the mathematical steps that would be involved in calculating either the average or standard deviation, as illustrated in Figure 1. For example, one of the first steps involved in calculating a standard deviation is to calculate the difference between the average (
This is the end of the preview. Sign up to access the rest of the document.

## This note was uploaded on 01/03/2009 for the course CHEM 241 taught by Professor Tiani during the Spring '08 term at UNC.

### Page1 / 10

Experiment0 - CHEM 241L: Statistics, Data Analysis, and...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online