Microsoft KB Archive/213939

= XL2000: Algorithms Used in the ATP Functions =

Article ID: 213939

Article Last Modified on 8/22/2007

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q213939





SUMMARY
Detailed information about the algorithms used to create the Microsoft Excel Analysis ToolPak (ATP) functions can be retrieved from several resources. The "More Information" section of this article lists some of these resources.



MORE INFORMATION
For detailed information about the algorithms used to create the Microsoft Excel engineering functions, refer to the following book:

Strum, Robert D., and Donald E. Kirk. First Principles of Discrete Systems and Digital Signal Processing. Reading, Mass.: Addison-Wesley

Publishing Company, 1988.

For detailed information about the algorithms or statistical methods used to create the Microsoft Excel statistical functions, refer to the following books:
 * Abramowitz, Milton, and Irene A. Stegun, eds. Handbook of Mathematical Functions with Formulas, Graphs, and Mathematical Tables. Washington, D.C.: U.S. Government Printing Office, 1972.
 * Box, George E.P., William G. Hunter, and J. Stuart Hunter. Statistics for Experimenters. New York: John Wiley and Sons, 1972.
 * Devore, Jay L. Probability and Statistics for Engineering and the Sciences, 3d ed. Pacific Grove, California: Brooks/Cole Publishing Company, 1991.
 * McCall, Robert B. Fundamental Statistics for the Behavioral Sciences. 5th ed. New York: Harcourt Brace Jovanovich, 1990.
 * Press, W.H., B.P. Flannery, S.A. Teukolsky, and W.T. Wetterling. Numerical Recipes in C: The Art of Scientific Computing. New York: Cambridge University Press, 1988.
 * Sokal, Robert R., and F. James Rohlf. Biometry: The Principles and Practice of Statistics in Biological Research, 2nd ed. New York: W.H. Freeman and Company, 1981.

For detailed information about the algorithms or financial methods used to create the Microsoft Excel financial functions, refer to the following books:
 * Fabozzi, Frank J., and Irving M. Pollack. The Handbook of Fixed Income Securities. Homewood, Illinois: Business 1 Irwin, 1986.
 * Hewlett-Packard Company. HP - 12C Owner's Handbook and Problem-Solving Guide, 1981.
 * Lynch, John J. Jr., and Jan H. Mayle. Standard Securities Calculation Methods, Fixed Income Securities Formulas. New York: Securities Industry Association, 1986.

