a$.$ Calculate the portfolio return, $r_p,$ for each of the $6$ years assuming that $20\%$ is invested in VOO and $80\%$ is invested in QQQ$.$

b$.$ Calculate the average annual return for each ETF and the portfolio over the six$-$year period.

c$.$ Calculate the standard deviation of annual returns for each ETF and the portfolio. How does the portfolio standard deviation compare to the standard deviations of the individual ETFs?

d$.$ Calculate the correlation coefficient for the two ETFs. How would you characterize the correlation of returns of the two ETFs?

e$.$ Discuss any likely benefits of diversification achieved by Jamie through creation of the portfolio.

a$.$ The portfolio return for year $2014$ is $17\mathrm{.}21\%.($Round to two decimal places.$)$

The portfolio return for year $2015$ is $7\mathrm{.}95\%.($Round to two decimal places.$)$

The portfolio return for year $2016$ is $7\mathrm{.}55\%.($Round to two decimal places.$)$

The portfolio return for year $2017$ is ${31\mathrm{.}45}^{TT}\%.($Round to two decimal places.$)$

The portfolio return for year $2018$ is $-1\mathrm{.}94\%.($Round to two decimal places.$)$

The portfolio return for year $2019$ is $\%.($Round to two decimal places.$)$

b$.$ The average return of VOO over the $6-$year period is $12\mathrm{.}53\%.($Round to two decimal places.$)$

The average return of $QQQ$ over the $6-$year period is $,6.($Round to two decimal places.$)$

The average return of the portfolio over the $6-$year period is $16\mathrm{.}59\%.($Round to two decimal places.$)$

c$.$ The standard deviation of VOO returns over the $6-$year period is $\%.($Round to two decimal places.$)$

Data table

$($Click on the icon here in order to copy the contents of the data table below

into a spreadsheet.$)$

Please do the calculation with numbers not words