The Correlation Calculations form shows what variables correlate to a variable.   It provides four different line/curve fits to the data and calculates the Coefficient of Correlation (Coeff of Cor) for each. The correlation coefficients of correlation are a measurement of the goodness of fit. The higher the Coefficient, the better the fit (1.0 being a perfect fit). The list is sorted by the Linear Regression Coefficient of Correlation by default.

The Corrleaiton Calculations form is available from the following Graph Pac Forms:

Correlation Graph - Used to suggest an independent variable:

Multiple Linear Regression Graph - Used to suggest independent variables:

Variable Analysis Graphs - Used to suggest a variable to compare to:

Example: Find variables that correlate to Effluent BOD.

1. Go to Graph Pac, Variable Analysis Graphs

2. Choose Effluent BOD as the Variable to Analyze.

3. Click the button. This will display the Correlation Calculations for Effluent BOD:

In this example, we find that the Eff BOD Duplicate correlates to Eff BOD the best. However, while this makes perfect sense statistically, this give us no insight into what affects our Eff BOD. However, MLSS is second on the list and something we can control.

NOTE: If the variable list is blank then you have more than 500 variables of the same frequency (e.g. more than 500 daily variables). In this case you will need to hit the add button to add variables you would like the utility to search through.

4. Click on the MLSS row, the Selected Independent Variable will be updated and click OK.  MLSS will be chosen as the variable to compare Effluent BOD to.