Use the table of annual returns in Problem 5.9 for Home Depot (HD) and Lowe's (LOW) to create an Excel spreadsheet that calculates the standard deviation of annual returns for HD, LOW, and the equally weighted portfolio of HD and LOW.

Table from Problem 5.9

LOW Returns 16.1% Year 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 -4.3% 1.0% -31.1% -11.4% 30.5% 25.0% 23.5% 50.3% 35.9% 30.2% 26.8% -3.3% 10.6% 9.2% 3.4% 42.9% 41.8% 41.2%