Question: Develop a multiple regression model with categorical variables that incorporate seasonality for forecasting coal consumption, where December is the reference month. Consumption= ___+(___)Month +(___)Jan +(___)Feb+(___)Mar
Develop a multiple regression model with categorical variables that incorporate seasonality for forecasting coal consumption, where December is the reference month.
Consumption= ___+(___)Month +(___)Jan +(___)Feb+(___)Mar +(___)Apr +(____)May+(____)Jun+(____)Jul+(___)Aug+(___)Sep+(___)Oct+(___)Nov
(Type integers or decimals rounded to two decimal places as needed.)
| Month and Year | Consumption | Month |
| Jan 1990 | 16.2 | 1 |
| Feb 1990 | 14.91 | 2 |
| Mar 1990 | 12.42 | 3 |
| Apr 1990 | 12 | 4 |
| May 1990 | 8.07 | 5 |
| Jun 1990 | 8.41 | 6 |
| Jul 1990 | 12.2 | 7 |
| Aug 1990 | 11.23 | 8 |
| Sep 1990 | 9.22 | 9 |
| Oct 1990 | 9.38 | 10 |
| Nov 1990 | 14.1 | 11 |
| Dec 1990 | 24.28 | 12 |
| Jan 1991 | 19.59 | 13 |
| Feb 1991 | 13.69 | 14 |
| Mar 1991 | 12.2 | 15 |
| Apr 1991 | 9.02 | 16 |
| May 1991 | 7.33 | 17 |
| Jun 1991 | 7.14 | 18 |
| Jul 1991 | 9.56 | 19 |
| Aug 1991 | 8.62 | 20 |
| Sep 1991 | 7.08 | 21 |
| Oct 1991 | 7.87 | 22 |
| Nov 1991 | 15.35 | 23 |
| Dec 1991 | 19.77 | 24 |
| Jan 1992 | 16.62 | 25 |
| Feb 1992 | 13.14 | 26 |
| Mar 1992 | 11.77 | 27 |
| Apr 1992 | 12.06 | 28 |
| May 1992 | 7.09 | 29 |
| Jun 1992 | 6.53 | 30 |
| Jul 1992 | 10.66 | 31 |
| Aug 1992 | 8.79 | 32 |
| Sep 1992 | 8.21 | 33 |
| Oct 1992 | 8.19 | 34 |
| Nov 1992 | 14.53 | 35 |
| Dec 1992 | 20.82 | 36 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
