Excel Instructions: Hypothesis Testing for the Population Mean

To open Excel with the data in the worksheet, click here and it will automatically download the file to your computer. Find the downloaded file (usually in the Downloads folder) and double-click it to open it in Excel.

To carry out the test using Excel, we need to find the value of the test statistic (t), which we calculate using


Before we can do this, we first have to calculate the values for each of the variables in the equation: