DJIA vs. Amazon Stock

The Dow Jones Industrial Average (DJIA) is a stock market index.Amazon Download the daily stock price data for DJIA and your selected company DJIA in the last five years for the following tasks: a) Create a line chart that shows the DJIA adjusted price over time. (2.5 points) b) Create a line chart that shows the DJIA adjusted price as compared with your selected companys adjusted stock price. For this chart, use dual axes. (2.5 points) c) Compute the daily returns for the DJIA, and display these in a histogram. (2.5 points) d) Create a scatter chart showing the relationship of the DJIA daily return to the daily returns of your selected company. (2.5 points

2. A company has two divisions that have provided historical and project income statements. The data can be found in diva-incstmt.csv and divb-incstmt.csv. a) Clean the data first. (2.5 points) Then create the following charts to visualize the data: b) A stacked bar chart of historical and projected sales over time that includes both divisions sales. The X-axis must be the Year. (2.5 points) c) A clustered bar chart of sales over time that includes both divisions sales. The X-axis must be the Year. (2.5 points) d) Two separate pie charts, one for each division, showing the different kinds of expenses forecasted for 2021. (2.5 points) (Tip: the code to read diva-incstmt.csv is : dfdiva = pd.read_csv('diva-incstmt.csv', skiprows=5, usecols=[0,1,2,3,5]) )