Factorials are widely used in Mathematical analysis. It has a simple calculation in Mathematical perspective and can be applied to real-world phenomena as well. However, factorial calculations can be executed with a simple built-in function in Excel, which is pretty straightforward.

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

In this tutorial, you will teach yourself how to sum only positive or only negative numbers from your range.

Read More

In this Excel tutorial you will teach yourself how to count occurences of a character in a spreadsheet.

Read More

In this Excel tutorial, you will learn how to create a formula which returns the last value in a column.

Read More

In this Excel tutorial, you learn how to generate random text from a list.

Read More

Quartiles are statistical values that divide a sorted data set into four equal parts, with each quartile representing a specific percentile. This Excel tutorial will guide you through calculating quartiles using the QUARTILE.INC function.

Read More