![]() ![]() ![]() For example, because CRITBINOM returns the inverse of the binomial distribution, BINOM.INV is a more appropriate name. The new function names also more accurately describe their functionality. The following Statistical functions (reference) have been renamed so that they are more consistent with the function definitions of the scientific community and with other function names in Excel. Statistical functions (reference), Compatibility functions NEGBINOM.DIST function, NEGBINOMDIST function LOGNORM.DIST function, LOGNORMDIST function HYPGEOM.DIST function, HYPGEOMDIST function ![]() Statistical functions (reference), Compatibility functions (reference) Math and trigonometry functions (reference) The MOD function now uses new algorithms to achieve both accuracy and speed, and the RAND function now uses a new random number algorithm. For example, because the BETADIST function was inaccurate, a new algorithm has been implemented to improve the accuracy of this function. In this articleįor the following functions, algorithm changes have been implemented to improve function accuracy and performance. To provide improved function accuracy, consistent functionality that meets expectation, and function names that more accurately describe their functionality, several Excel functions have been updated, renamed, or added to the function library in Excel 2010.įor backward compatibility, renamed functions remain available with their old name. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |