Assignment #6 The file Dow.xlsx contains the monthly returns between the 30 stoc

Assignment #6
The file Dow.xlsx contains the monthly returns between the 30 stocks comprising the Dow Jones Index. Find the correlations between all stocks. Then, for each stock, use conditional formatting to highlight the three stocks most correlated with that stock. (Of course, you should not highlight a stock as correlated with itself.)
For 12 straight weeks, you have observed the sales (in number of cases) of canned tomatoes at Mr. D’s Supermarket. (See the file Grocery.xlsx.) Each week, you keep track of the following:
Was a promotional notice for canned tomatoes placed in all shopping carts?
Was a coupon for canned tomatoes given to each customer?
Was a price reduction (none, 1, or 2 cents off) given?
Use this data to determine how the above factors influence sales. Predict sales of canned tomatoes during a week in which you use a shopping cart notice, a coupon, and reduce the price by 1 cent.