## 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.

#### Binomial distribution, Binomial Distribution Binomial distribution  was...

Binomial Distribution Binomial distribution  was discovered by swiss mathematician James  Bernonulli, so this distribution is called as Bernoulli distribution also, this is a d

#### Latin Square design, what is the the Latin Square design? What is its appli...

what is the the Latin Square design? What is its application in research? please explain this term with very simple but with detailed explanation for effective understanding. I hav

#### Construct a component bar chart, data:59,59,65,70,74 176,17...

data:59,59,65,70,74 176,179,195,210,200

#### Assignment 1: Testing Hypotheses for Means, Review the Learning Resources a...

Review the Learning Resources and the media programs related to t tests. For additional support, review the Skill Builder: Research Design and Statistical Design and the Skill Buil

#### LPP, b. A paper mill produces two grades of paper viz., X and Y. Because of...

b. A paper mill produces two grades of paper viz., X and Y. Because of raw material restrictions, it cannot produce more than 400 tons of grade X paper and 300 tons of grade Y

#### Median for ungrouped data, If the data set contains an odd number of items,...

If the data set contains an odd number of items, the middle item of the array is the median. If there is an even number of items, the median is the average of the two items. If the

#### Questionnaire, Framing of Questionnaire: Questionnaire is a schedule of...

Framing of Questionnaire: Questionnaire is a schedule of questions which is sent to the respondents for filling in by them in their own handwriting together the information rel

#### What is the p-value, Use the information given below to find the P-value. ...

Use the information given below to find the P-value. Also, use a 0.05 significance level and state the conclusion about the null hypothesis (reject the null hypothesis or fail to

#### Active control equivalence studies (aces), Active Control Equivalence Studi...

Active Control Equivalence Studies (ACES) Clinical trials the field in which the object is easy to show that the new treatment is  as good as the existing treatment. Such type

#### Perform a simple linear regression analysis, In New Jersey, banks have been...

In New Jersey, banks have been charged with withdrawing from counties having a high percentage of minorities. To substantiate this charge, data is presented in the table below conc  