Help

+ O Question 8, 9.5.19 of 1 The accompanying dataset shows the monthly coal consumption (in trillions of BTUs) over the course of three years. Develop a multiple regression model with categorical variables that incorporate seasonality for fo Month and Year Consumption Month FFF Click the icon to view the coal consumption data. Jan 1990 16.36 Feb 1990 15.07 Mar 1990 12.63 Apr 1990 12.16 May 1990 8.21 Develop a multiple regression model with categorical variables/that incorporate seasonality for forecasting coal consumption, where December is the reference month. Jun 1990 8.46 Jul 1990 12.28 Consumption = 23.28 +-0.05 - Month + -4.66 ). Jan + (-8.21 . Feb + (-9.90 Aug 1990 11.41 + -14.46 ). May + (-14.49 Sep 1990 9.34 )- Jun + (-11.11 . Jul + (-12.27 . Aug + (-13.65 Oct 1990 9.42 (Type integers or decimals rounded to two decimal places as needed.) Nov 1990 14.30 Dec 1990 24.29 Jan 1991 19.76 Feb 1991 13.85 Mar 1991 12.36 Apr 1991 9.18 May 1991 7.49 Jun 1991 7.30 Jul 1991 9.7 Aug 1991 8.78 Sep 1991 7.24 Oct 1991 8.03 Nov 1991 15.51 Dec 1991 19.94 Jan 1992 16.84 Feb 1992 13.31 Mar 1992 12.01 Apr 1992 12.15 May 1992 7.28 Jun 1992 6.69 Jul 1992 10.82 Aug 1992 8.95 Sep 1992 8.37 Oct 1992 8.35 Nov 1992 14.74 Dec 1992 21.05