Log in
RegisterSpreadshit addiction [General Statistics]
Dear yicaoting and HS,
For my part I am very happy now that I have a solution, and it isn't of paramount importance to have 17 correct decimals. If a client of mine should ask for 17 decimals I would most likely tell him to go [to protect minors this sentence has been partly and pirately censored] himself
.
Decisions re. BE are made on basis of two decimals when we talk ordinary BE, so one can try and argue the same in my case.
I cannot find info on the actual implementations in neither Excel nor OO. A great paper comparing certain numeric precision aspects here.
Couldn't help laughing when I read page 19 ("Microsoft claims...."), by the way. Life is great. But then again, it is my impression that people at SAS aren't particularly informative either re. their implementations. That's why R so rules, imho.
Happy national day, yicaoting.
❝ Based on the result of R, It seems that BETAINV() in OO Calc has higher precision than that in Excel.
For my part I am very happy now that I have a solution, and it isn't of paramount importance to have 17 correct decimals. If a client of mine should ask for 17 decimals I would most likely tell him to go [to protect minors this sentence has been partly and pirately censored] himself
.Decisions re. BE are made on basis of two decimals when we talk ordinary BE, so one can try and argue the same in my case.
I cannot find info on the actual implementations in neither Excel nor OO. A great paper comparing certain numeric precision aspects here.
Couldn't help laughing when I read page 19 ("Microsoft claims...."), by the way. Life is great. But then again, it is my impression that people at SAS aren't particularly informative either re. their implementations. That's why R so rules, imho.
Happy national day, yicaoting.
—
Pass or fail!
ElMaestro
Pass or fail!
ElMaestro
Complete thread:
- Welch/Satterthwaite in practice ElMaestro 2011-09-21 17:04
![[Mix]](https://static.bebac.at/img/mix.png "open in Mix view")
- Not to round is the question d_labes 2011-09-22 09:11
- my problem ElMaestro 2011-09-22 12:34
- Ways out d_labes 2011-09-27 11:54
- my problem ElMaestro 2011-09-22 12:34
- Welch/Satterthwaite in practice yicaoting 2011-09-29 16:29
- Welch/Satterthwaite in practice ElMaestro 2011-09-29 17:39
- Spreadshit addiction Helmut 2011-09-30 16:52
- what a divine post! ElMaestro 2011-09-30 18:54
- what a divine post! Helmut 2011-09-30 19:41
- what a divine post! ElMaestro 2011-10-01 13:03
- what a divine post! Helmut 2011-10-01 13:20
- what a divine post! ElMaestro 2011-10-01 13:03
- what a divine post! Helmut 2011-09-30 19:41
- Spreadshit addiction yicaoting 2011-10-01 05:36
- Spreadshit addictionElMaestro 2011-10-01 11:13
- GNU addiction Helmut 2011-10-02 03:20
- Spreadshit addiction Helmut 2011-10-01 13:03
- Spreadshit addiction yicaoting 2011-10-01 16:39
- Spreadshit addiction yicaoting 2011-10-03 07:23
- Spreadshit addiction Helmut 2011-10-03 15:59
- Spreadshit addiction yicaoting 2011-10-03 17:35
- Spreadshit addiction Helmut 2011-10-03 17:41
- Spreadshit addiction yicaoting 2011-10-03 17:35
- Spreadshit addiction Helmut 2011-10-03 15:59
- Spreadshit addictionElMaestro 2011-10-01 11:13
- what a divine post! ElMaestro 2011-09-30 18:54
- Not to round is the question d_labes 2011-09-22 09:11
Ing. Helmut Schütz