How to draw a correlation function in excel

Click For Summary
To compute a correlation function in Excel using available data, the CORREL and INDIRECT functions are essential. Users are encouraged to consult Excel Help for guidance on these functions to ensure accurate calculations. The data format provided includes paired values for correlation analysis. Despite several attempts, the user has struggled to achieve the correct results. Understanding how to implement these functions correctly is crucial for completing the homework assignment successfully.
Stiba
Messages
1
Reaction score
0

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

 
Physics news on Phys.org
Stiba said:

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.
 

Similar threads

How to Calculate Correlation Time Using Numpy for Monte Carlo Simulations?
  • · Replies 1 ·
Replies
1
Views
2K
Graduate Computing Correlation functions
  • · Replies 1 ·
Replies
1
Views
2K
Undergrad Two-body correlation function computation
  • · Replies 1 ·
Replies
1
Views
3K
Mean, variance and correlation function of Langevin equation
  • · Replies 2 ·
Replies
2
Views
2K
Determining Delay with Cross Correlation
  • · Replies 11 ·
Replies
11
Views
13K
Undergrad How does one actually compute a correlation function?
  • · Replies 10 ·
Replies
10
Views
2K
Engineering How do I draw the Bode diagram of this transfer function?
  • · Replies 3 ·
Replies
3
Views
2K
Graduate Calculating asymptotic behavior of a correlation function
  • · Replies 2 ·
Replies
2
Views
2K
MATLAB Different correlation coefficient results between Matlab and Excel.
  • · Replies 3 ·
Replies
3
Views
6K
Undergrad Higher-Order Time Correlation Functions of White Noise?
  • · Replies 2 ·
Replies
2
Views
3K