Name Ticker Dow Jones Index INDU index General ElectricGE US EQUITYNASDAQ 100 Stock Index NDX index American Express AXP US Equity Morgan Stanley MS US Equity In the Stockstab starting in column R, dothe following:

1)Create a rolling 12 month return column from INDU prices.

2)Create a rolling 12 month correlation column of INDU & GE

3)Create a rolling 12 month correlation column of INDU & NDX

4)Create a rolling 12 month correlation column of GE & AXP

5)Create a rolling 12 month correlation column of GE & MS

6)Create a line with marker schartof the above 12 month rolling correlations.

7)Add the legend to the top of the chart.

8)Add a title to the chart.

9)Add dates to the chart and the dates should be located at the bottom of the chart.

10)Create a rolling 12-monthstandarddeviation columns of the following tickersa.INDUb.GEc.NDXd.AXPe.MS

11)Create a line with markers chart to include the above rolling 12-monthstandard deviations. a.Add the legend to the top of the chart.b.Add a title to the chart.c.Add dates to the chart and the dates should be located at the bottom of the chart.

12)Create a new worksheet and call it Histogram. In that worksheet use the return columns of the following tickers to create histogramcharts and title each chart.Remember to use the max returns and min returns, so all of the histograms are using the same bin. To find the histogram, go to data, then to data analysis, then to histograma.INDUb.AXPc.After completing the AXP histogram, add the INDU frequencies data into the AXP histogram chart so that both frequencies are combined into one chart.Add a legend to the top of the chart.d.After doing C, then change the gap width to 0%.To find the gap width, click on one of the bars on the chart, right click, go to format data series

13)Create a new worksheet and call it If Functiona.Copy the NDX monthly returns into the if functionworksheet.b.In the first column to the right of the returns column write an if function that asks if returns > 0% thenOK next to that return. If the return < 0%, then theif function should cause the cell to be blank.c.In the next column you would like the if function to ask if returns are >2% and < 4% then Goodshould be in the cell. If the returns are outside of 2% and 4% then the cell should be blank.d.In the next column you would like the if function to ask if returns are >5% and <7% then Very Good should be in the cell or If returns are > 8% then Great should be in the cell.

14)Go to the Filter tab:a.Filter for dates of March 20,23, & 27 and simultaneously filter for quantity greater than 5Once completed, copy the tab and it will automatically be renamed Filter 2b.Go back to filter sheet and clear all the filters.c.Now filter for the rows highlighted in green and copy the tab. It will automatically be renamed Filter 3d.Go back to filter sheet and clear all the filters.e.Use advance filter, click copy to another location, highlight column C for the list range. Copy to should be cell M2. Click the unique records only box. Then hit Ok.