Talk:Documentation/How Tos/Calc: TDIST function

From Apache OpenOffice Wiki
< Talk:Documentation
Revision as of 20:52, 15 November 2013 by Vladr (talk | contribs) (Created page with "=== ERRORS on the page === Page claims: TDIST returns the probability density function for the t-distribution '''FALSE!''' TDIST happens to actually return the CDF (actua...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

ERRORS on the page

Page claims:

 TDIST returns the probability density function for the t-distribution


FALSE! TDIST happens to actually return the CDF (actually 1-cdf(X)), not the PDF. Just plot it for 0≤X≤4, and compare to e.g. https://en.wikipedia.org/wiki/Student%27s_t-distribution Plot the differential THEN you get the pdf. The Microsoft page does a better job of explaining this by stating that TDIST(X,...) returns the probability of x>X (i.e. 1-cdf(X))


Vladr (talk) 20:52, 15 November 2013 (UTC)

Personal tools