Using Excel, Chapter 8: Hypothesis Testing - One Sample

← Back to document page

1Using 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 Proportion2The functions demonstrated here use the standard normal (z) distribution. Chapter - Hypothesis Tests About a Mean: Not Known (t-test)3The functions demonstrated here use thet-distribution. Chapter - Hypothesis Tests About a Mean: Known4The 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 inver

Chapter 8.2 - Hypothesis Testing About a Proportion Notation { Test Statistic = z ^p = p^ p q pq n { Signi cance Level = (in decimal form) { Critical Values = z or z =2 Finding Critical Values Here we use the NORM.S.INV function. NORM.S.INV stands for the inverse of the standard normal distribution (z-distribution).

  Using, Testing, Hypothesis, Hypothesis testing