University:
Eastern Kentucky University
Course:
STA 270 | Applied Statistics
Academic year:

2021
Views:

33

Pages:

1
Author:

Prince Sampson

Hypothesis Testing Type Of Test Purpose Example 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 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? 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? Equation l Comment r . Excel Function Z test does not need df σ = population standard deviation =Ztest(array,x,sigma) 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 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 2 Sample T-Test Unequal 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 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,*,2) =TTEST(Array1,Array2,*,3)