Calculate the annual returns for each year. Calculate the average stock price, average return, and standard deviation over this period. I have attached the tables its for Microsoft for the last 5 years
Sheet1 Date,Open,High,Low,Close,Volume,Adj Close 11/1/2012,28.84,29.56,28.82,29.52,144095800,29.52 10/1/2012,29.81,30.25,27.76,28.54,55946000,28.54 9/4/2012,30.45,31.61,29.74,29.76,49859800,29.76 8/1/2012,29.59,30.96,28.97,30.82,30797300,30.82 7/2/2012,30.62,31.05,28.54,29.47,42105900,29.28 6/1/2012,28.76,31.14,28.32,30.59,48969400,30.39 5/1/2012,32.05,32.34,28.64,29.19,47886600,29 4/2/2012,32.22,32.89,30.23,32.02,48821800,31.6 3/1/2012,31.93,32.95,31.49,32.26,44277900,31.84 2/1/2012,29.79,32,29.71,31.74,52182700,31.33 1/3/2012,26.55,29.95,26.39,29.53,70271500,28.95 12/1/2011,25.56,26.19,25.16,25.96,49264800,25.45 11/1/2011,26.19,27.2,24.3,25.58,53693200,25.08 10/3/2011,24.72,27.5,24.26,26.63,60235300,25.92 9/1/2011,26.46,27.5,24.6,24.89,63522800,24.22 8/1/2011,27.51,27.69,23.79,26.6,77332100,25.89 7/1/2011,25.93,28.15,25.84,27.4,68186700,26.5 6/1/2011,24.99,26,23.65,26,61377000,25.14 5/2/2011,25.94,26.25,24.03,25.01,67821800,24.19 4/1/2011,25.53,26.87,24.72,25.92,81660300,24.9 3/1/2011,26.6,26.78,24.68,25.39,59744300,24.39 2/1/2011,27.8,28.34,26.43,26.58,61355100,25.54 1/3/2011,28.05,29.46,27.42,27.73,71312700,26.49 12/1/2010,25.57,28.4,25.56,27.91,48111900,26.66 11/1/2010,26.88,28.87,24.93,25.26,68402700,24.13 10/1/2010,24.77,27.2,23.78,26.67,66458300,25.32 9/1/2010,23.67,25.53,23.54,24.49,63542900,23.25 8/2/2010,25.99,26.38,23.32,23.47,61156600,22.28 7/1/2010,23.09,26.41,22.73,25.81,71053500,24.37 6/1/2010,25.53,26.93,22.95,23.01,79675500,21.73 5/3/2010,30.67,31.06,24.56,25.8,89381300,24.36 4/1/2010,29.35,31.58,28.62,30.54,65821100,28.71 3/1/2010,28.77,30.57,28.24,29.29,51043300,27.53 2/1/2010,28.39,29.03,27.57,28.67,58684900,26.95 1/4/2010,30.62,31.24,27.66,28.18,81765200,26.37 12/1/2009,29.52,31.5,29.25,30.48,43297000,28.52 11/2/2009,27.7,30.14,27.41,29.41,53121400,27.52 10/1/2009,25.41,29.35,24.43,27.73,72581900,25.83 9/1/2009,24.35,26.25,23.76,25.72,52500600,23.96 8/3/2009,23.82,25.49,23.03,24.65,49659200,22.96 7/1/2009,24.05,25.72,22,23.52,71441700,21.79 6/1/2009,21,24.34,20.86,23.77,67163500,22.02 5/1/2009,20.19,20.94,19.01,20.89,57362800,19.35 4/1/2009,18.23,21.2,18.18,20.26,78563800,18.65 3/2/2009,15.96,18.88,14.87,18.37,78069100,16.91 2/2/2009,17.03,19.93,16.1,16.15,81560000,14.87 1/2/2009,19.53,21,16.75,17.1,81319400,15.63 12/1/2008,19.88,21.25,18.47,19.44,72425500,17.77 11/3/2008,22.48,23.66,17.5,20.22,95976900,18.48 10/1/2008,26.38,27.47,20.65,22.33,136418800,20.28 9/2/2008,27.67,27.76,23.5,26.69,96891900,24.24 8/1/2008,25.92,28.5,25.07,27.29,59889700,24.78 7/1/2008,27.27,27.91,24.87,25.72,77180100,23.26 6/2/2008,28.24,29.57,27.11,27.51,77058100,24.88 5/1/2008,28.5,30.53,27.95,28.32,69931800,25.61 4/1/2008,28.83,32.1,27.93,28.52,69066000,25.7 3/3/2008,27.24,29.59,26.87,28.38,74958500,25.57 2/1/2008,31.06,33.25,27.02,27.2,122053500,24.51 1/2/2008,35.79,35.96,31.04,32.6,97806800,29.26 12/3/2007,33.5,36.72,32.63,35.6,55002300,31.96 11/1/2007,36.53,37.5,32.68,33.6,90498800,30.16 10/1/2007,29.46,37,29.29,36.81,85080900,32.93 9/4/2007,28.5,29.85,28.27,29.46,61223000,26.36 8/1/2007,28.95,30.1,27.51,28.73,55264800,25.7 7/2/2007,29.67,31.84,28.95,28.99,64862000,25.85 6/1/2007,30.79,30.9,29.04,29.47,59647900,26.27 5/1/2007,29.94,31.16,29.9,30.69,64202000,27.36 4/2/2007,27.89,30.74,27.56,29.94,51337600,26.61 3/1/2007,27.82,28.55,26.6,27.87,59843900,24.77 2/1/2007,30.84,30.94,27.79,28.17,72483300,25.03 1/3/2007,29.91,31.48,29.4,30.86,69924300,27.33 Page 1 Sheet1 Date Dividends 08/14/12 0.2 05/15/12 0.2 02/14/12 0.2 11/15/11 0.2 08/16/11 0.16 05/17/11 0.16 02/15/11 0.16 11/16/10 0.16 08/17/10 0.13 05/18/10 0.13 02/16/10 0.13 11/17/09 0.13 08/18/09 0.13 05/19/09 0.13 02/17/09 0.13 11/18/08 0.13 08/19/08 0.11 05/13/08 0.11 02/19/08 0.11 11/13/07 0.11 08/14/07 0.1 05/15/07 0.1 02/13/07 0.1 Page 1
