How to Use the CORREL Function in Excel . Now that you understand what the CORREL function does and how to prepare your data, ...
Scatter diagrams are used to explore patterns ... for example 'Maths and Science assessment marks'. For a positive correlation, as one variable increases the other variable increases.