Excel’s ERFC.PRECISE function returns the complementary error function integrated from a lower bound to infinity. With the right scaling, it helps calculate probabilities outside normal-distribution limits. ERFC.PRECISE and ERFC give …
If you enter data in Excel often, a drop-down list can save time. With the drop-down, you pick an option instead of typing it. That helps prevent typos and wrong …
Excel’s ERFC function returns the complementary error function, integrated from a given value to infinity. Mathematically, it equals one minus the error function, ERF. With the right scaling, ERFC calculates …
Excel’s ERF.PRECISE function returns the error function integrated between 0 and a supplied number. It accepts one argument and matches the one-argument form of ERF. Divide a distance by the …
Excel’s DVARP function returns the population variance of numbers in a database column, using only the records that match your criteria. Variance measures how spread out those numbers are. Use …
Excel’s DVAR function returns the sample variance of numbers in a database field after applying criteria. It reduces all matching records to one value. DVAR returns variance in squared units. …
The DSTDEVP function in Excel calculates the population standard deviation of values in a database field after applying criteria. DSTDEVP is the function to use when the matching records are …
The DSTDEV function in Excel estimates the sample standard deviation of values from database records that meet specified criteria. It’s useful when your worksheet is arranged as a list with …
Excel’s DOLLARFR function converts a decimal value into fractional notation, so the digits after the decimal point represent a numerator over a chosen denominator. For example, 101.3125 converted to 32nds …
The DOLLARDE function in Excel converts a number written in fractional notation into a regular decimal number. In this notation, the digits after the point are a numerator, not decimal …
The DOLLAR function in Excel returns a number as currency-formatted text, rounded to the number of decimal places you choose. It works well when currency must sit inside a sentence …
The DISC function in Excel returns the annualized bank discount rate for a short-term security sold below face value and redeemed without periodic interest. This rate uses face value as …