How To Run Statistical Tests In Excel

In this Article we will learn to run the Statistical Tests in Excel:

Let us start adding the add-in Analysis ToolPak to the Excel file.

Click File > Options > Add-Ins.

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.

Analysis toolpak

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.

statistical tests sample data

Select the data and start the analysis, correlation first.

correlation

Results of correlation tests:

results of correlation

Let us run the Multiple Regression now:

regression

Results look like this:

regression statistics

And more statistical tests available in descriptive statistics Excel tool.

descriptive statistics

Similarly we can perform all other analysis like: anovahistogram, moving average, Sampling, t-test etc as per the requirements.

anova summary

Anova statistical tests are ready as well.

Template

You can download the Template here – Download
Previous articleExcel IFERROR Function: Error Handling Essentials
Next articleExcel Text Box Linking: Dynamic Data Presentation