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:ANOVAdfSSMSSignificance FRegressionResidual0.4670.06230.15632.7630.000130.005Total160.529Coefficients Standard Errort StatP-value0.0940.0000.003Intercept-1.1320.627-1.805X10.0210.0037.000X2-0.3340.092-3.630X30.0100.0071.4290.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.

As per our guidelines, we are allowed to answer first three sub-parts only. Thanks

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 Significance F 0.000 MS 0.467 Regression Residual 0.156 32.763 13 0.062 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.

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 Significance F 0.000 MS 0.467 Regression Residual 0.156 32.763 13 0.062 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.

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Similar questions

A study was conducted to determine the relationship between starting salaries (RM thousands) for recent statistics graduates and their grade point averages in the major course. A linear regression model was fitted to the data and the estimates regression function was obtained. Part of the computer output for the above analysis is given below: ANOVA Model Sum of df Mean F Sig. Squares Square Regression 147.28 .000 Error 734.9 40.828 Total 6748.2 Coefficients Unstandardized Coefficients Model Sig. Std. B Error Constant GPA -8.42 3.007 3.395 0.2477 -2.48 12.14 0.011 0.000 (a) Complete the ANOVA table (blue boxes). (b) Write down the estimated regression function. Interpret the estimated parameters. (c) Test whether there is a linear association between salaries and grade point average. Use a = 0.05. (d) Determine the coefficient of determination for the model and interpret its meaning.
A market study found that the sales for a firm were related to advertising expenditure, as follows: Advertising Expenditure (Kshs ‘000’) Sales (Kshs ‘000’) 0 13 1 16 2 14 3 22 4 17 5 21 6 26 Required Draw a scatter diagram with the line of best fit to show the relationship. Determine the regression line equation for estimating the sales for a given level of advertising expenditure What is the estimated sale in thousand, if no advertising expenditure is incurred?
For a MR model with 4 predictors, we have: SSE 288 and SST = 957 What percentage of the variation in Y is accounted for by its assumed relationship with the predictors?
Show the best fitted line on scatter diagram and Find the predicted value for each y using the exposure time and the equation obtained in part b (b. Find the equation of regression line between radiation doses on exposure time .usingleast square method)
The line of best fit through a set of data is y = 13.661 – 3.451x According to this equation, what is the predicted value of the dependent variable when the independent variable has value 80? y = Round to 1 decimal place.
A researcher interested in explaining the level of foreign reserves for the country of Barbadosestimated the following multiple regression model using yearly data spanning the period 2001 to 2016: ??=?+????+????+????Where FR = yearly foreign reserves ($000’s), OIL = annual oil prices, EXP = yearly total exports ($000’s) and FDI = annual foreign direct investment ($000’s). The sample of data was processed using MINITAB and the following is an extract of the output obtained:Predictor Coef StDev t-ratio p-value Constant 5491.38 2508.81 2.1888 0.0491OIL 85.39 18.46 4.626 0.0006EXP -377.08 112.19 * 0.0057FDI -396.99 160.66 -2.471 ** S = 2.45 R-sq = 96.3% R-sq(adj) = 95.3%Analysis of VarianceSource DF SS MS F pRegression 3 1991.31 663.77 ? ??Error 12 77.4 6.45Total 15 Perform the F Test making sure to state the null and alternative hypothesis. f) Given an interpretation of the term “R-sq” and comment on its value.
1. What is the value of the slope of the best fit trends line for the relationship between TDD and the depth of the active layer. 2. If α = 0.05, is this slope statistically significant? (yes/no) 3. Compute a new variable that states the depth of the active layer in inches. The conversion formula is: (depth in inches) = (depth in centimetres) / 2.54 What is the mean depth of the active layer, measured in inches?
A researcher interested in explaining the level of foreign reserves for the country of Barbados estimated the following multiple regression model using yearly data spanning the period 2001 to 2016: FR=a+B0IL+YEXP+8FDI Where FR = yearly foreign reserves ($000°s), OIL = annual oil prices, EXP = yearly total exports ($000's) and FDI = annual foreign direct investment ($000`s). The sample of data was processed using MINITAB and the following is an extract of the output obtained: Predictor Coef StDev t-ratio p-value Constant 5491.38 2508.81 2.1888 0.0491 OIL 85.39 18.46 4.626 0.0006 EXP -377.08 112.19 0.0057 FDI -396.99 160.66 -2.471 ** s = 2.45 R-sq = 96.3% R-sq (adj) = 95.3% Analysis of Variance Source DF MS F Regression 1991.31 663.77 ?? Error 12 77.4 6.45 Total 15 a) What is dependent and independent variables? b) Fully write out the regression equation
From the image: One toad in the dataset had a body mass of 128g and a total tested mass of 163 mg. Compute the residual corresponding to this toad and write a sentence interpreting the residual.