Fitting a quadratic function

Problem

Consider the data in the Excel file Nonlinear.xlsx.

a. Fit the model

\[y_i=β_1+β_2x_{2i}+β_3x_{2i}^2+ε_i\]

by changing the trendline from linear to quadratic (You need to click off and on the “display equation on chart” for it to update). Explain why the exogeneity assumption is more credible in this case.

b. Find   \(\hat{y}\) for \(x=50\)

c. According to your estimates, which value of \(x\) will maximize \(y\) ?

Solution

b. yhat = -0.0133*502 + 1.9003*50 + 12.076 = 73.8

c. We have y = -0.0133x2 + 1.9003x + 12.076. The derivative is 2*(-0.0133)x+1.9 which we set to zero. x = 1.9/(2*0.0133) = 71.4