Log in
RegisterWelch/Satterthwaite in practice [General Statistics]
Dear ElMaestro,
I think the key point of your task is the calculation of TINV(p, df) where df is not an integer in Excel.
Generally, it is impossible to do it.
But fortunately, you can use the FUNCTION NcTinv() which is nearly identical to Tinv() in SAS.
FUNCTION NcTinv() was developed by Dr. Russel Lenth, and could be accessed via FARTSSIE17, it is a user-defined function for Excel.
Usage of FUNCTION NcTinv() in Excel need some basic understanding of VBA for MS Excel.
Wish it help you.
BTW: I have tried it, the result was satisfactory.
My English is not very smooth, hope you can understand my posting.
I think the key point of your task is the calculation of TINV(p, df) where df is not an integer in Excel.
Generally, it is impossible to do it.
But fortunately, you can use the FUNCTION NcTinv() which is nearly identical to Tinv() in SAS.
FUNCTION NcTinv() was developed by Dr. Russel Lenth, and could be accessed via FARTSSIE17, it is a user-defined function for Excel.
Usage of FUNCTION NcTinv() in Excel need some basic understanding of VBA for MS Excel.
Wish it help you.
BTW: I have tried it, the result was satisfactory.
My English is not very smooth, hope you can understand my posting.
Complete thread:
- Welch/Satterthwaite in practice ElMaestro 2011-09-21 17:04 [General Statistics]
![[Mix]](https://static.bebac.at/img/mix.png "open in Mix view")
- Not to round is the question d_labes 2011-09-22 09:11
- my problem ElMaestro 2011-09-22 12:34
- Ways out d_labes 2011-09-27 11:54
- my problem ElMaestro 2011-09-22 12:34
- Welch/Satterthwaite in practiceyicaoting 2011-09-29 16:29
- Welch/Satterthwaite in practice ElMaestro 2011-09-29 17:39
- Spreadshit addiction Helmut 2011-09-30 16:52
- what a divine post! ElMaestro 2011-09-30 18:54
- what a divine post! Helmut 2011-09-30 19:41
- what a divine post! ElMaestro 2011-10-01 13:03
- what a divine post! Helmut 2011-10-01 13:20
- what a divine post! ElMaestro 2011-10-01 13:03
- what a divine post! Helmut 2011-09-30 19:41
- Spreadshit addiction yicaoting 2011-10-01 05:36
- Spreadshit addiction ElMaestro 2011-10-01 11:13
- GNU addiction Helmut 2011-10-02 03:20
- Spreadshit addiction Helmut 2011-10-01 13:03
- Spreadshit addiction yicaoting 2011-10-01 16:39
- Spreadshit addiction yicaoting 2011-10-03 07:23
- Spreadshit addiction Helmut 2011-10-03 15:59
- Spreadshit addiction yicaoting 2011-10-03 17:35
- Spreadshit addiction Helmut 2011-10-03 17:41
- Spreadshit addiction yicaoting 2011-10-03 17:35
- Spreadshit addiction Helmut 2011-10-03 15:59
- Spreadshit addiction ElMaestro 2011-10-01 11:13
- what a divine post! ElMaestro 2011-09-30 18:54
- Not to round is the question d_labes 2011-09-22 09:11
Ing. Helmut Schütz