STANDARDIZE Function

STANDARDIZE Function

The STANDARDIZE Excel function is a Statistical formla that calculates and returns normalized value (z-score) based on the mean and standard deviation of a data set. In this guide, we’re going to show you how to use the STANDARDIZE function and also go over some tips...
RANK.AVG (RANK AVG) Function in Excel

RANK.AVG (RANK AVG) Function in Excel

RANK.AVG (RANK AVG) is a Statistical function that can return the rank of a given value, within the specified array of values. If there are values that share the same rank, the average rank of that set of values will be returned. In this guide, we’re going to show you...
RANK EQ Excel Function (RANK.EQ)

RANK EQ Excel Function (RANK.EQ)

The RANK.EQ function is a Statistical formula that returns the rank of a given value, within the specified array of values. If there is more than one values that share the same rank, the higher rank of that set of values is going to be returned by the formula. In this...
AVERAGEA in Excel

AVERAGEA in Excel

The AVERAGEA in Excel is a Statistical function that can calculate and return the average (arithmetic mean) of the values of a range of cells. AVERAGEA differs from the AVERAGE function in its ability to include numbers in string format and logical values in the...
Excel SIGN Function

Excel SIGN Function

The Excel SIGN function is a Math & Trigonometry formula that returns the sign of the specified numeric value in its arguments. Need to identify outliers or any red flags in a data set? This function is perfect for that task! This function can be especially useful...
Function: SECOND

Function: SECOND

The Excel SECOND function is a Date & Time formula that parses and returns the second value from a time value. The return value is an integer, ranging from 0 to 59. The outcome of this function resets for every 60 seconds of input. In this guide, we’re going to...
Function: MINUTE

Function: MINUTE

The MINUTE Excel function is a Date & Time formula that returns the minute value from a specified time value. The return value is an integer, ranging from 0 to 59, and the minute values reset after 60 minutes. In this guide, we’re going to show you how to use the...
Function: HOUR

Function: HOUR

The Excel Hour function is a Date & Time formula that parses and returns the hour value from a time value. The return value is an integer, ranging from 0 (12:00 A.M.) to 23 (11:00 P.M.). In this guide, we’re going to show you how to use the Excel HOUR function and...