How To

How To Analyse Time Series

These tasks extract information from the time series, but do not manipulate the time series data itself.

Access Simple Statistics

Access Simple Statistics through the Time Series Properties

To access simple time series statistics through the time series properties:

1. Select|topic=How To Select A Time Series the time series

2. Right-click on the time series. The Properties Explorer will display two tabs: ‘Time Series’ and ‘Statistics’

3. Select the ‘Statistics’ tab. It will show the basic statistics

4. Average (Mean)|topic=Mean Value (Average)

5. Maximum|topic=Maximum Value

6. Minimum|topic=Minimum Value

7. Standard Deviation|topic=Standard Deviation

8. Number of Missing Values

These statistics are computed over the entire period of available data.

Access Simple Statistics through a Chart

To access simple time series statistics through a chart:

1. Add|topic=Create A New Chart the time series data to a chart

2. Access|topic=View Simple Time Series Statistics in a Chart the statistics in the chart properties

Compute Simple Statistics through Tools

To access simple time series statistics through ‘Time Series Analysis’ tools::

1. Select|topic=How To Select A Time Series the time series

2. In the Tools Explorer select one of the ‘Time Series Analysis Tools’

3. Maximum Value|topic=Maximum Value

4. Minimum Value|topic=Minimum Value

5. Mean (Time Weighted)|topic=Time Weighted Average (Mean)

6. Standard Deviation|topic=Standard Deviation

7. Mode|topic=Mode

8. Data Quantile|topic=Data Quantile

9. Execute|topic=How To Execute A Tool the tool. The results can be accessed in a table.

Compute Advanced Statistics

Advanced statistics are computed using the ‘Time Series Analysis’ tools. To compute these statistics:

1. Select|topic=How To Select A Time Series the time series

2. In the Tools Explorer select one of

3. Distribution|topic=Distribution (Cumulative Distribution Function – CDF, or probability Distribution Function – PDF)

4. Duration Curve|topic=Duration Curve Tool

5. In the Properties Explorer, set the desired tool properties.

6. Execute|topic=How To Execute A Tool the tool. The results can be accessed in a table or chart.

The results of these calculations can not be saved as time series in the DSS database.

Compute Statistics Time Series

Some advanced statistics, which themselves are time series, can be computed using the time series tools. To compute these statistics:

1. Select|topic=How To Select A Time Series the time series

2. In the Tools Explorer select one of

3. Moving Average|topic=Moving Average

4. Residual Mass|topic=Residual Mass

5. In the Properties Explorer, set the desired tool properties.

6. Execute|topic=How To Execute A Tool the tool. The results can be accessed in a table or chart.

The results of these calculations can be saved as time series in the DSS database.

How To Manipulate A Time Series

Manipulate Time Series Properties

To manipulate time series properties (not the data itself):

1. Select|topic=How To Select A Time Series the time series. The Properties Explorer will show two tabs: ‘Time Series’ and ‘Statistics’.

2. Select the ‘Time Series’ tab.

3. Edit time series properties by selecting properties fields

4. Drop down menus with options will be displayed for the Time series ‘Type|topic=Supported Time Types’ and the ‘Value Type|topic=Supported Value Types’,

5. The ‘Data Series Name’ and the ‘Variable’|topic=Supported Variable Types can be entered directly.

Changing the ‘Value Type’ or ‘Variable’ does not change the time series data itself, just its description. Therefore, tools|topic=Time Series Tools must be used to manipulate the time series data if the ‘Value Type’ or ‘Variable’ is changed.

See also .|topic=Create a New Time Series Manually

Manipulate Individual Data Values Manually

Data Tables are used to manipulate/edit time series data manually. To do so:

1. Tabulate|topic=How To Tabulate A Time Series the time series

2. Double-click the cell holding the data value to be edited

3. Type in a new value and hit return.

Data values must be edited one at a time.

Edits are immediately saved to the DSS database. Thus the original time series should be replicated (copied , pasted|topic=Cut\, Copy\, Paste Or Delete A Time Series and renamed|topic=How To Rename A Time Series) first.

Manipulate Data Values using Time Series Tools

Time series tools are available to manipulate large amounts of data either in batch mode or interactively.

Batch Type Data Manipulation

To manipulate time series data using batch type ‘Time Series Processing ‘tools:

1. Select|topic=How To Select A Time Series the time series

2. In the Tools Explorer select one of

3. Value Type Conversion|topic=Value Type Conversion

4. Extract Time Period|topic=Extract Time Period

5. Resample|topic=Resample

6. Shift/Lag Time Period|topic=Shift/Lag Time Period

7. Synchronizer|topic=Synchronizer

8. In the Properties Explorer, set the desired tool properties.

9. Execute|topic=How To Execute A Tool the tool. The results can be accessed in a table or chart.

Output time series can be saved|topic=Create a New Time Series from Tool Results to the DSS database via charts.

Interactive Data Manipulation

To manipulate time series data in interactve mode:

1. Select|topic=How To Select A Time Series the time series

2. In the Tools Explorer select one of

3. Double Mass Analysis|topic=Double Mass

4. Gap Filler|topic=Gap Filler

5. Execute|topic=How To Execute A Tool the tool. This will open the tool specific user interface.

6. Interact with the tool.

7. When ready select ‘Execute’ to tabulate or chart the results

Output time series can be saved|topic=Create a New Time Series from Tool Results to the DSS database via charts.