Home
Up

T

he spreadsheets listed on this page include all of those available through the Environmental Statistics course pages.

Analysis (spreadsheets)

Compute descriptive statistics (contains a Visual Basic (VB) macro to compute percentiles)

Compute binomial probabilities

Plot a normal pdf and cdf

Compute parameters of a lognormal distribution

Perform linear, quadratic, cubic, etc. interpolation (used to interpolate Land's H factor tables)

Compute lognormal MVUEs (contains a VB macro for Finney's G/Psi function)

Binomial confidence interval calculations (includes Bayes, beta, F, and direct formulas)

Graphical calculations with Student's t distribution (uses Excel's TInv() function and dynamically graphs the corresponding area)

Normal interval workbook  Computes confidence, prediction, and tolerance intervals based on the Normal distribution.  Contains VB macros to compute values of the non-central t distribution and its inverse.

Analysis (techniques and aids)

Normal probability paper

Geometric means, exponentials, and logs

Compute logarithms

Land's H-factors for lognormal confidence limits (Gilbert tables A.12-13) (use the cubic interpolation formulas above)

Simulation (spreadsheets)

Simulate normally distributed values (also computes summary statistics, a probability plot, and fits a line to the plot)

The Monty Hall puzzle

The Three Coins problem (discrete simulation)

ColorRamp, Memorized Calculations, Rotate, Sample, XSect, and Tissot  are  trademarks of Quantitative Decisions.  All other products mentioned are registered trademarks or trademarks of their respective companies.

Questions or problems regarding this web site should be directed to information (@quantdec.com).
Copyright © 2000-2002 Quantitative Decisions.  All rights reserved.
Last modified: Tuesday March 02, 2004.