Bioequivalence and Bioavailability Forum

Spreadshit addiction [General Sta­tis­tics]

posted by Helmut  – Vienna, Austria, 2011-10-03 17:59 (4962 d 16:18 ago) – Posting: # 7414
Views: 15,591

Dear yicaoting!

❝ Now, I am satisfied with MS's improvement on MS Excel 2010.

❝ What about you?

Sure. Took Micro$oft almost two decades (just checked Excel 5.0 [1993]: BETAINV(0.001,2,4)=0.010101318359375). Rome wasn’t built in a day.
Would be interesting whether v2010’s TINV() still rounds down dfs to the next integer. Would you be so kind and check?

❝ But I want to ask HS, before you used user-defined function NctInv() function, how could you do Welch's t-test for 2-group parallel BE analysis with unequal variances in your "Manual Excel 2000" which was frequently appeared in your PPTs?

It’s easy to code it the usual way. In Gnumeric’s output you even get the formulas in the result cells. In my slides I got the t-value from outside Excel, since the dfs are wrong (as we know). That’s why I stated in my slides »Maybe it’s time to leave M$-Excel.«

❝ I am highly interest in your Excel template for BE analysis, would you like to share it with me for personal in-house use?

Hhm. I wrote that just for fun in 1993 in order to check Chow’s/Liu’s examples. Have to dig it out from the grave…

—
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 addiction Helmut 2011-10-01 13:03
          • Spreadshit addiction yicaoting 2011-10-01 16:39
          • Spreadshit addiction yicaoting 2011-10-03 07:23
            • Spreadshit addictionHelmut 2011-10-03 15:59
              • Spreadshit addiction yicaoting 2011-10-03 17:35
                • Spreadshit addiction Helmut 2011-10-03 17:41