Hint: First, create a table (with columns of min, max, result, prob) similar to examples we have done in class. Then, use that table to find how much the stocks price will change each week so that you can use that change value to find the stocks new weekly price.

2. The price of a share of a particular stock listed on the New York Stock Exchange is currently $42. The following probability distribution shows how the price per share is expected to change over a week: Stock Price Change Prob. 0.05 0.15 0.20 0.25 0.15 0.10 0.10 -2 -1 4 With the current price of $42 per share, simulate the price per share for next 60 weeks in MS Excel. What is the ending simulated price per share? (Hand in only the values and formulas print-outs) 2. The price of a share of a particular stock listed on the New York Stock Exchange is currently $42. The following probability distribution shows how the price per share is expected to change over a week: Stock Price Change Prob. 0.05 0.15 0.20 0.25 0.15 0.10 0.10 -2 -1 4 With the current price of $42 per share, simulate the price per share for next 60 weeks in MS Excel. What is the ending simulated price per share? (Hand in only the values and formulas print-outs)