Essentials of Excel, Excel VBA, SAS and Minitab for Statistical and Financial Analyses

Cheng-Few LeeRutgers UniversityJohn LeeCenter for PBBEF ResearchJow-Ran ChangNational Tsing Hua UniversityTzu TaiRutgers University

• 1 Introduction.- 2 Data Collection and Presentation.- 3 Histograms and the Rate of Returns of Johnson & Johnson.- 4 Numerical Summary Measures on Rate of Returns of Amazon, Walmart and the S&P 500.- 5 Probability Concepts and Their Analysis.- 6 Discrete Random Variables and Probability Distributions​.- 7 The Normal and Lognormal Distributions.- 8 Sampling Distributions and Central Limit Theorem.- 9 Other Continuous Distributions.- 10 Estimation.- 11 Hypothesis Testing.- 12 Analysis Of Variance and Chi-Square Tests.- 13 Simple Linear Regression and The Correlation Coefficient.- 14 Simple Linear Regression and Correlation: Analyses and Applications.- 15 Multiple Linear Regression.- 16 Residual and Regression Assumption Analysis.- 17 Nonparametric Statistics.- 18 Time-Series: Analysis, Model, and Forecasting.- 19 Index Numbers and Stock Market Indexes.- 20 Sampling Surveys: Methods and Applications.- 21 Statistical Decision Theory: Methods and Applications.- 22 Introduction to EXCEL Programming.- 23 Introduction to VBA Programming.- 24 Professional Techniques Used in EXCEL and EXCEL VBA Techniques.​- 25 Binomial Option Pricing Model Decision Tree Approach.- 26 using Microsoft Excel to Estimate Alternative Option Pricing Models.- 27 Alternative Methods to Estimate Implied Variance.- 28 Greek Letters and Portfolio Insurance.- 29 Portfolio Analysis and Option Strategies.- 30 Simulation and its Application.- 31 Application of Simultaneous Equation in Finance Research: Methods and Empirical Results.- 32 Hedge Ratios: Theory and Applications