Summary categorical presents a statistical and visual overview of a categorical sample.
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.
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 Summary Categorical.
The report shows the number of observations analysed and the number of missing values excluded.
The mode (the most frequently occurring group), and a frequency table of the frequency and proportion of observations in each group are shown.
The frequency distribution plot (see below) visually shows the frequencies of each group.
We've been developing intuitive high-quality statistical software at an affordable price, backed up by fast friendly customer service for over 25 years...
Office hours: 9am-5pm GMT Mon-Fri
It's Tuesday 5:02 PM and the office is closed - e-mail us and we'll get back to you as soon as possible.