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