Changes

Jump to navigation Jump to search

Manuals/calci/TTEST (view source)

Revision as of 08:51, 3 February 2014

2,893 bytes removed ,  08:51, 3 February 2014
no edit summary
Line 1: Line 1: −
<div id="6SpaceContent" class="zcontent" align="left"><font color="#484848"><font face="Arial, sans-serif"><font size="2">'''TTEST'''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">(</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">'''ar1'''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">,</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">'''ar2'''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">,</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">'''t'''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">,</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">'''type'''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">)</font></font></font>
+
<div style="font-size:30px">'''TTEST(ar1,ar2,ta,ty)'''</div><br/>
 +
*<math>ar1 </math> and <math> ar2 </math> are the array of values.
 +
*<math> ta </math> is the number of distribution tails.
 +
*<math> ty </math> is the type of t-test.
   −
<font color="#484848"><font face="Arial, sans-serif"><font size="2">'''Where ar1, ar2 '''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">are t</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">he first and second data sets,'t' the number of distribution tails,and 'type' is the kind of t-Test to perform.</font></font></font>
     −
</div>
+
==Descrition==
−
----
+
*This function gives the probability of the t-test.
−
<div id="1SpaceContent" class="zcontent" align="left"> <font color="#484848"><font face="Arial, sans-serif"><font size="2">This function returns the probability associated with a Student's t-Test. </font></font></font></div>
+
*It is also called student's t-test.
−
----
+
*This function is used to find the probability of two samples having the same mean but equal or unequal variances.
−
<div id="7SpaceContent" class="zcontent" align="left">
+
*In TTEST(ar1,ar2,ta,ty), ar1 and ar2 are two set of array values.
 +
*ta is indicating the number of distribution tails. ta value is either 1 or 2.
 +
*If ta=1,then TTEST uses the one-tailed distrbution.If ta=2, then TTEST uses the two-tailed distrbution.ty is the type of t-Test. ty value is 1 or 2 or 3.
 +
ty value              t-Test is performed
 +
1      -                  Paired
 +
2      -                 Two-sample equal variance
 +
3      -                 Two-sample unequal variance
 +
*Suppose we are giving ta and ty in decimals , then it will converted in to integers.
 +
*TTEST uses the value of ar1 and ar2 to find non-negative t-statistic.
 +
*If ta=1, then it gives the probability of a higher value of the t-statistic with consideration of two arrays of samples with the same mean.
 +
*If ta=2, then TTEST is gives double that when ta=1 and corresponds to the probability of a higher absolute value of the t-statistic with the consideration of same mean.
 +
This function will give the result as error when
 +
      1. ar1 and ar2 have a different number of data points and ty=1.
 +
      2. Any one of the argument is nonnumeric.
 +
      3. ta>2 and ty>3.
   −
* <font color="#484848"><font face="Arial, sans-serif"><font size="2">TTEST returns the error value when array1 and array2 have a different number of data points or 't' or type is nonnumeric.</font></font></font>
  −
* <font color="#484848"><font face="Arial, sans-serif"><font size="2">In this test 't' value must be 1 or 2.</font></font></font>
     −
</div>
  −
----
  −
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
     −
TTEST
+
==Examples==
−
 
+
{| class="wikitable"
−
</div></div>
+
|+Spreadsheet
−
----
+
|-
−
<div id="8SpaceContent" class="zcontent" align="left"> 
+
! !! A !! B !! C !! D!! E!! F !! G
−
 
+
|-
−
<font color="#484848"><font face="Arial, sans-serif"><font size="2">Lets see an example,</font></font></font>
+
! 1
−
 
+
| 3 || 5 || 14 || 10 || 8 || 2 || 15
−
<font color="#484848"><font face="Arial, sans-serif"><font size="2">B C</font></font></font>
+
|-
 +
! 2
 +
| 11 || 19 || 5 || 4 || 15 || 7 || 3
 +
|}
   −
