SPSSX Discussion

T Test and Charts

Classic

List

Threaded

7 messages Options

behnaz shirazi-2

T Test and Charts

Hello dear all

Do you have any idea how can I have charts based on T-TEST.I have 8
variables which I compare them from entry to program and exit from program
as follow:

T-TEST
PAIRS= RgSchlT1 WITH lscafsch (PAIRED)
/CRITERIA=CIN(.95).

T-TEST
PAIRS=RtngHmT1 WITH lscafhom (PAIRED)
/CRITERIA=CIN(.95).

T-TEST
PAIRS= RgCmnTt1 WITH lscafcom (PAIRED)
/CRITERIA=CIN(.95).

T-TEST
PAIRS= RgBhvrT1 WITH lscafbeh (PAIRED)
/CRITERIA=CIN(.95).

T-TEST
PAIRS= RtngMdT1 WITH lscafmod (PAIRED)
/CRITERIA=CIN(.95).

T-TEST
PAIRS= RngHrmT1 WITH lscafhar (PAIRED)
/CRITERIA=CIN(.95).

T-TEST
PAIRS= RSstncT1 WITH lscafsub (PAIRED)
/CRITERIA=CIN(.95).

T-TEST
PAIRS= RTnkngT1 WITH lscafthk (PAIRED)
/CRITERIA=CIN(.95).

I need to have a chart for this output but I don't know what to do?

Thank you
Behnaz Shirazi

_________________________________________________________________
Don't just search. Find. Check out the new MSN Search!
http://search.msn.click-url.com/go/onm00200636ave/direct/01/

King Douglas

Stacked bar chart, two variables, percentages

Folks,

I'm assisting (poorly) a colleague who is using SPSS 13.

I'm a complete dummy when it comes to building charts in SPSS.
What my colleague needs is several variables summarized in several stacked bars on a single chart, summarizing percentages of cases.

Sample data using just two variables, hoping to expand the solution to about six variables:

Job Boss
1 3
2 1
3 2
1 3
2 1
3 2
1 3
2 1
3 2

Values (identical for all variables)
1 = Low
2 = Medium
3 = High

