Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
testing possible web interface glitch -- do not respond | Setting up and Configuration of Excel |