Explore BrainMass

Explore BrainMass

    Auto-Correlation

    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 March 4, 2021, 5:53 pm ad1c9bdddf
    https://brainmass.com/statistics/correlation/auto-correlation-16334

    Attachments

    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

    ADVERTISEMENT