{"id":19196,"date":"2016-12-21T21:59:04","date_gmt":"2016-12-21T21:59:04","guid":{"rendered":"http:\/\/www.oracletutoring.ca\/blog\/?p=19196"},"modified":"2016-12-21T21:59:04","modified_gmt":"2016-12-21T21:59:04","slug":"statistics-spreadsheets-tdist-function","status":"publish","type":"post","link":"https:\/\/www.oracletutoring.ca\/blog\/statistics-spreadsheets-tdist-function\/","title":{"rendered":"Statistics: Spreadsheets: tdist() function"},"content":{"rendered":"

The tutor covers the tdist() function, which seems to work the same on Excel and LibreOffice Calc.<\/h1>\n

The tdist() function is in the statistics category of functions. Its entry scheme is<\/p>\n

=tdist(t-value, degrees_of_freedom, number_of_tails)<\/p>\n

Perhaps surprisingly, the t-value itself must be positive. (For a negative value, you just use the corresponding positive one and the idea of symmetry.) The number_of_tails<\/span> parameter is either 1 or 2.<\/p>\n

The function returns the value in the tail, rather than between the center and the input. For instance,<\/p>\n

=tdist(2.042,30,2)<\/p>\n

yields 0.05: 0.025 from each tail.<\/p>\n

Example: Give the probability that, with df=20, a t statistic lies between -0.65 and 0.11.<\/strong><\/p>\n

Solution:<\/p>\n

    \n
  1. On the upper side, the probability will be =0.5-tdist(0.11,20,1)<\/span>. This yields 0.0432.<\/li>\n
  2. On the lower side, the probability will be =0.5-tdist(6.5,20,1)<\/span>.
    \nThis yields 0.2385.<\/li>\n
  3. The total probability is the sum of the two, which is 0.0432+0.2385=0.2817<\/li>\n
  4. Apparently, there is 28.2% probability that a t-statistic with df=20 will land between -0.65 and 0.11.<\/li>\n<\/ol>\n

    Source:<\/p>\n

    Harnett, Donald L. and James L. Murphy. Statistical Analysis for Business and Economics<\/u>. Don Mills: Addison-Wesley, 1986.<\/p>\n

    Jack of Oracle Tutoring by Jack and Diane,<\/a> Campbell River, BC.<\/p>\n","protected":false},"excerpt":{"rendered":"

    The tutor covers the tdist() function, which seems to work the same on Excel and LibreOffice …<\/p>\n

    Statistics: Spreadsheets: tdist() function<\/span> Read more \u2192<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19],"tags":[1078,1074,2075,2074],"class_list":["post-19196","post","type-post","status-publish","format-standard","hentry","category-statistics","tag-excel","tag-libreoffice-calc","tag-t-distribution-function-on-spreadsheet","tag-tdist-function"],"_links":{"self":[{"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/posts\/19196","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/comments?post=19196"}],"version-history":[{"count":14,"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/posts\/19196\/revisions"}],"predecessor-version":[{"id":19210,"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/posts\/19196\/revisions\/19210"}],"wp:attachment":[{"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/media?parent=19196"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/categories?post=19196"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/tags?post=19196"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}