PChem Teaching Lab

Using Excel 2016 - Data Analysis

The spreadsheet is able to perform a number of statistical analysis/procedures for you; many of which are beyond the scope of this course. However, before these can be performed the Data Analysis tool for Excel may need to be added.

1. If Data Analysis is not present under the Data tab,
click File followed by Options.

2. Click on Add-ins on the left of the pop up box.
3. Click Go next to the drop-down menu.

4. Tick the box next to Analysis ToolPak, then click OK.
The Data Analysis option should now be present under the Data tab.

Mean (with associated Error)

Using Excel 2016 - Contents Page

1.	If Data Analysis is not present under the Data tab, click File followed by Options.
2.	Click on Add-ins on the left of the pop up box.
3.	Click Go next to the drop-down menu.
4.	Tick the box next to Analysis ToolPak, then click OK. The Data Analysis option should now be present under the Data tab.