Standard deviation and Variance on excel.

Use the data below to answer the determine variance and standard deviation. (note: carry your calculator out to 4 decimal places).
Year Actual Return Average Return Deviation for the Mean Squared Deviation
1 .12 .103 .017 .00028
2 .07 .103 -.033 .00108
3 .08 .103 -.023 .00052
4 .14 .103 .037 .00136
Total .41 .003240

Determine variance and standard deviation

a) 0.321142; 0.566722
b) 0.025548; 0.159765
c) 0.001080; 0.032863
d) 0.248829; 0.498893

© SolutionLibrary Inc. solutionlibary.com 9836dcf9d7 https://solutionlibrary.com/business/finance/standard-deviation-and-variance-on-excel-7h4u