Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
jnoding
 
Posts: n/a
Default Need help simplifying t test information

I am needing more simplified information on how to produce a t test in Excel.
  #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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pull information from one worksheet to another Debbie Excel Discussion (Misc queries) 5 October 7th 05 02:16 PM
Moving a line of data when information is entered in a specific cell. opshmo Excel Discussion (Misc queries) 2 October 6th 05 06:08 PM
Vlookups or Match to find multiple information Nyanko Excel Worksheet Functions 0 July 27th 05 09:30 PM
Update a spreadsheet with new information. a6kim Excel Discussion (Misc queries) 1 May 2nd 05 11:56 AM
Clearing information in certain columns jolly_lolly Excel Discussion (Misc queries) 1 April 22nd 05 02:41 AM


All times are GMT +1. The time now is 02:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"