Bioequivalence and Bioavailability Forum • Rounding

Rounding [Software]

posted by Helmut – Vienna, Austria, 2013-01-01 17:51 (4509 d 13:57 ago) – Posting: # 9773
Views: 14,307

Hi Simulators!

How does your software round? Mine:

Excel 2000:       round(125.005, 2) → 125.01

OO Calc:          round(125.005, 2) → 125.01

Gnumeric 1.10.16: round(125.005, 2) → 125.01

WinNonlin 5.3:    round(125.005, 2) → 125.01

Phoenix 6.3:      round(125.005, 2) → 125.01

JavaScript:       Math.round(125.005*100)/100 → 125.01

PHP:              round(125.005, 2) → 125.01

PHP ≥5.3.0:       round(125.005, 2, PHP_ROUND_HALF_UP) → 125.01

                  round(125.005, 2, PHP_ROUND_HALF_DOWN) → 125.00

                  round(125.005, 2, PHP_ROUND_HALF_EVEN) → 125.00

                  round(125.005, 2, PHP_ROUND_HALF_ODD) → 125.01

R 2.15.2:         round(125.005, 2) → 125.00

R claims to be compliant with IEC 60559. In normal life not sooo important, but in simulations. Example (10⁶ sim’s, empiric alpha ~ T/R 1.25 in conventional balanced cross-overs).

 n   CV   alpha        alpha

         no rounding  CI rounded

42  15%  0.049842     0.050746 (sig. >0.05)

36  17%  0.050010     0.050706 (sig. >0.05)

@ElMaestro: Do you round in C?

—
Dif-tor heh smusma 🖖🏼 Довге життя Україна!
Helmut Schütz

The quality of responses received is directly proportional to the quality of the question asked. 🚮
Science Quotes

Complete thread:

RoundingHelmut 2013-01-01 16:51 [Software]
- Rounding d_labes 2013-01-02 12:51
  - Rounding Helmut 2013-01-04 17:35
    - Rounding d_labes 2013-01-05 19:25
      - Rounding Helmut 2013-01-05 20:13
        
        Sim’s are sim’s are sim’s d_labes 2013-01-05 20:57
      - Another vicious circle Helmut 2013-01-06 02:21
        
        Where all these numbers came from? d_labes 2013-01-07 15:52
        
        Flaw in the GL? Helmut 2013-01-07 17:29
        
        Flaw in the GL? d_labes 2013-01-08 11:44
        
        What a mess! Helmut 2013-01-08 19:08
        
        What a mess! d_labes 2013-01-09 10:33
        
        What a mess! Helmut 2013-01-09 15:18
- Rounding ElMaestro 2013-01-02 16:12
  - Abandon rounding Helmut 2013-01-02 17:04
- Rounding yjlee168 2013-01-05 23:15
  - Rounding Helmut 2013-01-06 03:29
  - Rounding Helmut 2013-01-06 15:34
    - Rounding yjlee168 2013-01-06 23:38