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.
Descriptive Statistics by Date (hour)
Moderators: EViews Gareth, EViews Jason, EViews Steve, EViews Moderator
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13317
- Joined: Tue Sep 16, 2008 5:38 pm
Re: Descriptive Statistics by Date (hour)
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.
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
Re: Descriptive Statistics by Date (hour)
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.
But I believe Eviews provides more powerful short cuts.
Re: Descriptive Statistics by Date (hour)
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.
Re: Descriptive Statistics by Date (hour)
Done!
Oh my days I feel so dumb now, haha.
Much appreciated.
Oh my days I feel so dumb now, haha.
Much appreciated.
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13317
- Joined: Tue Sep 16, 2008 5:38 pm
Re: Descriptive Statistics by Date (hour)
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
Who is online
Users browsing this forum: No registered users and 22 guests