Computing Reviews
Today's Issue Hot Topics Search Browse Recommended My Account Log In
Review Help
Spreadsheet calculations of probabilities from the F, t, &khgr;2, and normal distribution
Landram F., Cook J., Johnston M. Communications of the ACM29 (11):1090-1092,1986.Type:Article
Date Reviewed: Jul 1 1987

In the Conclusion, the authors state, “The difficulty of computing probabilities for the F, t, &khgr;2, and normal distributions restricts the use of statistics in spreadsheet operations because these probabilities are typically computed from numerical integration methods that require an iterative procedure.” The authors’ method normalizes the F distribution which allows probabilities to be computed from a closed formula; the t and &khgr;2 are likewise converted to an F value, and the previous method is used. The authors claim two-decimal-place accuracy; a little experimentation found no fault with this claim. However, two decimal places are not two significant figures. Thus, where they claim the probability to be 0.05, I found 0.0510 (&khgr;2), 0.0481 (t), and 0.0497 (F). This work is surely of value to spreadsheet users who need to do these type of statistical calculations.

Reviewer:  S. Wertheimer Review #: CR111430
Bookmark and Share
Would you recommend this review?
Other reviews under "Statistical Computing": Date
APL2 as a specification language for statistics
Thomson N. IBM Systems Journal 30(4): 539-542, 1991. Type: Article
Dec 1 1993
Meta-algorithmic systems for document classification
Simske S., Wright D., Sturgill M.  Document engineering (Proceedings of the 2006 ACM symposium, Amsterdam, The Netherlands, Oct 10-13, 2006)98-106, 2006. Type: Proceedings
Dec 29 2006
An approximation for the inverse distribution function of a combination of random variables, with an application to operating theatres
Shore H. Journal of Statistical Computation and Simulation 23(3): 157-181, 1986. Type: Article
Dec 1 1986

E-Mail This Printer-Friendly
Send Your Comments
Contact Us
Reproduction in whole or in part without permission is prohibited.   Copyright 2004™
Terms of Use
| Privacy Policy