Google Sheets

TDIST: Google Sheets Formulae Explained

How do you use TDIST in Google Sheets?

The TDIST function in Google Sheets calculates the probability that a given value is drawn from a given distribution. This can be used to calculate things like the odds of getting a specific score on a test, or the probability of a particular outcome in a sports game. To use the TDIST function, you first need to specify the distribution you're using. This can be done by typing the name of the distribution into the function, or by selecting it from a list. You then need to enter the value you want to calculate the probability for. The TDIST function will then calculate the probability that the value is drawn from the given distribution.

What is the syntax of TDIST in Google Sheets?

The syntax for TDIST in Google Sheets is: =TDIST(x,y,type) where "x" is the first input value, "y" is the second input value, and "type" is the type of distribution.

What is an example of how to use TDIST in Google Sheets?

One way to use TDIST in Google Sheets is to find the probability of a particular event occurring. For example, you might want to know the probability that the sum of two dice is seven. To do this, you would use the following formula:

TDIST(7,2,1)

This would return the value 0.0390625, which means that there is a 3.9% chance of the sum of two dice being seven.

When should you not use TDIST in Google Sheets?

There are a few instances when you should not use TDIST in Google Sheets. One instance is when you are trying to find the probability of two independent events occurring. In this case, you should use the function P(A and B), which is the multiplication of the two individual probabilities. Another instance is when you are trying to find the probability of two dependent events occurring. In this case, you should use the function P(A given B), which is the conditional probability of A occurring given that B has already occurred.

What are some similar formulae to TDIST in Google Sheets?

The following are some similar formulae to TDIST in Google Sheets:

1. T.DIST() 2. TDIST.INV() 3. T.INV() 4. TTEST()

Move beyond 

Google Sheets

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.