ZCubes Wiki

Difference between revisions of "Manuals/calci/TTESTPAIRED"
 
(10 intermediate revisions by 5 users not shown)
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.
 +
**TTESTPAIRED() determines whether a samples means are distinct.
  
 
==Description==
 
==Description==
−
*This function gives a paired t -test.  
+
*This function gives a value of paired t -test.  
 
*A paired t-test looks at the difference between paired values in two samples.
 
*A paired t-test looks at the difference between paired values in two samples.
 
*Paired samples also called matched samples or repeated measures.  
 
*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.
 
*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:  
 
*The t statistic of this function calculated by:  
 
<math> t = \frac{\bar{x}-\mu_ 0}{s.d/\sqrt{n}}</math>  
 
<math> t = \frac{\bar{x}-\mu_ 0}{s.d/\sqrt{n}}</math>  
−
where <math> \bar{x} is the average value, <math> sd </math> is the standard deviation and <math> \mu_0 </math> is the constant.
+
where <math> \bar{x}</math> is the average value, <math> s.d </math> is the standard deviation and <math> \mu_0 </math> is the constant.
 
*This function will give the result as error when  
 
*This function will give the result as error when  
 
       1. any one of the argument is non_numeric.
 
       1. any one of the argument is non_numeric.
−
       2. alpha>1.
+
       2. Alpha>1.
  
 
==Examples==
 
==Examples==
−
Array1={21,24,29,11,19,8}
 
−
Array2={17,10,32,7,15,22}
 
−
TTESTPAIRED(A1:F1,A2:F2,5,0.25)
 
  
 
{| class="wikitable"
 
{| class="wikitable"
Line 37: Line 35:
 
| 17 || 10 || 32 || 7 || 15 || 22  
 
| 17 || 10 || 32 || 7 || 15 || 22  
 
|}
 
|}
 +
 +
#=TTESTPAIRED(A1:F1,A2:F2,5,0.25)
 +
{| class="wikitable"
 +
|+Result
 +
|+t-TEST: PAIRED TWO SAMPLE FOR MEANS
 +
|-
 +
! !! VARIABLE1  !! VARIABLE2
 +
|-
 +
! MEAN
 +
| 18.666666666666668 || 17.166666666666668
 +
|-
 +
! VARIANCE
 +
| 62.66666666666667 || 80.56666666666666
 +
|-
 +
! OBSERVATIONS
 +
| 6 || 6
 +
|-
 +
! PEARSON CORRELATION
 +
| 0.39499794997886284
 +
|-
 +
! HYPOTHESIZED MEAN DIFFERENCE
 +
| 5
 +
|-
 +
! DEGREE OF FREEDOM
 +
| 5
 +
|-
 +
! T STATISTICS
 +
| -0.9186172406951716
 +
|-
 +
! P(T<=t) ONE-TAIL
 +
|0.20022020093421516
 +
|-
 +
! T CRITICAL ONE-TAIL
 +
| 0.7266868353364707
 +
|-
 +
! P(T<=t) TWO-TAIL
 +
| 0.40044040186843033
 +
|-
 +
! T CRITICAL TWO-TAIL
 +
| 1.300949035127116
 +
|}
 +
 +
==Related Videos==
 +
 +
{{#ev:youtube|RHBIQ2reACM|280|center|TTESTPAIRED}}
  
 
==See Also==
 
==See Also==
Line 46: Line 89:
  
 
==References==
 
==References==
 +
*[http://en.wikipedia.org/wiki/Student%27s_t-test Student's t-test]
 +
 +
 +
 +
 +
*[[Z_API_Functions | List of Main Z Functions]]
 +
 +
*[[ Z3 |  Z3 home ]]

Latest revision as of 14:55, 18 June 2018

TTESTPAIRED(Array1,Array2,HypothesizedMeanDifference,Alpha,NewTableFlag)


  • and are set of values.
  • is the Hypothesized Mean Difference.
  • is the significance level.
  • is the logical value.
    • TTESTPAIRED() determines whether a samples means are distinct.

Description

  • This function gives a value of paired t -test.
  • A paired t-test looks at the difference between paired values in two samples.
  • 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  ,   and   are two arrays of sample values.
  •   is the value of the Hypothesized Mean Difference .In this function HypothesizedMeanDifference=0.
  •   is the significance level which ranges from 0 to 1.
  •   is the logical value like TRUE or FALSE.TRUE is indicating the result will display in new worksheet.Suppose we are omitted the   value it will consider the value as FALSE.
  • The t statistic of this function calculated by:

  where   is the average value,   is the standard deviation and   is the constant.

  • This function will give the result as error when
      1. any one of the argument is non_numeric.
      2. Alpha>1.

Examples

Spreadsheet
A B C D E F
1 21 24 29 11 19 8
2 17 10 32 7 15 22
  1. =TTESTPAIRED(A1:F1,A2:F2,5,0.25)
Result t-TEST: PAIRED TWO SAMPLE FOR MEANS
VARIABLE1 VARIABLE2
MEAN 18.666666666666668 17.166666666666668
VARIANCE 62.66666666666667 80.56666666666666
OBSERVATIONS 6 6
PEARSON CORRELATION 0.39499794997886284
HYPOTHESIZED MEAN DIFFERENCE 5
DEGREE OF FREEDOM 5
T STATISTICS -0.9186172406951716
P(T<=t) ONE-TAIL 0.20022020093421516
T CRITICAL ONE-TAIL 0.7266868353364707
P(T<=t) TWO-TAIL 0.40044040186843033
T CRITICAL TWO-TAIL 1.300949035127116

Related Videos

TTESTPAIRED

See Also

References



Retrieved from "http://wiki.zcubes.com/index.php?title=Manuals/calci/TTESTPAIRED&oldid=210364"