The binomial test is a non-parametric test for a difference in proportion between a sample and hypothesised proportion.
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 nominal or ordinal scale variable containing two groups.
When entering new data we recommend using New Dataset to create a new 1 variable (categorical) 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 Distribution then click Binomial.
The report shows the number of observations analysed, number of missing values excluded, summary statistics for the sample, and the hypothesised proportion.
The observed proportion of the group in the sample and confidence interval are shown, with a hypothesis test. The p-value is the probability of rejecting the null hypothesis, that the proportion of the group in the sample is the same as the hypothesised proportion, when it is in fact true. A significant p-value implies the observed proportion in the sample differs from the hypothesised proportion.
METHOD An exact p-value and confidence interval are calculated (see [1] or [2]). The p-value and confidence interval both exploit the mathematical link between the Binomial and F distribution (Clopper-Pearson method) and so are able to provide exact p-values for small and large samples. The 2-tailed p-value is computed as 2 x 1-tailed p-value.