may be possible -> Simulating studies in Excel not possible [Power / Sample Size]
❝ ...
❝ 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

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 https://www.pkpd168.com/bear
Download link (updated) -> here
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 possible Helmut 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
- Simulating studies in Excel not possible martin 2020-10-16 12:52
- may be possible -> Simulating studies in Excel not possibleyjlee168 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
- Have you upgraded to R v4.0.3 yet? yjlee168 2020-10-19 02:16
- Simulating studies in Excel possible but slow? Helmut 2020-10-17 11:30
- Simulating studies in Excel not possible dshah 2020-10-16 12:12
- Sample size for NTI using FDA method by excel macro d_labes 2020-10-16 11:09