In this article, you learn to run the Statistical Tests in Excel.
Adding Analysis Toolpak
Let us start adding the add-in Analysis ToolPak to the Excel file.
Click File > Options > Add-Ins.
From the inactive add ins select the "Analysis toolpak" and from manage select Excel add in and click ok.
Then check these options.
Statistical Test
Now in the data > analysis > Data analysis will be visible which will be used for different types of statistical tests.
Let us create some simple data for analysis.
Select the data and start the analysis, correlation first.
Results of correlation tests:
Let us run the Multiple Regression now:
Results look like this:
And more statistical tests available in descriptive statistics Excel tool.
Similarly, we can perform all other analysis like: anova, histogram, moving average, Sampling, t-test etc as per the requirements.
Anova statistical tests are ready as well.
To use these functions, you need to enter the data into Excel and then enter the appropriate function into a cell, along with the necessary arguments. The syntax and arguments for each function vary, so it's important to consult the Excel help documentation or a statistical reference guide for detailed instructions on how to use each function.