Today we discuss in this artical use of important excel statistical functions AVERAGE, AVERAGEA, AVERAGEIF, AVERAGIFS, MAX, MIN, LARGE, SMALL & MEDIAN, so please read carefully.
AVERAGE
This formula returns the average of selected range.Syntax
AVERAGE(number1,number2,...)
Example - In this example given employee chart like employee id, employee name & employee salary. Here I want average of salary so lets start function =AVERAGE(C3:C8) then press enter and result display average of salary is 85500.
AVERAGEA
This formula returns the average of selected range, including numbers, text, and logical values.
Syntax
AVERAGEA(number1,number2,...)
Example - In this example given employee chart like employee id, employee name & employee salary. Here I want average of salary including text so lets start function =AVERAGEA(C3:C8) then press enter and result display average of salary is 4000.
AVERAGEIF
This formula returns the average of all the selected cells in a range that meet a given criteriaSyntax
AVERAGEIF(range,criteria,average_range)
Example - In this example given employee chart like employee id, employee name & employee salary. Here I want average of salary with condition, employee "A" salary average so lets start function =AVERAGEIF(B3:B8,"A",C3:C8) then press enter and result display employee "A" average of salary is 666.67.
AVERAGEIFS
This formula returns the average of all selected cells that meet multiple criteria.Syntax
AVERAGEIFS(average_range,criteria_range1,criteria1,criteria_range2, criteria2…)Example - In this example I want average of salary employee "B" and Department "FINANCE" only so lets start function =AVERAGEIFS(C4:C9,B4:B9,"FINANCE",A4:A9,"B") then press enter and result display employee "B" and Department "FINANCE" average of salary is 400.
Microsoft Excel Easy Notes for Beginners
Syntax
MAX(number1,number2,...)
MAX
This formula returns the maximum value in a list of selected cells.Syntax
MAX(number1,number2,...)
Example- In this data we find Max number so start formula -
=MAX(A2:A6) and press enter result display Max no. is 60.
MIN
This function returns the minimum value in a list of selected range.Syntax
MIN(number1,number2,...)
Example- In this data we find Min number so start formula -
=MIN(A2:A6) and press enter result display Min no. is 20.
LARGE
This formula returns the k-th largest value in a data setSyntax
LARGE(array,k)
Example- In this data we find Large number 1 and 2, so start formula - =LARGE(A2:A6,1) and LARGE (A2:A6,2) and press enter result display Large No.1 is 60 and Large No.2 is 50.
SMALL
Syntax
SMALL(array,k)


Example- In this data we find Small number 1 and 2, so start formula - =SMALL(A2:A6,1) and SMALL (A2:A6,2) and press enter result display Small No.1 is 10 and Small No.2 is 20.
MEDIAN
This functions returns the median of the given numbers.
Syntax
MEDIAN(number1,number2,...)RANK
This formula returns the rank of a number in a list of numbers.Syntax
RANK(number,ref,order)
Example- In this data we find Rank of 40, then start formula - =RANK(40,A2:A6,1) here 1 is ascending order, press enter result display Rank of 40 is 3.
Conclusion
I hope you better understand formulas AVERAGE, AVERAGEA, AVERAGEIF, AVERAGIFS, MAX, MIN, LARGE, SMALL & MEDIAN. If any questions and comments so please ask me. We try reply soon.
0 टिप्पणियाँ
Please Submit Own Valuable Comments For This Post