Difference between revisions of "Manuals/calci/TTESTPAIRED"

From ZCubes Wiki
Jump to navigation Jump to search
 
(5 intermediate revisions by 3 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 38: Line 39:
 
{| class="wikitable"
 
{| class="wikitable"
 
|+Result
 
|+Result
 +
|+t-TEST: PAIRED TWO SAMPLE FOR MEANS
 
|-
 
|-
−
! !! Variable 1 !! Variable 2
+
! !! VARIABLE1  !! VARIABLE2
 
|-
 
|-
−
! Mean
+
! MEAN
−
| 18.666666666666668 || 17.166666666666668  
+
| 18.666666666666668 || 17.166666666666668
 
|-
 
|-
−
! Variance
+
! VARIANCE
 
| 62.66666666666667 || 80.56666666666666  
 
| 62.66666666666667 || 80.56666666666666  
 
|-
 
|-
−
! Observations
+
! OBSERVATIONS
 
| 6 || 6
 
| 6 || 6
 
|-
 
|-
−
! Pearson Correlation
+
! PEARSON CORRELATION
 
| 0.39499794997886284
 
| 0.39499794997886284
 
|-
 
|-
−
! Hypothesized Mean Difference
+
! HYPOTHESIZED MEAN DIFFERENCE
−
| 5  
+
| 5
 
|-
 
|-
−
! Degree Of Freedom
+
! DEGREE OF FREEDOM
 
| 5
 
| 5
 
|-
 
|-
−
! T-Statistics
+
! T STATISTICS
 
| -0.9186172406951716
 
| -0.9186172406951716
 
|-
 
|-
−
! P(T<=t) One-tail
+
! P(T<=t) ONE-TAIL
−
| 0.20022020093421516
+
|0.20022020093421516
 
|-
 
|-
−
! T Critical One-Tail
+
! T CRITICAL ONE-TAIL
−
| 0.7266868353364707
+
| 0.7266868353364707  
 
|-
 
|-
−
! P(T<=t) Two-tail
+
! P(T<=t) TWO-TAIL
−
| 0.40044040186843033  
+
| 0.40044040186843033
 
|-
 
|-
−
! T Critical Two-Tail
+
! T CRITICAL TWO-TAIL
 
| 1.300949035127116  
 
| 1.300949035127116  
 
|}
 
|}
Line 88: Line 90:
 
==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 ]]

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"