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

 

You can find similar Excel Questions and Answer hereunder

1) How do I find the median salary of employees with the same skillset in my Organization?

2) basic math functions power product quotient mod sum

3) statistical functions normsdist normsinv percentile percentrank permut

4) I have test scores for my student population. In Excel, how can I determine confidence interval for my Population Mean?

5) statistical functions gammainv gammaln geomean growth harmean intercept

6) statistical functions poisson prob quartile skew slope standardize

7) statistical functions avedev average averagea countblank countif

8) What is the design mode in the developer Tab in Excel

9) statistical functions stdev stdeva stdevp stdevpa steyx

10) statistical functions trend var vara varp varpa

 

Here the previous and next chapter