View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jerry W. Lewis Jerry W. Lewis is offline
external usenet poster
 
Posts: 837
Default 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!