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

Riemannian integral approximations, Investigate the use of fixed and perce...

Investigate the use of fixed and percentile meshes when applying chi squared goodness-of- t hypothesis tests. Apply the oversmoothing procedure to the LRL data. Compare the res

Production took place, Scenario: To fundraise for middle school camp the ye...

Scenario: To fundraise for middle school camp the year 3 and 4 syndicate designed and produced chocolate treats to sell to the year 1 and 2, and year 5 and 6 students at morning te

Assumptions in anova, Assumptions in ANOVA The various populations f...

Assumptions in ANOVA The various populations from which the samples are drawn should be normal and have the same variance. The requirement of normality can be discarded if t

Multiple regression analysis, Complete the multiple regression model using ...

Complete the multiple regression model using Y and your combined X variables.  State the equation.  Next, make sure that you evaluate overall model performance with the Anova table

Correlation analysis, Correlation Analysis Correlation Analysis is perf...

Correlation Analysis Correlation Analysis is performed to measure the degree of association between two variables. The measure is called coefficient of correlation. The coeffic

Small sample test for mean, If the sample size is less than 30, then we nee...

If the sample size is less than 30, then we need to make the assumption that X (the volume of liquid in any cup) is normally distributed. This forces    (the mean volume in the sam

Analysis of variance (anova), Analysis of variance allows us to test whethe...

Analysis of variance allows us to test whether the differences among more than two sample means are significant or not. This technique overcomes the drawback of the method used in

Quota sampling, Quota sampling Under this method enumerators shall sele...

Quota sampling Under this method enumerators shall select the respondents in place of those not available, as per the quota fixed according  to guide lines   provided to them.

Probability and expectation, Ten balls are put in 6 slots at random.Then ex...

Ten balls are put in 6 slots at random.Then expected total number of balls in the two extreme slots

Distrbution., The score distribution shown in the table is for all students...

The score distribution shown in the table is for all students who took a yearly AP statistical exam. An AP statistics teacher had 59 students preparing to take the AP exam. Though

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