Have you upgraded to R v4.0.3 yet? [Power / Sample Size]
Dear Helmut,
» However, I guess that simulations in VBA will be extremely slooow.
Perhaps. Maybe Dave can tell us more later. Well, it can be slow, but should not be that slooow.
» ...
» Sample size: 18
» Runtime (seconds):
» user system elapsed
» 0.14 0.01 0.15
I run the codes three times under R v4.0.3 and got:
a little bit faster.
I guess that you have not upgraded to R 4.0.3 yet. R v4.0.3 is simply faster (still my gut feeling
). I remember that your Xeon computer runs faster than my Windows, even than my Linux notebook last time. Is it the same computer?
» For paranoiacs: Ever heard of
macro viruses?
like Melissa? Yes, it's quite possible and should be very careful. But you know we cannot blame VBA. Bad guy is everywhere.
» I know of one company not allowing FARTSSIE…...
True. However, some time there is no need to talk to IT department to install R or anything else. Quite ironically.
» BTW, in v2.5 of last Tuesday Dave removed all reference-scaled methods and gives the code of
Thanks for the information.
» However, I guess that simulations in VBA will be extremely slooow.
Perhaps. Maybe Dave can tell us more later. Well, it can be slow, but should not be that slooow.
» ...
» Sample size: 18
» Runtime (seconds):
» user system elapsed
» 0.14 0.01 0.15
I run the codes three times under R v4.0.3 and got:
Sample size: 18
Runtime (seconds):
user system elapsed
0.11 0.00 0.13
Sample size: 18
Runtime (seconds):
user system elapsed
0.09 0.01 0.10
Sample size: 18
Runtime (seconds):
user system elapsed
0.11 0.00 0.11
a little bit faster.


» For paranoiacs: Ever heard of
![[image]](https://static.bebac.at/img/Favicon_wikipedia_en.gif)
like Melissa? Yes, it's quite possible and should be very careful. But you know we cannot blame VBA. Bad guy is everywhere.
» I know of one company not allowing FARTSSIE…...
True. However, some time there is no need to talk to IT department to install R or anything else. Quite ironically.
» BTW, in v2.5 of last Tuesday Dave removed all reference-scaled methods and gives the code of
PowerTOST
in a box. 
Thanks for the information.
—
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
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 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
- 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