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 = (x̄ - µ)/(σ√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.