5. Using the annual statistics, create an Excel plot with standard deviation (volatility) on the x-axis and average return on the y-axis as follows: a Create three columns on your spreadsheet with the statistics you created in Questions 3 and 4 for each of the individual stocks and the equally weighted port- folio. The first column will have the ticker, the second will have annual standard deviation, and the third will have the annual mean return.

b. Highlight the data in the last two columns (standard deviation and mean). choose > Insert > Chart > XY Scatter Plot. Complete the chart wizard to finish the plot.