Explore BrainMass

# Auto-Correlation

Not what you're looking for? Search our solutions OR ask your own Custom question.

This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

The problem is: Vernon wants to use excel to compute autocorrelation coefficients and correlogram for the data presented. This example was manually copied from the book and formulas were not entered.
I need assistance in writing a memo BRIEFLY EXPLAINING the results of the attached example (findings, I.E., GRAPH, LAG, ACF, CORRELATION).

Â© BrainMass Inc. brainmass.com December 24, 2021, 4:55 pm ad1c9bdddf
https://brainmass.com/statistics/correlation/auto-correlation-16334

#### Solution Preview

Please refer to the attachment.
<br>
<br>Autocorrelation is an important guide to the properties of a time series, which is provided by a series of quantities called autocorrelation coefficients. These coefficients measure correlation between observations at different time periods.
<br>(They often provide insights into the probability model that generates the data.)
<br>
<br>I then ran a regression of Yt on Lag1 and Lag2, the report is attached in the EXCEL.
<br>We notice a high F value = 7.4, which means that the Lag1 and Lag2 "jointly" help to explain Yt. (although we notice low t-values of Lag1 ...

#### Solution Summary

The problem is: Vernon wants to use excel to compute autocorrelation coefficients and correlogram for the data presented. This example was manually copied from the book and formulas were not entered.
I need assistance in writing a memo BRIEFLY EXPLAINING the results of the attached example (findings, I.E., GRAPH, LAG, ACF, CORRELATION).

\$2.49