<font color="#484848"><font face="Arial, sans-serif"><font size="2">4 5</font></font></font>
+
#=TTEST(A1:G1,A2:G2,1,1)=0.399108571503
 +
#=TTEST(A1:G1,A2:G2,2,1)=0.7982171430076
 +
#=TTEST(A1:G1,A2:G2,1,2)=0.3725946027453
 +
#=TTEST(A1:G1,A2:G2,2,2)=0.7451892054907
 +
#=TTEST(A1:G1,A2:G2,1,3) = 0.382340251837
 +
#=TTEST(A1:G1,A2:G2,2,3) = 0.76468050367
 +
#=TTEST(A1:G1,A2:G2,2.2,1.3) = NAN
   −
<font color="#484848"><font face="Arial, sans-serif"><font size="2">5 15</font></font></font>
     −
<font color="#484848"><font face="Arial, sans-serif"><font size="2">6 6</font></font></font>
+
==See Also==
 +
*[[Manuals/calci/TDIST  | TDIST ]]
 +
*[[Manuals/calci/TINV  | TINV ]]
   −
<font color="#484848"><font face="Arial, sans-serif"><font size="2">7 4</font></font></font>
     −
<font color="#484848"><font face="Arial, sans-serif"><font size="2">1 5</font></font></font>
  −
  −
<font color="#484848"><font face="Arial, sans-serif"><font size="2">2 5</font></font></font>
  −
  −
<font color="#484848"><font face="Arial, sans-serif"><font size="2">5 19</font></font></font>
  −
  −
<font color="#484848"><font face="Arial, sans-serif"><font size="2">4 2</font></font></font>
  −
  −
<font color="#484848"><font face="Arial, sans-serif"><font size="2"><nowiki>=TTEST(B2:B9,C2:C9,2,1) is 0.1499</nowiki></font></font></font>
  −
  −
</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="2SpaceContent" class="zcontent" align="left">
  −
  −
{| id="TABLE3" class="SpreadSheet blue"
  −
|- class="even"
  −
| class=" " |
  −
| class="      " | Column1
  −
| class="      " | Column2
  −
| class="  " | Column3
  −
| class="  " | Column4
  −
|- class="odd"
  −
| class=" " | Row1
  −
| class="sshl_f " | 4
  −
| class="sshl_f " | 5
  −
| class="sshl_f" | 0.149852
  −
| class="sshl_f" |
  −
|- class="even"
  −
| class="  " | Row2
  −
| class="sshl_f" | 5
  −
| class="sshl_f" | 15
  −
| class="sshl_f" |
  −
| class="sshl_f  " |
  −
|- class="odd"
  −
| Row3
  −
| class="sshl_f" | 6
  −
| class="sshl_f" | 6
  −
| class="sshl_f" |
  −
| class="sshl_f" |
  −
|- class="even"
  −
| Row4
  −
| class="sshl_f" | 7
  −
| class="sshl_f" | 4
  −
| class="sshl_f  " |
  −
| class="sshl_f" |
  −
|- class="odd"
  −
| class="sshl_f" | Row5
  −
| class="sshl_f" | 1
  −
| class="sshl_f" | 5
  −
| class="sshl_f  " |
  −
| class="sshl_f  " |
  −
|- class="even"
  −
| class="sshl_f" | Row6
  −
| class="sshl_f" | 2
  −
| class="sshl_f" | 5
  −
| class="sshl_f" |
  −
| class="sshl_f" |
  −
|- class="odd"
  −
| class="sshl_f" | Row7
  −
| class=" " | 5
  −
| class="sshl_f" | 19
  −
| class="sshl_f  " |
  −
| class="SelectTD" |
  −
|- class="even"
  −
| class="sshl_f" | Row8
  −
| class=" " | 4
  −
| class=" " | 2
  −
| class="  " |
  −
|
  −
|}
     −
<div align="left">[[Image:calci1.gif]]</div></div>
+
==References==
−
----
 
Devika
writer
6,694

edits

Retrieved from "http://wiki.zcubes.com/Special:MobileDiff/197574"

Navigation menu