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.Continue Reading
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:
Excel requires additional input to determine the t-function:
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.Learn more about Software