Not enough info here. What are your variables
called and what are their categories (values)? Can you send a sample data
set of say 20 cases?
Think about
crosstabs type by programs
.
. . .or whatever your vars are called.
Someone else will be better at
graphics.
----- Original Message -----
Sent: Friday, July 09, 2010 5:09 PM
Subject: problems creating tables
Dear Listers:
I have data from a survey of just under 100 social service agencies. Each
record contains the data for a single agency.
The agencies have been categorized into 5 groups.
The questions have mutually exclusive answers, e.g., each agency may
offer one, two or three programs.
I would like
to produce a table that shows the responses for the groups and for
all agencies. For example, for the question "How many programs does your
agency offer?" I would like to produce the table below with # and column
%:
|
Number of programs offered |
|
Group 1 Agencies |
Group 2 Agencies |
Group 3 Agencies |
Group 4 Agencies |
Group 5 Agencies |
All Agencies |
| One |
|
|
|
|
|
|
| Two |
|
|
|
|
|
|
| Three |
|
|
|
|
|
|
I would also like to produce a graph showing the above information
(%'s) in visual format.
I'm stumped as to how to produce either the table or the graph. I
thought about using AGGREGATE but I need to save the distribution for each
category (i.e., % of One program agencies, % of Two program agencies, % of
Three program agencies).
Any help would be appreciated. I'm using v17.
TIA
Pat
Locked
