Explanation

Statistical functions summarize large amounts of data and help identify patterns and performance.

Important Statistical Functions

Function

Purpose

AVERAGE

Calculates arithmetic mean

MEDIAN

Finds middle value

MODE.SNGL

Finds most frequently occurring value

MIN

Finds smallest value

MAX

Finds largest value

COUNT

Counts numeric cells

COUNTA

Counts non-empty cells

COUNTBLANK

Counts empty cells

COUNTIF

Counts cells matching one condition

COUNTIFS

Counts cells matching multiple conditions

AVERAGEIF

Average based on one condition

AVERAGEIFS

Average based on multiple conditions

RANK.EQ

Ranks a number

LARGE

Returns the nth largest value

SMALL

Returns the nth smallest value

Practice

Create a Student Marks dataset and calculate:

  • Average
  • Highest marks
  • Lowest marks
  • Number of students
  • Median
PreviousNext