Question: Use the data in the spreadsheet provided to estimate the beta of Nike stock using linear regression. The beta of Nike stock is ___?_____ Returns

Use the data in the spreadsheet provided to estimate the beta of Nike stock using linear regression.

The beta of Nike stock is ___?_____

Returns (%)

S\&P 500 Nike

Jan 2004 2.3064 1.7529

Feb 2004 1.5467 5.1536

Mar 2004 -1.0685 6.5802

Apr 2004 -2.4230 -7.6024

May 2004 1.4127 -1.1119

Jun 2004 2.1563 6.7463

Jul 2004 -3.7681 -4.0132

Aug 2004 0.2714 3.5758

Sep 2004 2.0555 4.8998

Oct 2004 1.7810 3.1853

Nov 2004 4.8243 4.1200

Dec 2004 3.5180 7.4179

Jan 2005 -2.6557 -4.4768

Feb 2005 2.2695 0.3694

Mar 2005 -1.6937 -3.8988

Apr 2005 -2.5182 -7.8022

May 2005 3.7916 7.0173

Jun 2005 1.1531 5.6569

Jul 2005 4.3331 -3.2333

Aug 2005 -0.5943 -5.8353

Sep 2005 1.0609 3.8271

Oct 2005 -2.0784 2.9016

Nov 2005 4.0406 1.4872

Dec 2005 0.3476 2.1102

Jan 2006 4.0112 -6.7289

Feb 2006 -0.1644 7.2020

Mar 2006 1.9060 -1.5787

Apr 2006 1.2968 -3.8308

May 2006 -3.1042 -1.8695

Jun 2006 -0.0396 1.2452

Jul 2006 -0.1902 -2.4691

Aug 2006 2.5085 2.2279

Sep 2006 1.9452 8.8782

Oct 2006 3.7086 4.8619

Nov 2006 2.3716 7.6948

Dec 2006 1.0823 0.4548

Jan 2007 1.9438 -0.2222

Feb 2007 -1.3998 5.7282

Mar 2007 1.2949 2.0676

Apr 2007 3.9893 1.3740

May 2007 3.8894 5.3658

Jun 2007 -1.4758 3.0396

Jul 2007 -3.1753 -3.1566

Aug 2007 1.1623 -0.1949

Sep 2007 4.0903 4.4462

Oct 2007 2.5842 12.9560

Nov 2007 -4.9279 -0.9206

Dec 2007 -0.4342 -1.7974

Jan 2008 -6.2305 -4.5299

Feb 2008 -2.2040 -1.8425

Mar 2008 -1.0470 13.3389

Apr 2008 5.1144 -1.7647

May 2008 2.3825 2.3503

Jun 2008 -7.8625 -12.4762

Jul 2008 -1.315 -1.5601

Aug 2008 1.1042 3.2890

Sep 2008 -9.8060 10.7573

Oct 2008 -18.4726 -13.8565

Nov 2008 -8.5206 -7.6002

Dec 2008 2.1482 -3.7559

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Q:

Go to Chapter Resources on MyFinanceLab and use the data in the spreadsheet provided to estimate the beta of Nike stock using linear regression.

Q:

26. Go to Chapter Resources on and use the data in the spreadsheet provided to estimate the beta of Nike stock using linear regression.

Q:

23. Go to Chapter Resources on MyFinanceLab and use the data in the spreadsheet provided to estimate the beta of Nike stock using linear regression.

Q:

Go to Chapter Resources on MyLab Finance and use the data in the spreadsheet provided to estimate the beta of Nike stock using linear regression.

Q:

Use the data in the spreadsheet provided to estimate the beta of Nike stock using linear regression. Jan-09 Feb-09 Mar-09 Apr-09 May-09 Jun-09 Jul-09 Aug-09 Sep-09 Oct-09 Nov-09 Dec-09 Jan-10 Feb-10...

Q:

Returns (%) S\&P 500 Nike Jan 2004 2.3064 1.7529 Feb 2004 1.5467 5.1536 Mar 2004 -1.0685 6.5802 Apr 2004 -2.4230 -7.6024 May 2004 1.4127 -1.1119 Jun 2004 2.1563 6.7463 Jul 2004 -3.7681 -4.0132 Aug...

Q:

Returns (%) S\&P 500 Nike Jan 2004 2.3064 1.7529 Feb 2004 1.5467 5.1536 Mar 2004 -1.0685 6.5802 Apr 2004 -2.4230 -7.6024 May 2004 1.4127 -1.1119 Jun 2004 2.1563 6.7463 Jul 2004 -3.7681 -4.0132 Aug...

Q:

Use the data in the spreadsheet provided to estimate the beta of Nike stock using linear regression. The beta of Nike stock is (Round to four decimal places.) Returns (%) S&P 500 Nike 2.3064 1.7529...

Q:

Use the data in the spreadsheet provided to estimate the beta of Nike stock using linear regression. The beta of Nike stock is Returns (%) S&P 500 Nike Jan-09 2.3064 1.7529 Feb-09 1.5467 5.1536...

Q:

Go to Chapter Resources on MyFinanceLab and use the data in the spreadsheet provided to estimate the beta of Nike stock using linear regression. Go to Chapter Resources on MyFinanceLab and use the...

Q:

Consider a 22 matrix A= a b d (a) If a=-1,b=0,c=0,d=-2 Perform the following calculations. Calculate its full SVD (that is, find its U, , V); Show that U is an unitary matrix; Find the null-space,...

Q:

On January 1, 2014, you bought a new Toyota automobile for $ 30,000. You made a $ 5,000 cash down payment and signed a $ 25,000 note, payable in four equal instalments on each December 31, the first...

Q:

Your patient was immersed in a chemical that is mildly corrosive. A hazardous material spec statement is most accurate? The decontamination process has probably been underway for several minutes. The...

Q:

Which factors in the external environment could (positively or negatively) affect the success of Macys new strategy?

Q:

Let's revisit HW 3c. For the rebate amount of $5, create a 2-way data-table to study the effects of the demand increase (5% to 25% by the increment of 5%) and the percentage of claims (5% to 25% by...

Q:

Implement and solve the model using AMPL. Make sure that the model allows for changes in the data as well as the dimension (i.e., size) of the problem instance. Provide the .mod, .dat and .run files...

Q:

The regulation must be screened and approved by an administrative law judge as being in compliance with the Administrative Procedures Act. An administrative agency is a governmental board,...

Q:

Examine how other firms or industries develop international supply chains as compared to Darden.

Q:

Create a 200 word summary on the Juvenile Justice System than and today. Describe The Juvenile system and provide a generalizable definition. Highlight the issues in the Juvenile system and why this...

Q:

Escondido Company frequently sells merchandise on promissory notes. The following transac- tions relate to one such note: Feb. 1 Sold merchandise for $9,000 to Marta Tabor; accepted a 6-month, 11%...

Q:

Rabona Slice, a U.S. company, sold 100,000 cases of tropical fruit to Ben Thanh Market, a Vietnamese firm, for 2.5 billion Vietnamese dong. The sale was made on November tee 2003, when one U.S....

Q:

Boulder View Corporation accounts for uncollectible accounts receivable using the allowance method. As of December 31, 2002, the credit balance in Allowance for Bad Debts was $130,000. During 2003,...