STA 3014 Team Project
Excel Templates for Two Sample and Correlation Test

You may download the Excel workbook Templates2 from this page.  Contained in the workbook are various sheets to perform two sample hypothesis tests and a correlation test:

Simply select the sheet at the bottom of the workbook corresponding to the test you would like to conduct.  The sheet will have a template(s) that requires you to fill-in the appropriate cells.  Cells with red in the upper right corner have explanations -- you can see them when you point your cursor to that cell.  An example screen is shown below:

You are required to carry out your analysis for the project using Excel.  These templates cover the more recent test, therefore, you may also use previous templates and procedures to complete your analysis.

Download Templates2