may be possible -> Simulating studies in Excel not possible [Power / Sample Size]

posted by yjlee168 Homepage – Kaohsiung, Taiwan, 2020-10-17 10:09 (1138 d 11:30 ago) – Posting: # 22019
Views: 3,052

(edited by yjlee168 on 2020-10-17 14:12)

Hi Helmut,

❝ ...

❝ Sorry, you have to convince your paranoic IT department.

Agree definitely.

❝ ...

❝ 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…

Not quite (my turn :-D). IMHO, simulation with MS-Excel does not require so many cells or number of rows. In MS-Excel or MS-Word, there is a macro language called VBA (Visual BASIC for Application) that is similar to any programming language. So you just save the final results when doing simulations. Therefore, I don't think you need so many cells to save each simulation, if I understand what you said correctly.

Ps. Here is a very nice slide file about MS-Excel simulations.

All the best,
-- Yung-jin Lee
bear v2.9.1:- created by Hsin-ya Lee & Yung-jin Lee
Kaohsiung, Taiwan
Download link (updated) -> here

Complete thread:

UA Flag
 Admin contact
22,811 posts in 4,783 threads, 1,640 registered users;
28 visitors (0 registered, 28 guests [including 16 identified bots]).
Forum time: 20:40 CET (Europe/Vienna)

Every man gets a narrower and narrower field of knowledge
in which he must be an expert in order to compete with other people.
The specialist knows more and more about less and less
and finally knows everything about nothing.    Konrad Lorenz

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