QUESTION $1$

You have observed a particular stock over the past year. Monthly returns have been as follows: $-7\%,-7\%,11\%,-8\%,0\%,2\%,2\%,-5\%,-1\%,-2\%,-4\%,11\%.$ Using Excel, calculate the average monthly returns to the nearest hundredth of a percent $(\mathrm{.}01).$ The average function is $=$average$().$

QUESTION $2$

You have observed a particular stock over the past year. Monthly returns have been as follows: $1\%,-6\%,9\%,-7\%,12\%,-4\%,-9\%,-1\%,11\%,2\%,-6\%,-11\%.$ Using Excel, calculate the standard deviation. For the standard deviation of a sample, use $=$ stdev.s$().$

$7\mathrm{.}886986$

$8\mathrm{.}005207$

$6\mathrm{.}680478$

$6\mathrm{.}939129$