Breaking News
You are here: Home / Notes / SEM-1 / PC Software-I / MS EXCEL Statistical Functions

MS EXCEL Statistical Functions

Statistical Functions

Statistical functions are among the most widely used functions in Excel.

Function Description
COUNT() Counts the number of cells that contains numbers, date and time only. Empty cells or cell containing text, logical errors are not counted.

A B

1

Purchase

3

2

Sales

4

3

12/8/2011

2

4

4

5

29

44

6

23.09

6

7

TRUE

4

8

#NAME?

4

9

              29

4

Syntax =COUNT(Range)Where Range=Group of Cells
Example =COUNT(A1:A9)
Output 4
COUNTA() Counts the number of cells that contains numbers, date and time, text, logical errors. Empty cells are not counted.
Syntax =COUNTA(Range)Where Range=Group of Cells
Example =COUNTA(A1:A9)
Output 8
COUNTBLANK() Counts the Empty cells in a specified range of cells.
Syntax =COUNTBLANK(Range)Where Range=Group of Cells
Example = COUNTBLANK (A1:A9)
Output 1
COUNTIF() Counts the number of cells that are the same as a specified value.
Syntax = COUNTIF(range, value)Where Range=Group of Cells
Example = COUNTBLANK (A1:A9,29)
Output 2
AVERAGE() Calculates the mean (arithmetic average) of a range of cells.
Syntax = AVERAGE(range)Where Range=Group of Cells
Example  AVERAGE(B1:B9)
Output 9
MIN() Returns the minimum value of a data set.
Syntax = MIN(range)Where Range=Group of Cells
Example =MIN(B1:B9)
Output 2
MAX() Returns the maximum value of a data set
Syntax = MAX(range)                                                  Where Range=Group of Cells
Example = MAX(B1:B9)
Output 44
STDEV() Calculates the standard deviation of a sample.
Syntax =  STDEV(range)                                                  Where Range=Group of Cells
Example  STDEV(B1:B9)
Output 14.18
MODE() Returns the Reminder after a number is divided by a divisor.
Syntax = MODE(number, divisor)
Example  MODE (B1,2)
Output 1

Download Paper Solutions from Below Link

About admin

Scroll To Top