Bioequivalence and Bioavailability Forum

Simulating studies in Excel not possible [Power / Sample Size]

posted by Helmut  – Vienna, Austria, 2020-10-16 13:11 (1560 d 23:15 ago) – Posting: # 22014
Views: 5,034

Hi dshah,

❝ I would like to know about any available excel tool for sample size calculation for NTI by FDA method.

❝ I am asking this as many times- tools like R, Gpower etc. requires installation of software which is not permissible by many firms/organization.

Sorry, you have to convince your paranoic IT department.
The package PowerTOST is used in many companies and by regulatory agencies as well. The FDA’s Donald Schuir­mann performed his simulations in S-Plus, (‼), and APL.*

Background: For all reference-scaled approaches (the EMA’s ABEL, the FDA’s RSABE and NTID) you have to simulate studies. To get a stable result 100,000 are required. Even if you manage it to simulate subjects in Excel (a nutjob’s work but in principle doable), you will hit even in the current version of Excel the maximum number of rows (2²⁰ = 1,048,576). In other words, you can’t simulate more than 10 subjects…

---

• Schuirmann DJ. Evaluation of Scaling Approaches to Demonstrate BE of NTI Drugs – OGD Simulation Efforts. Advisory Committee for Pharmaceutical Science and Clinical Pharmacology. 26 July, 2011.  Archive-It (p.57–100 of the PDF).

—
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:

• Sample size for NTI using FDA method by excel macro dshah 2020-10-16 06:20 [Power / Sample Size] 
  • Sample size for NTI using FDA method by excel macro d_labes 2020-10-16 11:09
    • Sample size for NTI using FDA method by excel macro dshah 2020-10-16 12:11
  • Simulating studies in Excel not possibleHelmut 2020-10-16 11:11
    • Simulating studies in Excel not possible dshah 2020-10-16 12:12
      • Simulating studies in Excel not possible martin 2020-10-16 12:52
        • Simulating studies in Excel not possible dshah 2020-10-20 06:59
    • may be possible -> Simulating studies in Excel not possible yjlee168 2020-10-17 08:09
      • Simulating studies in Excel possible but slow? Helmut 2020-10-17 11:30
        • Have you upgraded to R v4.0.3 yet? yjlee168 2020-10-19 02:16
          • Run on R v4.0.3 Helmut 2020-10-19 12:12