cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar
peder
Level III

Time Series, calculation lag

Hello, I want to check if some temperature data that I have are correlated, and I suspect there is a time-dependent lag.

I have tried the time-series analysis using cross correlation. As a test of what the analysis does I entered the following data columns. There is full correlation for a lag of 7 rows:

A      A+7

1        8

2        9

3        10

4        11

etc.

What I got just doesn't make sense. See the picture below. There should be some way to see a full correlation of the data for a lag of 7.

4445_lag7.png

1 ACCEPTED SOLUTION

Accepted Solutions
peder
Level III

Re: Time Series, calculation lag

Hmm - I suppose this have to do with the nature of the data. When I try with random data and do a manual calculation (shifting numbers and calculating the integral of the product for each value) it seems to give me the same as JMP does. The lag is -4, which peaks as it should. See the picture.

The thing is that the time series should be filtered for any autocorrelation, something I've read is called whitening. Not mentioned and not possible in JMP in an automatic way as I see it. Anyway - JMP seems to catch my lag of -4 when the data is random.

Can anyone confirm this?

4448_lag4.png4450_lag4data.png

View solution in original post

1 REPLY 1
peder
Level III

Re: Time Series, calculation lag

Hmm - I suppose this have to do with the nature of the data. When I try with random data and do a manual calculation (shifting numbers and calculating the integral of the product for each value) it seems to give me the same as JMP does. The lag is -4, which peaks as it should. See the picture.

The thing is that the time series should be filtered for any autocorrelation, something I've read is called whitening. Not mentioned and not possible in JMP in an automatic way as I see it. Anyway - JMP seems to catch my lag of -4 when the data is random.

Can anyone confirm this?

4448_lag4.png4450_lag4data.png