Can someone tell me if r1= .2777778?

NEAS - Wont the every entry in the last three columns be the same? Mean we just have to calculate r1, r2 and r3 right. Every entry in the third last column would be r1, in the second last column would be r2 and so for r3 right or am I reading the sum wrong? Please help.

[NEAS: This homework assignment works out the computation of r1, r2, and r3. Work out the deviations and the values minus the mean. For the column labeled cross product of lag 1, use deviation(t) * deviation(t-1); for the column labeled cross product of lag 2, use deviation(t) * deviation(t-2); and so forth. The sums of the products are the numerators of r1, r2, and r3. The denominator is the sum of squared deviations. Place r1, r2, and r3 in the last row of the table.

You compute r1, r2, and r3 by hand. The final exam asks similar problems.]

Should we be using an Excel worksheet for this like in HW 6?

[NEAS: Use an excel worksheet if you want. The computations are simple, and can be done by hand or by a calculator in a few minutes. You must solve the final exam problems without an Excel workbook, so be sure you know the procedure.]

Show the derivations with a table like the one below. Remember to use the proper number of terms in the numerator, depending on the lag.