Math Functions > Statistics Functions


Cyclic Analysis

The Cyclic Analysis function derives a set of cyclic statistics from a regular interval time series data set.  The time series data set must have a time interval of “1HOUR,” “1DAY” or “1MONTH.”  The function sorts the time series values into statistical "bins" relevant to the time interval.  Values for the 1HOUR interval data are sorted into 24 bins representing the hours of the day, 0100 to 2400.  The 1DAY interval data is apportioned to 365 bins for the days of the year.  The 1MONTH interval data is sorted into 12 bins for the months of the year.

 

The format of the resultant data sets is as a “pseudo” time series for the year 3000.  For example, the cyclic analysis of one month of hourly interval data will produce pseudo time series data sets having 24 hourly values for the day January 1, 3000.  If the statistical parameter is the “maximum” value, then the 24 values represent the maximum value occurring at that hour of the day in the original time series.  The cyclic analysis of daily interval data will produce pseudo time series data sets having 365 daily values for the year 3000.  The cyclic analysis of monthly interval data will result in pseudo time series data sets having 12 monthly values for the year 3000.   

 

Fourteen pseudo time series data sets are derived by the cyclic analysis function for the following statistical parameters:

 

§  Number of values processed for each time interval

§  Maximum value

§  Time of maximum value

§  Minimum value

§  Time of minimum value

§  Average value

§  Probability exceedence percentiles for 5%, 10%, 25%, 50% (median value), 75%, 90%, and 95%

§  Standard deviation

 

The appearance of the Math Functions screen for the Cyclic Analysis function is shown below. 

 

To compute the cyclic analysis of a time series data set:

  1. Choose the Statistics tab of the Math Functions screen and select the Cyclic Analysis type.
  2. From the Selected Data Set list, select a time series data set for cyclic analysis. 
  3. Click Compute.

 

Once the compute is performed, the resultant 14-pseudo time series data sets appear in Results list on the screen (see figure below).  One or more data sets in this list may be selected (by clicking, control-click or shift-click ) for saving to file, plotting or tabulation by using the Save  button, SaveAs  button, the Plot  button or the Tabulate  button from the toolbar located immediately above the Results list. An example showing the data plotted is shown in the second figure below.

 


Screen for Cyclic Analysis function


Plot of Data Set Results from Cyclic Analysis