My colleague needs two stacked bars where each bar represents the percentage of Low, Medium and High scores for each variable (in this case it's 33.3% per category per variable). If I were to create only a single stacked bar for "Job", I could use this (pasted) IGRAPH command:

IGRAPH
/VIEWNAME='Bar Chart'
/Y = $pct
/COLOR = VAR(Job) TYPE = CATEGORICAL STACK
/COORDINATE = VERTICAL
/X1LENGTH=3.0
/YLENGTH=3.0
/X2LENGTH=3.0
/CHARTLOOK='NONE'
/CATORDER VAR (My_Job) (ASCENDING VALUES OMITEMPTY)
/BAR KEY=ON SHAPE = RECTANGLE BASELINE = AUTO.

I've tried everything possible, so far as I can see (in Version 15), including Interactive Charts and the Chart Builder, and changing the variable levels. Why does this have to be so opaque (to me, anyway)?

Any pointers will be gratefully accepted.

Thanks

King Douglas
American Airlines Customer Research

Bob Schacht-3

Re: Stacked bar chart, two variables, percentages

At 12:13 PM 5/31/2007, King Douglas wrote:
>Folks,
>
>I'm assisting (poorly) a colleague who is using SPSS 13.
>
>I'm a complete dummy when it comes to building charts in SPSS.
>What my colleague needs is several variables summarized in several stacked
>bars on a single chart, summarizing percentages of cases.

The trick I think is to start the chart in IGRAPH, and then click on the
output, which allows you to edit the configuration of the output in amazing
ways. I think you can even re-define the variables involved. I had a
similar problem with stacked bar charts, and that's what I was told. Works
like a charm.

Bob in HI

>Sample data using just two variables, hoping to expand the solution to
>about six variables:
>
>Job Boss
> 1 3
> 2 1
> 3 2
> 1 3
> 2 1
> 3 2
> 1 3
> 2 1
> 3 2
>
>Values (identical for all variables)
>1 = Low
>2 = Medium
>3 = High
>
>My colleague needs two stacked bars where each bar represents the
>percentage of Low, Medium and High scores for each variable (in this case
>it's 33.3% per category per variable). If I were to create only a single
>stacked bar for "Job", I could use this (pasted) IGRAPH command:
>
>IGRAPH
> /VIEWNAME='Bar Chart'
> /Y = $pct
> /COLOR = VAR(Job) TYPE = CATEGORICAL STACK
> /COORDINATE = VERTICAL
> /X1LENGTH=3.0
> /YLENGTH=3.0
> /X2LENGTH=3.0
> /CHARTLOOK='NONE'
> /CATORDER VAR (My_Job) (ASCENDING VALUES OMITEMPTY)
> /BAR KEY=ON SHAPE = RECTANGLE BASELINE = AUTO.
>
>I've tried everything possible, so far as I can see (in Version 15),
>including Interactive Charts and the Chart Builder, and changing the
>variable levels. Why does this have to be so opaque (to me, anyway)?
>
>Any pointers will be gratefully accepted.
>
>Thanks
>
>King Douglas
>American Airlines Customer Research

King Douglas

Re: Stacked bar chart, two variables, percentages

Thanks, Bob.

My colleague has many similar charts to build, which will be recreated
quarterly, so is looking for a syntax-like solution. I'll give your
suggestion a try though, just to learn more about charts.

Thanks,

King

> -----Original Message-----
> From: SPSSX(r) Discussion [mailto:[hidden email]]On Behalf Of
> Bob Schacht
> Sent: Thursday, May 31, 2007 6:06 PM
> To: [hidden email]
> Subject: Re: Stacked bar chart, two variables, percentages
>
>
> At 12:13 PM 5/31/2007, King Douglas wrote:
> >Folks,
> >
> >I'm assisting (poorly) a colleague who is using SPSS 13.
> >
> >I'm a complete dummy when it comes to building charts in SPSS.
> >What my colleague needs is several variables summarized in
> several stacked
> >bars on a single chart, summarizing percentages of cases.
>
> The trick I think is to start the chart in IGRAPH, and then click on the
> output, which allows you to edit the configuration of the output
> in amazing
> ways. I think you can even re-define the variables involved. I had a
> similar problem with stacked bar charts, and that's what I was told. Works
> like a charm.
>
> Bob in HI
>
>
> >Sample data using just two variables, hoping to expand the solution to
> >about six variables:
> >
> >Job Boss
> > 1 3
> > 2 1
> > 3 2
> > 1 3
> > 2 1
> > 3 2
> > 1 3
> > 2 1
> > 3 2
> >
> >Values (identical for all variables)
> >1 = Low
> >2 = Medium
> >3 = High
> >
> >My colleague needs two stacked bars where each bar represents the
> >percentage of Low, Medium and High scores for each variable (in this case
> >it's 33.3% per category per variable). If I were to create only a single
> >stacked bar for "Job", I could use this (pasted) IGRAPH command:
> >
> >IGRAPH
> > /VIEWNAME='Bar Chart'
> > /Y = $pct
> > /COLOR = VAR(Job) TYPE = CATEGORICAL STACK
> > /COORDINATE = VERTICAL
> > /X1LENGTH=3.0
> > /YLENGTH=3.0
> > /X2LENGTH=3.0
> > /CHARTLOOK='NONE'
> > /CATORDER VAR (My_Job) (ASCENDING VALUES OMITEMPTY)
> > /BAR KEY=ON SHAPE = RECTANGLE BASELINE = AUTO.
> >
> >I've tried everything possible, so far as I can see (in Version 15),
> >including Interactive Charts and the Chart Builder, and changing the
> >variable levels. Why does this have to be so opaque (to me, anyway)?
> >
> >Any pointers will be gratefully accepted.
> >
> >Thanks
> >
> >King Douglas
> >American Airlines Customer Research

ViAnn Beadle

Re: Stacked bar chart, two variables, percentages

Your colleague could do this via syntax and even have the charts look good
if he had SPSS 15. I can send you an example off-list (once I find it ;-))
if you want to see it.

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
King Douglas
Sent: Friday, June 01, 2007 7:39 AM
To: [hidden email]
Subject: Re: Stacked bar chart, two variables, percentages

Thanks, Bob.

My colleague has many similar charts to build, which will be recreated
quarterly, so is looking for a syntax-like solution. I'll give your
suggestion a try though, just to learn more about charts.

Thanks,

King

King Douglas

Re: Stacked bar chart, two variables, percentages

ViAnn,

Well, I have SPSS 15 (although I couldn't find a solution) and could run the
syntax for her. Once it is complete, it won't be any bother.

I'd be very grateful if you'd take a look and see what you can find. While
you're at it, try to remember the steps so you can provide a little
tutorial, if you don't mind, on where to point/click. I'm a syntax guy
myself, but it doesn't hurt to know how to get SPSS to paste syntax now and
then.

With much appreciation,

King Douglas
American Airlines Customer Research

> -----Original Message-----
> From: SPSSX(r) Discussion [mailto:[hidden email]]On Behalf Of
> ViAnn Beadle
> Sent: Friday, June 01, 2007 9:34 AM
> To: [hidden email]
> Subject: Re: Stacked bar chart, two variables, percentages
>
>
> Your colleague could do this via syntax and even have the charts look good
> if he had SPSS 15. I can send you an example off-list (once I find it ;-))
> if you want to see it.
>
> -----Original Message-----
> From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
> King Douglas
> Sent: Friday, June 01, 2007 7:39 AM
> To: [hidden email]
> Subject: Re: Stacked bar chart, two variables, percentages
>
> Thanks, Bob.
>
> My colleague has many similar charts to build, which will be recreated
> quarterly, so is looking for a syntax-like solution. I'll give your
> suggestion a try though, just to learn more about charts.
>
> Thanks,
>
> King
>
> > -----Original Message-----
> > From: SPSSX(r) Discussion [mailto:[hidden email]]On Behalf Of
> > Bob Schacht
> > Sent: Thursday, May 31, 2007 6:06 PM
> > To: [hidden email]
> > Subject: Re: Stacked bar chart, two variables, percentages
> >
> >
> > At 12:13 PM 5/31/2007, King Douglas wrote:
> > >Folks,
> > >
> > >I'm assisting (poorly) a colleague who is using SPSS 13.
> > >
> > >I'm a complete dummy when it comes to building charts in SPSS.
> > >What my colleague needs is several variables summarized in
> > several stacked
> > >bars on a single chart, summarizing percentages of cases.
> >
> > The trick I think is to start the chart in IGRAPH, and then click on the
> > output, which allows you to edit the configuration of the output
> > in amazing
> > ways. I think you can even re-define the variables involved. I had a
> > similar problem with stacked bar charts, and that's what I was
> told. Works
> > like a charm.
> >
> > Bob in HI
> >
> >
> > >Sample data using just two variables, hoping to expand the solution to
> > >about six variables:
> > >
> > >Job Boss
> > > 1 3
> > > 2 1
> > > 3 2
> > > 1 3
> > > 2 1
> > > 3 2
> > > 1 3
> > > 2 1
> > > 3 2
> > >
> > >Values (identical for all variables)
> > >1 = Low
> > >2 = Medium
> > >3 = High
> > >
> > >My colleague needs two stacked bars where each bar represents the
> > >percentage of Low, Medium and High scores for each variable
> (in this case
> > >it's 33.3% per category per variable). If I were to create
> only a single
> > >stacked bar for "Job", I could use this (pasted) IGRAPH command:
> > >
> > >IGRAPH
> > > /VIEWNAME='Bar Chart'
> > > /Y = $pct
> > > /COLOR = VAR(Job) TYPE = CATEGORICAL STACK
> > > /COORDINATE = VERTICAL
> > > /X1LENGTH=3.0
> > > /YLENGTH=3.0
> > > /X2LENGTH=3.0
> > > /CHARTLOOK='NONE'
> > > /CATORDER VAR (My_Job) (ASCENDING VALUES OMITEMPTY)
> > > /BAR KEY=ON SHAPE = RECTANGLE BASELINE = AUTO.
> > >
> > >I've tried everything possible, so far as I can see (in Version 15),
> > >including Interactive Charts and the Chart Builder, and changing the
> > >variable levels. Why does this have to be so opaque (to me, anyway)?
> > >
> > >Any pointers will be gratefully accepted.
> > >
> > >Thanks
> > >
> > >King Douglas
> > >American Airlines Customer Research

ViAnn Beadle

Re: Stacked bar chart, two variables, percentages

There is no pasting here from Chart Builder--I started my GPL from Chart
Builder but that produced only about 50% of the base code specified in this
GGRAPH and GPL command and some of the generated code here is not really
necessary. It's probably easier for your colleague to edit the syntax
supplied rather than do what I did.

This syntax assumes that the variables to be plotted are categorical and
have similar coding (only one legend is supplied). I think this is a valid
assumption, otherwise why bother putting radically dissimilar variables into
one graph?

Run this against the 1991 GSS sample file which comes with SPSS:

GGRAPH
/GRAPHDATASET NAME="graphdataset" VARIABLES=hlth1 hlth2 hlth3 hlth4 hlth5

MISSING=LISTWISE REPORTMISSING=NO
/GRAPHSPEC SOURCE=INLINE.
BEGIN GPL
SOURCE: s=userSource(id("graphdataset"))
DATA: hlth1=col(source(s), name("hlth1"), unit.category())
DATA: hlth2=col(source(s), name("hlth2"), unit.category())
DATA: hlth3=col(source(s), name("hlth3"), unit.category())
DATA: hlth4=col(source(s), name("hlth4"), unit.category())
DATA: hlth5=col(source(s), name("hlth5"), unit.category())
GUIDE: axis(dim(1), label("Highest Year of School Completed"))
GUIDE: axis(dim(2), label("Percent"))
GUIDE: legend(aesthetic(aesthetic.color.interior), label("Health Problems
in Last Year"))
SCALE: linear(dim(2), include(0))
ELEMENT: interval.stack(position(summary.percent.count(("Ill Enough to Go
to a Doctor"),
base.coordinate(dim(1)))), color.interior(hlth1),
shape.interior(shape.square))
ELEMENT: interval.stack(position(summary.percent.count(("Counselling for
Mental Problems"),
base.coordinate(dim(1)))), color.interior(hlth2),
shape.interior(shape.square))
ELEMENT: interval.stack(position(summary.percent.count(("Infertility,
Unable to Have a Baby"),
base.coordinate(dim(1)))), color.interior(hlth3),
shape.interior(shape.square))
ELEMENT: interval.stack(position(summary.percent.count(("Drinking
Problem"),
base.coordinate(dim(1)))), color.interior(hlth4),
shape.interior(shape.square))
ELEMENT: interval.stack(position(summary.percent.count(("Illegal Drugs
(Marijuana, Cocaine)"),
base.coordinate(dim(1)))), color.interior(hlth5),
shape.interior(shape.square))
END GPL.

Notes:
* name all the variables to be included on the /GRAPHDATASET subcommand.
* name all the variables on a DATA statement, substituting the appropriate
names to the statement and to the name function.
* use one ELEMENT statement for each variable. Provide a descriptive label
for each variable to get a nice axis label for that stacked bar.
* specify the variable name to the color.interior function--this is what
produces the segments in the stack.

-----Original Message-----
From: King Douglas [mailto:[hidden email]]
Sent: Friday, June 01, 2007 8:47 AM
To: ViAnn Beadle; [hidden email]
Subject: RE: Stacked bar chart, two variables, percentages

ViAnn,

Well, I have SPSS 15 (although I couldn't find a solution) and could run the
syntax for her. Once it is complete, it won't be any bother.

I'd be very grateful if you'd take a look and see what you can find. While
you're at it, try to remember the steps so you can provide a little
tutorial, if you don't mind, on where to point/click. I'm a syntax guy
myself, but it doesn't hurt to know how to get SPSS to paste syntax now and
then.

With much appreciation,

King Douglas
American Airlines Customer Research