Bioequivalence and Bioavailability Forum

Ways out [General Statistics]

posted by d_labes – Berlin, Germany, 2011-09-27 13:54 (5022 d 23:07 ago) – Posting: # 7391
Views: 16,248

Dear EM,

❝ Simple: Spreadsheet is the option and that's not my decision.

Some ways to overcome the limitations of the spreadsheet implementations of the t-distribution:

Use Excel and the VB code for the non-central t-distribution contained in Dave Dubbins Fartssie.xls. According to the comments within it, it should be able to handle fractional df's.
Use RExcel, an add-in for Excel on MS Windows, that allows to transfer data between R and Excel, writing VBA macros using R as a library for Excel, and calling R functions.
If MS Excel is not an option but OO Calc use "R and Calc", an OpenOffice.org (OO.o) Calc add-on that allows you to use R methods and functions.

To be honest, I have no experience with any of these suggestions.

BTW: The EXCEL built in function tinv also truncates fractional degrees of freedom.

—
Regards,

Detlew

Complete thread:

Welch/Satterthwaite in practice ElMaestro 2011-09-21 17:04 [General Statistics]
- Not to round is the question d_labes 2011-09-22 09:11
  - my problem ElMaestro 2011-09-22 12:34
    - Ways outd_labes 2011-09-27 11:54
- Welch/Satterthwaite in practice yicaoting 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
    - 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

Ways out [General Sta­tis­tics]

Complete thread:

Ways out [General Statistics]