Module-III: Excel Assignment
Excel Assignment: Note that you need to submit your excel file via Blackboard by 07/21/2021, 10:00 pm.
1) Go Yahoo! Finance and download daily prices for two stocks (Amazon: ticker- AMZN and Tesla: ticker-TSLA) from Dec. 31, 2019, to Jun 30, 2021.
2) Calculate the respective daily returns.
3) Compute the respective descriptive statistics (e.g. Mean, Standard deviation, kurtosis, and skewness) and analyze the values.
4) Plot the respective histograms and discuss them.