Please include excel formula Using the following returns, calculate the arithmetic average returns, the variances, and the standard deviations for X and Y. Input area: YearXY 113%27% 226%36% 37%11% 4-5%-29% 511%16% (Use cells A6 to C11 from the given information to complete this question. You must use the built-in Excel function to answers this question. Make sure to use the “sample” Excel formulas.) Output area: Asset X: Average return Variance Standard deviation Asset Y: Average return Variance Standard deviation

It has been provided: Required: Asset X: Average return ? Variance ? Standard…

Answered: Using the following returns, calculate…

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 26P

See similar textbooks

Related questions

Question

Please include excel formula

Using the following returns, calculate the arithmetic average returns, the variances, and the standard deviations for X and Y.

Input area:

Year	X	Y
1	13%	27%
2	26%	36%
3	7%	11%
4	-5%	-29%
5	11%	16%

(Use cells A6 to C11 from the given information to complete this question. You must use the built-in Excel function to answers this question. Make sure to use the “sample” Excel formulas.)

Output area:

Asset X:
Average return
Variance
Standard deviation
Asset Y:
Average return
Variance
Standard deviation

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 3 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.

Similar questions