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. -2 0.05 -1 0.15 0 0.20 1 0.25 2 0.15 3 0.10 0.10 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 (one page for each)).

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. -2 0.05 -1 0.15 0 0.20 1 0.25 2 0.15 3 0.10 0.10 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 (one page for each)).

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018

18th Edition

ISBN:9780079039897

Author:Carter

Publisher:Carter

Chapter10: Statistics

Section10.6: Summarizing Categorical Data

Problem 10CYU

See similar textbooks