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:
-
T-test for two means
-
F-test for two variances
-
Z-test for two proportions
-
T-test for paired differences
-
T-test for correlation
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