Introduction
The Regression activity Activity allows you to view correlations on a siteSite, view the CUSUM and set targets based on the CUSUM and Regression. This activity is not available from the main Activity Menu; it is only available via right click of a Site or through the Site Overview activity.
Navigation
In Click on the Site in the Site Overview activity selecting Activity
Click Actions in the top right of the screen will to allow you to navigate to other activities within Sigma including Regression.
Click on Regression
Alternatively, right-click on a Site and select from Regression from the menu.
Navigate from Regression to the Control Chart via CUSUM by clicking in the bottom right corner or using the bar at the top of the activity.
- It is not possible to go directly from Regression to the Control Chart as it is a designed as a stepped approach.
Regression Correlation Window
Regression Correlations
Automatic Regressions
Sigma will automatically check the system to find any correlations with an R2 value of 0.9 or greater.
Correlations will be between two data points and those found automatically will display as follows:
Manual Regressions
Correlations can also be setup manually by selecting and and choosing the required correlation items within the setup screen.
Once a manual regression is created it will look similar to this.
To view the regression correlation, right-click the image and select or or double-click the regression image.
You will now see three tabs - Regression, CUSUM and Control Chart
Regression
...
Graph
- The graph plots the Dependent Data against the Independent Data and draws a line of best fit.
Overview
- The Overview chart shows the dependent data and independent data for the regression period and part of the historic period too.
- Dragging your mouse over this chart will update the regression period displayed.
- The Overview Graph can be minimised by clicking the Overview header bar.
Manage Regression Targets
- If a regression is found, it is automatically saved as Original Correlation, this correlation cannot be amended.
- A New performance line is also created which can be amended and saved as a new regression target.
Details
...
This section shows gradient and intercept of the graph.
The gradient and intercept can be adjusted by selecting and and entering a value in the popup box.
To remove the gradient and intercept select .click
When a custom gradient is set the R2 values are not available.
The details section displays both the Correlation Coefficient and Coefficient of Determination.
Monitoring Point
A Monitoring Point stores information that has been created from various sources of data. For example, a calculation of the total gas consumed by a number of sites derived from gas consumption data at each individual site.
The data in the Monitoring Point object would be generated by an equation (in this case a simple sum) combining all of the sources of data (in this example gas consumption at each site).
Regression Period
Use the start date to choose the start period for the graph, either selecting the drop down boxes or the calendar icon .
Set the end date for the graph in the same way.
Manage Regression Targets
- If a regression is found, it is automatically saved as Original Correlation, this correlation cannot be amended
- A New performance line is also created which can be amended and saved as a new regression target
Table tab
Selecting the tab displays The screen defaults to show the data in a graph. This can be changed to show as a table.
Click on to display the data points that are plotted on the graph.
Uncheck any line item that you want to exclude from the graph .graph
Excluding points from the graph will recalculate the line of best fit.
The date displayed within the table is the end date for that period.
The table and charts can be saved by selecting the icon.clicking
CUSUM
Click on
Graph
The graph shows the cumulative data based on the CUSUM period.
Clicking and dragging your mouse over the graph will zoom into the data.
Overview
The Overview chart (bottom of the screen) shows the dependent data and independent data for the CUSUM period and part of the historic period too.
Dragging your mouse over this chart will update the CUSUM period displayed.
If the CUSUM period is different to the Regression period then you will see two colours highlighted on the overview. Blue is the regression period and purple the CUSUM period.
The Overview Graph can be minimised by clicking the Overview header bar.
Details
CUSUM and CUSUM CO2 will always be 0.00 when moving straight from Regression without changing the CUSUM period.
When the CUSUM period is changed then anything above the 0 value based on the regression period will be calculated and listed in both kWh's and CO2.
Data Analysis
Check Tick the Show V-Mask box to add a V-Mask target onto the CUSUM. To confirm target creation select in in the resulting popup window.
By default a truncated V-Mask will be applied, adding a green layer to the graph.
There are 3 types of V-Mask targets available as follows. To change the type, continue reading.:
Full mask
Snub-nosed mask
Truncated mask
Check Tick Show Fixed Targets to add a CUSUM fixed target. To confirm target creation select in in the resulting popup window.
CUSUM Period
Use the start date to choose the start period for the graph, either selecting the drop down boxes or the calendar icon
Set the end date for the graph in the same way
Targets
This section displays any targets that have been created on the CUSUM.
To change any of the settings, right-click on the target and select .Edit
To remove a target, right-click on the target and select .Remove
If you edit a V-Mask Target you will be presented with the following window.
If you edit a CUSUM target you will be presented with the following window.
Update the settings as required and click OK.
The Targets will only create an event if the first point of data is outside the tolerance range by >5% or if there are two consecutive points of day outside the tolerance range but with the 5% range.
.CUSUM Period
Use the start date to choose the start period for the graph, either selecting the drop down boxes or the calendar icon .
Set the end date for the graph in the same way.
Table
Selecting the tab displays tab to show the data points that are plotted on the graph.
The date displayed within the table is the end date for that period.
The table and charts can be saved by selecting the icon.
...
click
Control Chart
It is not possible to go directly from Regression to the Control Chart as it is a designed as a stepped approach.
Navigate from Regression to the Control Chart via CUSUM by clicking then
Graph
The graph will display data for the same period that has been set in the CUSUM.
The graph displaysdisplays
Control Lines - Accepted accepted areas of data based on the control limit.
Exceptions - Areas areas which fall outside of the control limit.
Difference line - Data data for the period being presented.
Overview
The Overview graph Graph highlights the current target period by default and displays historic and future data.
The Overview Graph can be minimised by clicking the Overview header bar.
Targets
By default a New Control Target will be created for the user to amend as required. This target is not saved unless you click the Save button
...
The targets Targets section details the current control line parameters as well as allowing you to add and remove targets. Reverting the selection and saving the target.
Control Lines
To amend the control control lines applied change the control limit.
Alternatively you can manually drag the control lines on the graph, to do this select and and click and drag on the graph to set desired control limits.
To remove the Control Limits from the graph uncheck .
The Targets will only create an event if the first point of data is outside the tolerance range by >5% or if there are two consecutive points of day outside the tolerance range but with the 5% range.