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