Fwd: FW: [SPSSX-L] problems creating tables

[Spice Weasel]

John

 

You're right.  A simple cross tab will do what I want.  I was trying to make it far more complicated than was necessary. 

 

My only excuse is that it's been extremely hot here this week and I'm not thinking very clearly.

 

Many thanks.

From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of John F Hall
Sent: July 9, 2010 11:58 AM
To: [hidden email]
Subject: Re: [SPSSX-L] problems creating tables

 

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 -----

From: [hidden email]

To: [hidden email]

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

[John F Hall]

32.5°C here as well.  Everyone wilting and praying for rain.

 

Check out the SPSS tutorials on my website

----- Original Message -----

From: [hidden email]

To: [hidden email] ; [hidden email]

Sent: Friday, July 09, 2010 7:10 PM

Subject: Fwd: FW: [SPSSX-L] problems creating tables

John

 

You're right.  A simple cross tab will do what I want.  I was trying to make it far more complicated than was necessary. 

 

My only excuse is that it's been extremely hot here this week and I'm not thinking very clearly.

 

Many thanks.

From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of John F Hall
Sent: July 9, 2010 11:58 AM
To: [hidden email]
Subject: Re: [SPSSX-L] problems creating tables

 

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 -----

From: [hidden email]

To: [hidden email]

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