# Data Table Use the data in the spreadsheet provided to estimate the beta of Shoe Company stock using linear regression. The beta of Shoe Company stock is (Round to four decimal places.) Jan-09 Feb-09 Mar-09 Apr-09 May-09 Jun-09 1.7207 5.1708 6.5347 - 7.6967 - 1.1591 6.7486 -4.0136 3.5324 4.8488 3.1701 Jul-09 Aug-09 Sep-09 Oct-09 Nov-09 4.1296 2.3386 1.5082 - 1.0838 -2.4777 1.4231 2.1838 -3.7076 0.2782 2.0849 1.7667 4.8317 3.5141 -2.6361 2.2786 - 1.6205 -2.5417 3.7904 1.1071 4.3773 -0.5325 1.0587 - 2.0795 4.0423 0.3858 Dec-09 Jan-10 Feb-10 Mar-10 7.4983 - 4.4103 0.3523 -3.8046 - 7.8989 7.0558 Apr-10 May-10 Jun-10 Jul-10 Aug-10 Sep-10 Oct-10 Nov-10 Dec-10 5.6491 - 3.1539 -5.8523 3.8584 2.9735 1.4769 2.1682 Jan-11 Feb-11 Mar-11 Apr-11 May-11 Jun-11 Jul-11 -6.7449 7.2928 -1.5526 -3.8522 -1.8648 1.2016 -2.4543 4.0153 -0.1631 1.9051 1.2959 -3.1039 -0.0332 -0.1927 2.5432 1.9039 3.7244 2.3693 1.0831 1.9432 -1.3949 Aug-11 Sep-11 Oct-11 Nov-11 Dec-11 Jan-12 Feb-12 Mar-12 Apr-12 May-12 Jun-12 Jul-12 Aug-12 Sep-12 Oct-12 Nov-12 Dec-12 1.2945 3.9187 3.8889 - 1.4943 - 3.1137 1.7243 4.0164 2.5858 -4.9318 -0.4313 2.2064 8.8169 4.8445 7.6385 0.4574 -0.2162 5.7468 2.0794 1.3728 5.3634 3.0084 -3.1158 -0.1939 4.4204 12.9198 -0.9073 - 1.7587 -0.2162 5.7468 2.0794 1.3728 Jan-12 Feb-12 Mar-12 Apr-12 May-12 Jun-12 Jul-12 Aug-12 Sep-12 Oct-12 Nov-12 Dec-12 Jan-13 Feb-13 Mar-13 Apr-13 May-13 Jun-13 Jul-13 Aug-13 Sep-13 Oct-13 Nov-13 Dec-13 1.9432 - 1.3949 1.2945 3.9187 3.8889 - 1.4943 - 3.1137 1.7243 4.0164 2.5858 -4.9318 -0.4313 -6.2197 -2.1913 - 1.0451 5.1376 2.3862 - 7.8614 - 1.317 1.1158 - 9.8741 - 18.4759 5.3634 3.0084 - 3.1158 -0.1939 4.4204 12.9198 -0.9073 - 1.7587 - 4.5979 - 1.8524 13.3123 - 1.7851 2.3238 - 12.4533 - 1.5256 3.2034 10.7336 - 13.8864 - 7.6018 -3.7537 -8.5236 2.1451 # Data Table Use the data in the spreadsheet provided to estimate the beta of Shoe Company stock using linear regression. The beta of Shoe Company stock is (Round to four decimal places.) Jan-09 Feb-09 Mar-09 Apr-09 May-09 Jun-09 1.7207 5.1708 6.5347 - 7.6967 - 1.1591 6.7486 -4.0136 3.5324 4.8488 3.1701 Jul-09 Aug-09 Sep-09 Oct-09 Nov-09 4.1296 2.3386 1.5082 - 1.0838 -2.4777 1.4231 2.1838 -3.7076 0.2782 2.0849 1.7667 4.8317 3.5141 -2.6361 2.2786 - 1.6205 -2.5417 3.7904 1.1071 4.3773 -0.5325 1.0587 - 2.0795 4.0423 0.3858 Dec-09 Jan-10 Feb-10 Mar-10 7.4983 - 4.4103 0.3523 -3.8046 - 7.8989 7.0558 Apr-10 May-10 Jun-10 Jul-10 Aug-10 Sep-10 Oct-10 Nov-10 Dec-10 5.6491 - 3.1539 -5.8523 3.8584 2.9735 1.4769 2.1682 Jan-11 Feb-11 Mar-11 Apr-11 May-11 Jun-11 Jul-11 -6.7449 7.2928 -1.5526 -3.8522 -1.8648 1.2016 -2.4543 4.0153 -0.1631 1.9051 1.2959 -3.1039 -0.0332 -0.1927 2.5432 1.9039 3.7244 2.3693 1.0831 1.9432 -1.3949 Aug-11 Sep-11 Oct-11 Nov-11 Dec-11 Jan-12 Feb-12 Mar-12 Apr-12 May-12 Jun-12 Jul-12 Aug-12 Sep-12 Oct-12 Nov-12 Dec-12 1.2945 3.9187 3.8889 - 1.4943 - 3.1137 1.7243 4.0164 2.5858 -4.9318 -0.4313 2.2064 8.8169 4.8445 7.6385 0.4574 -0.2162 5.7468 2.0794 1.3728 5.3634 3.0084 -3.1158 -0.1939 4.4204 12.9198 -0.9073 - 1.7587 -0.2162 5.7468 2.0794 1.3728 Jan-12 Feb-12 Mar-12 Apr-12 May-12 Jun-12 Jul-12 Aug-12 Sep-12 Oct-12 Nov-12 Dec-12 Jan-13 Feb-13 Mar-13 Apr-13 May-13 Jun-13 Jul-13 Aug-13 Sep-13 Oct-13 Nov-13 Dec-13 1.9432 - 1.3949 1.2945 3.9187 3.8889 - 1.4943 - 3.1137 1.7243 4.0164 2.5858 -4.9318 -0.4313 -6.2197 -2.1913 - 1.0451 5.1376 2.3862 - 7.8614 - 1.317 1.1158 - 9.8741 - 18.4759 5.3634 3.0084 - 3.1158 -0.1939 4.4204 12.9198 -0.9073 - 1.7587 - 4.5979 - 1.8524 13.3123 - 1.7851 2.3238 - 12.4533 - 1.5256 3.2034 10.7336 - 13.8864 - 7.6018 -3.7537 -8.5236 2.1451