Assuming the below annual rates of return:

Annual Rates of Return:

Wamart - 12.36%

Coca Cola - 25.51%

Pfizer - 14%

CVS - 32.99%

Berkshire Hathaway - 29.66%

1. Choose percentages of a potential initial investment that you want to allocate amongst the five (5) securities (weights in the portfolio).

   1. Create embedded formulae which generate statistical properties of the portfolio upon insertion of the weights.

   2. Observe the mean, the standard deviation, and the CV of the annual rate of return of the portfolio.