تم الحل ✓
categoryإحصاء
schoolبكالوريوس
event_available2026-07-15
السؤال
Transcribed Image Text:
(All answers were generated using 1,000 trials and native Excel functionality.)
Suppose that the price of a share of a particular stock listed on the New York Stock Exchange is currently $39. The following probability distribution shows how the price per share is expected to
change over a three-month period:
Stock Price Change ($)
-2
-2
Probability
0.05
0.10
0
0.25
+1
0.20
+2
0.20
+3
+4
0.10
0.10
(a) Construct a spreadsheet simulation model that computes the value of the stock price in 3 months, 6 months, 9 months, and 12 months under the assumption that the change in stock price
over any three-month period is independent of the change in stock price over any other three-month period. For a current price of $39 per share, what is the average stock price per share
12 months from now? What is the standard deviation of the stock price 12 months from now?
Round your answers to two decimal places.
Average
Standard Deviation
$
check_circle الجواب — حل مفصل خطوة بخطوة
hourglass_top
🔒
الحل الكامل متاح للمشتركين
اشترك في أرشيف الأسئلة لعرض هذا الحل وآلاف الحلول المفصلة خطوة بخطوة من معلمين معتمدين.