How to determine statistical significance using T-test in Excel?

Question

I have two groups of datasets, A and B. I would like to know that the average value of A is significantly different from the average value of B. How to do this in Excel 2007?

(I know there the TTEST formula in excel, I also know that I do not need to use the paired version, what other parameters do I need to set and how to interpret the result?)

Thank,

John

Answer 1

= TTEST (array1, array2, tails, type)

array1 is a dataset A

array2 is data set B

: 1 = , 2 = . , , A B, B. , , A B. (, 1 .)

type: , , 1. 2 - , 3 - . , , B , Type 3.