# excel formula

## New Excel Functions in Excel 2021

Every time when Microsoft excel launches a new version new excel functions are also been added there. Excel 2021 also has new functions like  FILTER, SORT, SORT BY, UNIQUE, SEQUENCE. These all excel functions help us reducing our processing time. Let us see in brief what these functions are and how they work. Let us go through these New Excel Functions in Excel 2021.

FILTER function in excel

Excel FILTER function allows us to filter a range of data from a dataset based on some criteria. It is one of the New Excel Functions in Excel 2021. Let us understand first the syntax of Filter formula excel.

## What are measures of dispersion: How to calculate range, variance, Quartile and standard deviation

#### What are measures of dispersion

Dispersion or Spread is the extent to which the observations vary about their mean in a dataset. The quantity that measures a dispersion in a data set is known as measure of dispersion. It is used to check variability/spread of data i.e. to know how much homogenous or heterogeneous the data is. The measure of dispersion are of two types that is absolute and relative dispersion.

An absolute measure of dispersion is one that measures dispersion in terms of the same units as the unit of data. if the unit of data is meter, kilogram or mile then measure of dispersion will be in the same unit.