You can download the information when you find the stock on yahoo finance and download the historical data from Jan 1,2016 to Dec 31 2016

I don't know how to work excel very well yet and would appreciate the help! I need to submit the answer on an excel sheet

Using the following data to run a regression analysis to roughly estimate the beta of Amazon Dependent variable (Y): Daily holding period return of Amazon from Jan,1,2016 to Dec,31,2016. Independent variable (X): Daily holding period return of S&P 500 index from Jan,1,2016 to Dec,31,2016 (1) Report the regression output. (2) Plot the daily returns of Amazon and S&P on the same chart