Regression - Computational Questions

Use the data in the Excel file below to answer the following questions.

Regress x onto y.

Predict x if y=5.

What is the coefficient of determination?

Test alpha=1 with significance level=5%. Repeat for beta=1.5.

Analytically replicate Excel's regression output.

Excel Questions





Excel Solutions