statistics - Student's t distribution in JavaScript for Google Spreadsheet - Stack Overflow

admin管理员组

文章数量:1312848

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!

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!

• javascript
• statistics
• google-docs

Share Improve this question Follow edited Apr 25, 2010 at 20:14 Sai asked Apr 25, 2010 at 20:05 SaiSai 7,22977 gold badges4343 silver badges5555 bronze badges

Add a ment  | 

3 Answers 3

Sorted by: Reset to default 4

Here you go.

Google Sheets does now include the TDIST function (if you've switched to the new version).

http://www.math.ucla.edu/~tom/distributions/tDist.html - view source.

本文标签： statisticsStudent39s t distribution in JavaScript for Google SpreadsheetStack Overflow