Determining whether or not a relationship exists between two variables and if there is heteroskedasticity. Attachments in Excel.

Consider the data found in the file, "gas10." You are interested in the effect that a gas tax has on petroleum consumption. The data is cross-sectional and the variables are as follows: PCON = petroleum consumption (millions of BTU's) REG = motor vehicle registrations POP = population TAX = gas tax (cents per gallon) a) Run an appropriate regression to test the relationship between the gas tax and petroleum consumption. b) Using REG as your proportionality factor, conduct appropriate tests to determine whether there is heteroskedasticity among the error terms of your equation. Describe what you have done, and interpret your results. If there is heteroskedasticity, how does it affect ... click for more

Regression

Regression - variances, residual, mean, deviation

Regression

Coefficient of correlation, regression

Regression

Regression questions

Economics/Statistics

5.9.) To find out if there is any relationship between teacher's pay and per pupil expenditure in public schools, the following model was suggested: Payi=β1+ β2 Spendi +ui, where Pay stands for teacher's salary and Spend stands for per pupil expenditure. a.) Plot the data and eyeball a regression line. b.) Suppose on the base of "a.)" you decide to estimate the above regression model. Obtain the estimates of parameters, their standard errors, r², RSS, and ESS. c.) Interpret the regression. DOES it make economic sense? d.) Establish a 95% confidence interval for β2. Would you reject the hypothesis that the true slope coefficient is 3.0? e.) Obtain the mean and in... click for more