writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − ttest+ + + + + + + + + + + + + + + + + + + + + + +
Manuals/calci/TTESTTWOSAMPLESUNEQUALVARIANCES (view source)
Revision as of 23:50, 20 December 2016
, 23:50, 20 December 2016no edit summary
<div style="font-size:30px">'''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.
==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