Difference between revisions of "Manuals/calci/TTESTUNEQUALVARIANCES"

From ZCubes Wiki
Jump to navigation Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''TTESTTWOSAMPLESUNEQUALVARIANCES('''Array1, Array2, HypothesizeDiff, Alpha, NewTableFlag) where, '''Array1 '...")
 
Line 1: Line 1:
−
<div id="6SpaceContent" class="zcontent" align="left">
+
<div style="font-size:30px">'''TTESTTWOSAMPLESUNEQUALVARIANCES(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.
  
−
'''TTESTTWOSAMPLESUNEQUALVARIANCES('''Array1, Array2, HypothesizeDiff, Alpha, NewTableFlag)
 
  
−
where,
+
==Description==
 +
*This function calculating the two Sample for unequal variances determines whether two sample means also distinct.
 +
*We can use this test when both:
 +
*1.the two sample sizes  are may are may not be equal;
 +
*2. The means and variances are distinct .
 +
*In <math>TTESTTWOSAMPLESUNEQUALVARIANCES(ar1,ar2,md,alpha,lv), ar1</math> and <math> ar2 </math> are two arrays of sample values.
 +
*<math> md </math> is the Hypothesized Mean Difference .Suppose md=0 which  indicates that sample means are hypothesized to be equal.
 +
*<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 lv value it will consider the value as FALSE.
 +
*The t statistic of this function calculated by:
 +
t=x1(bar)-x2(bar)/sx1(bar)-x2(bar) where sx1(bar)-x2(bar)= sqart[s1^2/n1+s2^2/n2]
 +
*Here s1^2 and s2^2 are unbiased estimators of the variances of two samples.n1 and n2 are the number of data points in two arrays . sx1(bar)-x2(bar) is not a pooled variance.
 +
*This function will give the result as error when
 +
      1. any one of th argument is nonnumeric.
 +
      2.alpha>1
  
−
'''Array1 '''- Input range should be one block.
 
  
−
'''Array2 '''- Input range should be one block.
 
  
−
'''HypothesizeDiff '''- represents the Hypothesized Mean Difference.A value 0 indicates that sample means are hypothesized to be equal.
+
==Examples==
−
 
+
{| class="wikitable"
−
'''Alpha '''- represents the significance level and value in range 0 to 1.
+
|+Spreadsheet
−
 
+
|-
−
''' ''''''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>
+
! !! A !! B !! C !! D!! E !! F !! G
−
----
+
|-
−
<div id="1SpaceContent" class="zcontent" align="left">T-Test: Two Sample for unequal variances determines whether two sample means are distinct.</div>
+
! 1
−
----
+
| 12 || 21 || 9 || 18 || 27 || 37 ||41
−
<div id="7SpaceContent" class="zcontent" align="left">
+
|-
−
 
+
! 2
−
Lets see an example in (Column3Row1)
+
| 19 || 8 || 45 || 29 || 14 || 10 || 11
 +
|}
  
−
<nowiki>=TTESTTWOSAMPLESUNEQUALVARIANCES (R1C1:R6C1, R1C2:R5C2, 0, 0.05, TRUE)</nowiki>
 
  
−
TTESTTWOSAMPLESUNEQUALVARIANCES returns the result in new sheet(9Space).
 
  
−
<nowiki>=TTESTTWOSAMPLESUNEQUALVARIANCES(R1C1:R4C1,R1C2:R6C2, 0,- 0.055, TRUE)</nowiki>
+
#=TTESTSAMPLESEQUALVARIANCES(A1:F1,A2:F2,0.5)
  
−
TTESTTWOSAMPLESUNEQUALVARIANCES returns the #ERROR(Alpha = -0.055).
 
  
−
</div>
 
−
----
 
−
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
 
  
−
T-TEST : TWO SAMPLE ASSUMING UNEQUAL VARIANCES
+
==See Also==
 +
*[[Manuals/calci/TTEST  | TTEST ]]
 +
*[[Manuals/calci/TDIST  | TDIST ]]
 +
*[[Manuals/calci/TINV  | TINV ]]
 +
*[[Manuals/calci/TTESTEQUALVARIANCES  | TTESTEQUALVARIANCES ]]
  
−
</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, TTESTTWOSAMPLESUNEQUALVARIANCES returns the #ERROR.
 
−
 
−
</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
 
−
| 10
 
−
| 3
 
−
| class="sshl_f" | 5Space
 
−
| class=" " |
 
−
|- class="even"
 
−
| class="  " | Row2
 
−
| 7
 
−
| 8
 
−
| class="      " |
 
−
| class=" " |
 
−
|- class="odd"
 
−
| Row3
 
−
| 12
 
−
| 8
 
−
| class=" " |
 
−
| class=" " |
 
−
|- class="even"
 
−
| Row4
 
−
| 17
 
−
| 18
 
−
| class="sshl_f" | #ERROR
 
−
| class=" " |
 
−
|- class="odd"
 
−
| class=" " | Row5
 
−
| class=" " | 46
 
−
| 34
 
−
| 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="even"
 
−
| Row6
 
−
| class=" " | 6
 
−
| 7
 
−
| class=" " |
 
−
| class=" " |
 
−
|}
 
