Linear Trend – Multiple RegressionThe average price per gallon of gasoline in major U.S. cities for each month during the years 1999-2001 are shown in the table below:Month199920002001January0.9721.3011.472February0.9551.3691.484March0.9911.5411.447April1.1171.5061.564May1.1781.4981.729June1.1481.6171.640July1.1891.5931.482August1.2551.5101.427September1.2801.5821.531October1.2741.5591.362November1.2641.5551.263December1.2981.4891.131Forecast the average gasoline price for January 2002 using linear trend analysis.What is the linear equation that best fits the data?Graph the data.What is the forecast for the average gasoline price for January 2002?What is the MAPE for this method?Is this method more accurate than exponential smoothing for this data set
Linear Trend – Multiple RegressionThe average price per gallon of gasoline in major U.S. cities for each month during the years 1999-2001 are shown in the table below:Month199920002001January0.9721.3011.472February0.9551.3691.484March0.9911.5411.447April1.1171.5061.564May1.1781.4981.729June1.1481.6171.640July1.1891.5931.482August1.2551.5101.427September1.2801.5821.531October1.2741.5591.362November1.2641.5551.263December1.2981.4891.131Forecast the average gasoline price for January 2002 using linear trend analysis.What is the linear equation that best fits the data?Graph the data.What is the forecast for the average gasoline price for January 2002?What is the MAPE for this method?Is this method more accurate than exponential smoothing for this data set
Linear Trend – Multiple RegressionThe average price per gallon of gasoline in major U.S. cities for each month during the years 1999-2001 are shown in the table below:Month199920002001January0.9721.3011.472February0.9551.3691.484March0.9911.5411.447April1.1171.5061.564May1.1781.4981.729June1.1481.6171.640July1.1891.5931.482August1.2551.5101.427September1.2801.5821.531October1.2741.5591.362November1.2641.5551.263December1.2981.4891.131Forecast the average gasoline price for January 2002 using linear trend analysis.What is the linear equation that best fits the data?Graph the data.What is the forecast for the average gasoline price for January 2002?What is the MAPE for this method?Is this method more accurate than exponential smoothing for this data set
Linear Trend – Multiple RegressionThe average price per gallon of gasoline in major U.S. cities for each month during the years 1999-2001 are shown in the table below:Month199920002001January0.9721.3011.472February0.9551.3691.484March0.9911.5411.447April1.1171.5061.564May1.1781.4981.729June1.1481.6171.640July1.1891.5931.482August1.2551.5101.427September1.2801.5821.531October1.2741.5591.362November1.2641.5551.263December1.2981.4891.131Forecast the average gasoline price for January 2002 using linear trend analysis.What is the linear equation that best fits the data?Graph the data.What is the forecast for the average gasoline price for January 2002?What is the MAPE for this method?Is this method more accurate than exponential smoothing for this data set