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

This advanced textbook for business statistics teaches statistical analyses and research methods utilizing business case studies and financial data, with the applications of Excel VBA, Python and R. Each chapter engages the reader with sample data drawn from individual stocks, stock indices, options...

Full description

Bibliographic Details
Main Authors: Lee, John, Lee, Cheng-Few (Author)
Format: eBook
Language:English
Published: Cham Springer International Publishing 2022, 2022
Edition:2nd ed. 2022
Subjects:
Online Access:
Collection: Springer eBooks 2005- - Collection details see MPG.ReNa
LEADER 03963nmm a2200373 u 4500
001 EB002142020
003 EBX01000000000000001280146
005 00000000000000.0
007 cr|||||||||||||||||||||
008 230201 ||| eng
020 |a 9783031142369 
100 1 |a Lee, John 
245 0 0 |a Essentials of Excel VBA, Python, and R  |h Elektronische Ressource  |b Volume I: Financial Statistics and Portfolio Analysis  |c by John Lee, Cheng-Few Lee 
250 |a 2nd ed. 2022 
260 |a Cham  |b Springer International Publishing  |c 2022, 2022 
300 |a XVI, 696 p. 1113 illus., 1005 illus. in color  |b online resource 
505 0 |a 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 
653 |a Data Analysis and Big Data 
653 |a Business Mathematics 
653 |a Statistics  
653 |a Programming languages (Electronic computers) 
653 |a Quantitative research 
653 |a Statistics in Business, Management, Economics, Finance, Insurance 
653 |a Business mathematics 
653 |a Mathematical statistics / Data processing 
653 |a Statistics and Computing 
653 |a Programming Language 
700 1 |a Lee, Cheng-Few  |e [author] 
041 0 7 |a eng  |2 ISO 639-2 
989 |b Springer  |a Springer eBooks 2005- 
028 5 0 |a 10.1007/978-3-031-14236-9 
856 4 0 |u https://doi.org/10.1007/978-3-031-14236-9?nosfx=y  |x Verlag  |3 Volltext 
082 0 |a 300.727 
520 |a This advanced textbook for business statistics teaches statistical analyses and research methods utilizing business case studies and financial data, with the applications of Excel VBA, Python and R. Each chapter engages the reader with sample data drawn from individual stocks, stock indices, options, and futures. Now in its second edition, it has been expanded into two volumes, each of which is devoted to specific parts of the business analytics curriculum. To reflect the current age of data science and machine learning, the used applications have been updated from Minitab and SAS to Python and R, so that readers will be better prepared for the current industry. This first volume is designed for advanced courses in financial statistics, investment analysis and portfolio management. It is also a comprehensive reference for active statistical finance scholars and business analysts who are looking to upgrade their toolkits. Readers can look to the second volume for dedicated content on financial derivatives, risk management, and machine learning