Excel 2013 Statistical Analysis #54: 1 Tail Left Mean Hypothesis Z Test: P-value & Critical Value HD

Download files: http://people.highline.edu/mgirvin/excelisfun.htm Example of 1 tail test on the left (lower end) for mean catchup bottle weight when consumer group suspects that mean weight is below advertised amount, using critical value and p-value. See the Excel functions: COUNT, AVERAGE, ROUND, NORM.S.DIST and NORM.S.INV