I keep reading about an Excel Illustrative worksheet that shows how to do alot of the necessary calculations in Excel but have been unable to locate it.  The one link that a user posted no longer works.  Can somebody please lead me to this worksheet?  Thanks.

There is an excel file under the interest rates posting in the vee time series student project location.  This file gives you interest rates, formulas to calculate real interest rates from the nominal ones, formulas to calculate the sample autocorrelations, a macro to calc the sample autocorrelations, and correlograms.  This is what I'm using to get me started. 

I searched for a while before I came across this as well.  Nothing seems to be organized well on any of the discussion forums here.  NEAS should really look to clean up the postings into more clearly labeled groupings.

Thanks as I located the illustrative worksheet.  I have been going through it and cannot find the formulas they used to calculate the autocorrelations.  Just curious if anyone else has been through the worksheet and located them.

I can calculate the first autocorrelation, but I can't come up with lag two autocorrelation.

I finally found the illustrative worksheet, it is out in the Time Series Techniques area in the project section.

Mush,

Sorry about that.  I found the file and I renamed it when I downloaded it (from the area you described).  When I went looking for it again as I tried to answer your question, I saw that file I pointed to you and thought it was what I saved off earlier.  The file I pointed to you does not have any formulas in it, as you know.  Again, if things were more organized, we wouldn't have this problem.