−
 
−
<div align="left">[[Image:calci1.gif]]</div></div>
 
−
----
 
−
<div id="5SpaceContent" class="zcontent" align="left">
 
−
 
−
{| class="SpreadSheet blue"
 
−
|+ t-Test: Two-Sample Assuming Unequal Variances<br />
 
−
|- class="even"
 
−
!
 
−
! Variable1
 
−
! Variable2
 
−
|- class="odd"
 
−
| Mean
 
−
| 16.333333333333332
 
−
| 14.2
 
−
|- class="even"
 
−
| Variance
 
−
| 226.66666666666668
 
−
| 152.2
 
−
|- class="odd"
 
−
| Observations
 
−
| 6
 
−
| 5
 
−
|- class="even"
 
−
| Hypothesized Mean Difference
 
−
| 0
 
−
|- class="odd"
 
−
| Degree Of Freedom
 
−
| 9
 
−
|- class="even"
 
−
| T Statistics
 
−
| 0.2582913934642728
 
−
|- class="odd"
 
−
| P(T&lt;=t) One-tail
 
−
| 0.4009958484338277
 
−
|- class="even"
 
−
| T Critical One-tail
 
−
| 1.833112928058645
 
−
|- class="odd"
 
−
| P(T&lt;=t) Two-tail
 
−
| 0.8019916968676554
 
−
|- class="even"
 
−
| T Critical Two-tail
 
−
| 2.262157150957689
 
−
|}
 
  
−
</div>
+
==References==
−
----
 

Revision as of 03:37, 3 February 2014

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


  • and are set of values.
  • is the Hypothesized Mean Difference.
  • is the significance level.
  • is the logical value.


Description

  • This function calculating the two Sample for unequal variances determines whether two sample means also distinct.
  • We can use this test when both:
  • 1.the two sample sizes are may are may not be equal;
  • 2. The means and variances are distinct .
  • In and are two arrays of sample values.
  • is the Hypothesized Mean Difference .Suppose md=0 which indicates that sample means are hypothesized to be equal.
  • 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 lv value it will consider the value as FALSE.
  • The t statistic of this function calculated by:

t=x1(bar)-x2(bar)/sx1(bar)-x2(bar) where sx1(bar)-x2(bar)= sqart[s1^2/n1+s2^2/n2]

  • Here s1^2 and s2^2 are unbiased estimators of the variances of two samples.n1 and n2 are the number of data points in two arrays . sx1(bar)-x2(bar) is not a pooled variance.
  • This function will give the result as error when
     1. any one of th argument is nonnumeric.
     2.alpha>1


Examples

Spreadsheet
A B C D E F G
1 12 21 9 18 27 37 41
2 19 8 45 29 14 10 11


  1. =TTESTSAMPLESEQUALVARIANCES(A1:F1,A2:F2,0.5)


See Also


References

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