## Even my calculator... [Bioanalytics]

Haha,

Ohlbe and HS you seem to be having great fun here.

Let me add, I know of a famous, fantastic, brilliant and heavenly piece of software for 2,2,2-BE calculation in which the programmer circumvented problems of this type by scaling all input data* before the model fitting and ANOVA takes place.

There is one potential drawback of doing that, however: In a model fit you need differentials of the dF/dX type, possibly also double differentials. In order to do that the value of the delta (d above) should be chosen VERY wisely. It should in theory be infinitely small, but computers of course cannot do that, so we try e.g. 10e-4 or 10e-6 or whatever. But if the scaling causes the numbers in the input dataset to be of a magnitude close to the delta then everything could be screwed up. The pros and hardliners use Al Gore Rythms with variable delta's in their matrices and differentials. The programmer behind the software mentioned above didn't do that kind of fancy stuff, mainly because of the log operation.

Would still perhaps be interesting to see if a BE-script in R or SAS can be challenged by datasets with very large or very small numbers (perhaps even worse: When the range of values in the input dataset is narrow). Since I don't have SAS I cannot do it all, but I might try a few R challenges one of these days.

EM.

*: All data divided by the highest data entry in the entire dataset. All values then between 0 and 1.

Ohlbe and HS you seem to be having great fun here.

Let me add, I know of a famous, fantastic, brilliant and heavenly piece of software for 2,2,2-BE calculation in which the programmer circumvented problems of this type by scaling all input data* before the model fitting and ANOVA takes place.

There is one potential drawback of doing that, however: In a model fit you need differentials of the dF/dX type, possibly also double differentials. In order to do that the value of the delta (d above) should be chosen VERY wisely. It should in theory be infinitely small, but computers of course cannot do that, so we try e.g. 10e-4 or 10e-6 or whatever. But if the scaling causes the numbers in the input dataset to be of a magnitude close to the delta then everything could be screwed up. The pros and hardliners use Al Gore Rythms with variable delta's in their matrices and differentials. The programmer behind the software mentioned above didn't do that kind of fancy stuff, mainly because of the log operation.

Would still perhaps be interesting to see if a BE-script in R or SAS can be challenged by datasets with very large or very small numbers (perhaps even worse: When the range of values in the input dataset is narrow). Since I don't have SAS I cannot do it all, but I might try a few R challenges one of these days.

EM.

*: All data divided by the highest data entry in the entire dataset. All values then between 0 and 1.

### 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