Difference between revisions of "Talk:Documentation/How Tos/Calc: TDIST function"
From Apache OpenOffice Wiki
(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...") |
|||
| Line 5: | Line 5: | ||
| − | '''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. | + | '''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. [http://en.wikipedia.org/wiki/Student%27s_t-distribution Wikipedia]. Plot the differential THEN you get the pdf. [http://office.microsoft.com/en-us/excel-help/tdist-HP005209312.aspx 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)) |
[[User:Vladr|Vladr]] ([[User talk:Vladr|talk]]) 20:52, 15 November 2013 (UTC) | [[User:Vladr|Vladr]] ([[User talk:Vladr|talk]]) 20:52, 15 November 2013 (UTC) | ||
Latest revision as of 20:54, 15 November 2013
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. Wikipedia. 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))
