Question: Using regression analysis (i.e. do not use the "forecast" function in Excel) perform a linear trend forecast for the average monthly consumption of natural gas for each group in 2019. That is, I am asking you to forecast how much natural gas consumption will be, on average, each month during 2019. With what level of confidence could you conclude that the coefficient estimates are statistically significant? How do you know?

Be sure to include the regression output in Excel, the forecasting equation, interpretation of the coefficient estimates, and answers to the questions in Word.

Price: $2.99

Solution: The downloadable solution consists of 4 pages
Deliverable: Word Document