An economist wanted to investigate the factors that determined the price of petrol RON97. He gathered 17 months of data on the four variables below: Y = Price of petrol RON97 (RM/litre) X1 = Price of...


An economist wanted to investigate the factors that determined the price of petrol RON97. He gathered 17 months of data on the four variables below:<br>Y = Price of petrol RON97 (RM/litre)<br>X1 = Price of world oil (USD/barrel)<br>X2 = Exchange rate (RM/USD)<br>X3 = Quantity demand for petrol RON97 (million litre)<br>The Excel results are shown as follows:<br>ANOVA<br>df<br>SS<br>MS<br>Significance F<br>Regression<br>Residual<br>0.467<br>0.062<br>3<br>0.156<br>32.763<br>0.000<br>13<br>0.005<br>Total<br>16<br>0.529<br>Coefficients Standard Error<br>t Stat<br>P-value<br>0.094<br>0.000<br>0.003<br>Intercept<br>-1.132<br>0.627<br>-1.805<br>X1<br>0.021<br>0.003<br>7.000<br>X2<br>-0.334<br>0.092<br>-3.630<br>X3<br>0.010<br>0.007<br>1.429<br>0.165<br>(a) Determine the regression equation.<br>(b) Determine the coefficient of determination, and interpret.<br>(c) Which independent variables linearly related to the price of petrol RON 95 in this model? Explain.<br>(d) Is the model valid? Explain.<br>

Extracted text: An economist wanted to investigate the factors that determined the price of petrol RON97. He gathered 17 months of data on the four variables below: Y = Price of petrol RON97 (RM/litre) X1 = Price of world oil (USD/barrel) X2 = Exchange rate (RM/USD) X3 = Quantity demand for petrol RON97 (million litre) The Excel results are shown as follows: ANOVA df SS MS Significance F Regression Residual 0.467 0.062 3 0.156 32.763 0.000 13 0.005 Total 16 0.529 Coefficients Standard Error t Stat P-value 0.094 0.000 0.003 Intercept -1.132 0.627 -1.805 X1 0.021 0.003 7.000 X2 -0.334 0.092 -3.630 X3 0.010 0.007 1.429 0.165 (a) Determine the regression equation. (b) Determine the coefficient of determination, and interpret. (c) Which independent variables linearly related to the price of petrol RON 95 in this model? Explain. (d) Is the model valid? Explain.

Jun 08, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions ยป

Submit New Assignment

Copy and Paste Your Assignment Here