excel formula

New Excel Functions in Excel 2021: 5 Awesome Excel formulas

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.

New Excel Functions in Excel 2021
New Excel Functions in Excel 2021

What … Continue Reading

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.

What are measures of dispersion
Type of measures of 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.

A relative measure ofContinue Reading

What are measures of central tendency: How to calculate it in Excel?

What are measures of central tendency?

measure of central tendency is a single value that attempts to describe a set of data by identifying the central position within that set of data. These measures indicate where most values in a distribution fall and are also referred to as the central location of a distribution.

The three most commonly used measures of central tendency are mean, median, and mode. Each of these methods calculates the location of the central point by using a different method. Choosing the best measure of central tendency depends on the data we have.

Let us understand how to measure/calculate these central tendencies and how to determine which one is best for our data.

Mean/Average: Mean … Continue Reading