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.

Posted Date: 3/25/2013 5:56:31 AM | Location : United States

Ask an Expert

Related Discussions:- Estimate the values of the dependent variable, Assignment Help, Ask Question on Estimate the values of the dependent variable, Get Answer, Expert's Help, Estimate the values of the dependent variable Discussions

Write discussion on Estimate the values of the dependent variable
Your posts are moderated

Write your message here..

Related Questions

Probability function, Among the students doing a given course, there are fo... Among the students doing a given course, there are four boys enrolled in the ordinary version of the course, six girls enrolled in the ordinary version of the course,and six boys e

Calculate the current ratio and quick ratio, You were recently hired by E&T... You were recently hired by E&T Boats, Inc. to assist the company with its financial planning and to evaluate the company's performance.  E&T Boats, Inc. builds and sells boats to o

Changing the base of the index, How do you change the base of the index How do you change the base of the index

Standard cost method, Under the standard cost method which is also referred... Under the standard cost method which is also referred as the standard cost method ,stock receipts are assigned a standard cost. Any variations between the actual cost and standard

Cluster sampling, Cluster Sampling This method is also known as multi s... Cluster Sampling This method is also known as multi stage sampling .Under this method random selection is made of the ultimate or final units from a given stratum. The sampling

Utility function, The decision maker ranks lotteries according to the utili... The decision maker ranks lotteries according to the utility function (i) State the independence assumption. Does this decision maker satisfy it? (ii) Is this decision ma

Type i and ii errors, TYPE I AND II Errors If a statistical hypothesis ... TYPE I AND II Errors If a statistical hypothesis is tested, we may get the following four possible cases: The null hypothesis is true and it is accepted; The

Simple linear regression, We are interested in assessing the effects of tem... We are interested in assessing the effects of temperature (low, medium, and high) and technical configuration on the amount of waste output for a manufacturing plant. Suppose that

Statistical definition of probability, Statistical Definition of probabilit... Statistical Definition of probability: Ques: (a) (i)  Distinguish Statistical Definition of probability from the Classical Definition.                  (ii) State the A

Calculate the seasonal indexes , The total number of overtime hours (in 100... The total number of overtime hours (in 1000s) worked in a large steel mill was recorded for 16 quarters, as shown below. Year Quarter Overtime hour