Manuals/calci/TTESTPAIRED - Revision history

Devika at 20:55, 18 June 2018

2018-06-18T20:55:13Z

Sahiti: /* Examples */

2017-05-12T08:32:24Z

Examples

Sahiti: /* Examples */

2017-05-12T08:32:11Z

Examples

Jayaram at 07:36, 13 March 2017

2017-03-13T07:36:30Z

Devika: /* Examples */

2017-02-10T21:11:02Z

Examples

Devika: /* Examples */

2015-10-07T06:34:13Z

Examples

Swapna at 19:05, 2 July 2015

2015-07-02T19:05:51Z

Devika: /* References */

2015-05-11T19:03:41Z

References

Abin: /* Examples */

2014-02-10T08:52:57Z

Examples

Devika at 04:54, 7 February 2014

2014-02-07T04:54:29Z

@@ Line 1: / Line 1: @@
-<div style="font-size:30px">'''TTESTPAIRED(ar1,ar2,md,alpha,lv)'''</div><br/>
+<div style="font-size:30px">'''TTESTPAIRED(Array1,Array2,HypothesizedMeanDifference,Alpha,NewTableFlag)'''</div><br/>
-*<math>ar1 </math> and <math> ar2 </math>  are set of values.
+*<math>Array1 </math> and <math> Array2 </math>  are set of values.
-*<math>md </math> is the  Hypothesized Mean Difference.
+*<math>HypothesizedMeanDifference </math> is the  Hypothesized Mean Difference.
-*<math> alpha </math> is the significance level.
+*<math> Alpha </math> is the significance level.
-*<math> lv </math> is the logical value.
+*<math> NewTableFlag </math> is the logical value.
 ==Description==
@@ Line 10: / Line 11: @@
 *Paired samples also called matched samples or repeated measures.
 *This test is used when the samples are dependent. i.e.,only one sample which is tested twice or the two samples that have been paired.
-*In <math>TTESTPAIRED(ar1,ar2,md,alpha,lv)</math>, <math> ar1 </math> and <math> ar2 </math> are two arrays of sample values.
+*In <math>TTESTPAIRED(Array1,Array2,HypothesizedMeanDifference,Alpha,NewTableFlag)</math>, <math> Array1 </math> and <math> Array2 </math> are two arrays of sample values.
-*<math> md </math> is the Hypothesized Mean Difference .In this function md=0.
+*<math> HypothesizedMeanDifference </math> is the value of the Hypothesized Mean Difference .In this function HypothesizedMeanDifference=0.
-*<math> alpha </math> is the significance level which ranges from 0 to 1.
+*<math> Alpha </math> is the significance level which ranges from 0 to 1.
-*<math> lv </math> is the logical value like TRUE or FALSE.TRUE is indicating the result will display in new worksheet.Suppose we are omitted the <math>lv </math> value it will consider the value as FALSE.
+*<math> NewTableFlag </math> is the logical value like TRUE or FALSE.TRUE is indicating the result will display in new worksheet.Suppose we are omitted the <math>NewTableFlag </math> value it will consider the value as FALSE.
 *The t statistic of this function calculated by:
 <math> t = \frac{\bar{x}-\mu_ 0}{s.d/\sqrt{n}}</math>
@@ Line 19: / Line 20: @@
 *This function will give the result as error when
 . any one of the argument is non_numeric.
-. alpha>1.
+. Alpha>1.
 ==Examples==

@@ Line 38: / Line 38: @@
 {| class="wikitable"
 |+Result
-|t-TEST: PAIRED TWO SAMPLE FOR MEANS
+|+t-TEST: PAIRED TWO SAMPLE FOR MEANS
 |-
 ! !! VARIABLE1  !! VARIABLE2

@@ Line 38: / Line 38: @@
 {| class="wikitable"
 |+Result
-! t-TEST: PAIRED TWO SAMPLE FOR MEANS
+|t-TEST: PAIRED TWO SAMPLE FOR MEANS
 |-
 ! !! VARIABLE1  !! VARIABLE2

← Older revision		Revision as of 07:36, 13 March 2017
Line 89:		Line 89:
	==References==		==References==
	*[http://en.wikipedia.org/wiki/Student%27s_t-test Student's t-test]		*[http://en.wikipedia.org/wiki/Student%27s_t-test Student's t-test]
		+
		+
		+
		+
		+	*[[Z_API_Functions \| List of Main Z Functions]]
		+
		+	*[[ Z3 \| Z3 home ]]

@@ Line 38: / Line 38: @@
 {| class="wikitable"
 |+Result
 |-
-! !! Variable 1 !! Variable 2
+! !! VARIABLE1  !! VARIABLE2
 |-
-! Mean
+! MEAN
 | 18.666666666666668 || 17.166666666666668
 |-
-! Variance
+! VARIANCE
 | 62.66666666666667 || 80.56666666666666
 |-
-! Observations
+! OBSERVATIONS
 | 6 || 6
 |-
-! Pearson Correlation
+! PEARSON CORRELATION
 | 0.39499794997886284
 |-
-! Hypothesized Mean Difference
+! HYPOTHESIZED MEAN DIFFERENCE
-| 0
+| 5
 |-
-! Degree Of Freedom
+! DEGREE OF FREEDOM
 | 5
 |-
-! T-Statistics
+! T STATISTICS
-| 0.39369310315507355
+| -0.9186172406951716
 |-
-! P(T<=t) One-tail
+! P(T<=t) ONE-TAIL
-|0.35501800354613167
+|0.20022020093421516
 |-
-! T Critical One-Tail
+! T CRITICAL ONE-TAIL
-| 2.015048294624481
+| 0.7266868353364707
 |-
-! P(T<=t) Two-tail
+! P(T<=t) TWO-TAIL
-| 0.7100360070922633
+| 0.40044040186843033
 |-
-! T Critical Two-Tail
+! T CRITICAL TWO-TAIL
-|2.5705816859349686
+| 1.300949035127116
 |}

@@ Line 74: / Line 74: @@
 | 1.300949035127116
 |}
 ==See Also==

← Older revision		Revision as of 19:03, 11 May 2015
Line 83:		Line 83:

	==References==		==References==
		+	*[http://en.wikipedia.org/wiki/Student%27s_t-test Student's t-test]

@@ Line 35: / Line 35: @@
 |}
-#TTESTPAIRED(A1:F1,A2:F2,5,0.25)
+#=TTESTPAIRED(A1:F1,A2:F2,5,0.25)
+{| class="wikitable"
 ==See Also==