Compute multiple data analyses at once

[Guest]

Hello,

Is there a way I can perform a statistical analysis (i.e. two-sample equal
variance t-test) on one set of data and then have it automatically do the
same for all the other sets of data without having to reselect the test,
highlight the data, and tell excel which cells you want the analyses to go?
(kind of like how you can type in =sum( ) and then cut and paste across all
your data...(

THanks!

 

[Guest]

Yes, see Help for the TTEST worksheet function.

Jerry

 

[Guest]

Hi,

TTEST


Returns the probability associated with a Student's t-Test. Use TTEST to
determine whether two samples are likely to have come from the same two
underlying populations that have the same mean.

Syntax

TTEST(array1,array2,tails,type)

Array1 is the first data set.

Array2 is the second data set.

Tails specifies the number of distribution tails. If tails = 1, TTEST uses
the one-tailed distribution. If tails = 2, TTEST uses the two-tailed
distribution.

Type is the kind of t-Test to perform.

If type equals This test is performed
1 Paired
2 Two-sample equal variance (homoscedastic)
3 Two-sample unequal variance (heteroscedastic)

Remarks

If array1 and array2 have a different number of data points, and type = 1
(paired), TTEST returns the #N/A error value.
The tails and type arguments are truncated to integers.
If tails or type is nonnumeric, TTEST returns the #VALUE! error value.
If tails is any value other than 1 or 2, TTEST returns the #NUM! error value.
TTEST uses the data in array1 and array2 to compute a non-negative
t-statistic. If tails=1, TTEST returns the probability of a higher value of
the t-statistic under the assumption that array1 and array2 are samples from
populations with the same mean. The value returned by TTEST when tails=2 is
double that returned when tails=1 and corresponds to the probability of a
higher absolute value of the t-statistic under the “same population meansâ€
assumption.

Challa Prabhu