## Mathematical wizard - use WinNonlin Tools menu instead [Bioanalytics]

Hi Helmut,

»

»

Just saw your post on this - I managed to replicate it in a workbook using a cell formula, however this is

I would recommend any WinNonlin users to use the

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 Consultant

Pharsight - A Certara™ Company

Simon Davis at LinkedIn

Forthcoming meetings and training

Problems are not stop signs, they are guidelines. Robert H. Schuller

Simon

Senior Scientific Consultant

Pharsight - A Certara™ Company

Simon Davis at LinkedIn

Forthcoming meetings and training

Problems are not stop signs, they are guidelines. Robert H. Schuller

### Complete thread:

- Excel sheet usage in bioanalytical calculations - chbs, 2009-01-19 10:35 [Bioanalytics]
- 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 instead - SDavis, 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