國立高雄大學圖資館 |

Language: English

Back

Essentials of Excel VBA, Python, and R.Volume I, Financial statistics and portfolio analysis

Record Type:	Electronic resources : Monograph/item
Title/Author:	Essentials of Excel VBA, Python, and R.by John Lee, Cheng-Few Lee.
remainder title:	Financial statistics and portfolio analysis
Author:	Lee, John C.
other author:	Lee, Cheng F.
Published:	Cham :Springer International Publishing :2022.
Description:	xvi, 696 p. :ill. (chiefly color), digital ;24 cm.
Contained By:	Springer Nature eBook
Subject:	FinanceData processing.
Online resource:	https://doi.org/10.1007/978-3-031-14236-9
ISBN:	9783031142369$q(electronic bk.)

Essentials of Excel VBA, Python, and R.Volume I, Financial statistics and portfolio analysis
Lee, John C.

Essentials of Excel VBA, Python, and R.Volume I, Financial statistics and portfolio analysis[electronic resource] /Financial statistics and portfolio analysisby John Lee, Cheng-Few Lee. - Second edition. - Cham :Springer International Publishing :2022. - xvi, 696 p. :ill. (chiefly color), digital ;24 cm.

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.

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.

ISBN: 9783031142369$q(electronic bk.)

Standard No.: 10.1007/978-3-031-14236-9doiSubjects--Uniform Titles:

Microsoft Excel (Computer file)
Subjects--Topical Terms:

200666
Finance
--Data processing.

LC Class. No.: HG173

Dewey Class. No.: 332.0285

Essentials of Excel VBA, Python, and R.Volume I, Financial statistics and portfolio analysis
LDR:03777nmm a2200373 a 4500 001 634146
003 DE-He213
005 20230102180738.0
006 m d
007 cr nn 008maaau
008 230511s2022 sz s 0 eng d
020 $a 9783031142369$q(electronic bk.)
020 $a 9783031142352$q(paper)
024 7 $a 10.1007/978-3-031-14236-9 $2 doi
035 $a 978-3-031-14236-9
040 $a GP $c GP
041 0 $a eng
050 4 $a HG173
072 7 $a PBT $2 bicssc
072 7 $a K $2 bicssc
072 7 $a BUS061000 $2 bisacsh
072 7 $a PBT $2 thema
072 7 $a K $2 thema
082 0 4 $a 332.0285 $2 23
090 $a HG173 $b .L478 2022
100 1 $a Lee, John C. $3 380938
245 1 0 $a Essentials of Excel VBA, Python, and R. $n Volume I, $p Financial statistics and portfolio analysis $h [electronic resource] / $c by John Lee, Cheng-Few Lee.
246 3 0 $a Financial statistics and portfolio analysis
250 $a Second edition.
260 $a Cham : $b Springer International Publishing : $b Imprint: Springer, $c 2022.
300 $a xvi, 696 p. : $b ill. (chiefly color), digital ; $c 24 cm.
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.
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.
630 0 0 $a Microsoft Excel (Computer file) $3 190780
650 0 $a Finance $x Data processing. $3 200666
650 0 $a Finance $x Statistical methods. $3 240075
650 0 $a Electronic spreadsheets $x Computer programs. $3 220170
650 0 $a Python (Computer program language) $3 215247
650 0 $a R (Computer program language) $x Statistical methods. $3 544756
700 1 $a Lee, Cheng F. $3 233835
710 2 $a SpringerLink (Online service) $3 273601
773 0 $t Springer Nature eBook
856 4 0 $u https://doi.org/10.1007/978-3-031-14236-9
950 $a Mathematics and Statistics (SpringerNature-11649)