XL2000: Algorithms Used in the ATP Functions (213939)

MORE INFORMATION

For detailed information about the algorithms used to create the Microsoft Excel engineering functions, refer to the following book: 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.

For additional information about financial functions, click the article number below to view the article in the Microsoft Knowledge Base: