Difference between revisions of "Manuals/calci/CORRELATIONDATAANALYSIS"
Jump to navigation
Jump to search
(Created page with "==CORRE") |
|||
Line 1: | Line 1: | ||
− | == | + | <div style="font-size:30px">'''CORRELATIONDATAANALYSIS (Array,GroupBy,NewTableFlag)'''</div><br/> |
+ | *<math>Array</math> is the set of numbers | ||
+ | *<math>GroupBy</math> is the group name. | ||
+ | *<math>NewTableFlag</math> 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 <math>CORRELATIONDATAANALYSIS(Array,GroupBy,NewTableFlag)</math>,<math> Array</math> is the set of numbers . | ||
+ | *<math>Groupby</math> is the group name of correlation and <math>New table flag</math> 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== | ||
+ | #CORRELATIONDATAANALYSIS([10,12,13,34,10],"row", | ||
+ | |||
+ | ==See Also== | ||
+ | *[[Manuals/calci/CORREL | CORREL]] | ||
+ | *[[Manuals/calci/FACT | FACT]] | ||
+ | |||
+ | ==References== | ||
+ | [http://learntech.uwe.ac.uk/da/Default.aspx?pageid=1442 Correlation Data Analysis] |
Revision as of 15:00, 13 December 2016
CORRELATIONDATAANALYSIS (Array,GroupBy,NewTableFlag)
- is the set of numbers
- is the group name.
- 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 , is the set of numbers .
- is the group name of correlation and 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
- CORRELATIONDATAANALYSIS([10,12,13,34,10],"row",