Intro Download weekly prices for Ford (ticker symbol F) from Yahoo Finance from 1/1/2014 to 12/27/2017 to an Excel tab and label it "F". To download the historical prices, go to Yahoo Finance and search for "F". Click on "Historical Prices" and set a date range from 1/1/2014 to 12/27/2017. Select "Weekly prices" and click on "Get prices." Click on "Download data." Attempt 4/10 for 5 pts. Part 1 Add another column labeled "Return" and calculate the weekly return based on the change in the adjusted close price. What was the return from 1/1/14 to 1/8/14? Attempt 2/10 for 9 pts. Part 2 To find beta, we also need the return on the market portfolio. Download the data for the S&P 500 (^GSPC) for the same time period onto a new tab labeled "GSPC". What was the return on the index from 1/1/14 to 1/8/14?