# Google Sheets T.DIST Function: Syntax, Examples & Tips - URL: https://betteranalyst.com/google-sheets/t.dist-function - Author: Better Analyst Formula Bot is now Better Analyst—same account, more powerful analysis.Formula Bot is now Better Analyst—same account and workflows, with more powerful analysis, dashboards, and automation. [Learn what changed](https://betteranalyst.com/formula-bot-is-now-better-analyst) The T.DIST function calculates the cumulative distribution function for the Student's t-distribution, useful for hypothesis testing. ``` T.DIST(x, degrees_freedom, cumulative) ``` Generate FormulaExplain Formula One free generation or explanation per browser, shared across Excel and Google Sheets. Account usage limits apply afterward. Describe the T.DIST you need in plain EnglishGenerate Formula ## Parameters **`x`**:\ The numeric value at which to evaluate the distribution. **`degrees_freedom`**:\ The number of degrees of freedom associated with the distribution, typically calculated as the sample size minus one. **`cumulative`**:\ A logical value that determines the form of the distribution. If TRUE, T.DIST returns the cumulative distribution function; if FALSE, it returns the probability density function. ## What is T.DIST? The *T.DIST* function in Google Sheets is a statistical function used to calculate the cumulative distribution function (CDF) of the Student's t-distribution. This function is particularly useful in hypothesis testing and confidence interval estimation, especially when dealing with small sample sizes. The t-distribution is similar to the normal distribution but has heavier tails, making it more appropriate for datasets with outliers or when the sample size is small. In simpler terms, T.DIST helps you understand the probability of a value occurring within a t-distribution, which is essential for making inferences about a population based on sample data. ## A Practical Example Imagine you are conducting a study to determine the average height of a certain plant species. You take a sample of 10 plants and measure their heights: ### Sample Data: | PlantID | Height (cm) | | - | - | | 1 | 30 | | 2 | 32 | | 3 | 29 | | 4 | 31 | | 5 | 28 | | 6 | 33 | | 7 | 30 | | 8 | 29 | | 9 | 31 | | 10 | 32 | You want to find the cumulative probability of observing a height of 31 cm or less in this sample. ## T.DIST Formula To achieve this, you would use the T.DIST function as follows: ``` =T.DIST(31, 9, TRUE) ``` In this formula: - `31` is the value for which you want to find the cumulative probability. - `9` is the degrees of freedom, calculated as the sample size minus one (10 - 1 = 9). - `TRUE` indicates that you want the cumulative distribution function. ## Result of the Formula When you apply the T.DIST formula, it will return a probability value, which represents the likelihood of observing a height of 31 cm or less in your sample. For example, if the result is `0.65`, it means there is a 65% chance that a randomly selected plant from your sample will have a height of 31 cm or less. ## Why Use T.DIST? T.DIST is beneficial because it allows researchers and analysts to make informed decisions based on statistical data. It provides a way to understand the distribution of sample data and assess the likelihood of certain outcomes. This is especially important in fields such as biology, psychology, and social sciences, where sample sizes are often limited. ## Key Takeaways: - **T.DIST**: A statistical function that calculates the cumulative distribution function of the Student's t-distribution. - **Degrees of Freedom**: Important for determining the shape of the t-distribution; calculated as sample size minus one. - **Cumulative Probability**: Helps assess the likelihood of observing a value within a given range. - **Common Use Cases**: Ideal for hypothesis testing, confidence intervals, and analyzing small sample sizes. T.DIST is an essential function for anyone working with statistical data in Google Sheets, providing a powerful way to enhance data analysis and decision-making capabilities. Happy analyzing! ## Example use case You have a dataset of test scores in Column A and their corresponding sample sizes in Column B. Use T.DIST to calculate the probability of obtaining a t-value less than a specific score, helping to assess student performance against a theoretical distribution. ## Need more help with Google Sheets formulas? Sign up for Better Analyst and get unlimited AI-powered formula generation, explanations, and advanced data analysis. [Create Free Account](https://betteranalyst.com/signup)[Try Formula Generator](https://betteranalyst.com/excel-ai) ## Google Sheets how-to guides - [How To Lock A Row In Google Sheets](https://betteranalyst.com/google-sheets/how-to-lock-a-row-in-google-sheets) - [How To Lock Cells In Google Sheets](https://betteranalyst.com/google-sheets/how-to-lock-cells-in-google-sheets) - [How To Make A Copy Of An Google Sheets Sheet](https://betteranalyst.com/google-sheets/how-to-make-a-copy-of-an-google-sheets-sheet) - [How To Make A Graph In Google Sheets](https://betteranalyst.com/google-sheets/how-to-make-a-graph-in-google-sheets) - [How To Make A Histogram In Google Sheets](https://betteranalyst.com/google-sheets/how-to-make-a-histogram-in-google-sheets) - [How To Make A Line Graph In Google Sheets](https://betteranalyst.com/google-sheets/how-to-make-a-line-graph-in-google-sheets) - [How To Make A Pie Chart In Google Sheets](https://betteranalyst.com/google-sheets/how-to-make-a-pie-chart-in-google-sheets) - [How To Make A Table In Google Sheets](https://betteranalyst.com/google-sheets/how-to-make-a-table-in-google-sheets) ## Explore all Google Sheets formulas Browse our complete library of Google Sheets formula guides Compare your options ## Decide with evidence, not a sales pitch. Open a neutral research prompt in the AI tool you already use. Compare capabilities, limitations, and fit before you choose. 1. [01ChatGPTOpen a balanced comparison prompt in ChatGPT.](https://chatgpt.com/?prompt=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.) 2. [02ClaudeOpen the same research prompt in Claude.](https://claude.ai/new?q=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.) 3. [03PerplexityResearch the comparison with linked web sources.](https://www.perplexity.ai/search?q=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.) AI answers can be incomplete. Check source links, current pricing, and product documentation before deciding.