# Analysis ToolPak

## A collection of 9 posts

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
This example teaches you how to run a linear regression analysis in Excel and how to interpret the Summary Output. Below you can find our data. The big question is: is there a
27 October 2020
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
This example teaches you how to apply exponential smoothing to a time series in Excel. Exponential smoothing is used to smooth out irregularities (peaks and valleys) to easily recognize trends. 1. First, let&
25 October 2020
You can use the Analysis Toolpak add-in to generate descriptive statistics. For example, you may have the scores of 14 participants for a test. To generate descriptive statistics for these scores, execute the
25 October 2020
This example teaches you how to create a histogram in Excel. 1. First, enter the bin numbers (upper levels) in the range C4:C8. 2. On the Data tab, in the Analysis group,
25 October 2020
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
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
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