Excel Statistical Functions

How to use MAX function in Excel (6 Examples)

There are several statistical functions in Excel to help you perform your desired tasks easily and swiftly. Today we are going to show you how to use ...

How to use COUNTBLANK function in Excel (3 Examples)

Excel provides several statistical functions to help you perform tasks easily and swiftly. Today we are going to show you how to use a statistical ...

How to use AVERAGE function in Excel (5 Examples)

Excel provides several statistical functions to help you perform tasks easily and swiftly. Today we are going to show you how to use a statistical ...

How to Use SMALL Function in Excel (4 Common Examples)

In Microsoft Excel, the SMALL function is generally used to extract the nth lowest or smallest value from a range of cells containing numerical data ...

How to Use MIN Function in Excel (5 Relevant Examples)

In Microsoft Excel, the MIN function is generally used to extract the lowest or smallest value from a range of cells containing numerical data only. ...

How to Use LARGE Function in Excel (6 Easy Examples)

When we need to find a specific largest value, like the 2nd or the 3rd biggest number in any dataset. The Excel’s LARGE function returns numeric ...

How to Use COUNTIFS Function in Excel (4 Examples)

Today I will be showing how you can use the COUNTIFS function to count the number of cells satisfying one or more criteria from any range of cells in ...

How to Use COUNTIF Function in Excel (10 Suitable Applications)

In Microsoft Excel, the COUNTIF function is widely used to count cells with a given condition or criterion. In this article, you’ll get to learn how ...

How to Use AVERAGEIFS Function in Excel (4 Examples)

Today I will be showing how you can use the AVERAGEIFS function of Excel to calculate some averages while maintaining one or more criteria in Excel. ...

How to Use COUNT Function in Excel (With 5 Examples)

The COUNT function in Excel helps us to count the number of cells containing numerical values within a given range. This is one of the more popular ...

How to Use COUNTA Function in Excel (3 Suitable Examples)

In Microsoft Excel, the COUNTA function is generally used to count the cells containing the non-empty character(s) only. In this article, you’ll get ...

How to Use RANK Function in Excel (With 5 Examples)

The simplest technique to establish a number's relative position in a list of numbers is to sort the list in descending (from largest to smallest) or ...

The Different Ways of Counting in Excel

There is a total of five functions used for counting, predominantly in Excel. These are namely the COUNT Function, the COUNTA Function, the COUNTIF ...

How to calculate Average, Median, & Mode in Excel

The average of a set of numbers is referred to as the arithmetic mean and it is calculated by adding all the numbers in the data set and then ...

ExcelDemy
Logo