(adsbygoogle = window.adsbygoogle || []).push({}); 1. The problem statement, all variables and given/known data

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.

2. Relevant equations

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

3. The attempt at a solution

**Physics Forums | Science Articles, Homework Help, Discussion**

Join Physics Forums Today!

The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

# Homework Help: How to draw a correlation function in excel

**Physics Forums | Science Articles, Homework Help, Discussion**