This procedure is available in both the Analyse-it Standard and the Analyse-it Method Evaluation edition
The one sample z-test is a test for a difference in mean between a sample and hypothesised mean, when the population standard deviation is known.
The requirements of the test are:
Data in existing Excel worksheets can be used and should be arranged in a List dataset layout. The dataset must contain a continuous scale variable.
When entering new data we recommend using New Dataset to create a new 1 variable dataset ready for data entry.
To start the test:
Excel 97, 2000, 2002 & 2003:
Select any cell in the range containing the dataset to analyse, then click Analyse on the Analyse-it toolbar, click Describe then click z-test.
The report shows the number of observations analysed, number of missing values excluded, summary statistics for the sample, and the hypothesised mean and population standard deviation.
The mean of the sample and confidence interval are shown.
The Z statistic and hypothesis test are shown. The p-value is the probability of rejecting the null hypothesis, that the sample mean is the same as the hypothesised mean, when it is in fact true. A significant p-value implies that the sample mean is different from the hypothesised mean.
Analyse-it is the leading statistics software for Microsoft Excel. First released in 1997, Analyse-it surpasses traditional statistical software in ease of use, features and price. Over 25,000 customers now rely on Analyse-it for in-depth statistical analysis and visualization in Excel.