Date: prev next · Thread: first prev next last
2011 Archives by date, by thread · List index


Hi Markus,

Markus Mohrhard schrieb:
Hello,

this patch removes the check for the upper bound of the second parameter
of TINV. I checked the algorithm of TINV but there seems to be no reason
to limit this number.

The only problem is that for values greater than 1E14 the rounding error
dramatically increases but in my opinion everyone who uses such large
numbers should know about problems related to rounding and floating
point arithmetic.

I have no definite opinion on the upper limit of the second parameter. It is "degree of freedom" and 1E5 covers already exploring 5000 records. I don't know whether a larger limit is needed. But the user should get an information about problems with huge numbers, perhaps a remark in the help, that it is not recommended to use values above ...

Do you have valid reference values for the accuracy? Are the values of TINV worse or better than approximating with standard normal distribution?

There are some loops involved. Do you test the performance with huge values?

Kind regards
Regina


Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.