Difference between revisions of "Manuals/calci/TTESTPAIRED"

From ZCubes Wiki
Jump to navigation Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''TTESTPAIRED'''(Array1, Array2, HypothesizeDiff, Alpha, NewTableFlag) where, '''Array1 '''- Input range sho...")
 
Line 1: Line 1:
−
<div id="6SpaceContent" class="zcontent" align="left">
+
<div style="font-size:30px">'''TTESTPAIRED(ar1,ar2,md,alpha,lv)'''</div><br/>
 +
*<math>ar1 </math> and <math> ar2 </math>  are set of values.
 +
*<math>md </math> is the  Hypothesized Mean Difference.
 +
*<math> alpha </math> is the significance level.
 +
*<math> lv </math> is the logical value.
  
−
'''TTESTPAIRED'''(Array1, Array2, HypothesizeDiff, Alpha, NewTableFlag)
+
==Description==
 +
*This function gives a 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 <math>TTESTPAIRED(ar1,ar2,md,alpha,lv)</math>, <math> ar1 </math> and <math> ar2 </math> are two arrays of sample values.
 +
*<math> md </math> is the Hypothesized Mean Difference .In this function md=0.
 +
*<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.
 +
*The t statistic of this function calculated by:
 +
<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.
 +
*This function will give the result as error when
 +
      1. any one of the argument is non_numeric.
 +
      2. alpha>1.
  
−
where,
+
==Examples==
 +
Array1={21,24,29,11,19,8}
 +
Array2={17,10,32,7,15,22}
 +
TTESTPAIRED(A1:F1,A2:F2,5,0.25)
  
−
'''Array1 '''- Input range should be one block.
+
{| class="wikitable"
−
 
+
|+Spreadsheet
−
'''Array2 '''- Input range should be one block.
+
|-
−
 
+
! !! A !! B !! C !! D!! E !! F
−
'''HypothesizeDiff '''- represents the Hypothesized Mean Difference.A value 0 indicates that sample means are hypothesized to be equal.
+
|-
−
 
+
! 1
−
'''Alpha '''- represents the significance level and value in range 0 to 1.
+
| 21 || 24 || 29 || 11 || 19|| 8  
−
 
+
|-
−
''' ''''''NewTableFlag''' - is the TRUE or FALSE.If set as TRUE,the result in new sheet. If NewTableFlag is omitted, it assumed to be FALSE.</div>
+
! 2
−
----
+
| 17 || 10 || 32 || 7 || 15 || 22
−
<div id="1SpaceContent" class="zcontent" align="left">T-Test: Paired two-sample for mean determines whether a sample's means are distinct.</div>
 
−
----
 
−
<div id="7SpaceContent" class="zcontent" align="left">
 
−
 
 
−
Lets see an example in (Column3Row1)
 
−
 
 
−
<nowiki>=TTESTPAIRED (R1C1:R6C1, R1C2:R6C2, 0, 0.05, TRUE)</nowiki>
 
−
 
 
−
TTESTPAIRED returns the result in new sheet(5Space).
 
−
 
 
−
<nowiki>=TTESTPAIRED(R1C1:R4C1,R1C2:R6C2, 0, 0.055, TRUE)</nowiki>
 
−
 
 
−
TTESTPAIRED returns the #ERROR(LengthofArray1 != LengthofArray2).
 
−
 
 
−
</div>
 
−
----
 
−
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
 
−
 
 
−
T-TEST : PAIRED TWO SAMPLE FOR MEANS
 
−
 
 
−
</div></div>
 
−
----
 
−
<div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div>
 
−
----
 
−
<div id="4SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Remarks </div></div>
 
−
----
 
−
<div id="3SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Examples </div></div>
 
−
----
 
−
<div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div>
 
−
----
 
−
<div id="8SpaceContent" class="zcontent" align="left">
 
−
 
 
−
If the Alpha &lt; 0 or Alpha &gt;1, TTESTPAIRED returns the #ERROR.
 
−
 
 
−
TTESTPAIRED returns the #ERROR, if Length of Array1 != Length of Array2.
 
−
 
 
−
</div>
 
−
----
 
−
<div id="2SpaceContent" class="zcontent" align="left">
 
−
 
 
−
{| id="TABLE3" class="SpreadSheet blue"
 
−
|- class="even"
 
−
| class=" " |
 
−
| Column1
 
−
| Column2
 
−
| class="  " | Column3
 
−
| Column4
 
−
|- class="odd"
 
−
| class=" " | Row1
 
−
| 1
 
−
| 3
 
−
| class="sshl_f" | 5Space
 
−
| class=" " |
 
−
|- class="even"
 
−
| class="  " | Row2
 
−
| 7
 
−
| 8
 
−
| class="    " |
 
−
| class=" " |
 
−
|- class="odd"
 
−
| Row3
 
−
| 12
 
−
| 5
 
−
| class="sshl_f" | #ERROR
 
−
| class=" " |
 
−
|- class="even"
 
−
| Row4
 
−
| 17
 
−
| 18
 
−
| class="    SelectTD1 ChangeBGColor SelectTD1" |
 
−
<div id="2Space_Handle" class="zhandles" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="2Space_Copy" class="zhandles" title="Click and Drag over to AutoFill other cells."></div><div id="2Space_Drag" class="zhandles" title="Click and Drag to Move/Copy Area.">[[Image:copy-cube.gif]]  </div>
 
−
| class=" " |
 
−
|- class="odd"
 
−
| class=" " | Row5
 
−
| 37
 
−
| class=" " | 31
 
−
| class=" " |
 
−
| class=" " |
 
−
|- class="even"
 
−
| Row6
 
−
| 6
 
−
| class=" " | 9
 
−
| class=" " |
 
−
| class=" " |
 
 
|}
 
|}
  
−
<div align="left">[[Image:calci1.gif]]</div></div>
+
==See Also==
−
----
+
*[[Manuals/calci/TTEST  | TTEST ]]
−
<div id="5SpaceContent" class="zcontent" align="left">
+
*[[Manuals/calci/TDIST  | TDIST ]]
−
 
+
*[[Manuals/calci/TINV  | TINV ]]
−
{| class="SpreadSheet blue"
+
*[[Manuals/calci/TTESTEQUALVARIANCES  | TTESTEQUALVARIANCES ]]
−
|+ t-Test: Paired Two Sample for Means<br />
+
*[[Manuals/calci/TTESTUNEQUALVARIANCES  | TTESTUNEQUALVARIANCES ]]
−
|- class="even"
 
−
!
 
−
! Variable1
 
−
! Varianble2
 
−
|- class="odd"
 
−
| Mean
 
−
| 13.333333333333334
 
−
| 12.333333333333334
 
−
|- class="even"
 
−
| Variance
 
−
| 164.26666666666665
 
−
| 110.26666666666665
 
−
|- class="odd"
 
−
| Observations
 
−
| 6
 
−
| 6
 
−
|- class="even"
 
−
| Pearson Correlation
 
−
| 0.9500807056547026
 
−
|- class="odd"
 
−
| Hypothesized Mean Difference
 
−
| 0
 
−
|- class="even"
 
−
| Degree Of Freedom
 
−
| 5
 
−
|- class="odd"
 
−
| T Statistics
 
−
| 0.5649326828660319
 
−
|- class="even"
 
−
| P(T&lt;=t) One-tail
 
−
| 0.29826188106281603
 
−
|- class="odd"
 
−
| T Critical One-tail
 
−
| 2.015048294624481
 
−
|- class="even"
 
−
| P(T&lt;=t) Two-tail
 
−
| 0.5965237621256321
 
−
|- class="odd"
 
−
| T Critical Two-tail
 
−
| 2.5705816859349686
 
−
|}
 
  
−
</div>
+
==References==
−
----
 

Revision as of 22:51, 6 February 2014

TTESTPAIRED(ar1,ar2,md,alpha,lv)


  • 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 ar1 } 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 ar2 } 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 md } 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 lv } is the logical value.

Description

  • This function gives a 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(ar1,ar2,md,alpha,lv)} , 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 ar1 } 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 ar2 } 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 md } is the Hypothesized Mean Difference .In this function md=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 lv } 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 lv } 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 (Conversion error. Server ("https://wikimedia.org/api/rest_") reported: "Cannot get mml. Server problem."): {\displaystyle {\bar {x}}istheaveragevalue,<math>sd} 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

Array1={21,24,29,11,19,8} Array2={17,10,32,7,15,22} TTESTPAIRED(A1:F1,A2:F2,5,0.25)

Spreadsheet
A B C D E F
1 21 24 29 11 19 8
2 17 10 32 7 15 22

See Also

References

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