Derivation of the Ordinary Least Squares Estimator

To place the sum of this column (23) in cell D5, we type the equal sign in the command line. This tells Excel that we are entering a formula. The "function" name we want is sum. Selecting "SUM" from the functions bar results in the dialogue box shown below. We need to indicate that the block of cells to sum … ................
................

In order to avoid copyright disputes, this page is only a partial summary.