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",