The Cross Correlation Analysis viewlet shows various kinds of correlations between variables with a certain confidence interval. This viewlet uses linear regression analysis to provide actual correlation values. If the pattern of dots slopes from lower left to upper right, it suggests a positive correlation between the variables being studied. If the pattern of dots slopes from upper left to lower right, it suggests a negative correlation. A line of best fit (alternatively called 'trendline') can be drawn in order to study the correlation between the variables. In addition, an identity line, i.e., a y=x line, or an 1:1 line, is often drawn as a reference. The more the two data sets agree, the more the scatters tend to concentrate in the vicinity of the identity line; if the two data sets are numerically identical, the scatters fall on the identity line exactly.
New Screenshot Pending
Setting up the Cross Correlation viewlet is a multi-step process:
- Click the wrench icon to filter by unit or location if desired.
- Use the X-Axis tab to select the variable of interest, such as “Main Power (kWh)” and Roll-up type, such as Avg, Min, Max or Sum.
- Use the Y-Axis tab to select the cross correlation variable such as “Outside Air Temperature” and Roll-up type, such as Avg, Min, Max or Sum.
- Finally, click on the Config tab to select a predetermined date range or a custom date period. Additional configuration is available to select colors, radius and best fit and/or identity line:
If desired, stray points can be removed from the linear regression calculation by clicking on them.
New Screenshot Pending