How to draw a correlation function in excel

[Stiba]

Homework Statement

For my homework i have to compute a correlation function in excel from available data. Data goes somewhat like this: 1 xxx yyy
2 xxx yyy
3 xxx yyy
I now I have to calculate the correlation at a given point (1,2,3,4,...) but all my atempts sofar turnedout to be wrong.

Homework Equations

It is statet in the "hint" section of the homework that you should use functions CORREL and INDIRECT.

The Attempt at a Solution

 

[berkeman]

Homework Statement

For my homework i have to compute a correlation function in excel from available data. Data goes somewhat like this: 1 xxx yyy
2 xxx yyy
3 xxx yyy
I now I have to calculate the correlation at a given point (1,2,3,4,...) but all my atempts sofar turnedout to be wrong.

Homework Equations

It is statet in the "hint" section of the homework that you should use functions CORREL and INDIRECT.

The Attempt at a Solution

Welcome to the PF. So what does Excel Help say about those functions? That would seem to be a good place to start.