writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + − + − + Line 17:
Line 17: − + − + − + − + − +
no edit summary
<div style="font-size:30px">'''CORREL(array1,array2)'''</div><br/>
<div style="font-size:30px">'''CORREL(Array1,Array2)'''</div><br/>
*<math>array1</math> and <math>array2 </math> are the set of values.
*<math>Array1</math> and <math>Array2 </math> are the set of values.
==Description==
==Description==
*This function gives the correlation coefficient of the 1st set(<math>array1</math>) of values and 2nd set(<math>array2</math>) of values.
*This function gives the correlation coefficient of the 1st set(<math>Array1</math>) of values and 2nd set(<math>Array2</math>) of values.
*Correlation is a statistical technique which shows the relation of strongly paired variables.
*Correlation is a statistical technique which shows the relation of strongly paired variables.
*For example, test average and study time are related; those who spending more time to study will get high marks and Average will go down for those who spend less time for studies.
*For example, test average and study time are related; those who spending more time to study will get high marks and Average will go down for those who spend less time for studies.
*<math>\bar x</math> and <math>\bar y</math> are the sample means of <math>X</math> and <math>Y</math>.
*<math>\bar x</math> and <math>\bar y</math> are the sample means of <math>X</math> and <math>Y</math>.
*This function will give the result as error when
*This function will give the result as error when
1.<math>array1</math> and <math>array2</math> are non-numeric or different number of data points.
1.<math>Array1</math> and <math>Array2</math> are non-numeric or different number of data points.
2.<math>array1</math> or <math>array2</math> is empty
2.<math>Array1</math> or <math>Array2</math> is empty
3.The denominator value is zero.
3.The denominator value is zero.
*Suppose <math>array1</math> and <math>array2</math> contains any text, logical values, or empty cells, like that values are ignored.
*Suppose <math>Array1</math> and <math>Array2</math> contains any text, logical values, or empty cells, like that values are ignored.
==ZOS==
==ZOS==
*The syntax is to calculate CORREL in ZOS is <math>CORREL(array1,array2)</math>.
*The syntax is to calculate CORREL in ZOS is <math>CORREL(Array1,Array2)</math>.
**<math>array1</math> and <math>array2 </math> are the set of values.
**<math>Array1</math> and <math>Array2 </math> are the set of values.
*For e.g.,CORREL([(-5)..(-1)],[10..15])
*For e.g.,CORREL([(-5)..(-1)],[10..15])
{{#ev:youtube|Il4jCpJy0IA|280|center|Correlation Coefficient}}
{{#ev:youtube|Il4jCpJy0IA|280|center|Correlation Coefficient}}