Jan 052018

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.

"Sincerely,"

Tom Peterson

10164 Skeman Road

"Brighton, MI 48116"

"Compuserve # 73477,2565"

"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.

"Sincerely,"

Tom Peterson

10164 Skeman Road

"Brighton, MI 48116"

"Compuserve # 73477,2565"

January 5, 2018
Add comments