Statistical Functions in Excel

Count

The COUNT function calculates how many values are present in the selected range of cells.

Count if

Use the COUNTIF function, to count cells based on a single criterion; e.g. count cells if equal to etc.

Count Blank

To highlight, how many blank cells are present in the selected range of cells, use the COUNTBLANK function.

Average

Use the average function to get an average of numbers or range of cells.

AverageIF

The AverageIF function calculates an average of range of cells based on one condition, like you may exclude 9 to calculate average.

Small

To figure out a small value of your choice (like first one or second one etc.) in your data, use the SMALL function. 

In above screenshot, the second smallest values were found by using the function.

Large

To highlight the largest figure or second largest etc., use the LARGE function.

In the above-mentioned screenshot, the third largest figure was calculated by using the LARGE function.

Median

To calculate median of data, use the MEDIAN function.

Mode

Use MODE function to find out mode of the selected values.

Standard Deviation

To calculate standard deviation, use the STDEVA function.

Copyright © 2016 - 2018 Explainry.com | All Rights Reserved