##### Hi you helped me on previous homework, can you help me with this-(Answered)

**Description**

Instant Solution ? Click "Buy button" to Download the solution File

**Question**

Hi you helped me on previous homework, can you help me with this one please. thank you very much

HOMEWORK

QUESTIONS

Subject

Code

and

Title

STAT

2000:

Quantitative

Analysis

Assessment

Module

5:

Homework

questions

Additional

Information

When

there

is

evidence

of

academic

dishonesty,

a

student

will

face

Misconduct

Procedures.

Please

refer

to

Torrens

policies

and

procedures

in:

http://www.torrens.edu.au/about/policies

Instructions

Answer

these

questions

and

problems

Chapter

14

Questions

and

problems

23,

24,

25,

26,

27,

28,

29,

30,

33,

34,

40

Use

the

following

data

and

Microsoft

Excel

program

to

answer

questions

23?30.

The

table

gives

monthly

rates

of

return

for

3-??month

treasury

bills;

the

value

weighted

New

York

Stock

Exchange

Index;

and

Chrysler,

Ford,

and

GM

stock.

23.

In

finance,

we

are

often

interested

in

how

the

return

of

one

stock

is

related

to

some

market

index

such

as

the

NYSE.

The

model

we

usually

estimate

to

understand

this

relationship

is

known

as

the

market

model

and

is

given

by

the

equation

R

j,

t

=

?j

+

?

j

R

m,

t

+

e

j,

t

where:

R

j,

t

=

return

on

stock

j

in

month

t

R

m,

t

=

return

on

some

market

index

in

month

t

?j =

intercept

of

the

regression

line

?j

=

slope

of

the

regression

line

e

j,

t =

a

random

error

term

Use

Excel

to

do

the

following:

(a)

Draw

a

scatter

diagram

for

Ford

and

the

NYSE

index.

(b)

Estimate

the

parameters

?

and

?.

(c)

Compute

SSE,

SSR,

SST,

R2,

and

the

standard

error

of

the

estimate

for

this

regression.

(d)

Compute

the

standard

error

for

b,

and

use

a

t-??

test

to

test

the

significance

of

the

slope

of

the

regression.

Page

1

of

4

24.

In

finance,

we

sometimes

choose

to

estimate

the

capital

asset

pricing

(CAPM)

version

of

the

market

model,

which

is

given

by

the

equation

where

Rj,t

is

the

return

on

a

risk-??free

asset

(such

as

T-??bills)

in

month

t.

Repeat

parts

(a)?(d)

of

question

23

for

the

CAPM

version

of

the

market

model

using

the

Excel

program.

25.

Using

R2

as

the

measure

of

goodness

of

fit,

compare

the

market

model

estimated

in

question

23

with

the

CAPM

version

estimated

in

question

24.

26.

Find

a

95

%

confidence

interval

for

the

slope

coefficients

you

calculated

in

questions

23

and

24.

Which

estimate

of

?

has

the

wider

confidence

interval?

Page

2

of

4

27.

Suppose

we

are

interested

in

testing

whether

?

is

equal

to

1.

Then

we

would

test

H0:

?

=

1

against

H1:

?

?1.

Using

the

model

given

in

question

23,

test

this

hypothesis.

28.

Repeat

questions

23?27,

using

GM

stock?s

rates

of

return.

29.

Repeat

questions

23?27,

using

Chrysler

stock?s

rates

of

return.

30.

Suppose

we

are

interested

in

the

relationship

between

the

return

on

the

risk-??free

asset

(T-??bills)

and

the

return

on

the

NYSE

index.

(a)

Estimate

the

intercept

and

the

slope

for

a

regression

of

R

m,

t

on

R

f,

t.

(b)

Compute

the

standard

error

of

the

regression

and

use

a

t-??

test

to

test

the

significance

of

b.

(c)

Calculate

a

99

%

confidence

interval

for

b.

33.

When

estimating

the

relationship

between

the

price

of

a

good

and

the

quantity

of

the

good

sold

(the

demand

curve),

economists

sometimes

choose

to

transform

the

price

and

quantity

data

by

taking

the

natural

logarithm

of

both.

When

this

is

done,

the

slope

coefficient

b

can

be

interpreted

as

the

price

elasticity

of

demand

(the

sensitivity

of

quantity

to

changes

in

price).

Consider

the

following

information

on

the

price

and

quantity

of

So-??Good

Candy

Bars.

Price

($)

Quantity

1.50

100

1.25

135

1.00

175

0.75

225

0.50

300

0.25

500

Use

the

EXCEL

program

to

answer

the

following:

(a)

Estimate

the

elasticity

of

demand

for

these

data.

(b)

Use

a

t-??

test

to

test

the

significance

of

b.

(c)

Construct

a

95

%

confidence

interval

for

the

price

elasticity.

34.

The

batting

instructor

of

the

Minnesota

Twins

is

interested

in

the

relationship

between

number

of

hours

of

batting

practice

and

batting

average.

He

collects

the

following

data

on

8

players:

Hours

of

batting

practice

per

week

5

8

9

10

11

9

7

6

Batting

Average

0.265

0.277

0.254

0.320

0.301

0.260

0.230

0.272

Use

the

EXCEL

program

to

answer

the

following:

Page

3

of

4

(a)

Draw

a

scatter

diagram

for

these

data.

(b)

Compute

the

regression

parameters

a

and

b.

(c)

Compute

the

standard

error

of

b,

and

use

a

t

-??test

to

test

the

significance

of

the

slope

of

the

regression.

(d)

Construct

a

95

%

confidence

interval

for

b.

40.

Investment

advisors

sometimes

recommend

holding

gold

as

part

of

an

investor?s

portfolio,

because

the

value

of

gold

appears

to

be

negatively

related

to

that

of

the

stock

market.

Thus,

when

the

stock

market

goes

down

in

value,

the

value

of

gold

goes

up

in

value,

and

some

of

the

investor?s

losses

in

the

market

are

offset

by

gains

in

the

value

of

her

or

his

gold.

The

accompanying

table

shows

data

on

annual

rates

of

return

for

a

gold

mutual

fund

and

for

the

S&P

500.

Year

1979

1980

1981

1982

1983

1984

1985

1986

1987

1988

Gold

mutual

fund

151.30

70.70

-??18.90

47.30

8.20

-??25.30

-??11.00

30.10

51.50

11.30

S&P

500

18.16

31.48

-??4.85

20.37

22.30

5.97

31.05

18.75

5.24

16.58

Use

EXCEL

to

answer

the

following

questions:

(a) Estimate

the

slope

of

the

regression

of

the

rates

of

return

of

the

gold

mutual

fund

against

those

of

the

S&P

500.

(b)

Use

a

t-??

test

to

test

the

hypothesis

that

b

<

0.

(c)

If

you

expect

the

rate

of

return

to

be

20

%

next

year

(1989),

what

is

the

rate

of

return

of

the

gold

mutual

fund

you

expect?

Page

4

of

4

Paper#9210697 | Written in 27-Jul-2016

Price :*$19*