Page 89 - 2619_PlusGPT V2.1_C-7

Statistical Functions

These functions are used to analyse data and calculate statistical measures. Some of the statistical
functions are given below:
Functions Purpose Example

Input: =MAX(4,16,12,9)
MAX(range) It returns the largest value in the given range.
Output: 16
Input: =MIN(4,16,12,9)
MIN(range) It returns the smallest value in the given range.
Output: 4
It returns the average of the given numbers in Input: =AVERAGE(12,3,6)
AVERAGE(range)
a range. Output: 7
It returns the count of the number of values in Input: =COUNT(4,8,12)
COUNT(range)
the selected range. Output: 3

Let’s CatCh uP

Write the output of the following:

1. =MIN (5,7,8) _____________ 2. =AVERAGE(12,3,6) _____________
3. =COUNT(4,8,12) _____________

Let’s BaCk-uP

A cell or a range of cells that you want to use in your calculation is called reference.
Formulas in Excel 2016 begin with an equal to (=) sign.
Excel calculates consecutive operators with the same level of precedence from left to right.
Excel 2016 allows users to create custom formulas to perform calculations on the data.
A cell reference is a cell address that can be used in a formula to denote a specific cell.

A group of selected cells is called a range.
Functions are pre-defined formulas in Excel to perform simple and complex calculations.
Different categories of functions are Statistical functions, Mathematical functions, Logical
functions, Text functions and Date and Time functions.

Formulas and Functions in Google Sheets 87