Analysis ToolPak

A collection of 9 posts

How To Use t-Test In Excel

This example teaches you how to perform a t-Test in Excel. The t-Test is used to test the null hypothesis that the means of two populations are equal. Below you can find the
28 October 2020

How To Use F-Test In Excel

This example teaches you how to perform an F-Test in Excel. The F-Test is used to test the null hypothesis that the variances of two populations are equal. Below you can find the
25 October 2020

How To Use Moving Average In Excel

This example teaches you how to calculate the moving average of a time series in Excel. A moving average is used to smooth out irregularities (peaks and valleys) to easily recognize trends. 1.
25 October 2020

How to Use One-Way Anova In Excel

This example teaches you how to perform a single factor ANOVA (analysis of variance) in Excel. A single factor or one-way ANOVA is used to test the null hypothesis that the means of
24 October 2020

How To Use Correlation In Excel

The correlation coefficient (a value between -1 and +1) tells you how strongly two variables are related to each other. We can use the CORREL function or the Analysis Toolpak add-in in Excel
24 October 2020