How to draw a correlation function in excel

Click For Summary
SUMMARY

The discussion focuses on calculating a correlation function in Excel using the CORREL and INDIRECT functions. The user struggles with implementing these functions correctly to compute correlation at specified data points. The conversation emphasizes the importance of understanding how to utilize Excel's built-in help resources to clarify the usage of these functions for accurate results.

PREREQUISITES
  • Familiarity with Excel functions, specifically CORREL and INDIRECT
  • Basic understanding of correlation and its significance in data analysis
  • Ability to organize data in Excel for analysis
  • Knowledge of how to access and interpret Excel Help resources
NEXT STEPS
  • Research how to effectively use the CORREL function in Excel
  • Learn about the INDIRECT function and its applications in dynamic cell referencing
  • Explore tutorials on data organization for correlation analysis in Excel
  • Review Excel Help documentation for advanced function usage and troubleshooting
USEFUL FOR

This discussion is beneficial for students, data analysts, and anyone seeking to perform correlation analysis using Excel, particularly those new to using statistical functions in spreadsheet software.

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
3K
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