Student's t distribution in JavaScript
- by Sai Emrys
Google Spreadsheets currently does not support the standard function TDIST - i.e. the Student's t-distribution. This function is critical for calculating p-values.
It seems that this is related to the fact that no integral-using functions (AFAICT) are implemented either.
However, Google Docs allows people to add and publish their own scripts, in JavaScript.
So ideally we should have something like:
function tdist(t_value, degrees_of_freedom, two_tailed [defaults true]) {...}
Anyone know of either an extant implementation of this (my google-fu has not turned up one, but may be weaker than yours) or a good idea for how to do it?
I'd like to publish this together with some other useful functions that are currently calculable but a bit of a pain (like Student's t-test itself).
Thanks!