1
$\begingroup$

I'm using Google Docs for a statistics class and my instructor suggested we use the "tdist()" function in Excel. http://office.microsoft.com/en-us/excel-help/tdist-HP005209312.aspx

I can't find anything similar in Google Spreadsheets. https://support.google.com/drive/bin/static.py?hl=en&topic=25273&page=table.cs&tab=1240295

Does anyone have an alternative formula/function I could use?

$\endgroup$
  • 3
    $\begingroup$ This may be of interest to you. $\endgroup$ – Jonathan Christensen Dec 20 '12 at 17:18
  • 1
    $\begingroup$ According to this SO post, the tdist() function isn't available on Google Spreadsheets, but can be programmed in JavaScript. $\endgroup$ – smillig Dec 20 '12 at 17:18
1
$\begingroup$

Run!, run away! and flee! from the idea of using spreadsheets as statistical analysis tools.

Ok, on a little more serious note, read this article on Spreadsheet Addiction to get a better view of why you might want to consider using other tools besides spreadsheets. In the long run (even the medium run) you will gain more by learning to use programs designed for statistics to do statistics.

Then next time someone tells you that they want to be able to do everything in Excel (or other program) then challenge them to use it as mail client and word processor, that they should use only excel to write their next article or report. If you really want to push this into more obvious sillyness then challenge them to use Excel to cook their dinner or wash their car. When they react that your challenge is silly ask them why it is any less silly to use a spread sheet for statistics when there are programs specifically designed for that which do a much better job (again see the link above).

| cite | improve this answer | |
$\endgroup$
  • 1
    $\begingroup$ I have to say, I disagree, at least when it comes to google sheets. The fact that you can now add custom functions (written in javascript) means that you can strike the right balance between spreadsheet and code. $\endgroup$ – lorentzfactor Jun 14 '15 at 22:35

Not the answer you're looking for? Browse other questions tagged or ask your own question.