Welcome! Register Now to Unlock Exclusive Excel Tutorials
Get Started- Exclusive Playlists
- Downloadable Videos
- No Ads!
- Exclusive Templates
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.