Estimate the values of the dependent variable, Applied Statistics

Assignment Help:

1. Suppose you are estimating the imports (from both the U.S. mainland and foreign countries) of fuels and petroleum products in Hawaii (the dependent variable). The values of the dependent variable from 1958 to 2008 are provided in the attached EXCEL file. According to economic theory, imports are affected by total personal income or disposable personal income. In addition, since Hawaii's energy consumption is mainly rely on imported crude oil, the prices of crude oil should also affect the values of imported fuels and petroleum products. The historical data of some potential independent variables (some are relevant, some are irrelevant) from 1958 to 2008 are also provided in the EXCEL file. Based on these data, please do the following:

a. Develop a linear or log-linear (double-log or convert both the DV and the IVs into LN(Y) and LN(X1), LN(X2)...) regression model to estimate the dependent variable based on the data provided in the EXCEL file. Select the independent variables (only include the relevant variables) and the forms (linear or log-linear). [Hint: you should try alternative combinations of independent variables and the regression model with highest Adjusted R Squared Value and all significant independent variables (the P-values of the independent variables should be less than 0.1) should be selected as the best model.] Run the regression models using data from 1958 to 2008.

b. Estimate the values of the dependent variable from 2006 to 2008 using your regression models (both linear and log-linear) and the values of the independent variables provided in the EXCEL file.

c. Calculate the forecasting errors from 2006-2008 based on the mean of absolute errors (MAE) [also called mean absolute deviation or MAD]. The MAE is calculated as follows: first calculate the forecast errors (the actual value of the dependent variable minus the forecasted values of the dependent variable) in each year (2006-2008), and then calculated the average values of the absolute values of the errors. Based on the MAE, which model do you recommend?

d. Run a regression using crude oil price as the only independent variable. Assuming crude oil price in 2009 and 2010 will be $70/BBL and $80/BBL, respectively, forecast the imports of fuels and petroleum products in Hawaii in 2009 and 2010.


Related Discussions:- Estimate the values of the dependent variable

Multiple correspondence analysis, Correspondence Analysis (CA) is a general...

Correspondence Analysis (CA) is a generalization of PCA to contingency tables. The factors of correspondence analysis give an orthogonal decomposi:ion of the Chi- square associated

Index number, give a elementary example for characterstics of index number

give a elementary example for characterstics of index number

Data reduction, The PCA is amongst the oldest of the multivariate statistic...

The PCA is amongst the oldest of the multivariate statistical methods of data reduction. It is a technique for simplifying a dataset, by reducing multidimensional datasets to lower

Determine the effects of stopping smoking on weight gain, Determine the Eff...

Determine the Effects of Stopping Smoking On Weight Gain As part of a study to determine the effects of stopping smoking on weight gain, nine females were weighed on the day t

Arithmetic average or mean, Arithmetic Average or Mean The arithmetic m...

Arithmetic Average or Mean The arithmetic mean is the most widely and the most generally understandable of all the averages. This is clear from the reason that when the term

Chi square test, who invented the chi square test and why? what is central ...

who invented the chi square test and why? what is central chi square and non central chi square test? what is distribution free statistics? what are the conditions when the chi squ

Continuous frequency distribution, Formation of Continuous Frequency Distri...

Formation of Continuous Frequency Distribution:    Continuous frequency distribution is most popular in practice. With reference to the formation of this type of frequency distr

Find the optimal adaptive meshes for a skewed beta density, Show that the I...

Show that the ISB in a bin containing the origin of the double exponen-tial density, f(x) = exp(-|x|)/2, is O(h 3 ); hence, the discontinuity in the derivative of f does not have a

Business statistics, Betting on sporting events is big business both in the...

Betting on sporting events is big business both in the US and abroad. Consider, for instance, next winter’s American football tournament known as the Superbowl. Billions of dollars

X-bar charts, First we look at these charts assuming that we know both the ...

First we look at these charts assuming that we know both the mean and the standard deviation of the process, that is  μ and  σ . These values represent the acceptable values (bench

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd