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

Help!, in a normal distribution with a mean of 85 and a STD of 5, what is t...

in a normal distribution with a mean of 85 and a STD of 5, what is the percentage of scores between 75 and 90?

Regression, The 4 assumptions of regression: 1.       Variables are norm...

The 4 assumptions of regression: 1.       Variables are normally distributed 2.       Linear relationship between the independent and dependent variables 3.       Homosced

PERCENTAGES, CALCULATE THE PERCENTAGE OF REFUNDS EXPECTED TO EXCEED $1000 U...

CALCULATE THE PERCENTAGE OF REFUNDS EXPECTED TO EXCEED $1000 UNDER THE CURRENT WITHHOLDING GUIDELINES

Confirmatory factor analysis, Confirmatory factor analysis (CFA) seeks to d...

Confirmatory factor analysis (CFA) seeks to determine whether the number of factors and the loadings of measured (indicator) variables on them conform to what is expected on the ba

Simple regression, Simple Regression: The Teacher Preparation Researc...

Simple Regression: The Teacher Preparation Research Team conducted a study of college students who took the Praxis II-a teacher certification examination. Some variables from

Universe or population, Universe or Population The word universe as use...

Universe or Population The word universe as used in statistics denotes the aggregate from which a sample is to be taken. According to Simpson and Kafka, a universe or populatio

Stratified sampling, Stratified Sampling Stratified Sampling is ...

Stratified Sampling Stratified Sampling is generally used when the population is heterogeneous. In this case, the population is first subdivided into several parts (or s

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

Initial centroids data set, Find unlabeled data set test.txt and initial ...

Find unlabeled data set test.txt and initial centroids data set centroids.txt in the archive, both files have the following format: [attribute1_value attribute2_value ...

Ashland MultiComm Services, Suppose that in the actual survey of 50 prospec...

Suppose that in the actual survey of 50 prospective customers, 6 subscribe to the 3 for all offer, what does this tell you about the previous estimate of the proportion of customer

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