Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Use the data in the spreadsheet provided to estimate the beta of Shoe CompanyShoe Company stock using linear regression. Returns (%) Value Weighted Market Shoe

Use the data in the spreadsheet provided to estimate the beta of Shoe CompanyShoe Company

stock using linear regression.

Returns (%)

Value Weighted Market

Shoe CompanyShoe Company

Jan-09

2.30152

1.7601

Feb-09

1.5808

5.1987

Mar-09

-1.0649

6.5576

Apr-09

-2.4357

-7.6108

May-09

1.4468

-1.1334

Jun-09

2.1527

6.7486

Jul-09

-3.7611

-4.0672

Aug-09

0.2768

3.5441

Sep-09

2.0166

4.8538

Oct-09

1.7753

3.1961

Nov-09

4.8619

4.1049

Dec-09

3.5717

7.4574

Jan-10

-2.6896

4.4585

Feb-10

2.2197

0.3099

Mar-10

1.6624

3.8113

Apr-10

2.5422

7.8247

May-10

3.7586

7.0296

Jun-10

1.1339

5.6732

Jul-10

4.3025

3.2924

Aug-10

0.5865

5.8396

Sep-10

1.0939

3.8811

Oct-10

2.0939

2.9872

Nov-10

4.0116

1.4941

Dec-10

0.3251

2.1446

Jan-11

4.0579

6.7494

Feb-11

0.1626

7.2391

Mar-11

1.9045

1.5976

Apr-11

1.2988

3.8654

May-11

3.1141

1.8419

Jun-11

0.0325

1.2115

Jul-11

0.1981

2.4799

Aug-11

2.5504

2.2602

Sep-11

1.9105

8.8557

Oct-11

3.7242

4.8627

Nov-11

2.3956

7.6072

Dec-11

1.0844

0.4579

Jan-12

1.9424

0.2014

Feb-12

1.3883

5.7138

Mar-12

1.2998

2.0164

Apr-12

3.9521

1.3568

May-12

3.8814

5.3452

Jun-12

1.4899

3.0215

Jul-12

3.1983

3.1795

Aug-12

1.2067

0.1991

Sep-12

4.0158

4.4518

Oct-12

2.5861

12.9138

Nov-12

4.9018

0.9301

Dec-12

0.4354

1.7546

Jan-13

6.2272

4.5648

Feb-13

2.2018

1.8896

Mar-13

1.0433

3.3668

Apr-13

5.1206

1.7846

May-13

2.3881

2.3563

Jun-13

7.8853

12.4808

Jul-13

1.317

1.5919

Aug-13

1.1092

3.2166

Sep-13

9.8413

10.7368

Oct-13

18.4738

13.8768

Nov-13

8.5204

7.6097

Dec-13

2.1404

3.7543

The beta of Shoe CompanyShoe Company

stock is:

(Round to four decimal places.)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Finance Introduction To Institutions Investments And Management

Authors: Ronald W. Melicher, Edgar A. Norton

11th Edition

0470004460, 978-0470004463

More Books

Students also viewed these Finance questions

Question

What applied experiences do you have? (For Applied Programs Only)

Answered: 1 week ago