PChem Teaching Lab

Using Excel 2010 - Mean (with associated Error)

*If Data Analysis... is not present under the Data tab, it will need to be added by following these instructions.

To calculate the mean (with associated error) on a set of multiple measurements, use the following procedure:

Select a new worksheet.
Enter the following data into Column A of the sheet. Note that the data title should be entered into Cell A1, with the data values being entered into Cell A2 downwards.
Temp/^oC 25.0 24.8 25.3 23.9 26.0 25.5 24.6

1. Select the Data tab and click on Data Analysis*.

2. Select Descriptive Statistics then click OK.

3. Make sure the flashing cursor is in the window to the right of Input Range:

4. Highlight the cells containing your data by clicking and dragging the mouse from cell A2 to the end of your data. The cell addresses of your data should appear in the window to the right of Input Range:

5. Under Output options, click on the circle to the left of Output Range:

6. Make sure the flashing cursor is in the window to the right of Output Range:

7. Click on the cell C1 in the spreadsheet. This address should appear in the window to the right of Output Range:

8. Then click on the box to the left of Summary statistics and the box to the left of Confidence Level for Mean.

9. Click OK.

Your spreadsheet should look like that shown opposite.
We are interested in the Mean and Confidence Level (95%) results. Remember, the Confidence Level (95%) is our estimate of the error on the mean.

Regression Analysis

Using Excel 2010 - Contents Page

1.	Select the Data tab and click on Data Analysis*.
2.	Select Descriptive Statistics then click OK.
3.	Make sure the flashing cursor is in the window to the right of Input Range:
4.	Highlight the cells containing your data by clicking and dragging the mouse from cell A2 to the end of your data. The cell addresses of your data should appear in the window to the right of Input Range:
5.	Under Output options, click on the circle to the left of Output Range:
6.	Make sure the flashing cursor is in the window to the right of Output Range:
7.	Click on the cell C1 in the spreadsheet. This address should appear in the window to the right of Output Range:
8.	Then click on the box to the left of Summary statistics and the box to the left of Confidence Level for Mean.
9.	Click OK.
Your spreadsheet should look like that shown opposite. We are interested in the Mean and Confidence Level (95%) results. Remember, the Confidence Level (95%) is our estimate of the error on the mean.