Lee J.C. Business and Financial Statistics Using Minitab 12 and Microsoft Excel 97

World Scientific Publishing Company, 2000. — 366 p. — ISBN: 9810238797A discussion of statistical analysis using two personal computer software packages, Minitab 12 and Microsoft Excel 97.
Minitab was chosen because it is powerful and is one of the more user-friendly statistical software packages. Microsoft Excel 97 was selected because it is one of the most important software packages to learn and most companies use Excel. Excel is not dedicated to statistical analysis like Minitab, but it has many statistical features and a very powerful development environment for writing customized statistical analysis. The book has a textbook format. Each chapter discusses statistical concepts and illustrates the use of Minitab and/or Excel. Often it becomes necessary to write macros (programs) in order to do specific statistical analysis. This book prints the codes of the macros for the reader to use and study.Introduction and Descriptive StatisticsData Collection and Presentation
Frequency Distributions and Data Analyses
Numerical Summary Measures
Probability and Important Distributions
Probability Concepts and Their Analysis
Discrete Random Variables and Probability Distributions
The Normal and Lognormal Distributions
Sampling and Sampling Distributions
Other Continuous Distributions and Moments for Distributions
Statistical Inferences Based on Samples
Estimation and Statistical Quality Control
Hypothesis Testing
Analysis of Variance and Chi-Square Tests
Regression and Correlation: Relating Two or More Variables
Simple Linear Regression and the Correlation Coefficient
Simple Linear Regression and Correlation: Analyses and Applications
Multiple Linear Regression
Other Topics in Applied Regression Analysis
Selected Topics in Statistical Analysis for Business and Economics
Nonparametric Statistics
Time-Series: Analysis, Model, and Forecasting
Index Numbers and Stock Market Indexes
Sampling Surveys: Methods and Applications
Statistical Decision Theory: Methods and Applications
Using Microsoft Excel to Estimate Alternative Option Pricing Models
Appendix: References