Wednesday, September 03, 2014

New Video: "How To... Calculate a z-Score in Excel 2010 "

The One-Sample Z-Test is one of the commonest and easiest of statistical test - it is mostly use to determine the accuracy of a sample when compared to a population (by comparing the means of each). The formula that is used is as follows:

Z = ( - µ)/(σ√N)


    x̄ is the mean of the sample
    µ is the mean of the population
    σ is the standard deviation of the population
    N is the number of measures in sample

If the population standard deviation (σ) is unknown, the sample standard deviation (s) can be used instead. Below in my latest video I outline how to do this test in Excel.

No comments:

Post a Comment