Home Tutorials E-mail us Forum


Solved Statistics problems. Practice exercises



a. Exercise 2—Wilcoxon-Signed Rank Test

The 1997 price/earnings ratios for a sample of 12 stocks are shown in the following list ( Barron’s, December 8, 1997). Assume that a financial analyst has provided the estimated price/earnings ratio for 1998. Using a .05 level of significance, what is your conclusion about the differences between the price/earnings ratios for 1997 and 1998?

COMPANY

1997 P/E RATIO

1998 P/E RATIO

Coca-Cola

40

32

Du Pont

24

22

Eastman Kodak

21

23

General Electric

30

23

General Mills

25

19

IBM

19

19

McDonalds

20

17

Merck

29

19

Motorola

35

20

Philip Morris

17

18

Walt Disney

33

27

Xerox

20

16

Solution Exercise b.

Now we use Wilcoxon-Signed Rank Test. First, we have to make a table with the difference between the two years 1997 and 1998

COMPANY

1997 P/E RATIO

1998 P/E RATIO

DIFFERENCE

Coca-Cola

40

32

8

Du Pont

24

22

2

Eastman Kodak

21

23

-2

General Electric

30

23

7

General Mills

25

19

6

IBM

19

19

0

McDonalds

20

17

3

Merck

29

19

10

Motorola

35

20

15

Philip Morris

17

18

-1

Walt Disney

33

27

6

Xerox

20

16

4

Now we build the following rank table:

MAGNITUDE

ORDER

RANK

(+) RANK

(-) RANK

0 (+)

1

1

1

1 (-)

2

2

2

2 (+)

3

3.5

3.5

2 (-)

4

3.5

3.5

3 (+)

5

5

5

4 (+)

6

6

6

6(+)

7

7.5

7.5

6 (+)

8

7.5

7.5

7 (+)

9

9

9

8 (+)

10

10

10

10 (+)

11

11

11

15 (+)

12

12

12

S=

72.5

This way the statistics is S = 72.5, and also

and

Using these quantities, we define:

(the “-1/2” comes from continuity correction). For the given significance, we reject the

null hypothesis if Z>R, where R=1.644853 at the 0.05 level of significance. Therefore, we conclude that there’s a difference (decrease) between the 1997 P/E and the 1998 P/E.



(If you find any mistakes please report them here)
Solved Math Problems





Tutorials