Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Compute multiple data analyses at once
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Compute multiple data analyses at once
Yes, see Help for the TTEST worksheet function.
Jerry "Elle" wrote: 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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Compute multiple data analyses at once
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 "Elle" wrote: 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formulas will not compute | Excel Worksheet Functions | |||
Formulas that don't compute | Excel Worksheet Functions | |||
Formula won't compute | Excel Discussion (Misc queries) | |||
compute? hmmm. | Excel Discussion (Misc queries) | |||
How do I compute ratios? | Excel Discussion (Misc queries) |