preview

The Regression Analysis

Good Essays

3. The slope of the linear regression line is 0.0647. This is shown in the equation of the line, on the right hand side of the chart. The Y-intercept of the linear regression line is -127.64. The equation is Y=0.0647X-127.64. The regression analysis, including residuals is in the Excel file attached. Part II This project was aimed at creating some reasonable forecasts of the trend of gas prices in the United States in the next period of time, based on an analysis of a series of annual gas prices in the United States from 1982 to 2011. These observations are essential in our delivery business because so much of our expenses and overall operational costs are, in fact, based on the gas prices. The main objective of this project is, thus, to analyze the perspectives of the evolution of gas prices in the next period of time and, based on that, to determine potential preventive solutions that can help in lowering the impact of a significant increase in gasoline prices over the next years. As mentioned, the analysis was based on a time series with monthly gas prices from 1982 to 2011. Gas prices started at around $1.3 a gallon in 1982, with the prices still affected by the Iranian Revolution in 1979 and the limits imposed on imports from the Middle East because of that. In an overlook on the figures, these went below $1 a gallon from 1987 to 1989 and then again, in 1999. From that moment, the prices have gradually increased until the present time, with $3.167 a gallon at

Get Access