Averaging hourly data

[TracyW]

Hi,
I'm using Eviews 8. I have a lot of hourly data showing power demand for multiple years. I'd like to look at things like the average demand for each hour in a given month (eg the average of the hourly demand from 1 April to 30 April for 1am, 2am, 3am .... etc) or a season, or a year. I've read the data in as hourly data into Eviews, and I have the date-time, but now I can't figure out how to tell Eviews to show me an average over a set number of days. Can someone please help?

[EViews Gareth]

Create a new group containing @year @month @hour

Code: Select all

group g @year @month @hour

Then open up your series, click on View->Descriptive Statistics->Stats by classification and then enter the name of the group in the series/group to classify by box.

If you only have data for one year you can drop the @year bit from the group.

[TracyW]

Thank you for the quick reply.

[TracyW]

I worked out that if I reversed your order to @hour @month @year I could get the hours all nicely lined up next to each other, by month.

[TracyW]

Can I graph this data within Eviews?

[EViews Gareth]

What do you mean?