CH118 General Chemistry IICourse Information
The data sets are available as a tab-delimited text file (txt file). This file can be opened by many different spreadsheet programs (such as Excel).
To obtain a copy of the file:
Right-click on the link for the unknown assigned to you. Select "Save link as..." Note the location where this file will be saved.
To open the file in Excel:
Start Excel. Open the file using the open command. A dialog box will ask you a couple of questions and you are ready to go. (or you can open the link and cut-and-paste the data into an open Excel file)
Formulas you will need for Excel:
To convert a column of concentration data, [C], to ln[C]:
Select the target cell, then in the equation box at the top type:
To convert a column of concentration data, [C], to 1/[C]:
Select the target cell, then in the formula bar type:
Example: We have data in column A. We would like to use the natural logarithm of the values in A, so we click in B1 and enter the formula in the formula bar as shown. When you hit enter, the result of ln(2), should be visible in B1.
To repeat the calculation in all of the cells below B1. Click on the small black square on the lower right-hand corner of B1 and drag down until you reach the end of your data set.
Another handout on