Bioequivalence and Bioavailability Forum

Spreadshit addiction [General Sta­tis­tics]

posted by Helmut  – Vienna, Austria, 2011-10-01 15:03 (5018 d 22:06 ago) – Posting: # 7403
Views: 16,130

Dear yicaoting!

❝ Since Delta is a optional var in Dr. Russel Lenth's NctInv(), in case of data without NC variable, you can recode

❝ NCtInv = Solve("tDummy", p, x, y)

❝ as

❝ 'NCtInv = Solve("tDummy", p, x, y)

❝ to omit the execution of this code, then NctInv() will work well in your spreadsheet.

Yes, right. I was wondering why the VBA compiler had problems, since the Else-part of the code should not be triggered (IsMissing(Delta) = TRUE).

❝ The difference between Dr. Russel Lenth's NctInv() in Excel and R may be caused by the different results of BetaInv() function generated with Excel and R.

Correct. As ElMaestro noted above one of the wonderful things in R is the documentation (including the algorithms used; see here).

❝ Since I didn't install R in my computer […]

Get it from one of the mirror sites close to you. Big fun.

• CTEX.ORG
  
• Computer Network Information Center, CAS, Beijing
  
• Beijing Jiaotong University, Beijing
  
• University of Science and Technology of China
  
• GeoExpat.Com (slow!)
  
• Xiamen University

❝ […] here I can only compare BetaInv() function in Excel with that in SAS.

❝ Excel 2003:

❝ =BETAINV(0.001,2,4)=0.010101318359375

❝ SAS 9.1:

❝ =BETAINV(0.001,2,4)=0.0101017879

❝ OO Calc 3.3

❝ =BETAINV(0.001,2,4)=0.0101017878837378

Results in Excel 2000 = Excel 2003. My numbercruncher’s (R 2.13.0, options(digits=22)) nitpicking results:
qbeta(0.001,2,4)
[1] 0.01010178788373775407572

❝ Nevertheless, Dr. Russel Lenth's NctInv() is a highly useful UDF for our calculation, […]

Sure. It helped me to come up with the 280 character monster formula which can be used in Excel/OO Calc without active scripting (which might be the only option in some companies).

❝ Based on the result of R, It seems that BETAINV() in OO Calc has higher precision than that in Excel.

❝ Dear HS, do you agree with me?

Absolutely.

Happy National Day!

—
Dif-tor heh smusma 🖖🏼 Довге життя Україна! 
Helmut Schütz


The quality of responses received is directly proportional to the quality of the question asked. 🚮
Science Quotes

Complete thread:

• Welch/Satterthwaite in practice ElMaestro 2011-09-21 17:04 [General Sta­tis­tics] 
  • 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
  • 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 addictionHelmut 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