Difference between revisions of "Manuals/calci/TTESTTWOSAMPLESUNEQUALVARIANCES"

From ZCubes Wiki
Jump to navigation Jump to search
(Created page with "ttest")
 
 
(6 intermediate revisions by 2 users not shown)
Line 1: Line 1:
−
ttest
+
<div style="font-size:25px">'''TTESTTWOSAMPLESUNEQUALVARIANCES (Array1,Array2,HypothesizedMeanDifference,Alpha,NewTableFlag)'''</div><br/>
 +
*<math>Array1 </math> and <math> Array2 </math>  are set of values.
 +
*<math>HypothesizedMeanDifference </math> is the  Hypothesized Mean Difference.
 +
*<math> Alpha </math> is the significance level.
 +
*<math> NewTableFlag </math> is either 0 or 1.
 +
**TTESTTWOSAMPLESUNEQUALVARIANCES(), determines whether two sample means are distinct.
 +
 
 +
==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 (Array1,Array2,HypothesizedMeanDifference,Alpha,NewTableFlag)</math>, <math>Array1</math> and <math> Array2 </math> are two arrays of sample values.
 +
*<math> HypothesizedMeanDifference </math> is the Hypothesized Mean Difference. Suppose HypothesizedMeanDifference = 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> NewTableFlag </math> is either 0 or 1.
 +
*"1" is indicating the result will display in new worksheet.Suppose we are omitted the <math>NewTableFlag</math> value it will consider the value as "0".
 +
*The t-statistic of this function calculated by:
 +
<math> t=\frac{\bar{x_1}-\bar{x_2}}{s_{\bar{x_1}-\bar{x_2}}}</math>
 +
where <math>s_{\bar{x_1}-\bar{x_2}}= \sqrt{\frac{s_1^2}{n_1}+\frac{s_2^2}{n_2}} </math>
 +
*Here <math> s_1^2</math> and <math> s_2^2</math> are unbiased estimators of the variances of two samples. <math> n_1</math> and <math> n_2</math> are the number of data points in two arrays. <math>s_{\bar{x_1}-\bar{x_2}}</math> is not a pooled variance.
 +
*This function will give the result as error when
 +
      1. any one of the argument is non-numeric.
 +
      2.Alpha>1
 +
 
 +
==Examples==
 +
{| class="wikitable"
 +
|+Spreadsheet
 +
|-
 +
! !! A !! B !! C !! D!! E !! F !! G
 +
|-
 +
! 1
 +
| 12 || 21 || 9 || 18 || 27 || 37 ||41
 +
|-
 +
! 2
 +
| 19 || 8 || 45 || 29 || 14 || 10 || 11
 +
|}
 +
 
 +
 
 +
 
 +
#=TTESTTWOSAMPLESUNEQUALVARIANCES(A1:F1,A2:F2,3,0.5,0)
 +
{| class="wikitable"
 +
|+t-Test: Two-Sample Assuming Unequal Variances
 +
|-
 +
! !! Variable 1 !! Variable 2
 +
|-
 +
! Mean
 +
| 23.571428571428573 || 19.428571428571427
 +
|-
 +
! Variance
 +
| 146.61904761904762 || 177.6190476190476
 +
|-
 +
! Observations
 +
| 7|| 7
 +
|-
 +
! Hypothesized Mean Difference
 +
| 3
 +
|-
 +
! Degree Of Freedom
 +
| 12
 +
|-
 +
! T- Statistics
 +
|0.1679225216302784
 +
|-
 +
! P(T<=t) One-tail
 +
| 0.43472054489717515
 +
|-
 +
! T Critical One-Tail
 +
| 0 
 +
|-
 +
! P(T<=t) Two-tail
 +
| 0.8694410897943503
 +
|-
 +
! T Critical Two-Tail
 +
| 0.6954828655202375
 +
|}
 +
 
 +
==Related Videos==
 +
 
 +
{{#ev:youtube|v=L-jfenou5hI|280|center|TTESTTWOSAMPLESUNEQUALVARIANCES}}
 +
 
 +
==See Also==
 +
*[[Manuals/calci/TTEST  | TTEST ]]
 +
*[[Manuals/calci/TDIST  | TDIST ]]
 +
*[[Manuals/calci/TINV  | TINV ]]
 +
*[[Manuals/calci/TTESTTWOSAMPLESEQUALVARIANCES  | TTESTTWOSAMPLESEQUALVARIANCES ]]
 +
 
 +
==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 15:51, 6 December 2018

TTESTTWOSAMPLESUNEQUALVARIANCES (Array1,Array2,HypothesizedMeanDifference,Alpha,NewTableFlag)


  • and are set of values.
  • is the Hypothesized Mean Difference.
  • is the significance level.
  • is either 0 or 1.
    • TTESTTWOSAMPLESUNEQUALVARIANCES(), determines whether two sample means are distinct.

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 HypothesizedMeanDifference = 0 which indicates that sample means are hypothesized to be equal.
  • is the significance level which ranges from 0 to 1.
  • is either 0 or 1.
  • "1" is indicating the result will display in new worksheet.Suppose we are omitted the value it will consider the value as "0".
  • The t-statistic of this function calculated by:

where

  • Here and are unbiased estimators of the variances of two samples. and are the number of data points in two arrays. is not a pooled variance.
  • 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 G
1 12 21 9 18 27 37 41
2 19 8 45 29 14 10 11


  1. =TTESTTWOSAMPLESUNEQUALVARIANCES(A1:F1,A2:F2,3,0.5,0)
t-Test: Two-Sample Assuming Unequal Variances
Variable 1 Variable 2
Mean 23.571428571428573 19.428571428571427
Variance 146.61904761904762 177.6190476190476
Observations 7 7
Hypothesized Mean Difference 3
Degree Of Freedom 12
T- Statistics 0.1679225216302784
P(T<=t) One-tail 0.43472054489717515
T Critical One-Tail 0
P(T<=t) Two-tail 0.8694410897943503
T Critical Two-Tail 0.6954828655202375

Related Videos

TTESTTWOSAMPLESUNEQUALVARIANCES

See Also

References



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