Manuals/calci/PEARSON - Revision history

Devika at 21:01, 8 August 2018

2018-08-08T21:01:56Z

2018-06-08T19:00:43Z

2017-03-13T06:38:52Z

2017-03-09T11:26:42Z

2015-10-05T14:04:35Z

2015-06-20T01:38:17Z

2014-01-22T08:01:19Z

Description

2014-01-22T08:00:11Z

2014-01-22T06:07:56Z

Examples

2014-01-07T08:27:57Z

Examples

@@ Line 2: / Line 2: @@
 *<math>Array1</math> is the array of independent values
 *<math>Array2</math> is the array of dependent values.
 ==Description==

@@ Line 1: / Line 1: @@
-<div style="font-size:30px">'''PEARSON (ar1,ar2)'''</div><br/>
+<div style="font-size:30px">'''PEARSON (Array1,Array2)'''</div><br/>
-*<math>ar_1</math> is the array of independent values
+*<math>Array1</math> is the array of independent values
-*<math>ar_2</math> is the array of dependent values.
+*<math>Array2</math> is the array of dependent values.
 ==Description==
@@ Line 16: / Line 16: @@
 where <math> \bar{x}</math>   and   <math>\bar{y} </math>  are Average of the two Samples  <math>x </math> and  <math>y </math>.
-*In  <math>PEARSON(ar_1,ar_2)</math>, the value of <math> ar_1</math> and <math> ar_2</math> must be either numbers or names, array,constants or references that contain numbers.
+*In  <math>PEARSON(Array1,Array2)</math>, the value of <math>Array1</math> and <math>Array2</math> must be either numbers or names, array,constants or references that contain numbers.
 *Suppose the array contains text, logicl values or empty cells, like that values are not considered.
-*This function will return the result as error when the number of values are different for <math> ar_1 </math> and <math> ar_2 </math>.
+*This function will return the result as error when the number of values are different for <math> Array1 </math> and <math> Array2 </math>.
 ==Examples==

← Older revision		Revision as of 06:38, 13 March 2017
Line 78:		Line 78:


−	[[Z_API_Functions \| List of Main Z Functions]]	+	*[[Z_API_Functions \| List of Main Z Functions]]

−	[[ Z3 \| Z3 home ]]	+	*[[ Z3 \| Z3 home ]]

← Older revision		Revision as of 11:26, 9 March 2017
Line 74:		Line 74:
	==References==		==References==
	[http://en.wikipedia.org/wiki/Pearson_product-moment_correlation_coefficient Pearson]		[http://en.wikipedia.org/wiki/Pearson_product-moment_correlation_coefficient Pearson]
		+
		+
		+
		+
		+	[[Z_API_Functions \| List of Main Z Functions]]
		+
		+	[[ Z3 \| Z3 home ]]

@@ Line 47: / Line 47: @@
 |}
-  =PEARSON(A1:D1,A2:D2) = -0.759206026
+  =PEARSON(A1:D1,A2:D2) = 0.034204238054579846
 .

← Older revision		Revision as of 01:38, 20 June 2015
Line 63:		Line 63:

	=PEARSON(A1:C1,A2:B2) = NAN		=PEARSON(A1:C1,A2:B2) = NAN
		+
		+	==Related Videos==
		+
		+	{{#ev:youtube\|JO-Gc5bEG70\|280\|center\|PEARSON}}

	==See Also==		==See Also==

@@ Line 12: / Line 12: @@
 indicates no correlation
   -1 indicates the perfect negative correlation.
-*The formula for PPMC,<math> r </math> is defined by:
+*The formula for PPMC, <math> r </math> is defined by:
 <math> r= \frac{ \Sigma(x-\bar{x})(y-\bar{y})}{\sqrt {\Sigma(x-\bar{x})^2(y-\bar{y})^2}}</math>
 where <math> \bar{x}</math>   and   <math>\bar{y} </math>  are Average of the two Samples  <math>x </math> and  <math>y </math>.
-*In  <math>PEARSON(ar1,ar2)</math>, the value of <math> ar1</math> and <math> ar2</math> must be either numbers or names, array,constants or references that contain numbers.
+*In  <math>PEARSON(ar_1,ar_2)</math>, the value of <math> ar_1</math> and <math> ar_2</math> must be either numbers or names, array,constants or references that contain numbers.
-*Suppose the array contains text,logicl values or empty cells, like that values are not considered.
+*Suppose the array contains text, logicl values or empty cells, like that values are not considered.
-*This function will return the result as error when the number of values are different for <math> ar1 </math> and <math> ar2 </math>.
+*This function will return the result as error when the number of values are different for <math> ar_1 </math> and <math> ar_2 </math>.
 ==Examples==

@@ Line 1: / Line 1: @@
 <div style="font-size:30px">'''PEARSON (ar1,ar2)'''</div><br/>
-*<math>ar1</math> is the array of independent values
+*<math>ar_1</math> is the array of independent values
-*<math>ar2</math> is the array of dependent values.
+*<math>ar_2</math> is the array of dependent values.
 ==Description==
-*This function gives the Pearson product-moment correlation coefficient.
+*This function gives the Pearson Product-Moment Correlation Coefficient.
 *It is denoted by PPMC, which shows the linear relationship between two variables.
 *It is a measure of the strength of a linear association between two variables .
 *The two variables  <math> X </math>  and <math> Y </math>, giving a value between +1 and −1 inclusive.
-*Here +1 indicates the perfect positive correlation, 0 indicates no correlation and -1 indicates the perfect negative correlation.
+*Here
 *The formula for PPMC,<math> r </math> is defined by:
 <math> r= \frac{ \Sigma(x-\bar{x})(y-\bar{y})}{\sqrt {\Sigma(x-\bar{x})^2(y-\bar{y})^2}}</math>

@@ Line 18: / Line 18: @@
 ==Examples==
-*1.Array1           Array2
+{| class="wikitable"
-                       8
+|+Spreadsheet
-                        12
+|-
-                      15
+! !! A !! B !! C
-PEARSON(B1:B3,C1:C3)=0.968619605
+|-
-*2.Array1            Array2
+! 1
-                   10
+| 5 || 9 || 10
-                        11
+|-
-                        7
+! 2
-                       13
+| 8 || 12 || 15
-PEARSON(D1:D4,E1:E4)=-0.759206026
+|}
-*3.Array1            Array2
-                       4
+ =PEARSON(A1:C1,A2:C2) = 0.968619605
-                       5
+.
+{| class="wikitable"
-PEARSON(A1:A3,B1:B2)=NAN
+|+Spreadsheet
 ==See Also==