Q32 189 DO NOT USE EXCEL Fill in the tables provided The fol

Q32. (18.9) DO NOT USE EXCEL. Fill in the tables provided. The following tables show residential and commercial natural gas consumption (quadrillion Btu) from 1992 through 2007. (a) Put a three-year centered moving average over the original series.

Solution

Year

Consumption

3 year moving total

3 year moving average

1992

29.6

1993

30.6

1994

30.8

(29.6+30.6+30.8) =91.0

91/3= 30.333

1995

33.3

(30.6+30.8+33.3) =94.7

94.7/3=31.567

1996

33.0

(30.8+33.3+33.0)= 97.1

97.1/3=32.367

Year	Consumption	3 year moving total	3 year moving average
1992	29.6
1993	30.6
1994	30.8	(29.6+30.6+30.8) =91.0	91/3= 30.333
1995	33.3	(30.6+30.8+33.3) =94.7	94.7/3=31.567
1996	33.0	(30.8+33.3+33.0)= 97.1	97.1/3=32.367