Log in
RegisterMathematical wizard - use WinNonlin Tools menu instead [Bioanalytics]
posted by SDavis 
– UK, 2009-01-22 12:56 (5991 d 15:18 ago) – Posting: # 3108
Views: 29,058
Hi Helmut,
Just saw your post on this - I managed to replicate it in a workbook using a cell formula, however this is not how I'd recommend people perform such data manipulations in WinNonlin.
Performing the same calculation using either Descriptive Stats or the summary stats within Table Wizard will give you the correct answer i.e. 1. (as indeed will your worked example of calculating it without using the SD function).
I would recommend any WinNonlin users to use the Tools functions I described above since the 'grid' calculations come from, I think FormulaOne, which is a third party tool we use that seems to be susceptible to this error. Incidentally I don't think this should be a problem with Version 6 since it's not using this data grid anymore.
Cheers,
Simon
❝ WinNonlin 5.2.1
❝ STDEV(90000001;90000002;90000003) = 0
Just saw your post on this - I managed to replicate it in a workbook using a cell formula, however this is not how I'd recommend people perform such data manipulations in WinNonlin.
Performing the same calculation using either Descriptive Stats or the summary stats within Table Wizard will give you the correct answer i.e. 1. (as indeed will your worked example of calculating it without using the SD function).
I would recommend any WinNonlin users to use the Tools functions I described above since the 'grid' calculations come from, I think FormulaOne, which is a third party tool we use that seems to be susceptible to this error. Incidentally I don't think this should be a problem with Version 6 since it's not using this data grid anymore.
Cheers,
Simon
—
Simon
Senior Scientific Trainer, Certara™
[link=https://www.youtube.com/watch?v=xX-yCO5Rzag[/link]
https://www.certarauniversity.com/dashboard
https://support.certara.com/forums/
Simon
Senior Scientific Trainer, Certara™
[link=https://www.youtube.com/watch?v=xX-yCO5Rzag[/link]
https://www.certarauniversity.com/dashboard
https://support.certara.com/forums/
Complete thread:
- Excel sheet usage in bioanalytical calculations chbs 2009-01-19 10:35 [Bioanalytics]
![[Mix]](https://static.bebac.at/img/mix.png "open in Mix view")
- do not use excel martin 2009-01-19 11:52
- do not use excel ? Ohlbe 2009-01-19 23:54
- Never martin 2009-01-20 14:52
- Mathematical wizard Helmut 2009-01-20 17:03
- Do not trust in computers d_labes 2009-01-21 11:00
- Do not trust in computers Helmut 2009-01-21 13:00
- Do not trust in computers Ohlbe 2009-01-21 14:03
- Do not trust in Excelence d_labes 2009-01-21 15:42
- Do not trust in computers Helmut 2009-01-22 02:49
- Do not trust in computers Ohlbe 2009-01-22 10:33
- Even my calculator... Ohlbe 2009-01-22 22:06
- Even my calculator... Helmut 2009-01-22 23:26
- Even my calculator... ElMaestro 2009-01-23 12:12
- Even my calculator... Ohlbe 2009-01-24 19:44
- Even my calculator... ElMaestro 2009-01-23 12:12
- Even my calculator... Helmut 2009-01-22 23:26
- Do not trust in computers Ohlbe 2009-01-21 14:03
- Do not trust in computers Helmut 2009-01-21 13:00
- data exchange format martin 2009-01-21 12:16
- Raw data (paper vs. electronic) Helmut 2009-01-21 12:31
- Mathematical wizard - use WinNonlin Tools menu insteadSDavis 2009-01-22 11:56
- Do not trust in computers d_labes 2009-01-21 11:00
- Mathematical wizard Helmut 2009-01-20 17:03
- Why not use R? Helmut 2009-01-21 01:02
- Why not use R? ElMaestro 2009-01-22 19:32
- Why not use R? ElMaestro 2009-01-23 22:45
- Why not use R? Aceto81 2009-01-26 16:15
- Why not use R? d_labes 2009-01-26 16:35
- Why not use R? Aceto81 2009-01-26 16:15
- Never martin 2009-01-20 14:52
- do not use excel ? Ohlbe 2009-01-19 23:54
- do not use excel martin 2009-01-19 11:52
Ing. Helmut Schütz