Autocorrelation function in Excel

Click For Summary
The discussion focuses on performing autocorrelation in Excel using the CORREL function with a large dataset. The user initially faced issues extending the formula for autocorrelation calculations across multiple data ranges. The solution involved using the dollar sign ($) to fix the variable references in the formula, which resolved the problem. For further assistance with Excel-related queries, a suggestion was made to visit the Excel Forum for additional support.
dinky
Messages
2
Reaction score
0
Autocorrelation function in Excel (SOLVED)

Hi, I have tried reading through this forum looking for similar example but am unable to find one.

Basically, I have a large set of data that I intend to do autocorrelation.

=CORREL(A1:A10000,A2:A10001)
=CORREL(A1:A10000,A3:A10002)
=CORREL(A1:A10000,A4:A10003)
...
=CORREL(A1:A10000,A10000:A20000)

But when i try to extend the formula, it does not seem to work? Can anyone help me on this? Thanks.

Added the $ sign to make it a fixed variable.
Problem solved. Thanks for the help
 
Last edited:
Computer science news on Phys.org
Thread 'ChatGPT Examples, Good and Bad'

Thread 'ChatGPT Examples, Good and Bad'

I've been experimenting with ChatGPT. Some results are good, some very very bad. I think examples can help expose the properties of this AI. Maybe you can post some of your favorite examples and tell us what they reveal about the properties of this AI. (I had problems with copy/paste of text and formatting, so I'm posting my examples as screen shots. That is a promising start. :smile: But then I provided values V=1, R1=1, R2=2, R3=3 and asked for the value of I. At first, it said...
View full post »

Similar threads

What Causes #HREF! Errors in Excel 2007?
  • · Replies 5 ·
Replies
5
Views
2K
Calculating Autocorrelations for Large Data Sets in Excel: Tips and Alternatives
  • · Replies 7 ·
Replies
7
Views
28K
Ising model autocorrelation function calculation
  • · Replies 1 ·
Replies
1
Views
2K
MATLAB How Can You Explore Autocorrelation Functions for Different Lags in Matlab?
  • · Replies 5 ·
Replies
5
Views
3K
Undergrad Formal derivation of statement from Peano Arithmetic system
  • · Replies 10 ·
Replies
10
Views
933
Comp Sci An Introduction to Deep Learning and Modifying Code
  • · Replies 7 ·
Replies
7
Views
2K
Fixing Annoying Word/Excel Windows Problem
  • · Replies 3 ·
Replies
3
Views
2K
High School Not sure about the magnetic flux (phi) depending on a cosine function
  • · Replies 9 ·
Replies
9
Views
2K
FindRoot solving of Excel input columns
  • · Replies 3 ·
Replies
3
Views
4K
Using Variables in Summing Formulas in Excel/Open Calc
  • · Replies 3 ·
Replies
3
Views
2K