Help and Support

Algorithms Used in the ATP Functions

View products that this article applies to.
Article ID:149236
Last Review:August 17, 2005
Revision:1.3
This article was previously published under Q149236

SUMMARY

Detailed information about the algorithms used to create the Microsoft Excel Analysis ToolPak 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.
Stigum, Marcia, and John Mann. "Money Market Calculations: Yields,
Break-Evens, and Arbitrage." Homewood, Illinois: Business 1 Irwin,
1989.
For additional information, please see the following article in the Microsoft Knowledge Base:
117813 (http://support.microsoft.com/kb/117813/EN-US/) XE0962: Excel AppNote: "Equations for Financial Functions"

Back to the top

REFERENCES

"User's Guide 2," version 4.0, Chapter 1, "Analyzing and Calculating Data" "Function Reference," version 4.0, page 481

Back to the top

APPLIES TO
•Microsoft Excel 97 Standard Edition
•Microsoft Excel 95 Standard Edition
•Microsoft Excel 5.0 Standard Edition
•Microsoft Excel 98 for Macintosh

Back to the top

Keywords: 
kbualink97 KB149236

Back to the top

Article Translations

 

Related Support Centers

Other Support Options

  • Need More Help?
    Contact a Support professional by Email, Online or Phone.
  • Customer Service
    For non-technical assistance with product purchases, subscriptions, online services, events, training courses, corporate sales, piracy issues, and more.
  • Newsgroups
    Pose a question to other users. Discussion groups and Forums about specific Microsoft products, technologies, and services.