ݺߣ

ݺߣShare a Scribd company logo

hypothesis-testing-cheat-sheet.pptx

•
•
Melba Shaya Sweety
Melba Shaya Sweety

This document provides a cheat sheet on hypothesis testing. It lists common hypothesis tests including the z-test, one sample t-test, paired t-test, two sample t-test with equal variances, and two sample t-test with unequal variances. For each test, it gives the purpose, an example, the equation, and notes on using the test in Excel. The cheat sheet is intended for statistics students at Ryerson University.

1 of 3
Studocu is not sponsored or endorsed by any college or university Downloaded by enam professor (enamprofessor@gmail.com) Hypothesis Testing Cheat Sheet Statistics (Ryerson University) lOMoARcPSD|18360879
Hypothesis Testing Type Of Test Purpose Example Equation Comment Excel Function Z Test Test if the average of a single population is equal to a target value Do babies born at this hospital weigh more than the city average Z test does not need df σ = population standard deviation =Ztest(array,x,sigma) 1 Sample T-Test Test if the average of a single population is equal to a target value Is the average height of male college students greater than 6.0 feet? s = sample standard deviation no built in equation use =STDEVA for standard deviation use =AVERAGE for mean use =T.DIST.RT to get 1 tailed confidence use =T.DIST.2T to get 2 tailed confidence Paired T-Test Test if the average of the differences between paired or dependent samples is equal to a target value Weigh a set of people. Put them on a diet plan. Weigh them after. Is the average weight loss significant enough to conclude the diet works? d bar = average difference between samples s = sample deviation of the difference n = count of one set of the pairs (don't double count) =TTEST(Array1,Array2,*,1) * -> 1 for 1 tailed, 2 for 2 tailed n1, n2 = count of sample 1, 2 2 Sample T-Test Equal Variance Test if the difference between the averages of two independent populations is equal to a target value Do cats eat more of type A food than type B food =TTEST(Array1,Array2,*,2) 2 Sample T-Test Unequal Variance Test if the difference between the averages of two independent populations is equal to a target value Is the average speed of cyclists during rush hour greater than the average speed of drivers =TTEST(Array1,Array2,*,3) lOMoARcPSD|18360879
Downloaded by enam professor (enamprofessor@gmail.com) lOMoARcPSD|18360879

More Related Content

hypothesis-testing-cheat-sheet.pptx

  • 1. Studocu is not sponsored or endorsed by any college or university Downloaded by enam professor (enamprofessor@gmail.com) Hypothesis Testing Cheat Sheet Statistics (Ryerson University) lOMoARcPSD|18360879
  • 2. Hypothesis Testing Type Of Test Purpose Example Equation Comment Excel Function Z Test Test if the average of a single population is equal to a target value Do babies born at this hospital weigh more than the city average Z test does not need df σ = population standard deviation =Ztest(array,x,sigma) 1 Sample T-Test Test if the average of a single population is equal to a target value Is the average height of male college students greater than 6.0 feet? s = sample standard deviation no built in equation use =STDEVA for standard deviation use =AVERAGE for mean use =T.DIST.RT to get 1 tailed confidence use =T.DIST.2T to get 2 tailed confidence Paired T-Test Test if the average of the differences between paired or dependent samples is equal to a target value Weigh a set of people. Put them on a diet plan. Weigh them after. Is the average weight loss significant enough to conclude the diet works? d bar = average difference between samples s = sample deviation of the difference n = count of one set of the pairs (don't double count) =TTEST(Array1,Array2,*,1) * -> 1 for 1 tailed, 2 for 2 tailed n1, n2 = count of sample 1, 2 2 Sample T-Test Equal Variance Test if the difference between the averages of two independent populations is equal to a target value Do cats eat more of type A food than type B food =TTEST(Array1,Array2,*,2) 2 Sample T-Test Unequal Variance Test if the difference between the averages of two independent populations is equal to a target value Is the average speed of cyclists during rush hour greater than the average speed of drivers =TTEST(Array1,Array2,*,3) lOMoARcPSD|18360879
  • 3. Downloaded by enam professor (enamprofessor@gmail.com) lOMoARcPSD|18360879