Consider the following results of a multiple regression model of dollar price of unleaded gas (dependent variable) and a set of independent variables: price of crude oil, value of S&P500, price U.S. Dollars against Euros, personal disposal income (in million of dollars) :
Coefficient |
t-statistics |
|
Intercept |
0.5871 |
68.90 |
Crude Oil |
0.0651 |
32.89 |
S&P 500 |
-0.0020 |
18.09 |
Price of $ |
-0.0415 |
14.20 |
PDI |
0.0001 |
17.32 |
R-Square = 97%
Crude Oil = 95; S&P500 = 1775; Price of $ = 0.80 Euros; PDI = 800
What will be forecasted price of unleaded gas if the value of
independent variables are as follows: Crude Oil = 95; S&P500 =
1775; Price of $ = 0.80 Euros; PDI = 800
=0.5871+95*0.0651+1775*(-0.0020)+0.80*(-0.0415)+800*0.0001=3.2684
What is the interpretation of R-Square?
97% of the movement in unleaded gas price can be explained by this
forecasting model.
What is the interpretation of coefficient for S&P500?
Every 1 unit increase in the value of S&P500 will cause
unleaded gas price to decrease by 0.20 cents.
The variable which is being forecasted is referred as:
endogenous variable
Ideally, in forecasting what kind of correlations should exist
between a set of independent variables?
low correlation
The R-square of a regression equation of a dependent variable
(Y) and a set of independent variables represents:
the % movements in Y that can be explained by the forecasting
model
Consider the following results of a multiple regression model of dollar price of unleaded gas (dependent variable) and a set of independent variables: price of crude oil, value of S&P500, price U....
Consider the following results of a simple regression model of dollar price of unleaded gas (dependent variable) and dollar price of crude oil (independent variable): Coefficient t-statistics Intercept 0.56 28.27 Crude Oil 0.0457 73.34 R-square = 0.87 What will be expected change in the price of unleaded gas if the crude oil price is expected to fall by 7%. The current price of crude oil and unleaded gas are $74 and $3.10 respectively? (7.89%) (6.85%) (7.25%) (7.64%) What will be...
Consider a multiple regression model of the dependent variable y on independent variables x1, X2, X3, and x4: Using data with n 60 observations for each of the variables, a student obtains the following estimated regression equation for the model given: y0.35 0.58x1 + 0.45x2-0.25x3 - 0.10x4 He would like to conduct significance tests for a multiple regression relationship. He uses the F test to determine whether a significant relationship exists between the dependent variable and He uses the t...
Consider the multiple regression model shown next between the dependent variable Y and four independent variables X1, X2, X3, and X4, which result in the following function: Y = 33 + 8X1 – 6X2 + 16X3 + 18X4 For this multiple regression model, there were 35 observations: SSR= 1,400 and SSE = 600. Assume a 0.01 significance level. What is the predictions for Y if: X1 = 1, X2 = 2, X3 = 3, X4 = 0
A linear regression model found the following : Dependent variable : Quantity Independent variables : X1 X2 coefficient constant. 10 price. -2 Income. 3 R^2 = 0.83 t = 2.36 a. write the demand function as an equation b. do the sign of the coefficients make sense ? why? c. if price = 10, Income = 24 what is the predicted quantity sold? d. find the point price elasticity at price =10, Income = 24
4. Testing for significance Aa Aa Consider a multiple regression model of the dependent variable y on independent variables x1, x2, X3, and x4: Using data with n = 60 observations for each of the variables, a student obtains the following estimated regression equation for the model given: 0.04 + 0.28X1 + 0.84X2-0.06x3 + 0.14x4 y She would like to conduct significance tests for a multiple regression relationship. She uses the F test to determine whether a significant relationship exists...
Consider a multiple regression model of the dependent variable y on independent variables x1, x2, and x3: Using data with n = 12 observations for each of the variables, a researcher obtains the following estimated regression equation for the above model y0.5216 + 1.2419x1 + 0.3049x2 - 0.0217x3 The standard error of estimate for this equation is s0.6489 The table below gives the values for the independent and dependent variables and their corresponding predicted values, residuals, and leverage Predicted Value...
Economists wish to look at the relationship between the price of regular unleaded gasoline in the U.S. (units-$/gallon) and the acquisition cost of OPEC crude oil (units-$10/barrel). Summary measures for a random sample of 13 years are given below 13 29.3 70.39 60.5 329.67 143.61 What is the estimated regression equation? (Specify which variable is y and which is x) Question 1 where ce of gas t of Question 2 Show the ANOVA table MS df Regression Error Total Question...
Exercise 4.8 Suppose the Sherwin-Williams Company has developed the following multiple regression model, with paint sales Y (x 1,000 gallons) as the dependent variable and promotional expenditures A (x $1,000) and selling price P (dollars per gallon) as the independent variables. Y=α+βaA+βpP+εY=α+βaA+βpP+ε Now suppose that the estimate of the model produces following results: α=344.585α=344.585 , ba=0.106ba=0.106 , bp=−12.112bp=−12.112 , sba=0.155sba=0.155 , sbp=4.421sbp=4.421 , R2=0.813R2=0.813 , and F-statistic=10.372F-statistic=10.372 . Note that the sample consists of 10 observations. According to the estimated...
Domestic Car Sales Consider the following multiple regression model of domestic car sales (DCS) where: DCS = domestic car sales DCSP = domestic car sales price (in dollars) PR = prime rate as a percent (i.e., 10% would be entered as 10) Q2 = quarter 2 dummy variable Q3 = quarter 3 dummy variable Q4 = quarter 4 dummy variable Multiple Regression — Result Formula DCS = 3,266.66 + ((DCSP) × −0.098297) + ((PR) × −21.17) + ((Q2) × 292.88)...
The following ANOVA model is for a multiple regression model with two independent variables: Degrees of Sum of Mean Source Freedom Squares Squares F Regression 2 60 Error 18 120 Total 20 180 Determine the Regression Mean Square (MSR): Determine the Mean Square Error (MSE): Compute the overall Fstat test statistic. Is the Fstat significant at the 0.05 level? A linear regression was run on auto sales relative to consumer income. The Regression Sum of Squares (SSR) was 360 and...