The Chi-Square test is a statistical test used to determine if there is a significant association between two categorical variables. In this Excel tutorial, you will learn how to calculate the Chi-Square test in Excel.

Read More

Anova means Analysis of Variance. In this Excel tutorial, you will teach yourself how to perform Anova.

Read More

If we take samples from two populations and wish to ascertain whether the variations of both samples are equal, we can use the Variation Ratio test also known as the F-Ratio test to determine this.

Read More

In this Excel tutorial lesson, you will learn what skewness is and how to calculate skewness in Excel application.

Read More

In this Excel tutorial lesson, you will learn how to find the largest number, whether negative or positive, in a range of values. This is not obvious, but you need just one formula.

Read More

Quartiles are used to divide a set of data into four equal parts. In this Excel tutorial, you will teach yourself how to calculate quartiles.

Read More

You probably want to know how to calculate probability with Excel. You’ll learn how to calculate probability in Excel using built-in functions like PROB, as well as how to handle more complex scenarios such as dice rolls, coin flips, and poker hands.

Read More

Excel has got many features connected with statistics. For examples Excel could help you to calculate binomial distribution (aka bernoulli distribution).

Let’s learn how to do it in this easy steps.

Read More

Mode is the most frequently occurring number in a given data set. To calculate the mode in Excel you need to use dedicated Excel function as I am trying to show you below.

To learn how to calculate the mode in Excel, follow the steps below. We are going to use dummy data.

Read More

A rolling average is a type of moving average that calculates the average of a set of data points over a specified period. The period can be fixed or variable, and it is typically used to smooth out fluctuations in the data.

Read More