MS Excel Statistical Functions

Function name

Description

average(range)

 Return average of given range

averageif(range, criteria)

 Return average of given range after satisfying criteria

counta(range)

 Count number of cells that are not blank in given range.

countblank(range)

 Count number of cells that are blank in given range.

frequency(data_Array, bins_array)

 How often values occur in a given range.


Name    Age

A             1

B             2

C             3

D            4

E             10

F             67

G            12

H            13

I              14

J              55

K             60

L             70

 

 

Age        NOP

10           5             less than 10

50           3             between 10 to 50

80           4             between 50 to 80

 

Select all the rows of NOP, then direct write this formula(=frequence(range_of_data, bin_array) )  then press ctrl + shift + enter

© 2016 - 2022, All Rights are Reserved.