Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

XL2000: Algorithms Used in the ATP Functions


View products that this article applies to.

This article was previously published under Q213939

↑ Back to the top


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.

↑ Back to the top


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.

↑ Back to the top


References

For more information about algorithms used in the Analysis ToolPak, click Microsoft Excel Help on the Help menu, type analysis tools in the Office Assistant or the Answer Wizard, click Search, select Supplemental information about statistical methods and algorithms, and then click Search to view "Supplemental information about statistical methods and algorithms."

↑ Back to the top


Keywords: KB213939, kbualink97, kbhowto

↑ Back to the top

Article Info
Article ID : 213939
Revision : 6
Created on : 8/22/2007
Published on : 8/22/2007
Exists online : False
Views : 265