Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
I am needing more simplified information on how to produce a t test in Excel.
|
#2
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
'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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pull information from one worksheet to another | Excel Discussion (Misc queries) | |||
Moving a line of data when information is entered in a specific cell. | Excel Discussion (Misc queries) | |||
Vlookups or Match to find multiple information | Excel Worksheet Functions | |||
Update a spreadsheet with new information. | Excel Discussion (Misc queries) | |||
Clearing information in certain columns | Excel Discussion (Misc queries) |