I will create a macro for statistical analysis using Excel VBA. This explains how to use Excel for statistical analysis, assuming basic knowledge of statistics and Excel. This book explains from the basics to advanced methods of analyzing statistical data using Excel macros and VBA. This book uses Excel 97/2000 for Windows. It can be used almost as is with Excel 98 for Mac. Table of Contents 1. Introduction to VBA 2. Input and Processing of Array Data 3. Using Excel Functions, Input Boxes, and User Interfaces 4. Simulation with Random Numbers 5. Calculation of Matrix Products and Transpose Matrices 6. Determinants and Inverse Matrices 7. Matrix Calculation Using User Forms 8. Regression Analysis and Least Squares Method 9. Calculation of Regression Equation Indicators 10. Wilcoxon Test 11. Wilcoxon Signed-Rank Test 12. Using List Boxes and Add-ins 13. References 14. Index - Title: Introduction to Statistical Data Analysis with Excel VBA - Author: Kazumitsu Nawata (Author) - CD-ROM: Included - Publisher: Asakura Publishing (2000/5/1) - Paperback: 185 pages