ST 555 -- Summer 2013 Homework #6 -- Due MONDAY, 24 June 2013 In the sum13d directory are five (comma delimited) files of daily stock returns downloaded from Yahoo! Finance for the 2011 and 2012. The stocks are Alcoa (alcoa.csv), General Electric (ge.csv), Ford (ford.csv), DuPont (dupont.csv), 3M Corp (mmm.csv), Procter and Gamble (pg.csv), as well as the Standard & Poors 500 Index (SP500.csv). Also find two files of data from the St. Louis Federal Reserve Bank's FRED database (also comma delimited). One is the 10-Year Treasury rate (DGS10.csv); the other is a bond index from Moody's (DBAA.csv). a) Read one of the stock return files, focusing on the adjusted close. b) Read one of the monetary index files. c) Read the S&P Stock index. d) Put the datasets together with MERGE. e) For the two year time span, find the max, min, and mean values of the stock returns, the money index, and the S&P 500 Index. f) Find the correlations among the stock returns, money and stock indices, and time. g) Write and constructively use a user-written format. Note: Yahoo! Finance files have a record for each day the stock market is open; FRED files have a record for each Monday through Friday, with a missing value . for days when the exchange is not open. Both have a single line header.