Question: Use the data in the spreadsheet provided below to estimate the beta of Shoe Company stock using linear regression. Question: Part 1 The beta of
Use the data in the spreadsheet provided below to estimate the beta of Shoe Company stock using linear regression. Question: Part 1 The beta of Shoe Company stock is (Round to four decimal places.) Returns (%) Value WeightedMarket ShoeCompany Jan 2004 2.3022 1.7105 Feb 2004 1.5103 5.1337 Mar 2004 -1.0791 6.5264 Apr 2004 -2.4624 -7.6967 May 2004 1.4384 -1.1147 Jun 2004 2.1051 6.7109 Jul 2004 -3.7254 -4.0942 Aug 2004 0.2766 3.5071 Sep 2004 2.0073 4.8727 Oct 2004 1.7656 3.1499 Nov 2004 4.8466 4.1787 Dec 2004 3.5394 7.4078 Jan 2005 -2.6569 -4.4866 Feb 2005 2.2494 0.3003 Mar 2005 -1.6211 -3.8666 Apr 2005 -2.5851 -7.8635 May 2005 3.7625 7.0312 Jun 2005 1.1429 5.6306 Jul 2005 4.3048 -3.2889 Aug 2005 -0.5576 -5.8742 Sep 2005 1.0029 3.8675 Oct 2005 -2.0689 2.9609 Nov 2005 4.0117 1.4239 Dec 2005 0.3647 2.1756 Jan 2006 4.0453 -6.7069 Feb 2006 -0.1675 7.2826 Mar 2006 1.9122 -1.5367 Apr 2006 1.2987 -3.8335 May 2006 -3.1364 -1.8397 Jun 2006 -0.0315 1.2902 Jul 2006 -0.1996 -2.4315 Aug 2006 2.5655 2.2515 Sep 2006 1.9162 8.8522 Oct 2006 3.7282 4.8342 Nov 2006 2.3769 7.6266 Dec 2006 1.0842 0.4536 Jan 2007 1.9481 -0.2111 Feb 2007 -1.3956 5.7442 Mar 2007 1.2986 2.0888 Apr 2007 3.9939 1.3906 May 2007 3.8841 5.3482 Jun 2007 -1.4515 3.0572 Jul 2007 -3.1448 -3.1178 Aug 2007 1.4289 -0.1941 Sep 2007 4.0467 4.4516 Oct 2007 2.5879 12.9063 Nov 2007 -4.9021 -0.9039 Dec 2007 -0.4346 -1.7891 Jan 2008 -6.2009 -4.5446 Feb 2008 -2.2081 -1.8725 Mar 2008 -1.0435 13.3258 Apr 2008 5.1478 -1.7641 May 2008 2.3893 2.3407 Jun 2008 -7.8804 -12.4896 Jul 2008 -1.315 -1.5556 Aug 2008 1.1274 3.2407 Sep 2008 -9.8189 10.7094 Oct 2008 -18.4793 -13.8769 Nov 2008 -8.5213 -7.6082 Dec 2008 2.1496 -3.7502
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
