see attached --- finance question

profilekavsin
question_16.xlsx

Sheet1

Use the data in table 9.3 to compute a five day moving average for Computers Inc. Can you identify and buy or sell signals?
Trading Day Computers, Inc. Industry Index Trading Day Computers, Inc. Industry Index
1 19.63 50 21 19.63 54.1
2 20 50.1 22 21.5 54
3 20.5 50.5 23 22 53.9
4 22 50.4 24 23.13 53.7
5 21.13 51 25 24 54.8
6 22 50.7 26 25.25 54.5
7 21.88 50.5 27 26.25 54.6
8 22.5 51.1 28 27 54.1
9 23.13 51.5 29 27.5 54.2
10 23.88 51.7 30 28 54.8
11 24.5 51.4 31 28.5 54.2
12 23.25 51.7 32 28 54.8
13 22.13 52.2 33 27.5 54.9
14 22 52 34 29 55.2
15 20.63 53.1 35 29.25 55.7
16 20.25 53.5 36 29.5 56.1
17 19.75 53.9 37 30 56.7
18 18.75 53.6 38 28.5 56.7
19 17.5 52.9 39 27.75 56.5
20 19 53.4 40 28 56.1
This Year Last Year
Yield on top-rated corporate bonds 8% 8.50%
Yield on intermeduate-grade
coporate bonds 10.5 10

Sheet2

Sheet3