Question: Using the following returns, calculate the arithmetic average returns, the variances, and the standard deviations for X and Y. Ro the standard deviation, use the

Using the following returns, calculate the arithmetic average returns, the variances, and the standard deviations for X and Y. Ro the standard deviation, use the Excel function in SQRT.

	Returns	Returns
Year	X	Y
1	17%	23%
2	22	34
3	8	11
4	-15	-32
5	10	21

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

You bought one of Great White Shark Repellant Company's 8 percent coupon bonds one year ago for $790. These bonds make annual payments and mature 7 years from now. Suppose you decide to sell your...

2 3 4 Using the following returns, calculate the arithmetic average returns, the variances, and the standard deviations for X and Y. Input area: 5 6 7 8 9 10 11 12 13 (Use cells A6 to C11 from the...

this assignment is in excel please help find excel forumla ex: AVERAGE SUM SQRT Using the following returns, calculate the arithmetic average returns, the variances, and the standard deviations for X...

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

Using the following returns, calculate the arithmetic average returns, the variances, and the standard deviations for X and Y. Year X Y 1 13% 27% 2 26% 36% 3 7% 11% 4 -5% -29% 5 11% 16% (Use cells A6...

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%...

Using the following returns, calculate the arithmetic average returns, the variances, and the standard deviations for X and Y. Input area: \begin{tabular}{|ccc|} \hlineYear & X & Y \\ 1 & 13% & 27%...

Calculating returns and variability - Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Calibri 11 - % Paste BIU Cells Editing Alignment Number Conditional Format as Cell...

XDA 5 ? Calculating returns and variability - Excel FORMULAS DATA REVIEW FILE HOME INSERT PAGE LAYOUT VIEW Sign In BE Calibri 11 AA = % Paste BIU Cells Editing Alignment Number Conditional Format as...

Need an excel person to help with this. I don't know what cells or cell functions to use to solve this Using the following returns, calculate the arithmetic average returns, the variances, and the...

Explain how the genetic constitution of mitochondrial genome is related to it's function?

How is the potential upside of bonds and equities different? Equitios have a capped upside determined by the company's agreed repayments, while bonds offer the possibility of multiplied returns. Both...

26. Which of these may occur if a firm uses its overall cost of capital as the discount rate for all projects? I. Profitable low-risk projects may be incorrectly rejected. II. Only projects with...