Manuals/calci/CORRELATIONDATAANALYSIS

CORRELATIONDATAANALYSIS (Array,GroupBy,NewTableFlag)

• $Array$ is the set of numbers
• $GroupBy$ is the group name.
• $NewTableFlag$ is either 0 or 1.

Description

• This function shows the correlation data analysis.
• The Correlation coeffiecient shows the relationship between two continuous variables of each other.
• In $CORRELATIONDATAANALYSIS(Array,GroupBy,NewTableFlag)$,$Array$ is the set of numbers .
• $Groupby$ is the group name of correlation and $Newtableflag$ is either "0" or"1".
• We can use the CORREL function to find the correlation coefficient between two variables.
• This is also called Pearson's correlation coefficient.
• It is a measure of the strength of the association between the two variables.
• The correlation coefficient should not be calculated if the relationship is not linear.
• Positive correlation indicates that both variables increase or decrease together, whereas negative correlation indicates that as one variable increases, so the other decreases, and vice versa.

Examples

1. CORRELATIONDATAANALYSIS([[56,56,65,65,50,25,87,44,35],[87,91,85,91,75,28,122,66,58]],"rows",1)

Spreadsheet

CORRELATION BY ROWS
	ROW1	ROW2
ROW1	1	0.9661943464912911
ROW2	0.9661943464912911	1

1 1

See Also

• CORREL
• FACT

References

Correlation Data Analysis