Jan 052018
Various statistical macros for Microsoft Excel.
File STATPA.ZIP from The Programmer’s Corner in
Category Financial and Statistics
Various statistical macros for Microsoft Excel.
File Name File Size Zip Size Zip Type
README.TXT 1450 802 deflated
STATEXAM.XLW 215 120 deflated
STATPACK.XLM 12731 5418 deflated
STATS.XLS 21191 7267 deflated

Download File STATPA.ZIP Here

Contents of the README.TXT file

I have seen a long-term advantage to providing my laboratory and
"working group with the ability to simply perform a variety of basic statistical tests,"
and I have created this spreadsheet and macrosheet to this end.

STATS.XLS is a spreadsheet which demonstrates the Macro functions
in STATPACK.XLM. A list of the functions is shown below:
" CORR(X1:Xn,Y1:Yn) - Calculates Correlation Coefficient."
" FDIST(F-Value,dfNumerator,dfDenominator) - Converts F-Value to Probability Value."
" RTVAL(r,N) - Converts Correlation-value to T-value."
SUMSQ(X1:Xn) - Calculates Sum of Squares.
" TDIST(T-Value,df) - Converts T-Value to Probability Value."
TNULL(X1:Xn) - Performs T-Test That Group Mean Is Different from Zero.
" TPAIRED(X1:Xn,Y1:Yn) - Performs Paired T-Test."
" TUNPAIRED(X1:Xm,Y1:Yn) - Performs Unpaired T-Test."
" * LINEST(Y1:Ym,X1:Xn) - Example of Excel's Linear Regression Analysis."

The formulae and examples are taken from two sources:
" Horowitz, Leonard M., Elements of statistics for psychology and education."
" New York: McGraw-Hill, Inc., 1974."
" Poole, Lon, et al. Some Common BASIC Programs. Berkley, California: "
" OSBORNE/McGraw-Hill, 1980."

I recommend that you validate these functions for yourself by entering examples
from textbooks you have on your own bookshelf.


Tom Peterson
10164 Skeman Road
"Brighton, MI 48116"
"Compuserve # 73477,2565"

 January 5, 2018  Add comments

Leave a Reply