XL: Algorithms Used in the ATP Functions

Last reviewed: February 2, 1998
Article ID: Q149236
The information in this article applies to:
  • Microsoft Excel 98 Macintosh Edition
  • Microsoft Excel 97 for Windows
  • Microsoft Excel for Windows 95, version 7.0
  • Microsoft Excel for Windows, versions 4.0, 5.0, 5.0c
  • Microsoft Excel for the Macintosh, versions 4.0, 5.0, 5.0a

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.

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:

   ARTICLE-ID: Q117813
   TITLE     : XE0962: Excel AppNote: "Equations for Financial
               Functions"

REFERENCES

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


Additional query words: 8.00 97 XL97 98 XL98 sources formulas resources
toolpack tool pak pack
Keywords : xladdins xlformula xlhelp kbualink97
Version : MACINTOSH:4.0,5.0,5.0a,98; WINDOWS:5.0,5.0c,7.0,97
Platform : MACINTOSH WINDOWS
Issue type : kbref


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: February 2, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.