by Ilker | Sep 12, 2019 | Excel Formulas

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...
by Ilker | Sep 11, 2019 | Excel Formulas

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...
by Ilker | Sep 10, 2019 | Excel Formulas

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...
by Ilker | Aug 29, 2019 | Excel Formulas

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...
by Ilker | Aug 29, 2019 | Excel Formulas

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...
by Ilker | Aug 27, 2019 | Excel Formulas

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...
by Ilker | Aug 27, 2019 | Excel Formulas

The DURATION Excel function is a Financial formula that calculates and returns the annual duration of a security based on the Macauley duration formula. In this guide, we’re going to show you how to use the DURATION function and also go over some tips and error...
by Ilker | Aug 26, 2019 | Excel Formulas

The Excel YIELD function is a Financial formula that calculates and returns the yield on a security that pays a periodic interest. A common use case for the YIELD function is calculating bond yields. In this guide, we’re going to show you how to use the Excel YIELD...
by Ilker | Aug 22, 2019 | Excel Formulas

The Excel PRICEMAT function is a Financial formula that calculates and returns the price per $100 face value of a security that pays interest at maturity. In this guide, we’re going to show you how to use the PRICEMAT function and also go over some tips and error...