Function: STDEVPA

Function: STDEVPA

The STDEVPA is a Statistical function that calculates and returns the standard deviation for the entire population of data. The standard deviation is a measure of how widely values are dispersed from the average value (the mean). The STDEVPA calculates standard...
Function: STDEVA

Function: STDEVA

The STDEVA is a Statistical function that calculates and returns the standard deviation for a sample data. The standard deviation is a measure of how widely values are dispersed from the average value (the mean). The STDEVA function calculates standard deviation using...
NORM.S.DIST (standard normal distribution) Function

NORM.S.DIST (standard normal distribution) Function

The NORM.S.DIST is a Statistical function that calculates and returns the standard normal distribution of a specified value. The standard normal distribution is a normal distribution with a mean of zero (0) and a standard deviation of one (1). In this guide, we’re...
Function: STDEV.S

Function: STDEV.S

The STDEV.S (STDEV S) is a Statistical function that calculates and returns the standard deviation for a sample of data. The standard deviation is a measure of how widely values are dispersed from the average value (the mean). The STDEV.S calculates standard deviation...
Excel NORM.DIST Function

Excel NORM.DIST Function

The NORM.DIST function is a Statistical formula that calculates and returns the normal distribution of a value for the specified mean (average) and standard deviation. The NORM.DIST function can calculate either the Normal Probability Density Function or the...
Excel STDEV.P Function

Excel STDEV.P Function

The Excel STDEV.P function is a Statistical formula that calculates and returns the standard deviation for the entire population of data. The standard deviation is a measure of how much values are dispersed from the mean of a data set. The STDEV.P calculates the...
Use the ERROR.TYPE to Identify Excel Errors

Use the ERROR.TYPE to Identify Excel Errors

The ERROR.TYPE function is an Information formula that returns an index number corresponding to a specific error value in Microsoft Excel. If there are no errors in the target cell(s), the function returns another error value, #N/A. This function can be especially...
Function: NOMINAL

Function: NOMINAL

The Excel NOMINAL function is a Financial formula that calculates and returns the nominal annual interest rate, for a given effective annual interest rate and number of compounding periods per year. The nominal annual interest rate is used for calculating financial...
Excel EFFECT Function

Excel EFFECT Function

The Excel EFFECT function is a Financial formula that calculates and returns the effective annual interest rate, for a given nominal annual interest rate and number of compounding periods per year. The effective annual interest rate is used to compare financial loans...