Sheet1 Spreadsheet Exercise...

Question

Sheet1

                                Spreadsheet Exercise 3
                Assets            Portfolios
                            AB    AC    BC
        Year    Stock A    Stock B    Stock C        (50% A + 50% B)    (50% A + 50% C)    (50% B + 50% C)
        2012    10%    10%    12%        10.00%    11.00%    11.00%
        2013    13%    11%    14%
        2014    15%    8%    10%
        2015    14%    12%    11%
        2016    16%    10%    9%
        2017    14%    15%    9%
        2018    12%    15%    10%
        Statistics:
    a.    Expected Value    AVERAGE(C9:C15)            c.
    b.    Standard Deviation    STDEVA(C9:C15)            d.
    e.
    f.
Sheet2
                            AB    AC    BC
        Year    Stock A    Stock B    Stock C        (50% A +...

Ayushi · Accepted Answer

Sheet1
	
								Spreadsheet Exercise 3
				Assets			Portfolios
							AB	AC	BC
		Year	Stock A	Stock B	Stock C		(50% A + 50% B)	(50% A + 50% C)	(50% B + 50% C)
		2012	10%	10%	12%		10.00%	11.00%	11.00%
		2013	13%	11%	14%
		2014	15%	8%	10%
		2015	14%	12%	11%
		2016	16%	10%	9%
		2017	14%	15%	9%
		2018	12%	15%	10%
		Statistics:
	a.	Expected Value	AVERAGE(C9:C15)			c.
	b.	Standard Deviation	STDEVA(C9:C15)			d.
	e.
	f.

Sheet1 Spreadsheet Exercise 3 Assets Portfolios AB AC BC Year Stock A Stock B Stock C (50% A + 50% B) (50% A + 50% C) (50% B + 50% C) 2012 10% 10% 12% 10.00% 11.00% 11.00% 2013 13% 11% 14%...

Solution

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment