calculate Sb1 the estimate of the standard error of the coefficient of \'burger\

Question

calculate Sb1 the estimate of the standard error of the coefficient of 'burger'

For ten years from 1992 to 2001 A.J.Jones has kept a record of several variables. Here are his data on the average gasoline price in cents per litre over the year (gas), the average burger price in dollars over the year (burger), the average unemployment rate over the year in percentage (unemp), and the consumer price index for the year (cpi) ANOVA MS value Regression Residual Total 2 857 3797 428689847.24201 0.0000862 7 63.52035 9.074336 9 920.9 year gas burger unemp cpi 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 136 141 140 148 147 155 160 157 162 165 0.8 0.8 0.9 7.3 37.8 38.2 45.1 47.4 56.9 60.1 66.3 67.2 65.0 68.5 7.6 8.5 8.3 6.5 5.9 5.5 4.2 Standard 1.2 1.5 1.4 Coefficients Ero Stot p-value Intercept 148.9299 7.89691 18.85926 0.00000293 burger unemp3 1.4 0.000982 N.B. Use a = 0.05 for all hypothesis tests. when answering a question look for a short, possibly indirect, way to get the result before embarking on a long calculation. 3.78271 0.695021 -5.44259 0.000964 1. For the regression of 'cpi, on·burger' and 'unemp? x10.70 53.9308 -3441676 340676 2186 RESIDUAL OUTPUT Observation PredictedY Residuals 1139.7697 3.76969 2 140.5262 0.47377 3 140.9416 0.94158 4 144.4573 3.542747 753930-340676 340.676 2186 53.504 ' 2530.604 14.988 6 152.0227 2.977318 7 161.2124 1.21243 8 160.4188 3.41881 9 1584162 3.58378 753.9308-340,676 340676 2186 53,504 8 1604188 22.97 14.662 26.6436 14.662 46.3496 v 26.6436 34.5924 41.7636 10 165.7146 0.71461

Explanation / Answer

Using the excel,the estimate of the standard error of the coefficient of burger is calculated as follows:

CPL is considered as Input Y and burger and unemp is considered as X

ANOVA df SS MS F Significance F Regression 2 857.3796511 428.6898 47.2420072 0.00000862 Residual 7 63.52034886 9.074336 Total 9 920.9 Coefficients Standard Error t Stat P-value Intercept 148.9298564 7.896909813 18.85926 .000000293 unemp -3.782714591 0.695020891 -5.44259 0.00096358 burger 23.06705899 4.252227718 5.4247 0.00098216 RESIDUAL OUTPUT Observation Predicted Y Residuals 1 139.7696871 -3.769687092 2 140.52623 0.47376999 3 140.9415786 -0.941578613 4 144.4572532 3.542746822 5 147.520502 -0.520501994 6 152.0226824 2.977317641 7 161.2124288 -1.21242881 8 160.4188087 -3.418808748 9 158.41622 3.58377998 10 165.7146092 -0.714609175

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.