Statistical significance

Error and Uncertainty in Google Sheets

Evan Kramer

Instructor

Statistical significance

  • <5% probability due to chance
    • Not 0%
  • T.TEST()
    • Likelihood that differences are significant
Error and Uncertainty in Google Sheets

T-tests

  • T.TEST()
    • range1
    • range2
    • tails
    • type
Error and Uncertainty in Google Sheets

T-tests

  • tails
    • 1: Upper or lower distribution
    • 2: Upper and lower distribution
  • type
    • 1: Paired-samples
    • 2: Two-sample (equal variance)
    • 3: Two-sample (unequal variance)
Error and Uncertainty in Google Sheets

Confidence levels

  • Significance

    • Confidence level
      • Probability due to chance
  • T.TEST() <= 0.05

Error and Uncertainty in Google Sheets

Let's practice!

Error and Uncertainty in Google Sheets

Preparing Video For Download...