Question

In a recent 5-year period, mutual fund manager Diana Sauros produced the following percentage rates of return for the Mesozoic Fund. Rates of return on the market index are given for comparison 20 1 -1.4 -0.7 Fund Market index 2 +24.7 +15.0 3 +40.7 +31.7 4 +11.7 +11.0 5 +0.5- -0.5 points . a. Calculate (a) the average return on both the Fund and the index, and (b) the standard deviation of the returns on each. (Do not round intermediate calculations. Round your answers to 2 decimal places.) b. Did Ms. Sauros do better or worse than the market index on these measures? = = = x Answer is complete but not entirely correct. Mesozoic Market Fund Portfolio Return Return Average return 15.24 11.30 Standard deviation 17.64 x 13.35 Did Ms. Sauros do better or worse thane the market index on these measures?

just need standard deviations.

Answer 1

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

it is population standard deviation, you calculated sample standard deviation, otherwise all fine

STATS - Microsoft Excel (Product Activation Failed) Add-Ins File Home Insert Page Layout Formulas Data Review View - 2x % Cut Σ AutoSum : A Dr General Wrap Text Merge & Center - $ -% . Fill 2 Clear Styles Find & Select Formatting as Table Styles -11AA = = = U B- A Font C for QF QG Sort & Filter Editing Alignment Number Calibri E Copy Paste Format Painter B I Clipboard QK221 - I QD E 204 205 206 207 208 Cells QH Q Q QK QL QM QN QO MESOZOIC MESOZOIC X = FUND -1.4 24.7 40.7 11.7 0.5 Y = MARKET -0.7 15 31.7 209 210 XBAR = 15.24 (X-XBAR)^2 274.8964 90.6304 651.2704 12.1104 215.5024 1244.4100 (X-XBAR)^2 YBAR = 11.30 (Y-YBAR)^2 158.76 9.61 392.04 0.81 153.76 714.9800 E(Y-YBAR)^2 211 11 212 -0.5 213 214 215 TOTAL RETURN AVERAGE RETURN 76.20 15.24 [76.20/5] 56.5 11.30 [56.5/5] 216 217 218 VARIANCE n = NO OF OBSERVATIONS 219 220 (X-XBAR)^2/n 1244.41/5 248.88 (Y-YBAR)^2/n 714.9800/5 143.00 15.78 11.96 221 222 223 224 STANDARD DEVIATION SQRT(VARIANCE) PV FV DIVIDEND EMV MEAN STDV assignment DEAR Sheet2 COV TIME SERIEScorr REGRESSION range CAMERA TREND Sheet1 Sheet4 ferences Rea fregMATRIX INTERVAL, NIC I BOU 120% 1 + 9 . * ENG 30-11-2019 ... B