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

posted by Helmut Homepage – Vienna, Austria, 2020-10-16 13:11 (777 d 12:26 ago) – Posting: # 22014
Views: 2,712

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 [image] 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, [image] (‼), 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 (220 = 1,048,576). In other words, you can’t simulate more than 10 subjects…

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

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

Complete thread:

UA Flag
 Admin contact
22,426 posts in 4,694 threads, 1,600 registered users;
11 visitors (0 registered, 11 guests [including 7 identified bots]).
Forum time: 00:37 CET (Europe/Vienna)

The rise of biometry in this 20th century,
like that of geometry in the 3rd century before Christ,
seems to mark out one of the great ages or critical periods
in the advance of the human understanding.    R.A. Fisher

The Bioequivalence and Bioavailability Forum is hosted by
BEBAC Ing. Helmut Schütz