Calculate the beta for a stock whose returns for 2019 were:

Jan 2.5%

Feb 1%

Mar 4.5%

Apr -2%

May 2%

June 6%

July 1%

Aug 2%

Sept -3%

Oct 5%

Nov 0%

Dec 1%

For market returns, use the monthly returns of the S&P 500 Total Return Index. (This index includes the dividend payments made by the individual stocks). (

Dec. 31, 2019	3.02%
Nov. 30, 2019	3.63%
Oct. 31, 2019	2.17%
Sept. 30, 2019	1.87%
Aug. 31, 2019	-1.58%
July 31, 2019	1.44%
June 30, 2019	7.05%
May 31, 2019	-6.35%
April 30, 2019	4.05%
March 31, 2019	1.94%
Feb. 28, 2019	3.21%
Jan. 31, 2019	8.01%

Send me an excel sheet with your work.