Difference between revisions of "Manuals/calci/TTESTPAIRED"

From ZCubes Wiki
Jump to navigation Jump to search
 
(8 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==
Line 10: Line 11:
 
*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>  
Line 19: Line 20:
 
*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==
Line 35: Line 36:
 
|}
 
|}
  
−
#TTESTPAIRED(A1:F1,A2:F2,5,0.25)
+
#=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"