Complete the table below, showing ñ₁ and ñ₂, the autocorrelations of lags 1 and 2. Use an Excel spreadsheet (or other software) and form the table by coding the cell formulas. Print the Excel spreadsheet and send it in as your homework assignment.

 

ö1	ö2	ñ1	ñ2	ö1	ö2	ñ1	ñ2
0.2	0.2			-0.2	0.2
0.2	0.3			-0.2	0.3
0.2	0.4			-0.2	0.4
0.2	0.5			-0.2	0.5
0.2	0.6			-0.2	0.6
0.2	0.7			-0.2	0.7
0.2	-0.2			-0.2	-0.2
0.2	-0.3			-0.2	-0.3
0.2	-0.4			-0.2	-0.4
0.2	-0.5			-0.2	-0.5
0.2	-0.6			-0.2	-0.6
0.2	-0.7			-0.2	-0.7
0.2	-0.8			-0.2	-0.8
0.2	-0.9			-0.2	-0.9

 

Quick Check. This HW seemed a little easier than many of the others, so I wanted to post two 'examples.' This way I can confirm that my process is right without "giving away" all the answers.

For Phi1 = .2, Phi2 = .4 (third row) I got rho1 = .33333 and rho2 = .46666667
For Phi1 = -.2, Phi2 = -.8 (second last row), I got rho1 = -.1111111 and rho2 = -.77777778

If anyone can confirm these values, I'll feel confident that the other 26 are also correct.

Quick Check. This HW seemed a little easier than many of the others, so I wanted to post two 'examples.' This way I can confirm that my process is right without "giving away" all the answers.

For Phi1 = .2, Phi2 = .4 (third row) I got rho1 = .33333 and rho2 = .46666667
For Phi1 = -.2, Phi2 = -.8 (second last row), I got rho1 = -.1111111 and rho2 = -.77777778

If anyone can confirm these values, I'll feel confident that the other 26 are also correct.

                              nhanewinckel,

I agree with the solutions that you posted.

For Phi1 = .2, Phi2 = .4 (third row) I got rho1 = .33333 and rho2 = .46666667
For Phi1 = -.2, Phi2 = -.8 (second last row), I got rho1 = -.1111111 and rho2 = -.77777778