A.     What is the least squares estimator of á?

B.     What is the least squares estimator of â₁, the coefficient of X₁?

C.    What is the least squares estimator of â₂, the coefficient of X₂?

 

Show the formulas and the computations. You can check your work with Excel or other statistical software.

 

You can also use RExcel add in. It will save a lot of time writing code. However, it'll take a bit of time trying to figure out how to use it. Or you could get the Analysis data tool pack. By itself, Excel is somewhat ill equipped to handle advanced statistical analysis.