9 Statistical Functions in Excel You Need to Know

Description:

Do you need to data for your business?

If so, you'll want to learn about the different statistical functions Excel has to offer.

In this video, we will take a look at 9 of the most useful statistical functions and see how they can help you get insights into your data.

Each one of these functions can be incredibly helpful in : your data and getting more accurate results! So don't miss out - watch the video now!

Table of Content;

00:00 INTRODUCTION

01:00 AVERAGE Function in Excel

02:40 AVERAGEIF Function in Excel

04:30 MODE Function in Excel

05:45 MIN Function in Excel

06:50 MAX Function in Excel

07:19 LARGE Function in Excel

08:32 SMALL Function in Excel

09:41 MEDIAN Function in Excel

10:30 STDEV Function in Excel

11:50 conclusion

Lets discuss and understand syntax of each and every functions above.

1 Average Function in Excel

This function is used to calculate the average of a given set of numbers. The syntax for this function is =average(cell range).

The average function can be used to calculate the average of a single number or a range of numbers.

Let us understand the syntax of Average Function in excel;

=average(cell range)

Where;

cell range: The range of cells you want to calculate the average of.

This function takes in two arguments. The first argument is the range of cells that you want to calculate the average for, and the second argument is the name of the cell where you want to calculate the average.

2 AVERAGEIF Function in Excel

The averageif function is used to calculate the average of a given set of numbers, but only if a certain condition is met.

The syntax for this function is

=averageif(condition, cell range).

Where;

condition: The condition you want to meet in order for the average to be calculated.

cell range: The range of cells you want to calculate the average of.

The average function takes in two arguments. The first argument is the condition that you want to meet in order for the average to be calculated, and the second argument is the range of cells that you want to calculate the average for.

3 MODE Function in Excel

The mode function is used to find the most common value in a given set of data.

The syntax for this function is

=mode(cell range).

Where;

cell range: The range of cells you want to find the mode for.

This function takes in one argument. The first argument is the range of cells that you want to find the mode for.

This function will return the most common value in the given set of data.

4 MIN Function in Excel

The min function is used to find the minimum value in a given set of data.

The syntax for this function is

=min(cell range).

Where;

cell range: The range of cells you want to find the minimum for.

This function takes in one argument. The first argument is the range of cells that you want to find the minimum for.

5 MAX Function in Excel

The max function is used to find the maximum value in a given set of data.

The syntax for this function is

=max(cell range).

Where;

cell range: The range of cells you want to find the maximum for.

This function takes in one argument. The first argument is the range of cells that you want to find the maximum for.

This function will return the maximum value in the given set of data.

6 LARGE Function in Excel

The large function is used to find the nth largest value in a given set of data.

The syntax for this function is

=large(cell range, number).

Where;

cell range: The range of cells you want to find the nth largest value for.

number: The position of the largest value you want to find.

This function takes in two arguments. The first argument is the range of cells that you want to find the nth largest value for, and the second argument is the position of the largest value that you want to find.

7 SMALL Function in Excel

The small function is used to find the nth smallest value in a given set of data.

The syntax for this function is

=small(cell range, number).

Where;

cell range: The range of cells you want to find the nth smallest value for.

number: The position of the smallest value you want to find.

This function takes in two arguments. The first argument is the range of cells that you want to find the nth smallest value for, and the second argument is the position of the smallest value that you want to find.

8 MEDIAN Function in Excel