A В 1 Equity A Weighted Weighted Squared State of Rate of Squared Deviation Probability Rate of Deviation Еconomy Return Return Deviation Recession 0.20 -0.15 =B3*C3 =C3-G6 =E3^2 =B3*F3 Normal 0.50 0.20 =B4*C4 =C4-G6 =E4^2 =B4*F4 Вoom 0.30 0.60 =B5*C5 =C5-G6 =E5^2 =B5*F5 Expected Return =D3+D4+D5 7 Variance =G3+G4+G5 Standard Deviation =SQRT(G7) 8 9 Equity B 10 Weighted Squared Weighted State of Rate of Squared Deviation 11 Probability Rate of Deviation Еconomy Return Return Deviation 12 Recession 0.20 0.20 =B12*C12 =C12-G15 |=E12^2 =B12*F12 13 Normal 0.50 0.30 =B13*C13 =C13-G15 |=E13^2 =B13*F13 14 Вoom 0.30 0.40 =B14*C14 =C14-G15 |=E14^2 =B14*F14 Expected Return =D12+D13+D14 15 16 Variance =G12+G13+G14 17 Standard Deviation =SQRT(G16)
A В 1 Equity A Weighted Weighted Squared State of Rate of Squared Deviation Probability Rate of Deviation Еconomy Return Return Deviation Recession 0.20 -0.15 =B3*C3 =C3-G6 =E3^2 =B3*F3 Normal 0.50 0.20 =B4*C4 =C4-G6 =E4^2 =B4*F4 Вoom 0.30 0.60 =B5*C5 =C5-G6 =E5^2 =B5*F5 Expected Return =D3+D4+D5 7 Variance =G3+G4+G5 Standard Deviation =SQRT(G7) 8 9 Equity B 10 Weighted Squared Weighted State of Rate of Squared Deviation 11 Probability Rate of Deviation Еconomy Return Return Deviation 12 Recession 0.20 0.20 =B12*C12 =C12-G15 |=E12^2 =B12*F12 13 Normal 0.50 0.30 =B13*C13 =C13-G15 |=E13^2 =B13*F13 14 Вoom 0.30 0.40 =B14*C14 =C14-G15 |=E14^2 =B14*F14 Expected Return =D12+D13+D14 15 16 Variance =G12+G13+G14 17 Standard Deviation =SQRT(G16)
Essentials of Business Analytics (MindTap Course List)
2nd Edition
ISBN:9781305627734
Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Chapter5: Probability: An Introduction To Modeling Uncertainty
Section: Chapter Questions
Problem 19P
Related questions
Question
Here How has been the value of G6 calculated? explanation please
Transcribed Image Text:A
D
F
G
Equity A
1
Weighted
Rate of
Weighted
Squared
State of
Rate of
Squared
Probability
Deviation
Economy
Return
Deviation
Return
Deviation
Recession
0.20
-0.15
=B3*C3
=C3-G6
|=E3^2
=B3*F3
4
Normal
0.50
0.20
=B4*C4
=C4-G6
=E4^2
=B4*F4
Вoom
0.30
0.60
=B5*C5
=C5-G6
=E5^2
=B5*F5
Expected Return
=D3+D4+D5
6.
7
Variance
=G3+G4+G5
Standard Deviation
=SQRT(G7)
9
Equity B
10
Weighted
Rate of
Weighted
Squared
State of
Rate of
Squared
Deviation
11
Probability
Deviation
Economy
Return
Return
Deviation
Recession
0.20
0.20
=B12*C12
=C12-G15 =E12^2
=B12*F12
12
13
Normal
0.50
0.30
=B13*C13
=C13-G15=E13^2
=B13*F13
14
Вoom
0.30
0.40
=B14*C14
=C14-G15 |=E14^2
=B14*F14
Expected Return
=D12+D13+D14
15
16
Variance
=G12+G13+G14
Standard Deviation
=SQRT(G16)
17
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.Recommended textbooks for you
Essentials of Business Analytics (MindTap Course …
Statistics
ISBN:
9781305627734
Author:
Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:
Cengage Learning
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning
Essentials of Business Analytics (MindTap Course …
Statistics
ISBN:
9781305627734
Author:
Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:
Cengage Learning
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning