Statistical functions maxa, median, mina, mode, normdist, norminv
Excel Function MAXA
The MAXA() function is used to retrieve the largest value from the supplied set of numbers.
If text string is passed as a parameter, it is considered as 0.
If bool TRUE is passed as an argument, it is considered as 1.
A FALSE is considered as 0.
Values | MAXA() | Formula |
12 | 12 | =MAXA(L4:L5) |
4 | 4 | =MAXA(L5:L6) |
A | 0 | =MAXA(L6,L8) |
True | 1 | =MAXA(L6:L7) |
False | 0.1 | =MAXA(0.1,L8) |
Excel Function MEDIAN
The MEDIAN() function is used to calculate the median value for a given set of numbers.
The median is nothing but the middle value of a series of numbers.
The syntax is as follows:
MEDIAN(num1,num2�num255)
MEDIAN() | Formula |
4 | =MEDIAN(1,4,2,5,90) |
25 | =MEDIAN(10,20,30,40) |
25 | =MEDIAN(20,10,40,30) |
13 | =MEDIAN(11,12,13,14,15) |
3 | =MEDIAN(1,2,3,4,5) |
Excel Function MINA
The MINA() function is used to retrieve the least value from the supplied set of numbers.
If text string is passed as a parameter, it is considered as 0.
If bool TRUE is passed as an argument, it is considered as 1.
A FALSE is considered as 0.
Values | MINA() | Formula |
12 | 4 | =MINA(L30:L31) |
4 | 1 | =MINA(L30,L33) |
1 | 0 | =MINA(L32,L34) |
True | 1 | =MINA(L32:L33) |
False | 0 | =MINA(0.1,L34) |
Excel Function MODE
The MODE() function is used to find the most frequent occurrence of a number from an array.
If more than one number has the same maximum occurrence, then the least one is returned.
The syntax is as follows:
MODE(num1,num2,�num255)
MODE() | Formula |
2 | =MODE(1,2,2,2,3,4,4) |
23 | =MODE(23,22,1,22,23,22,1,1,23,23) |
1 | =MODE(1,6,4,1,6) |
1 | =MODE(1,1,1,12,2,2,2) |
4 | =MODE(1,2,3,4,5,6,4) |
Excel Function NORMDIST
The NORMDIST() function is used to calculate the Normal probability density function of a given value.
This function needs to be specified the mean and standard deviation as its arguments.
The syntax is as follows:
NORMDIST(x,mean,std_deviation,cumulative)
x | mean | sd | NORMDIST() | Formula |
2 | 14 | 9 | 9.1211E-02 | =NORMDIST(L56,M56,N56,TRUE) |
13 | 11 | 35 | 0.522784 | =NORMDIST(L57,M57,N57,TRUE) |
34 | 17 | 21 | 0.790893 | =NORMDIST(L58,M58,N58,TRUE) |
21 | 26 | 20 | 0.401293 | =NORMDIST(L59,M59,N59,TRUE) |
45 | 4 | 10 | 0.999979 | =NORMDIST(L60,M60,N60,TRUE) |
Excel Function NORMINV
The NORMINV() function is used to calculate the inverse function of the normal distribution of a given value.
The syntax is as follows:
NORMINV(probability,mean,std_dev)
Probability | Mean | SD | NORMINV() |
0.3 | 3 | 1 | 2.47559948729196 |
0.5 | 4 | 7 | 4 |
0.8 | 2 | 2 | 3.68324246714583 |
0.1 | 7 | 9 | -4.5339640899014 |