This preview shows pages 1–3. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: 1 How to use EXCEL Kinetics Lab EXCEL is a popular spreadsheet software program, which allows a user to perform many kinds of statistical analyses of data. It can perform a variety of mathematical calculations and plot data in a variety of formats. The goal of this tutorial is to familiarize you with the EXCEL software and to practice preparing graphs from reaction rate data. This tutorial information will be useful and applicable to the processing of data in chemistry and other classes. In the START menu of the PC computer, select PROGRAMS and click on Microsoft EXCEL . There are (in general) three different steps when working with EXCEL : Data entry, data analysis and graphing. Step (I): Data Entry Entering the raw data. This exercise will show you how to enter the rate data for the reaction of Brilliant Blue FCF and hypochlorite (found on the next page) . On the spreadsheet, columns are labeled as A, B, C, etc and rows as 1, 2, 3, etc. Each cell (i.e. a rectangular box) is defined by the location of the column and row. For example, the very first cell located on the upper left corner has an address of A1. Before you start entering data, you may want to increase the width of the columns. For example, if you want to increase the width of column A, point the cursor to the letter A and click on the left button of the mouse. The entire column A should now be highlighted. Go to the menu bar and click on FORMAT . Select COLUMN , then select WIDTH . A dialog box will appear. Type in a number that is greater than the original number shown to increase the width of the column. To decrease the width of the column, type in a smaller number. You can always go back and increase the column width anytime even after you enter the data. (Alternatively, you can increase the width of a column by moving the cursor to the edge of a cell until you see the cursor change to a symbol with horizontal arrows. Now holding the mouse left button down, drag the cursor to the left or right to give you the column width that you want.) Now that the columns are of the width you want, it is time to start entering the data. Move the cursor (or cross) to the cell with an address A1 (i.e. the very first cell in the spreadsheet). Type Time. Move the cursor to cell B1 and type Absorbance . These are the labels or titles for each of the columns. Now go to cell A2 and start entering the time data from the table on page 2 of this handout. When you are finished entering the data for time, enter the data for the Absorbance (starting with cell B2 ). When you are done, your spreadsheet should look like the table on page 2. 2 Sample data for the reaction of Brilliant Blue FCF with hypochlorite ( molar absorptivity, for Brilliant Blue FCF 1.38 x 10 5 M cm-1 ) A B C D E 1 Time Absorbance 2 0 1.72 3 30 1.29 4 60 0.87 5 90 0.58 6 120 0.39 7 150 0.25 8 180 0.17 9 210 0.11 10 240 0.073 11 270 0.048 12 300 0.032 0....
View Full Document
- Spring '08