The annual returns of three shares of stock during the last seven years are pres
The annual returns of three shares of stock during the last seven years are presented in the following table:REQUIRED:Determine the average return and the standard deviation of returns for each stock. The formula for the average is AVERAGE(X1:Y5) and for the standard deviation is STDEVP(X1:Y5)Which stock has the highest expected return and which one has the highest risk in terms of volatility?
The annual returns of three shares of stock during the last seven years are presented in the following table:
REQUIRED: Determine the average return and the standard deviation of returns for each stock. The formula for the average is AVERAGE(X1:Y5) and for the standard deviation is STDEVP(X1:Y5) Which stock has the highest expected return and which one has the highest risk in terms of volatility?
Worksheet:
Attachments:
You can place an order similar to this with us. You are assured of an authentic custom paper delivered within the given deadline besides our 24/7 customer support all through.
Latest completed orders:
| # | topic title | discipline | academic level | pages | delivered |
|---|---|---|---|---|---|
|
6
|
Writer's choice
|
Business
|
University
|
2
|
1 hour 32 min
|
|
7
|
Wise Approach to
|
Philosophy
|
College
|
2
|
2 hours 19 min
|
|
8
|
1980's and 1990
|
History
|
College
|
3
|
2 hours 20 min
|
|
9
|
pick the best topic
|
Finance
|
School
|
2
|
2 hours 27 min
|
|
10
|
finance for leisure
|
Finance
|
University
|
12
|
2 hours 36 min
|
