Question Description
Excel functions – Excel does not always have a straight-forward way of getting the test statistic and p- value for a one-sample test of hypotheses. The commands below should work. In each case replace data range with a valid Excel cell reference, e.g. A12:A37.
Z-test ( known)
o To test: 0 : = 0 versus : > 0
=z.test(data range, 0, ) – This finds the p-value of the test =norm.s.inv(1–pvalue) – This finds the test statistic
o To test: 0 : = 0 versus
OR
PayPal Gateway not configured
OR
PayPal Gateway not configured