## 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