Illustrative Worksheet


Illustrative Worksheet

Author
Message
Haasz32
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: Forum Members
Posts: 3, Visits: 1

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.


Mush
Forum Newbie
Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)

Group: Forum Members
Posts: 4, Visits: 1
I finally found the illustrative worksheet, it is out in the Time Series Techniques area in the project section.
xaznstylegrlx
Forum Newbie
Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)

Group: Forum Members
Posts: 5, Visits: 1
I can calculate the first autocorrelation, but I can't come up with lag two autocorrelation.
Mush
Forum Newbie
Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)

Group: Forum Members
Posts: 4, Visits: 1
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.
Haasz32
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: Forum Members
Posts: 3, Visits: 1

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.


Mush
Forum Newbie
Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)

Group: Forum Members
Posts: 4, Visits: 1
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.
GO
Merge Selected
Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...





Reading This Topic


Login
Existing Account
Email Address:


Password:


Social Logins

  • Login with twitter
  • Login with twitter
Select a Forum....













































































































































































































































Neas-Seminars

Search