In order to use MS Excel for statistical analysis (like the t-Test or Regression Analysis), you need to make sure that you have the Analysis ToolPak Installed.

This screencast will show you how to install on a PC



Step by step directions for PC:

• To check whether it's already installed, click on the Data tab (shown here circled in red) at the top of your Workbook. If the Analysis ToolPak is installed, you should see the Data Analysis option (shown here circled in green).
  
  
  
  
• If you don't see the Data Analysis option, it should be easy to install the ToolPak using the following directions. If these steps don't work for you, you may need to re-install Excel on your computer in order to make the ToolPak available, though you may want to meet with your professor to make sure before you go through re-installation.

1. Go to the File tab and click on the Options button.
   
   
   
   
2. Click Add-Ins, and highlight the Analysis ToolPak.
   
   
   
   
3. Click Go. When you see the Add-Ins window, make sure the Analysis ToolPak box is checked, then click OK.
   
   
   
   
4. If installation was successful, you should now see the Data Analysis option under the Data tab. Good luck!