Using Python to calculate the S&P500 annual mean return (4 lines)
Yuxing Yan
Using Python to calculate the S&P500 annual mean return (4 lines)
5:49
Running a smart contract by connecting Remix, Ganache, and MetaMask.
Yuxing Yan
Running a smart contract by connecting Remix, Ganache, and MetaMask.
8:19
How to run a smart contract? Location of sample programs, launch Remix, load, run a Solidity program
Yuxing Yan
How to run a smart contract? Location of sample programs, launch Remix, load, run a Solidity program
7:40
My new book (2023): Learning R and Python for Business School Students
Yuxing Yan
My new book (2023): Learning R and Python for Business School Students
16:59
Excel Tutorial (MTMT 095) Fall 2022
Yuxing Yan
Excel Tutorial (MTMT 095) Fall 2022
5:28
Chapter 3: Time value of Money (II), Stock & Bond valuation: perpetuities and annuities
Yuxing Yan
Chapter 3: Time value of Money (II), Stock & Bond valuation: perpetuities and annuities
37:11
Chapter2: Time value of money (Part I): FV=PV(1+R)^n, PV=FV/(1+R)^n, and three ways to estimate NPV
Yuxing Yan
Chapter2: Time value of money (Part I): FV=PV(1+R)^n, PV=FV/(1+R)^n, and three ways to estimate NPV
41:25
Chapter 1: Introductoin to Corporate Finance (FNCE311, Managerial Finance), R-assisted learning env
Yuxing Yan
Chapter 1: Introductoin to Corporate Finance (FNCE311, Managerial Finance), R-assisted learning env
33:10
DANL100: Intro convert sentence (text) to voice. Students are not reqauired to understand the code.
Yuxing Yan
DANL100: Intro convert sentence (text) to voice. Students are not reqauired to understand the code.
6:58
CO2 emissions in 2020: Who are the top 15 countries? Generating a pie by using Excel, R and Python
Yuxing Yan
CO2 emissions in 2020: Who are the top 15 countries? Generating a pie by using Excel, R and Python
50:32
Fix the issues associated with the Python moviepy module installation plus 11 examples
Yuxing Yan
Fix the issues associated with the Python moviepy module installation plus 11 examples
52:26
Comparisons between R and Python (1/3), DANL100: Programming for Data Analytics
Yuxing Yan
Comparisons between R and Python (1/3), DANL100: Programming for Data Analytics
51:54
DANL100: Programming for Data Analytics, Chapter22: Project, Types I and II
Yuxing Yan
DANL100: Programming for Data Analytics, Chapter22: Project, Types I and II
44:21
Chapter21: Simple string manipulation using Python
Yuxing Yan
Chapter21: Simple string manipulation using Python
43:20
Estimating IBM’s annual returns and annual risk by using Excel, R and Python
Yuxing Yan
Estimating IBM’s annual returns and annual risk by using Excel, R and Python
57:53
Chapter 18: Python loops, conditions, logic 'and', 'or', and 'no', download all the SEC zip files
Yuxing Yan
Chapter 18: Python loops, conditions, logic 'and', 'or', and 'no', download all the SEC zip files
48:22
Chapter 17: A true date variable, Data Frame (I)., Data output, how to generate ff3Monthly.pickle
Yuxing Yan
Chapter 17: A true date variable, Data Frame (I)., Data output, how to generate ff3Monthly.pickle
1:20:22
Chapter 16: Data Input: generate our own data, read clipboard, CSV, text, pickle and Excel data
Yuxing Yan
Chapter 16: Data Input: generate our own data, read clipboard, CSV, text, pickle and Excel data
37:28
Chapter 15: Introduction to Python module
Yuxing Yan
Chapter 15: Introduction to Python module
35:19
Chapter14: Python basics (DANL100: Programming for Data Analytics)
Yuxing Yan
Chapter14: Python basics (DANL100: Programming for Data Analytics)
38:25
Chapter 13: Zip, SAS, Pickle data sets, and Google Drive
Yuxing Yan
Chapter 13: Zip, SAS, Pickle data sets, and Google Drive
47:20
Chapter9 and datacase5: statistical testing of the International Fisher Effect
Yuxing Yan
Chapter9 and datacase5: statistical testing of the International Fisher Effect
1:06:18
Chapter 12: Introduction to R packages, 3 ways to install a package, help, data set 4 all packages
Yuxing Yan
Chapter 12: Introduction to R packages, 3 ways to install a package, help, data set 4 all packages
48:44
DANL100 Programming for Data Analytics, Chapter 11: Simple string manipulation
Yuxing Yan
DANL100 Programming for Data Analytics, Chapter 11: Simple string manipulation
1:06:53
DANL100 Programming for Data Analytics, Chapter 10: Simple matrix manipulations
Yuxing Yan
DANL100 Programming for Data Analytics, Chapter 10: Simple matrix manipulations
40:23
DANL100, chapter9: Date variable, data frame, recycling rule, attach() , list(), unlist(),as.list()
Yuxing Yan
DANL100, chapter9: Date variable, data frame, recycling rule, attach() , list(), unlist(),as.list()
36:33
chapter8: Plot, pie, histogram, barplot, title, x-, y-labels, save our images, moving GIF, add music
Yuxing Yan
chapter8: Plot, pie, histogram, barplot, title, x-, y-labels, save our images, moving GIF, add music
38:27
DANL100: Chapter 7: loops and conditions (2), pv perpetuity, annuity, NPV, IRR,parse SEC index file
Yuxing Yan
DANL100: Chapter 7: loops and conditions (2), pv perpetuity, annuity, NPV, IRR,parse SEC index file
1:25:34
Chapter 7: Loops and conditions, logic 'and'. 'or' and 'no', dumping all the SEC index zip files
Yuxing Yan
Chapter 7: Loops and conditions, logic 'and'. 'or' and 'no', dumping all the SEC index zip files
1:09:46
DANL100:Chapter 5:Simple data manipulation,𝐡𝐞𝐚𝐝,𝐭𝐚𝐢𝐥,𝐬𝐮𝐦𝐦𝐚𝐫𝐲, dim,nrow, sort,order,cbind,rbind
Yuxing Yan
DANL100:Chapter 5:Simple data manipulation,𝐡𝐞𝐚𝐝,𝐭𝐚𝐢𝐥,𝐬𝐮𝐦𝐦𝐚𝐫𝐲, dim,nrow, sort,order,cbind,rbind
40:29
DANL100:Chapter 6:Data output,𝐰𝐫𝐢𝐭𝐞.𝐜𝐬𝐯,𝐰𝐫𝐢𝐭𝐞.𝐭𝐚𝐛𝐥𝐞,save,load,load & url, saveRDS,readRDS,save.image
Yuxing Yan
DANL100:Chapter 6:Data output,𝐰𝐫𝐢𝐭𝐞.𝐜𝐬𝐯,𝐰𝐫𝐢𝐭𝐞.𝐭𝐚𝐛𝐥𝐞,save,load,load & url, saveRDS,readRDS,save.image
31:11
DANL100: Chapter 3: Open data, 𝐒𝐄𝐂 𝐟𝐢𝐥𝐢𝐧𝐠𝐬, 𝐘𝐚𝐡𝐨𝐨!𝐅𝐢𝐧𝐚𝐧𝐜𝐞, Census, 𝐅𝐑𝐄𝐃 Data, Fr𝐞𝐧𝐜𝐡's 𝐃𝐚𝐭𝐚 𝐋𝐢𝐛𝐫𝐚𝐫𝐲
Yuxing Yan
DANL100: Chapter 3: Open data, 𝐒𝐄𝐂 𝐟𝐢𝐥𝐢𝐧𝐠𝐬, 𝐘𝐚𝐡𝐨𝐨!𝐅𝐢𝐧𝐚𝐧𝐜𝐞, Census, 𝐅𝐑𝐄𝐃 Data, Fr𝐞𝐧𝐜𝐡's 𝐃𝐚𝐭𝐚 𝐋𝐢𝐛𝐫𝐚𝐫𝐲
21:07
Programming for Data Analytics: Chapter 4: Data input, seq(),c(), read.csv(),read.table(),load()
Yuxing Yan
Programming for Data Analytics: Chapter 4: Data input, seq(),c(), read.csv(),read.table(),load()
48:42
Programming for Data Analytics: DANL100, Chapter 2: Writing simple R functions, 1-line to multi-line
Yuxing Yan
Programming for Data Analytics: DANL100, Chapter 2: Writing simple R functions, 1-line to multi-line
33:16
Programming for Data Analytics (DANL100) Chapter 1: R basics, how to download an install R, etc.
Yuxing Yan
Programming for Data Analytics (DANL100) Chapter 1: R basics, how to download an install R, etc.
44:26
Individualized exams: how my students take exams; 2 examples, design your own exams using my code
Yuxing Yan
Individualized exams: how my students take exams; 2 examples, design your own exams using my code
47:44
2 functions; correlation between 2 exchange rates , what is VaR?, VaR 4 $5 million foreign currency
Yuxing Yan
2 functions; correlation between 2 exchange rates , what is VaR?, VaR 4 $5 million foreign currency
24:09
Name a cell; Multinomial Distribution Goodness of Fit Test; Equality of Population Proportions
Yuxing Yan
Name a cell; Multinomial Distribution Goodness of Fit Test; Equality of Population Proportions
37:31
Draw 𝝌^𝟐 density distribution, test of equal distributions, test whether data follow the Benford Law
Yuxing Yan
Draw 𝝌^𝟐 density distribution, test of equal distributions, test whether data follow the Benford Law
30:26
Test of independence using Excel: formulae, two decision rules and one example
Yuxing Yan
Test of independence using Excel: formulae, two decision rules and one example
18:59
Hypothesis test of equal means for two samples: 1) using formulae, 2) using Excel function
Yuxing Yan
Hypothesis test of equal means for two samples: 1) using formulae, 2) using Excel function
38:58
Hypothesis tests using Excel: two-sided vs. one-sided tests when standard deviation is given
Yuxing Yan
Hypothesis tests using Excel: two-sided vs. one-sided tests when standard deviation is given
38:18
From Margin of Error to n, Confidence internal for proportion, from daily prices to annual returns
Yuxing Yan
From Margin of Error to n, Confidence internal for proportion, from daily prices to annual returns
41:21
Draw student-t density/cumulative density distributions, 3 ways to estimate Margin of of Error
Yuxing Yan
Draw student-t density/cumulative density distributions, 3 ways to estimate Margin of of Error
28:47
Direct/indirect quotations, cross exchange rate, triangular arbitrage with/without spread
Yuxing Yan
Direct/indirect quotations, cross exchange rate, triangular arbitrage with/without spread
19:47
Normal distribution using Excel, density vs. cumulative distributions, expondist(), VBA exponD()
Yuxing Yan
Normal distribution using Excel, density vs. cumulative distributions, expondist(), VBA exponD()
34:33
Uniform distribution using Excel density function and cumulative density function
Yuxing Yan
Uniform distribution using Excel density function and cumulative density function
28:45
Concept: Bivariate vs. binomial; Review: combinations; Intro to Binomial and Poisson distributions
Yuxing Yan
Concept: Bivariate vs. binomial; Review: combinations; Intro to Binomial and Poisson distributions
46:23
Uniformly distributed random numbers, estimate variance, covariance when probability is given
Yuxing Yan
Uniformly distributed random numbers, estimate variance, covariance when probability is given
57:43
Complement, union, interception, conditional probability, multiplication law , independence etc.
Yuxing Yan
Complement, union, interception, conditional probability, multiplication law , independence etc.
23:47
Combination and permutation (concepts, formulae and Excel related functions)
Yuxing Yan
Combination and permutation (concepts, formulae and Excel related functions)
27:45
Estimate variance, standard deviation, Z-score manually & using Excel for both population & sample
Yuxing Yan
Estimate variance, standard deviation, Z-score manually & using Excel for both population & sample
33:59
Estimate arithmetic, geometric, weighted mean, median, mode, percentile, quartile by using Excel
Yuxing Yan
Estimate arithmetic, geometric, weighted mean, median, mode, percentile, quartile by using Excel
38:24
Simpson's paradox: Three examples
Yuxing Yan
Simpson's paradox: Three examples
28:35
Business and Economics Statistics (Week 2: 1/2)
Yuxing Yan
Business and Economics Statistics (Week 2: 1/2)
13:28
Business and Economics Statistics (ECON205) Week #1: Part 2 (2/2)
Yuxing Yan
Business and Economics Statistics (ECON205) Week #1: Part 2 (2/2)
43:46
International Finance (FNCE316) Week #1: 1/2
Yuxing Yan
International Finance (FNCE316) Week #1: 1/2
25:58
Business and Economics Statistics (Week 1, 1/2)
Yuxing Yan
Business and Economics Statistics (Week 1, 1/2)
29:24
Learning simpe Excel Macro in 20 minutes
Yuxing Yan
Learning simpe Excel Macro in 20 minutes
18:59
Normality Test: the procedure and one example: Do IBM’s returns follow a normal distribution?
Yuxing Yan
Normality Test: the procedure and one example: Do IBM’s returns follow a normal distribution?
22:19
Fama-French 3-factor model, one of the most popular asset pricing models
Yuxing Yan
Fama-French 3-factor model, one of the most popular asset pricing models
19:42
CAPM (Capital Asset Pricing Model) . What is the beta (market risk) for IBM?
Yuxing Yan
CAPM (Capital Asset Pricing Model) . What is the beta (market risk) for IBM?
15:18
Black-Sholes-Merton option model (European options) using Excel
Yuxing Yan
Black-Sholes-Merton option model (European options) using Excel
32:20
Basic concepts for option theory: no math, various trading strategies, using Excel
Yuxing Yan
Basic concepts for option theory: no math, various trading strategies, using Excel
26:39
Durbin-Watson Test for autocorrelation
Yuxing Yan
Durbin-Watson Test for autocorrelation
28:37
Learning VBA (Visual Basic Applications) in just 5 minutes
Yuxing Yan
Learning VBA (Visual Basic Applications) in just 5 minutes
20:58
Event study
Yuxing Yan
Event study
27:41
Granger causality: correlation vs. causality, one example: Chicken or eggs, who causes whom?
Yuxing Yan
Granger causality: correlation vs. causality, one example: Chicken or eggs, who causes whom?
19:53
Definition, simple examples, Excel duration() and my durationYan() functions
Yuxing Yan
Definition, simple examples, Excel duration() and my durationYan() functions
29:01
Conversion of effective interest rates
Yuxing Yan
Conversion of effective interest rates
15:40
Multivariate Regression
Yuxing Yan
Multivariate Regression
17:22
Simple linear regression (Part 1)
Yuxing Yan
Simple linear regression (Part 1)
19:49
Simple linear regression (Part 2)
Yuxing Yan
Simple linear regression (Part 2)
20:09
Benford Law: an example of 23 receipts
Yuxing Yan
Benford Law: an example of 23 receipts
20:42
stock1
Yuxing Yan
stock1
22:00