Essentials of Excel VBA, Python, and R : Volume I: Financial Statistics and Portfolio Analysis

Chapter 1. Introduction.- Chapter 2. Data Collection, Presentation, and Yahoo Finance.- Chapter 3. Histograms and the Rate of Returns of JPM and JNJ.- Chapter 4. Numerical Summary Measures on Stock Rates of Return and Market Rates of Return.- Chapter 5. Probability Concepts and their Analysis.- Chapter 6. Discrete Random Variables and Probability Distributions.- Chapter 7. The Normal and Lognormal Distributions.- Chapter 8. Sampling Distributions and Central Limit Theorem.- Chapter 9. Other Continuous Distributions.- Chapter 10. Estimation.- Chapter 11. Hypothesis Testing.- Chapter 12. Analysis of Variance and Chi-Square Tests.- Chapter 13. Simple Linear Regression and the Correlation Coefficient.- Chapter 14. Simple Linear Regression and Correlation: Analyses and Applications.- Chapter 15. Multiple Linear Regression.- Chapter 16. Residual and Regression Assumption Analysis.- Chapter 17. Nonparametric Statistics.- Chapter 18. Time Series: Analysis, Model, and Forecasting.- Chapter 19. Index Numbers and Stock Market Indexes.- Chapter 20. Sampling Surveys: Methods and Applications.- Chapter 21. Statistical Decision Theory.- Chapter 22. Sources of Risks and their Determination.- Chapter 23. Risk-Aversion, Capital Asset Allocation, and Markowitz Portfolio Selection Model.- Chapter 24. Capital Asset Pricing Model and Beta Forecasting.- Chapter 25. Single-Index Models for Portfolio Selection.- Chapter 26. Sharpe Performance Measure and Treynor Performance Measure Approach to Portfolio Analysis.