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

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

[excelisfun]

Excel 2013 Statistical Analysis #54: 1 Tail Left Mean Hypothesis Z Test: P-value & Critical Value
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

[KishanDobariya_KD]

As we have sample data of catchup .... cant we find sample SD??