Statistical Analysis Toolset is a collection of eight Microsoft Excel spreadsheet programs, each of which performs calculations pertaining to an aspect of statistical analysis.

These programs present input and output data in user friendly, menu-driven formats, with automatic execution. The following types of calculations are performed:

  • Descriptive statistics are computed for a set of data x(i) (i = 1, 2, 3 . . . ) entered by the user.
  • "Normal Distribution Estimates" will calculate the statistical value that corresponds to cumulative probability values, given a sample mean and standard deviation of the normal distribution.
  • "Normal Distribution from two Data Points" will extend and generate a cumulative normal distribution for the user, given two data points and their associated probability values.
  • Two programs perform two-way analysis of variance (ANOVA) with no replication or generalized ANOVA for two factors with four levels and three repetitions.
  • "Linear Regression-ANOVA" will curve fit data to the linear equation y = f(x) and will do an ANOVA to check its significance.
  • Two multiple regression programs will do statistical analysis on test data that includes more than one predictor and will perform curve-fitting of the data to either the equation y = f(x1, x2) or y = f(x1, x2, x3, x4).

This program was written by Paul L. Luz of Marshall Space Flight Center. For further information, contact Sammy Nabors, MSFC Commercialization Assistance Lead, at This email address is being protected from spambots. You need JavaScript enabled to view it. . Refer to MFS-31796.

NASA Tech Briefs Magazine

This article first appeared in the January, 2005 issue of NASA Tech Briefs Magazine.

Read more articles from the archives here.