Aw: Re: Re: no tests for trigonometric functions? need help / hints how to adapt tests for gnumeric 'long' version,
- From: newbie nullzwei <newbie-02 gmx de>
- To: Gnumeric Forum <gnumeric-list gnome org>
- Subject: Aw: Re: Re: no tests for trigonometric functions? need help / hints how to adapt tests for gnumeric 'long' version,
- Date: Sat, 18 Jun 2022 00:05:58 +0200
- how to deal with / construct tests for functions / ranges where 'long' and 'double' version have
justified different results?
( how to build tests which allow / demand improved results, but accept 'double accuracy results' when
using double datatype? )
let me give it an example ( pros will find better ones ):
t1013-crlibm, crlibm.gnumeric, row 18278:
formula: '=exp(239.043590469953)'
reference: 6.536003490281019E+103,
'double' result: 6.536003490281019E+103 - 'quality': ' ' or '99' or 100% or best ...
'long' result: 6.536003490281029007E+103 - 'quality' only 14.819377377076821122 digits, thus
bad?
my 'srt-deco-round' version: 6.536003490281095E+103, - 'quality' only 13.934498683160548 digits, thus
worse? but!!!
correct acc. 'ttmath.org': 6.5360034902810943723150710853138994266057660109196409934141980800730... E103,
and acc. 'wolframalpha.com': 6.5360034902810943723150710853138994266057660109196409934141... × 10^103
thus ttmath and wolframalpha seem correct ( equal ), 6.536003490281094E+103 would be the best approximation
with doubles,
my improved version second, 'long' third and double 'acceptable' ?
idea ... use the correct result as reference, protect against messing it up by saves from low capa versions
by storing as text ( '=value(".... ")' ), prepare for future improved versions by storing more digits (50?),
calculate the 'quality' ( correct digits? ) with the log formula as of now, and require a threshold of e.g
13.9 digits for double and 16.9 digits for long results to pass the test ... ??? one would immediately see
that the long version has far less accuracy ( ~13.99 digits ) than it pretends by it's precision, and could
try to dig for the reason ...
disclaimer: 'no!', I don't really need this level of accuracy, I'm seeking for modes to calculate which don't
undermine math logic, and in this area - tests - I am looking for something that is oriented to normal
mathematics, rewards good results and marks deviations ... for this I also have to play through extreme
considerations ...
[
Date Prev][
Date Next] [
Thread Prev][
Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]