AVERAGE

Purpose

Calculates the arithmetic mean of numbers.

Syntax

=AVERAGE(number1,number2,…)

Example

Student

Marks

Amit

75

Neha

85

Rahul

65

Priya

90

Simran

70

Formula:

=AVERAGE(B2:B6)

Result:

77

Real-World Uses

  • Average marks
  • Average sales
  • Average salary
  • Average attendance
  • Average monthly expenses

MEDIAN

Returns the middle value after arranging numbers in order.

=MEDIAN(B2:B6)

For:

65, 70, 75, 85, 90

Result:

75

MODE.SNGL

Returns the most frequently occurring value.

=MODE.SNGL(B2:B8)

Example:

50, 60, 70, 70, 80, 70, 90

Result:

70

Practice

Create a marks dataset and calculate:

  • Average
  • Median
  • Mode

Compare how the three measures differ.

PreviousNext