Skip to main content
Back

Finding Probabilities and T Critical Values - Excel definitions

Control buttons has been changed to "navigation" mode.
1/15
  • T.INV.2T
    Excel function for finding t critical values for two-tail probabilities, essential for confidence intervals.
  • T.INV
    Excel function for calculating t scores from left-tail probabilities, used in inferential statistics.
  • T.DIST
    Excel function for determining cumulative left-tail probabilities from t scores and degrees of freedom.
  • T.DIST.RT
    Excel function for finding right-tail probabilities given a t score and degrees of freedom.
  • T.DIST.2T
    Excel function for calculating two-tail probabilities, useful for significance tests and confidence intervals.
  • Degrees of Freedom
    Value calculated as sample size minus one, crucial for t-distribution calculations in Excel.
  • Alpha
    Combined probability in both tails, found by subtracting confidence level from one; input for critical value functions.
  • Confidence Interval
    Range constructed using t critical values to estimate population parameters with a specified confidence level.
  • Left Tail Probability
    Chance of obtaining a t score below a specified value, used as input for certain Excel functions.
  • Right Tail Probability
    Chance of obtaining a t score above a specified value, often converted to left-tail for Excel calculations.
  • Two-Tail Probability
    Combined probability of extreme values in both tails, relevant for hypothesis testing and confidence intervals.
  • Student’s t-distribution
    Probability distribution used for inferential statistics with small samples, requiring degrees of freedom.
  • Critical Value
    Threshold t score separating acceptance and rejection regions in hypothesis testing or confidence intervals.
  • Sample Size
    Number of observations in a dataset, used to determine degrees of freedom for t-distribution calculations.
  • Cumulative Probability
    Total probability up to a given t score, found using Excel functions for left-tail calculations.