Overview

This activity will help you gather and analyze data about returns and standard deviations.

Prompt

Use Morningstar to get annual pricing for the S&P $500$ exchange$-$traded fund $($ETF$)$ SPY$,$ Coca$-$Cola, and Netflix for the past $10$ years. Use the Module Two Activity Instructions to complete this activity.

Specifically, the following critical elements must be addressed:

I. Calculate the standard deviation for the $10-$year period for the S&P $500$ ETF SPY$,$ Coca$-$Cola, and Netflix. Support each calculation by showing the work involved.

II$.$ Calculate the annualized return for the $10-$year period. Support each calculation by showing the work involved.

III. 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.

What to Submit

You must submit a completed Excel spreadsheet that fulfills the requirements outlined in the Module Two Activity Instructions document.