Descriptive Statistics by Date (hour)

For questions regarding the import, export and manipulation of data in EViews, including graphing and basic statistics.

Moderators: EViews Gareth, EViews Steve, EViews Jason, EViews Moderator, EViews Pamela

Ricardo98
Posts: 14
Joined: Tue Jun 20, 2017 12:49 pm

Descriptive Statistics by Date (hour)

Postby Ricardo98 » Tue Jun 20, 2017 1:27 pm

Hi all,

I am experimenting for first time with Eviews in order to build a SARIMAX model for the UK Electricity Market Demand. Right now I am just testing the raw data (hourly demand from 2006.1.1 to 2016.12.31)

I am now very much stuck since I have a time series of demand values for 10 years and need to visualize Mean, Variance, Kurtosis and Skewness for every hour of the day.

So the question is, how do I get these Descriptive Statistics for every 24h? Lets say I want to obtain the Mean, Kurtosis, etc. for every hour of the day. So I would obtain 24 values of them for every statistical parameter.

Please do not hesitate on posting any related old topic or material.

Thanks so much in advance, I am looking forward to participating actively in this forum.

Ricardo.

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 11299
Joined: Tue Sep 16, 2008 5:38 pm

Re: Descriptive Statistics by Date (hour)

Postby EViews Gareth » Tue Jun 20, 2017 1:30 pm

Depends on how the data are structured.

If you're in an hourly workfile, you could open the series and click on View->Descriptive Statistics->Stats by Classification and enter "@hour" as the classifying variable.
Follow us on Twitter @IHSEViews

Ricardo98
Posts: 14
Joined: Tue Jun 20, 2017 12:49 pm

Re: Descriptive Statistics by Date (hour)

Postby Ricardo98 » Tue Jun 20, 2017 1:32 pm

I am right now starting with the only solution I came up with. Im creating dummy variables depending of the "hour of the day" 1-24 in order to sample demand values using the "if" function with the dummy variable next to it.

But I believe Eviews provides more powerful short cuts.

Ricardo98
Posts: 14
Joined: Tue Jun 20, 2017 12:49 pm

Re: Descriptive Statistics by Date (hour)

Postby Ricardo98 » Tue Jun 20, 2017 1:33 pm

EViews Gareth wrote:Depends on how the data are structured.

If you're in an hourly workfile, you could open the series and click on View->Descriptive Statistics->Stats by Classification and enter "@hour" as the classifying variable.



Thanks Gareth! I will start from there.

Ricardo98
Posts: 14
Joined: Tue Jun 20, 2017 12:49 pm

Re: Descriptive Statistics by Date (hour)

Postby Ricardo98 » Tue Jun 20, 2017 1:34 pm

Done!

Oh my days I feel so dumb now, haha.

Much appreciated.

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 11299
Joined: Tue Sep 16, 2008 5:38 pm

Re: Descriptive Statistics by Date (hour)

Postby EViews Gareth » Tue Jun 20, 2017 1:36 pm

No need to feel dumb - a lot of users don't know about that nifty feature. And your question was better structured/explained than most!
Follow us on Twitter @IHSEViews


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 3 guests