LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default How to do TI83 2-SampTTest (hypothesis testing)?

What Excel function or expression gives the same results
as the TI83 2-SampTTest function -- at least the p-value?

Ostensibly, TTEST() seems to be the right thing. But it
seems to want to work with the original data.

I want to enter just the means and std devs of the two
samples and compute the p-value.

With a lot of effort, I suppose I could create two normal
distributions that have the same mean and std devs. But
that is "killing an ant with a sledgehammer".

If I had the math formulas for computing the p-value, I
suppose I could create a macro. But sigh, my stat text
is unclear to me now, some time later -- like what should
delta be in the Excel help sheet for "About statistical
analysis tools t-test". Besides, even that is more work
than I think should be necessary.
 
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
testing possible web interface glitch -- do not respond Dirk Goldgar Setting up and Configuration of Excel 3 January 27th 06 08:43 PM


All times are GMT +1. The time now is 07:37 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"