Excel$-$Create a table.

$A.$ Title the table Annual Total Return.

$B.$ Create four columns. From left $to$ right, the columns should $be$ titled Year, $KO,NFLX,$

$SPY.$

$C.In$ the Year column, enter the past $10$ years $in$ ascending order.

$5.$ Below the table, skip one row. Then add a new table with two rows with the following titles:

$A.$ AVG $(for$ average annual return$)$

$B.SD(for$ standard deviation$)$

$6.$ Copy data from Morningstar $to$ the Excel table.

$A.$ For $KO,NFLX,$ and $SPY,$ enter the return data for each $of$ the past $10$ years next $to$ the

corresponding year $in$ the table.

$B.$ Calculate the following:

$i.$ The average annual return for the past $10$ years

$ii.$ The standard deviation for the past $10$ years

Enter the average annual return for each stock into the row $of$ the lower table titled

AVG.

Enter the standard deviation for each stock into the row $of$ the lower table titled $SD.$

Compare the differences $in$ returns and standard deviations $of$ the three sets $of$ data. Based $on$ your analysis, explain which one $of$ the three investment products you would choose $to$ invest $in$ and why.