(a) Plot the data on gas bills. (b)Can you see seasonal patterns? Explain. (c)Use MegaStat or MINITAB to calculate estimated seasonal indexes and trend. (d)Which months are the most expensive? The least expensive? Can you explain this pattern? (e) Is there a trend in the deseasonalized data? *(f) Use MegaStat or MINITAB to perform a regression using seasonal binaries. Interpret the results.
Natural GasBills for a Residence, 2000-2003 | ||||
Month | 2001 | 2002 | 2003 | 2003 |
Jan | 78.98 | 118.86 | 101.44 | 155.37 |
Feb | 84.44 | 111.31 | 122.20 | 148.77 |
Mar | 65.54 | 75.62 | 99.49 | 115.12 |
Apr | 62.60 | 77.47 | 55.85 | 85.89 |
May | 29.24 | 29.23 | 44.94 | 46.84 |
Jun | 18.10 | 17.10 | 19.57 | 24.93 |
Jul | 91.57 | 16.59 | 15.98 | 20.84 |
Aug | 6.48 | 27.64 | 14.97 | 26.94 |
Sep | 19.35 | 28.86 | 18.03 | 34.17 |
Oct | 29.02 | 48.21 | 56.98 | 88.58 |
Nov | 94.09 | 67.15 | 115.27 | 100.63 |
Dec | 101.65 | 125.18 | 130.95 | 174.63 |
We need at least 10 more requests to produce the solution.
0 / 10 have requested this problem solution
The more requests, the faster the answer.