ZCubes Wiki

Difference between revisions of "Manuals/calci/TTESTPAIRED"
 
(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)


  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Array1 } and Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Array2 } are set of values.
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle HypothesizedMeanDifference } is the Hypothesized Mean Difference.
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Alpha } is the significance level.
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle NewTableFlag } 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 Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle TTESTPAIRED(Array1,Array2,HypothesizedMeanDifference,Alpha,NewTableFlag)} , Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Array1 } and Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Array2 } are two arrays of sample values.
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle HypothesizedMeanDifference } is the value of the Hypothesized Mean Difference .In this function HypothesizedMeanDifference=0.
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Alpha } is the significance level which ranges from 0 to 1.
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle NewTableFlag } is the logical value like TRUE or FALSE.TRUE is indicating the result will display in new worksheet.Suppose we are omitted the Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle NewTableFlag } value it will consider the value as FALSE.
  • The t statistic of this function calculated by:

Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle t = \frac{\bar{x}-\mu_ 0}{s.d/\sqrt{n}}} where Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle \bar{x}} is the average value, Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle s.d } is the standard deviation and Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle \mu_0 } 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"