Return to site

Calculating autocorrelation in excel

broken image
broken image

If the slope is positive, the autocorrelation is positive if there is a negative slope, the autocorrelation is negative. the same data at lag π‘˜ may show a positive or negative trend.

broken image
broken image

Just as correlation measures the extent of a linear relationship between two variables, autocorrelation measures the linear relationship between lagged values of data.Δͺ plot of the data vs.

broken image