Question

For this and the next 4 questions: Please use the following data to answer the questions that follow. You may copy over the data to Excel and use spreadsheet functions to perform the required analyses. 1. Calculate the covariance between the Market and Stock A. 2. Calculate the COVARIANCE BETWEEN STOCK B AND MARKET. 3. What is the VARIANCE OF STOCK A? 4. What is the STANDARD DEVIATION OF THE MARKET?

Year	Market	Stock A	Stock B
1	-0.10	-0.17	0.057
2	0.08	0.20	0.057
3	0.05	0.10	0.057
4	0.15	0.25	0.057
5	0.06	0.07	0.057

		0.0145
		-0.00268
		0.0000
		0.976
		None of the above

Answer 1

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

Home nert Page Layout Formulas Data Review View dd-Ins s Cut ta copy." Σ AutoSum ー E " ゴWrap Text в 1 프 . Ej-., Δ. : rーー 逻锂函Merge & Center. $, % , 弼,8 C Conditional Format CeInsert Delete Format Formatting as Table Styles2 Clear Sort &Find & Format Painter Clipboard Alignment Number Cells Edting AA197 Formula Bar AB AC AD AE AF AH Al Al 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 4 Sheet2 COV STOCK A (R(M)-E(R(M)))A2 DA2 R(A) R(A) ER(A) R(M) R(M)-ER(M) B*D 0.26 0.11 0.01 0.16 0.02 0.1 0.08 0.05 0.15 0.06 0.048 -0.148 0.03848 0.021904 0.032 0.00352 0.001024 0.002 0.000 0.000004 0.102 0.01632 0.010404 0.012 0.00024 0.000144 0.17 0.1 0.25 0.07 0.09 4 ER(A) ER(M) = COV(R(A), R(M)) 0.0581 ANS 1 COVARIANCE BETWEEN MARKET AND STOCK A = 0.0581 STOCK B SERIEScorr REGRESSIONCAMERAEXP RETURN TREND MATRK INTERVAL, NORMALHYPOTHESIS GPMATHSSheet