Hi Ronnie,
I haven't done a thorough analysis but have you noticed the condition in
the ODF description of this function that says "The sum of the
probabilities in Probability shall equal 1". Clearly your worked example
violates that guidance, which may be your problem.
Regards,
Steve
------ Original Message ------
From: "GANDHI RONNIE" <gron...@cs.iitr.ac.in>
To: documentat...@libreoffice.org; "Documentation Team"
<documentation@global.libreoffice.org>; "stevemfanning...@gmail.com"
<stevemfanning...@gmail.com>; "Olivier Hallot"
<olivier.hal...@libreoffice.org>
Sent: 25/10/2020 13:40:07
Subject: Issue understanding PROB function
Hello Steve and Olivier,
I am having an issue understanding PROB. I tried running the function
using details from help and in the same way as MS's counterpart but in
Calc it returns a #VALUE! error. Can you point out the reason for the
same since I am unable to get any legit numerical result till now.
error_prob.png
Regards,
Ronnie Gandhi
Undergraduate at Computer Science and Engineering
Indian Institute of Technology, Roorkee
+91-07874243430
--
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy