Completing statistical analysis in Microsoft Excel requires multiple steps, including getting the data into the program, activating the statistical analysis functions and determining the confidence interval. Excel includes various statistical analysis functions including equations for calculating critical t-function.
Excel is one of the computer programs included in the Microsoft Office Suite. Versions available in the 95 or later editions allow users to complete basic statistical analyses. There are several steps necessary before a user can calculate a critical t-function.
First, information related to the sample data, such as test scores or percentages of change before or after an intervention, must be added to the Excel spreadsheet. Second, the Analysis ToolPak includes the necessary components for calculating statistical information. Third, users should access the Descriptive Analysis function through the Data Analysis tool in the ToolPak to set the confidence interval. Excel offers default settings for users who do not require specific intervals.
The Data Analysis tool includes a number of t-tests:
- Paired two sample for means
- Two-sample assuming equal variances
- Two-sample assuming unequal variances
Excel requires additional input to determine the t-function:
- Variable ranges
- Labels or names of variables
- Hypothesized mean difference from the null hypothesis
- Alpha, or level of significance
- Output location
Clicking "OK" after all the required information is included will enable Excel to complete the required calculations. Results are provided in a table layout that can be printed or saved for later use.