View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Alex
 
Posts: n/a
Default Need help simplifying t test information

'jnoding'

Maybe you could give more information as to what you need?

As a starting point a t-test can be done in Excel using =TTEST. The
arguments a

=TTEST(array1, array2, tails, type).

'Array1' and 'Array2' are the two sets of data that you want to 'compare.
'Tails' is for whether you want a one-tailed or two-tailed test.
'Type' is whether your sample is array1 and array2 are paired, have equal
varaince, or unequal variance.

Does this help any? I would also add that:

(1) Excel is not strong with statisitcal analysis but can handle most basic
stuff.
(2) If you actually want to learn more about the ttest as a statistical
procedure then I would 'google ttest. There is a welath of info out there.

Regards


Alex





"jnoding" wrote:

I am needing more simplified information on how to produce a t test in Excel.