Transcription of Using Excel, Chapter 8: Hypothesis Testing - One Sample
1 1 Using Excel, Chapter 8: Hypothesis Testing - One SampleExcel alone does not conduct complete Hypothesis tests1. However, once you calculate the test statistic, Excelcan get the critical values and theP-values needed to complete the test. The functions used to get criticalvalues andP-values are demonstrated here. Chapter - Hypothesis Testing About a Proportion2 The functions demonstrated here use the standard normal (z) distribution. Chapter - Hypothesis Tests About a Mean: Not Known (t-test)3 The functions demonstrated here use thet-distribution. Chapter - Hypothesis Tests About a Mean: Known4 The functions demonstrated here use the standard normal (z) does actually have two functions, , that return aP-value for a data set but the alternate hypothesisis awkward (it only conducts right-tailed tests) and you need the raw - Hypothesis Testing About a Proportion Notation Test Statistic =z p= p p pqn Significance Level = (in decimal form) Critical Values =z or z /2 Finding Critical ValuesHere we use for the inverse of the standard normal distribution (z-distribution).
2 (area to the left of the critical value)This function returns the critical value from thez-distribution provided you put in the appropriate Tests:z = ( )Right-Tailed Tests:z = (1 )Two-Tailed Tests:z /2= ( /2) FindingP-ValuesHere we use for the standard normal distribution (z-distribution). (z, Cumulative?)This function returns the area under the curve to the left ofzwhen Cumulative = Tests:P-value = (z p, TRUE)z pshould be< Tests:P-value = 1 (z p, TRUE)z pshould be> Tests:P-value = 2 (1 (|z p|,TRUE))3 Chapter - Hypothesis Tests About a Mean: Not Known (t-test) Notation Test Statistic =t x= x s n Significance Level = (in decimal form) Critical Values =t or t /2 df = degrees of freedom =n- 1 Finding Critical ValuesHere we use for the inverse of (area left of critical value, degrees of freedom)This function returns the critical value from thet-distribution provided you put in the appropriate areaand degrees of Tests:t = ( , df)Right-Tailed Tests.
3 T = (1 , df )Two-Tailed Tests:t /2= ( /2, df) FindingP-ValuesHere we use for (t, df, Cumulative?)This function returns the area under the curve to the left oftwhen Cumulative = Tests:P-value = (t x, df, TRUE)Right-Tailed Tests:P-value = 1 (t x, df, TRUE) Two-Tailed Tests:P-value = 2 (1 (|t x|,df,TRUE)) New to Excel 2010 and (t x, df) yields the right-tailed (t x, df) yields the two-tailed - Hypothesis Tests About a Mean: Known Notation Test Statistic =z x= x n Significance Level = (in decimal form) Critical Values =z or z /2 Finding Critical ValuesHere we use for the inverse of the standard normal distribution (z-distribution). (area to the left of the critical value)This function returns the critical value from thez-distribution provided you put in the appropriate Tests:z = ( )Right-Tailed Tests:z = (1 )Two-Tailed Tests:z /2= ( /2) FindingP-ValuesHere we use for the standard normal distribution (z-distribution).
4 (z, Cumulative?)This function returns the area under the curve to the left ofzwhen Cumulative = Tests:P-value = (z x, TRUE)z xshould be< Tests:P-value = 1 (z x, TRUE)z xshould be> Tests:P-value = 2 (1 (|z x|,TRUE))
