How To ...

General

Communicate about Windows

Data manipulation

Create a dBase file with Excel

DBF.EXE -- Display dBase header and field descriptor

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)

Return to the Environmental Statistics home page

This page is copyright (c) 2001 Quantitative Decisions and William A. Huber.  Please cite it as

This page was created 31 January 2001 and last updated 24 March 2001 (added the normal interval workbook).