From: Automatic digest processor <[hidden email]>
Subject: SPSSX-L Digest - 10 May 2009 to 11 May 2009 (#2009-132)
To: "Recipients of SPSSX-L digests" <[hidden email]>
Date: Tuesday, May 12,
2009, 12:00 AM
There are 29 messages totalling 3290 lines in this issue.
Topics of the day:
1. <No subject given> (3)
2. unsuscribe
3. creating new variables (2)
4. Export to NeoOffice/OpenOffice formats (3)
5. SPSS SYNTAX AND MACROS WORKSHOPS FOR 1ST & 2ND JULY ARE NOW FULLY
BOOKED
6. Regression Analysis (5)
7. Statistics Flow-chart updated
8. hypothesis testing for difference between two means (2)
9. Tetrachoric Correlations (3)
10. ROC Area under the Curve (2)
11. Selection of cases based on date variable (2)
12. about transposing-help (2)
13. V16 Examine procedure
14. Z-test in SPSS (was: Re: hypothesis testing for difference between two
means)
=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send
the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD
----------------------------------------------------------------------
Date: Mon, 11 May 2009 00:20:25 -0400
From: ksairam reddy <[hidden email]>
Subject: <No subject given>
--_b643d2e8-4ea5-4eb4-9571-493f534c0d6b_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
UNSUBSCRIBE
_________________________________________________________________
Hotmail=AE has a new way to see what's up with your friends.
http://windowslive.com/Tutorial/Hotmail/WhatsNew?ocid=3DTXT_TAGLM_WL_HM_Tut=
orial_WhatsNew1_052009=
--_b643d2e8-4ea5-4eb4-9571-493f534c0d6b_
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<html>
<head>
<style>
.hmmessage
P
{
margin:0px=3B
padding:0px
}
body.hmmessage
{
font-size: 10pt=3B
font-family:Verdana
}
</style>
</head>
<body class=3D'hmmessage'>
UNSUBSCRIBE<br /><hr />Hotmail=AE has a new way to see what's
up with your =
friends. <a
href=3D'http://windowslive.com/Tutorial/Hotmail/WhatsNew?ocid=
=3DTXT_TAGLM_WL_HM_Tutorial_WhatsNew1_052009'
target=3D'_new'>Check it out.=
</a></body>
</html>=
--_b643d2e8-4ea5-4eb4-9571-493f534c0d6b_--
------------------------------
Date: Sun, 10 May 2009 23:25:14 -0500
From: Bertol <[hidden email]>
Subject: unsuscribe
--00504502dc426294a204699b5de3
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
--00504502dc426294a204699b5de3
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding:
7bit
<br>
--00504502dc426294a204699b5de3--
------------------------------
Date: Mon, 11 May 2009 06:31:16 +0000
From: abdelrhman elmubarak <[hidden email]>
Subject: Re: creating new variables
--_ec278c25-8b9a-430b-a697-5dfaf47b04e3_
Content-Type: text/plain; charset="windows-1256"
Content-Transfer-Encoding: 8bit
thanks Melissa
I am finding difficulty if there are more than one possible extra repair on the
same day , your synatx work very fine if there are one repair on the same
day...any help is higly appreciated.
thanks
Abdulrahman
Date: Thu, 7 May 2009 09:14:37 -0500
From: [hidden email]
Subject: Re: creating new variables
To: [hidden email]
One way would be to use the sort function so that the 209 record is last. (it
may help to create a dichotomy for rep209=1 or 0 if not--something
like this
would be needed if there are >2 repairs in a day)
Then do a lag function to create morejobs and moremoney.
THE FOLLOWING ASSUMES that no client has >2 repairs in a day AND 209 is the
highest repair value.
sort cases by id repdate reptype.
if (id=lag(id) and repdate=lag(repdate) and reptype=209) morejobs=1.
if ((id ne lag(id) or repdate ne lag(repdate)) and reptype=209) morejobs=0.
if (id=lag(id) and repdate=lag(repdate) and reptype=209) moremoney=lag(money).
The actual syntax will differ if there are more than one possible extra repairs
on the same date (i.e. one id could have 3+ per day), but similar logic should
work.
HTH,
Melissa
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
abdelrhman elmubarak
Sent: Thursday, May 07, 2009 3:36 AM
To: [hidden email]
Subject: [SPSSX-L] creating
new variables
Hi
my data looks as below
id
Repair Date
Repair Type
money
16
20090430
115
23
30
20090325
209
45
30
20090124
103
62
47
20090409
209
78
47
20090409
101
69
I want to create two more variables for those who did repair type 209…the
purpose is to know did they did more jobs on the same day of their visit and
what the money generated from that ….at the final my data should be look as
below
id
Repair Date
Repair Type
money
more jobs plus
more money
plus
16
20090430
115
23
30
20090325
209
45
0
30
20090124
103
62
47
20090409
209
78
1
69
47
20090409
101
69
I can explain more if it is required
Thanks in advance
Abdulrahman
Invite your mail contacts to join your friends list with Windows Live Spaces.
It's easy! Try it!
Invite your mail contacts to join your friends list with Windows Live Spaces.
It's easy! Try it!
PRIVILEGED AND CONFIDENTIAL INFORMATION
This transmittal and any attachments may contain PRIVILEGED AND
CONFIDENTIAL information and is intended only for the use of the
addressee. If you are not the designated recipient, or an employee
or agent authorized to deliver such transmittals
to the designated
recipient, you are hereby notified that any dissemination,
copying or publication of this transmittal is strictly prohibited. If
you have received this transmittal in error, please notify us
immediately by replying to the sender and delete this copy from your
system. You may also call us at (309) 827-6026 for assistance.
_________________________________________________________________
Drag n’ drop—Get easy photo sharing with Windows Live™ Photos.
http://www.microsoft.com/windows/windowslive/products/photos.aspx
--_ec278c25-8b9a-430b-a697-5dfaf47b04e3_
Content-Type: text/html; charset="windows-1256"
Content-Transfer-Encoding: 8bit
<html>
<head>
<style>
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Verdana
}
</style>
</head>
<body class='hmmessage'>
thanks
Melissa <BR>
I am finding difficulty if there are more than one possible extra repair on the
same day , your synatx work very fine if there are one repair on the
same day...any help is higly appreciated.<BR>
thanks<BR>
Abdulrahman<BR> <BR>
<HR id=stopSpelling>
Date: Thu, 7 May 2009 09:14:37 -0500<BR>From:
[hidden email]<BR>Subject: Re: creating new variables<BR>To:
[hidden email]<BR><BR>
<STYLE>
.ExternalClass .EC_hmmessage P
{padding-right:0px;padding-left:0px;padding-bottom:0px;padding-top:0px;}
.ExternalClass BODY.EC_hmmessage
{font-size:10pt;font-family:Verdana;}
</STYLE>
<DIV dir=ltr align=left><SPAN class=EC_353335913-07052009><FONT
face=Arial color=#0000ff>One way would be to
u</FONT></SPAN><SPAN class=EC_353335913-07052009><FONT
face=Arial
color=#0000ff>se the sort function so that the 209 record is
last. (it may help to create a dichotomy for rep209=1 or 0 if
not--something like this would be needed if there are >2 repairs in a
day)</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=EC_353335913-07052009><FONT
face=Arial color=#0000ff>Then do a lag function to create morejobs and
moremoney.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=EC_353335913-07052009><FONT
face=Arial color=#0000ff></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=EC_353335913-07052009><FONT
face=Arial color=#0000ff>THE FOLLOWING ASSUMES that no client has
>2 repairs in a day AND 209 is the highest repair
value.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN
class=EC_353335913-07052009><FONT
face=Arial color=#0000ff></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=EC_353335913-07052009><FONT
face=Arial color=#0000ff><FONT size=2>
sort cases by id repdate reptype.<BR>
if (id=lag(id) and repdate=lag(repdate) and reptype=209) morejobs=1.<BR>
if ((id ne lag(id) or repdate ne lag(repdate)) and reptype=209)
morejobs=0.<BR>
if (id=lag(id) and repdate=lag(repdate) and reptype=209)
moremoney=lag(money).<BR>
<BR>
<BR></FONT></FONT></SPAN><SPAN
class=EC_353335913-07052009><FONT face=Arial color=#0000ff><SPAN
class=EC_353335913-07052009></SPAN></DIV>
<DIV dir=ltr align=left>
<DIV dir=ltr align=left><SPAN class=EC_353335913-07052009>The
actual syntax will differ if there are more than
one possible extra repairs on
the same date (i.e. one id could have 3+ per day), but similar logic should
work.</SPAN></DIV>
<DIV dir=ltr align=left><SPAN
class=EC_353335913-07052009></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN
class=EC_353335913-07052009>HTH,</SPAN></DIV>
<DIV dir=ltr align=left><SPAN
class=EC_353335913-07052009>Melissa</SPAN> </FONT></SPAN></DIV></DIV>
<DIV dir=ltr align=left><SPAN class=EC_353335913-07052009><FONT
face=Arial color=#0000ff></FONT></SPAN> </DIV>
<DIV dir=ltr align=left>
<HR>
</DIV>
<DIV dir=ltr align=left><FONT face=Tahoma><B>From:</B>
SPSSX(r) Discussion [mailto:[hidden email]] <B>On Behalf Of
</B>abdelrhman
elmubarak<BR><B>Sent:</B> Thursday, May
07, 2009 3:36 AM<BR><B>To:</B>
[hidden email]<BR><B>Subject:</B> [SPSSX-L] creating
new variables<BR></FONT><BR></DIV>
<DIV></DIV><BR> <BR><BR>
<P class=EC_EC_MsoNormal><FONT
color=#000000>Hi</FONT></P>
<P class=EC_EC_MsoNormal><FONT color=#000000>my data looks as below
</FONT></P>
<P class=EC_EC_MsoNormal><SPAN><FONT
color=#000000></FONT></SPAN> </P>
<TABLE class=EC_EC_MsoNormalTable style="WIDTH: 308pt; BORDER-COLLAPSE:
collapse" cellSpacing=0 cellPadding=0 width=411 border=0>
<TBODY>
<TR style="HEIGHT: 15pt">
<TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORDER-TOP: windowtext 1pt solid;
PADDING-LEFT: 5.4pt; BACKGROUND: #666699;
PADDING-BOTTOM: 0in; BORDER-LEFT: windowtext 1pt solid; WIDTH: 84pt;
PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15pt"
width=112>
<P class=EC_EC_MsoNormal style="LINE-HEIGHT: normal; TEXT-ALIGN:
center" align=center><B><SPAN style="FONT-SIZE: 9pt;
COLOR: white; FONT-FAMILY:
'Arial','sans-serif'">id</SPAN></B><BR></P></TD>
<TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 5.4pt; BACKGROUND: #666699;
PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 70pt; PADDING-TOP: 0in;
BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15pt" width=93>
<P class=EC_EC_MsoNormal style="LINE-HEIGHT: normal; TEXT-ALIGN:
center" align=center><B><SPAN style="FONT-SIZE: 9pt;
COLOR: white; FONT-FAMILY:
'Arial','sans-serif'">Repair
Date</SPAN></B></P></TD>
<TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 5.4pt; BACKGROUND: #666699;
PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 77pt; PADDING-TOP: 0in;
BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15pt" width=103>
<P class=EC_EC_MsoNormal style="LINE-HEIGHT: normal; TEXT-ALIGN:
center" align=center><B><SPAN style="FONT-SIZE: 9pt;
COLOR: white; FONT-FAMILY: 'Arial','sans-serif'">Repair
Type</SPAN></B></P></TD>
<TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 5.4pt; BACKGROUND: #666699;
PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 77pt; PADDING-TOP: 0in;
BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15pt" width=103>
<P class=EC_EC_MsoNormal
style="LINE-HEIGHT: normal; TEXT-ALIGN:
center" align=center><B><SPAN style="FONT-SIZE: 9pt;
COLOR: white; FONT-FAMILY:
'Arial','sans-serif'">money</SPAN></B></P></TD></TR>
<TR style="HEIGHT: 15pt">
<TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM:
0in; BORDER-LEFT: windowtext 1pt solid; WIDTH: 84pt; PADDING-TOP: 0in;
BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15pt" width=112>
<P class=EC_EC_MsoNormal style="LINE-HEIGHT: normal; TEXT-ALIGN:
center" align=center><SPAN style="FONT-SIZE: 9pt; COLOR: black;
FONT-FAMILY:
'Arial','sans-serif'">16</SPAN></P></TD>
<TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM:
0in; BORDER-LEFT:
#ece9d8; WIDTH: 70pt; PADDING-TOP: 0in; BORDER-BOTTOM:
windowtext 1pt solid; HEIGHT: 15pt" width=93>
<P class=EC_EC_MsoNormal style="LINE-HEIGHT: normal; TEXT-ALIGN:
center" align=center><SPAN style="FONT-SIZE: 9pt; COLOR: black;
FONT-FAMILY:
'Arial','sans-serif'">20090430</SPAN></P></TD>
<TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM:
0in; BORDER-LEFT: #ece9d8; WIDTH: 77pt; PADDING-TOP: 0in; BORDER-BOTTOM:
windowtext 1pt solid; HEIGHT: 15pt" width=103>
<P class=EC_EC_MsoNormal style="LINE-HEIGHT: normal; TEXT-ALIGN:
center" align=center><SPAN style="FONT-SIZE: 9pt; COLOR: black;
FONT-FAMILY:
'Arial','sans-serif'">115</SPAN></P></TD>
<TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt;
BACKGROUND: white; PADDING-BOTTOM:
0in; BORDER-LEFT: #ece9d8; WIDTH: 77pt; PADDING-TOP: 0in; BORDER-BOTTOM:
windowtext 1pt solid; HEIGHT: 15pt" width=103>
<P class=EC_EC_MsoNormal style="LINE-HEIGHT: normal; TEXT-ALIGN:
center" align=center><SPAN style="FONT-SIZE: 9pt; COLOR: black;
FONT-FAMILY:
'Arial','sans-serif'">23</SPAN></P></TD></TR>
<TR style="HEIGHT: 15pt">
<TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: yellow; PADDING-BOTTOM:
0in; BORDER-LEFT: windowtext 1pt solid; WIDTH: 84pt; PADDING-TOP: 0in;
BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15pt" width=112>
<P class=EC_EC_MsoNormal style="LINE-HEIGHT: normal; TEXT-ALIGN:
center" align=center><SPAN style="FONT-SIZE: 9pt; COLOR: red;
FONT-FAMILY:
'Arial','sans-serif'">30</SPAN></P></TD>
<TD
style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: yellow; PADDING-BOTTOM:
0in; BORDER-LEFT: #ece9d8; WIDTH: 70pt; PADDING-TOP: 0in; BORDER-BOTTOM:
windowtext 1pt solid; HEIGHT: 15pt" width=93>
<P class=EC_EC_MsoNormal style="LINE-HEIGHT: normal; TEXT-ALIGN:
center" align=center><SPAN style="FONT-SIZE: 9pt; COLOR: red;
FONT-FAMILY:
'Arial','sans-serif'">20090325</SPAN></P></TD>
<TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: yellow; PADDING-BOTTOM:
0in; BORDER-LEFT: #ece9d8; WIDTH: 77pt; PADDING-TOP: 0in; BORDER-BOTTOM:
windowtext 1pt solid; HEIGHT: 15pt" width=103>
<P class=EC_EC_MsoNormal style="LINE-HEIGHT: normal; TEXT-ALIGN:
center" align=center><SPAN style="FONT-SIZE: 9pt; COLOR:
red;
FONT-FAMILY:
'Arial','sans-serif'">209</SPAN></P></TD>
<TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: yellow; PADDING-BOTTOM:
0in; BORDER-LEFT: #ece9d8; WIDTH: 77pt; PADDING-TOP: 0in; BORDER-BOTTOM:
windowtext 1pt solid; HEIGHT: 15pt" width=103>
<P class=EC_EC_MsoNormal style="LINE-HEIGHT: normal; TEXT-ALIGN:
center" align=center><SPAN style="FONT-SIZE: 9pt; COLOR: red;
FONT-FAMILY:
'Arial','sans-serif'">45</SPAN></P></TD></TR>
<TR style="HEIGHT: 15pt">
<TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM:
0in; BORDER-LEFT: windowtext 1pt solid; WIDTH: 84pt; PADDING-TOP: 0in;
BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15pt" width=112>
<P
class=EC_EC_MsoNormal style="LINE-HEIGHT: normal; TEXT-ALIGN:
center" align=center><SPAN style="FONT-SIZE: 9pt; COLOR: black;
FONT-FAMILY:
'Arial','sans-serif'">30</SPAN></P></TD>
<TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM:
0in; BORDER-LEFT: #ece9d8; WIDTH: 70pt; PADDING-TOP: 0in; BORDER-BOTTOM:
windowtext 1pt solid; HEIGHT: 15pt" width=93>
<P class=EC_EC_MsoNormal style="LINE-HEIGHT: normal; TEXT-ALIGN:
center" align=center><SPAN style="FONT-SIZE: 9pt; COLOR: black;
FONT-FAMILY:
'Arial','sans-serif'">20090124</SPAN></P></TD>
<TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM:
0in; BORDER-LEFT: #ece9d8; WIDTH: 77pt; PADDING-TOP: 0in;
BORDER-BOTTOM:
windowtext 1pt solid; HEIGHT: 15pt" width=103>
<P class=EC_EC_MsoNormal style="LINE-HEIGHT: normal; TEXT-ALIGN:
center" align=center><SPAN style="FONT-SIZE: 9pt; COLOR: black;
FONT-FAMILY:
'Arial','sans-serif'">103</SPAN></P></TD>
<TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM:
0in; BORDER-LEFT: #ece9d8; WIDTH: 77pt; PADDING-TOP: 0in; BORDER-BOTTOM:
windowtext 1pt solid; HEIGHT: 15pt" width=103>
<P class=EC_EC_MsoNormal style="LINE-HEIGHT: normal; TEXT-ALIGN:
center" align=center><SPAN style="FONT-SIZE: 9pt; COLOR: black;
FONT-FAMILY:
'Arial','sans-serif'">62</SPAN></P></TD></TR>
<TR style="HEIGHT: 15pt">
<TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORDER-TOP: #ece9d8; PADDING-LEFT:
5.4pt; BACKGROUND: yellow; PADDING-BOTTOM:
0in; BORDER-LEFT: windowtext 1pt solid; WIDTH: 84pt; PADDING-TOP: 0in;
BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15pt" width=112>
<P class=EC_EC_MsoNormal style="LINE-HEIGHT: normal; TEXT-ALIGN:
center" align=center><SPAN style="FONT-SIZE: 9pt; COLOR: red;
FONT-FAMILY:
'Arial','sans-serif'">47</SPAN></P></TD>
<TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: yellow; PADDING-BOTTOM:
0in; BORDER-LEFT: #ece9d8; WIDTH: 70pt; PADDING-TOP: 0in; BORDER-BOTTOM:
windowtext 1pt solid; HEIGHT: 15pt" width=93>
<P class=EC_EC_MsoNormal style="LINE-HEIGHT: normal; TEXT-ALIGN:
center" align=center><SPAN style="FONT-SIZE: 9pt; COLOR: red;
FONT-FAMILY:
'Arial','sans-serif'">20090409</SPAN></P></TD>
<TD style="BORDER-RIGHT: windowtext 1pt
solid; PADDING-RIGHT: 5.4pt;
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: yellow; PADDING-BOTTOM:
0in; BORDER-LEFT: #ece9d8; WIDTH: 77pt; PADDING-TOP: 0in; BORDER-BOTTOM:
windowtext 1pt solid; HEIGHT: 15pt" width=103>
<P class=EC_EC_MsoNormal style="LINE-HEIGHT: normal; TEXT-ALIGN:
center" align=center><SPAN style="FONT-SIZE: 9pt; COLOR: red;
FONT-FAMILY:
'Arial','sans-serif'">209</SPAN></P></TD>
<TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: yellow; PADDING-BOTTOM:
0in; BORDER-LEFT: #ece9d8; WIDTH: 77pt; PADDING-TOP: 0in; BORDER-BOTTOM:
windowtext 1pt solid; HEIGHT: 15pt" width=103>
<P class=EC_EC_MsoNormal style="LINE-HEIGHT: normal; TEXT-ALIGN:
center" align=center><SPAN style="FONT-SIZE: 9pt; COLOR:
red;
FONT-FAMILY:
'Arial','sans-serif'">78</SPAN></P></TD></TR>
<TR style="HEIGHT: 15pt">
<TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: yellow; PADDING-BOTTOM:
0in; BORDER-LEFT: windowtext 1pt solid; WIDTH: 84pt; PADDING-TOP: 0in;
BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15pt" width=112>
<P class=EC_EC_MsoNormal style="LINE-HEIGHT: normal; TEXT-ALIGN:
center" align=center><SPAN style="FONT-SIZE: 9pt; COLOR: red;
FONT-FAMILY:
'Arial','sans-serif'">47</SPAN></P></TD>
<TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: yellow; PADDING-BOTTOM:
0in; BORDER-LEFT: #ece9d8; WIDTH: 70pt; PADDING-TOP: 0in; BORDER-BOTTOM:
windowtext 1pt solid; HEIGHT: 15pt" width=93>
<P class=EC_EC_MsoNormal
style="LINE-HEIGHT: normal; TEXT-ALIGN:
center" align=center><SPAN style="FONT-SIZE: 9pt; COLOR: red;
FONT-FAMILY:
'Arial','sans-serif'">20090409</SPAN></P></TD>
<TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM:
0in; BORDER-LEFT: #ece9d8; WIDTH: 77pt; PADDING-TOP: 0in; BORDER-BOTTOM:
windowtext 1pt solid; HEIGHT: 15pt" width=103>
<P class=EC_EC_MsoNormal style="LINE-HEIGHT: normal; TEXT-ALIGN:
center" align=center><SPAN style="FONT-SIZE: 9pt; COLOR: black;
FONT-FAMILY:
'Arial','sans-serif'">101</SPAN></P></TD>
<TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM:
0in; BORDER-LEFT: #ece9d8; WIDTH: 77pt; PADDING-TOP: 0in; BORDER-BOTTOM:
windowtext 1pt solid;
HEIGHT: 15pt" width=103>
<P class=EC_EC_MsoNormal style="LINE-HEIGHT: normal; TEXT-ALIGN:
center" align=center><SPAN style="FONT-SIZE: 9pt; COLOR: black;
FONT-FAMILY:
'Arial','sans-serif'">69</SPAN></P></TD></TR></TBODY></TABLE><BR>
<P class=EC_EC_MsoNormal><FONT
color=#000000></FONT> </P>
<P class=EC_EC_MsoNormal><FONT color=#000000>I want to create two
more variables for those <SPAN> </SPAN>who
<SPAN> </SPAN>did repair type 209…the purpose is to know
did they did more jobs on the same day of their visit and what the money
generated from that ….at the final my data should be look as
below</FONT></P>
<P class=EC_EC_MsoNormal><FONT
color=#000000></FONT> </P>
<TABLE class=EC_EC_MsoNormalTable style="WIDTH: 372pt;
BORDER-COLLAPSE:
collapse" cellSpacing=0 cellPadding=0 width=496 border=0>
<TBODY>
<TR style="HEIGHT: 15pt">
<TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 5.4pt; BACKGROUND: #666699;
PADDING-BOTTOM: 0in; BORDER-LEFT: windowtext 1pt solid; WIDTH: 50pt;
PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15pt"
width=67>
<P class=EC_EC_MsoNormal style="LINE-HEIGHT: normal; TEXT-ALIGN:
center" align=center><B><SPAN style="FONT-SIZE: 9pt;
COLOR: white; FONT-FAMILY:
'Arial','sans-serif'">id</SPAN></B><BR></P></TD>
<TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 5.4pt; BACKGROUND: #666699;
PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 56pt; PADDING-TOP: 0in;
BORDER-BOTTOM: windowtext 1pt
solid; HEIGHT: 15pt" width=75>
<P class=EC_EC_MsoNormal style="LINE-HEIGHT: normal; TEXT-ALIGN:
center" align=center><B><SPAN style="FONT-SIZE: 9pt;
COLOR: white; FONT-FAMILY: 'Arial','sans-serif'">Repair
Date</SPAN></B></P></TD>
<TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 5.4pt; BACKGROUND: #666699;
PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 56pt; PADDING-TOP: 0in;
BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15pt" width=75>
<P class=EC_EC_MsoNormal style="LINE-HEIGHT: normal; TEXT-ALIGN:
center" align=center><B><SPAN style="FONT-SIZE: 9pt;
COLOR: white; FONT-FAMILY: 'Arial','sans-serif'">Repair
Type</SPAN></B></P></TD>
<TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORDER-TOP: windowtext 1pt solid; PADDING-LEFT:
5.4pt; BACKGROUND: #666699;
PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 56pt; PADDING-TOP: 0in;
BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15pt" width=75>
<P class=EC_EC_MsoNormal style="LINE-HEIGHT: normal; TEXT-ALIGN:
center" align=center><B><SPAN style="FONT-SIZE: 9pt;
COLOR: white; FONT-FAMILY:
'Arial','sans-serif'">money</SPAN></B></P></TD>
<TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 5.4pt; BACKGROUND: #666699;
PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 68pt; PADDING-TOP: 0in;
BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15pt" width=91>
<P class=EC_EC_MsoNormal style="LINE-HEIGHT: normal; TEXT-ALIGN:
center" align=center><B><SPAN style="FONT-SIZE: 9pt;
COLOR: white; FONT-FAMILY: 'Arial','sans-serif'">more
jobs plus
</SPAN></B></P></TD>
<TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 5.4pt; BACKGROUND: #666699;
PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 86pt; PADDING-TOP: 0in;
BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15pt" width=115>
<P class=EC_EC_MsoNormal style="LINE-HEIGHT: normal; TEXT-ALIGN:
center" align=center><B><SPAN style="FONT-SIZE: 9pt;
COLOR: white; FONT-FAMILY: 'Arial','sans-serif'">more
money plus</SPAN></B></P></TD></TR>
<TR style="HEIGHT: 15pt">
<TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM:
0in; BORDER-LEFT: windowtext 1pt solid; WIDTH: 50pt; PADDING-TOP: 0in;
BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15pt" width=67>
<P
class=EC_EC_MsoNormal style="LINE-HEIGHT: normal; TEXT-ALIGN:
center" align=center><SPAN style="FONT-SIZE: 9pt; COLOR: black;
FONT-FAMILY:
'Arial','sans-serif'">16</SPAN></P></TD>
<TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM:
0in; BORDER-LEFT: #ece9d8; WIDTH: 56pt; PADDING-TOP: 0in; BORDER-BOTTOM:
windowtext 1pt solid; HEIGHT: 15pt" width=75>
<P class=EC_EC_MsoNormal style="LINE-HEIGHT: normal; TEXT-ALIGN:
center" align=center><SPAN style="FONT-SIZE: 9pt; COLOR: black;
FONT-FAMILY:
'Arial','sans-serif'">20090430</SPAN></P></TD>
<TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM:
0in; BORDER-LEFT: #ece9d8; WIDTH: 56pt; PADDING-TOP: 0in;
BORDER-BOTTOM:
windowtext 1pt solid; HEIGHT: 15pt" width=75>
<P class=EC_EC_MsoNormal style="LINE-HEIGHT: normal; TEXT-ALIGN:
center" align=center><SPAN style="FONT-SIZE: 9pt; COLOR: black;
FONT-FAMILY:
'Arial','sans-serif'">115</SPAN></P></TD>
<TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM:
0in; BORDER-LEFT: #ece9d8; WIDTH: 56pt; PADDING-TOP: 0in; BORDER-BOTTOM:
windowtext 1pt solid; HEIGHT: 15pt" width=75>
<P class=EC_EC_MsoNormal style="LINE-HEIGHT: normal; TEXT-ALIGN:
center" align=center><SPAN style="FONT-SIZE: 9pt; COLOR: black;
FONT-FAMILY:
'Arial','sans-serif'">23</SPAN></P></TD>
<TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT:
#ece9d8;
WIDTH: 68pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid;
HEIGHT: 15pt; BACKGROUND-COLOR: transparent" width=91>
<P class=EC_EC_MsoNormal style="LINE-HEIGHT: normal; TEXT-ALIGN:
center" align=center><SPAN style="COLOR:
black"><SPAN></SPAN></SPAN> </P></TD>
<TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT:
#ece9d8; WIDTH: 86pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid;
HEIGHT: 15pt; BACKGROUND-COLOR: transparent" width=115>
<P class=EC_EC_MsoNormal style="LINE-HEIGHT: normal; TEXT-ALIGN:
center" align=center><SPAN style="COLOR:
black"></SPAN> </P></TD></TR>
<TR style="HEIGHT: 15pt">
<TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORDER-TOP: #ece9d8; PADDING-LEFT:
5.4pt; BACKGROUND: yellow; PADDING-BOTTOM:
0in; BORDER-LEFT: windowtext 1pt solid; WIDTH: 50pt; PADDING-TOP: 0in;
BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15pt" width=67>
<P class=EC_EC_MsoNormal style="LINE-HEIGHT: normal; TEXT-ALIGN:
center" align=center><SPAN style="FONT-SIZE: 9pt; COLOR: red;
FONT-FAMILY:
'Arial','sans-serif'">30</SPAN></P></TD>
<TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: yellow; PADDING-BOTTOM:
0in; BORDER-LEFT: #ece9d8; WIDTH: 56pt; PADDING-TOP: 0in; BORDER-BOTTOM:
windowtext 1pt solid; HEIGHT: 15pt" width=75>
<P class=EC_EC_MsoNormal style="LINE-HEIGHT: normal; TEXT-ALIGN:
center" align=center><SPAN style="FONT-SIZE: 9pt; COLOR: red;
FONT-FAMILY:
'Arial','sans-serif'">20090325</SPAN></P></TD>
<TD style="BORDER-RIGHT: windowtext 1pt
solid; PADDING-RIGHT: 5.4pt;
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: yellow; PADDING-BOTTOM:
0in; BORDER-LEFT: #ece9d8; WIDTH: 56pt; PADDING-TOP: 0in; BORDER-BOTTOM:
windowtext 1pt solid; HEIGHT: 15pt" width=75>
<P class=EC_EC_MsoNormal style="LINE-HEIGHT: normal; TEXT-ALIGN:
center" align=center><SPAN style="FONT-SIZE: 9pt; COLOR: red;
FONT-FAMILY:
'Arial','sans-serif'">209</SPAN></P></TD>
<TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: yellow; PADDING-BOTTOM:
0in; BORDER-LEFT: #ece9d8; WIDTH: 56pt; PADDING-TOP: 0in; BORDER-BOTTOM:
windowtext 1pt solid; HEIGHT: 15pt" width=75>
<P class=EC_EC_MsoNormal style="LINE-HEIGHT: normal; TEXT-ALIGN:
center" align=center><SPAN style="FONT-SIZE: 9pt; COLOR:
red;
FONT-FAMILY:
'Arial','sans-serif'">45</SPAN></P></TD>
<TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: yellow; PADDING-BOTTOM:
0in; BORDER-LEFT: #ece9d8; WIDTH: 68pt; PADDING-TOP: 0in; BORDER-BOTTOM:
windowtext 1pt solid; HEIGHT: 15pt" width=91>
<P class=EC_EC_MsoNormal style="LINE-HEIGHT: normal; TEXT-ALIGN:
center" align=center><SPAN style="COLOR:
red">0</SPAN></P></TD>
<TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT:
#ece9d8; WIDTH: 86pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid;
HEIGHT: 15pt; BACKGROUND-COLOR: transparent" width=115>
<P class=EC_EC_MsoNormal style="LINE-HEIGHT: normal; TEXT-ALIGN:
center" align=center><SPAN
style="COLOR:
black"></SPAN> </P></TD></TR>
<TR style="HEIGHT: 15pt">
<TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM:
0in; BORDER-LEFT: windowtext 1pt solid; WIDTH: 50pt; PADDING-TOP: 0in;
BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15pt" width=67>
<P class=EC_EC_MsoNormal style="LINE-HEIGHT: normal; TEXT-ALIGN:
center" align=center><SPAN style="FONT-SIZE: 9pt; COLOR: black;
FONT-FAMILY:
'Arial','sans-serif'">30</SPAN></P></TD>
<TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM:
0in; BORDER-LEFT: #ece9d8; WIDTH: 56pt; PADDING-TOP: 0in; BORDER-BOTTOM:
windowtext 1pt solid; HEIGHT: 15pt" width=75>
<P class=EC_EC_MsoNormal
style="LINE-HEIGHT: normal; TEXT-ALIGN:
center" align=center><SPAN style="FONT-SIZE: 9pt; COLOR: black;
FONT-FAMILY:
'Arial','sans-serif'">20090124</SPAN></P></TD>
<TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM:
0in; BORDER-LEFT: #ece9d8; WIDTH: 56pt; PADDING-TOP: 0in; BORDER-BOTTOM:
windowtext 1pt solid; HEIGHT: 15pt" width=75>
<P class=EC_EC_MsoNormal style="LINE-HEIGHT: normal; TEXT-ALIGN:
center" align=center><SPAN style="FONT-SIZE: 9pt; COLOR: black;
FONT-FAMILY:
'Arial','sans-serif'">103</SPAN></P></TD>
<TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM:
0in; BORDER-LEFT: #ece9d8; WIDTH: 56pt; PADDING-TOP: 0in; BORDER-BOTTOM:
windowtext 1pt solid;
HEIGHT: 15pt" width=75>
<P class=EC_EC_MsoNormal style="LINE-HEIGHT: normal; TEXT-ALIGN:
center" align=center><SPAN style="FONT-SIZE: 9pt; COLOR: black;
FONT-FAMILY:
'Arial','sans-serif'">62</SPAN></P></TD>
<TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT:
#ece9d8; WIDTH: 68pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid;
HEIGHT: 15pt; BACKGROUND-COLOR: transparent" width=91>
<P class=EC_EC_MsoNormal style="LINE-HEIGHT: normal; TEXT-ALIGN:
center" align=center><SPAN style="COLOR:
black"></SPAN> </P></TD>
<TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT:
#ece9d8; WIDTH: 86pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt
solid;
HEIGHT: 15pt; BACKGROUND-COLOR: transparent" width=115>
<P class=EC_EC_MsoNormal style="LINE-HEIGHT: normal; TEXT-ALIGN:
center" align=center><SPAN style="COLOR:
black"></SPAN> </P></TD></TR>
<TR style="HEIGHT: 15pt">
<TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: yellow; PADDING-BOTTOM:
0in; BORDER-LEFT: windowtext 1pt solid; WIDTH: 50pt; PADDING-TOP: 0in;
BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15pt" width=67>
<P class=EC_EC_MsoNormal style="LINE-HEIGHT: normal; TEXT-ALIGN:
center" align=center><SPAN style="FONT-SIZE: 9pt; COLOR: red;
FONT-FAMILY:
'Arial','sans-serif'">47</SPAN></P></TD>
<TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: yellow;
PADDING-BOTTOM:
0in; BORDER-LEFT: #ece9d8; WIDTH: 56pt; PADDING-TOP: 0in; BORDER-BOTTOM:
windowtext 1pt solid; HEIGHT: 15pt" width=75>
<P class=EC_EC_MsoNormal style="LINE-HEIGHT: normal; TEXT-ALIGN:
center" align=center><SPAN style="FONT-SIZE: 9pt; COLOR: red;
FONT-FAMILY:
'Arial','sans-serif'">20090409</SPAN></P></TD>
<TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: yellow; PADDING-BOTTOM:
0in; BORDER-LEFT: #ece9d8; WIDTH: 56pt; PADDING-TOP: 0in; BORDER-BOTTOM:
windowtext 1pt solid; HEIGHT: 15pt" width=75>
<P class=EC_EC_MsoNormal style="LINE-HEIGHT: normal; TEXT-ALIGN:
center" align=center><SPAN style="FONT-SIZE: 9pt; COLOR: red;
FONT-FAMILY:
'Arial','sans-serif'">209</SPAN></P></TD>
<TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT:
5.4pt;
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: yellow; PADDING-BOTTOM:
0in; BORDER-LEFT: #ece9d8; WIDTH: 56pt; PADDING-TOP: 0in; BORDER-BOTTOM:
windowtext 1pt solid; HEIGHT: 15pt" width=75>
<P class=EC_EC_MsoNormal style="LINE-HEIGHT: normal; TEXT-ALIGN:
center" align=center><SPAN style="FONT-SIZE: 9pt; COLOR: red;
FONT-FAMILY:
'Arial','sans-serif'">78</SPAN></P></TD>
<TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: yellow; PADDING-BOTTOM:
0in; BORDER-LEFT: #ece9d8; WIDTH: 68pt; PADDING-TOP: 0in; BORDER-BOTTOM:
windowtext 1pt solid; HEIGHT: 15pt" width=91>
<P class=EC_EC_MsoNormal style="LINE-HEIGHT: normal; TEXT-ALIGN:
center" align=center><SPAN style="COLOR:
red">1</SPAN></P></TD>
<TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT:
5.4pt;
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: yellow; PADDING-BOTTOM:
0in; BORDER-LEFT: #ece9d8; WIDTH: 86pt; PADDING-TOP: 0in; BORDER-BOTTOM:
windowtext 1pt solid; HEIGHT: 15pt" width=115>
<P class=EC_EC_MsoNormal style="LINE-HEIGHT: normal; TEXT-ALIGN:
center" align=center><SPAN style="FONT-SIZE: 9pt; COLOR: red;
FONT-FAMILY:
'Arial','sans-serif'">69</SPAN></P></TD></TR>
<TR style="HEIGHT: 15pt">
<TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: yellow; PADDING-BOTTOM:
0in; BORDER-LEFT: windowtext 1pt solid; WIDTH: 50pt; PADDING-TOP: 0in;
BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15pt" width=67>
<P class=EC_EC_MsoNormal style="LINE-HEIGHT: normal; TEXT-ALIGN:
center" align=center><SPAN style="FONT-SIZE: 9pt; COLOR:
red;
FONT-FAMILY:
'Arial','sans-serif'">47</SPAN></P></TD>
<TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: yellow; PADDING-BOTTOM:
0in; BORDER-LEFT: #ece9d8; WIDTH: 56pt; PADDING-TOP: 0in; BORDER-BOTTOM:
windowtext 1pt solid; HEIGHT: 15pt" width=75>
<P class=EC_EC_MsoNormal style="LINE-HEIGHT: normal; TEXT-ALIGN:
center" align=center><SPAN style="FONT-SIZE: 9pt; COLOR: red;
FONT-FAMILY:
'Arial','sans-serif'">20090409</SPAN></P></TD>
<TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM:
0in; BORDER-LEFT: #ece9d8; WIDTH: 56pt; PADDING-TOP: 0in; BORDER-BOTTOM:
windowtext 1pt solid; HEIGHT: 15pt" width=75>
<P class=EC_EC_MsoNormal style="LINE-HEIGHT: normal; TEXT-ALIGN:
center"
align=center><SPAN style="FONT-SIZE: 9pt; COLOR: black;
FONT-FAMILY:
'Arial','sans-serif'">101</SPAN></P></TD>
<TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM:
0in; BORDER-LEFT: #ece9d8; WIDTH: 56pt; PADDING-TOP: 0in; BORDER-BOTTOM:
windowtext 1pt solid; HEIGHT: 15pt" width=75>
<P class=EC_EC_MsoNormal style="LINE-HEIGHT: normal; TEXT-ALIGN:
center" align=center><SPAN style="FONT-SIZE: 9pt; COLOR: black;
FONT-FAMILY:
'Arial','sans-serif'">69</SPAN></P></TD>
<TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT:
#ece9d8; WIDTH: 68pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid;
HEIGHT: 15pt; BACKGROUND-COLOR: transparent" width=91>
<P
class=EC_EC_MsoNormal style="LINE-HEIGHT: normal; TEXT-ALIGN:
center" align=center><SPAN style="COLOR:
black"></SPAN> </P></TD>
<TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT:
#ece9d8; WIDTH: 86pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid;
HEIGHT: 15pt; BACKGROUND-COLOR: transparent" width=115>
<P class=EC_EC_MsoNormal style="LINE-HEIGHT: normal; TEXT-ALIGN:
center" align=center><SPAN style="COLOR:
black"></SPAN> </P></TD></TR></TBODY></TABLE><BR>
<P class=EC_EC_MsoNormal><SPAN><FONT
color=#000000></FONT></SPAN> </P>
<P class=EC_EC_MsoNormal><FONT color=#000000>I can explain more if
it is required</FONT></P>
<P
class=EC_EC_MsoNormal><FONT color=#000000>Thanks in
advance</FONT></P>
<P class=EC_EC_MsoNormal><FONT
color=#000000></FONT> </P>
<P class=EC_EC_MsoNormal><FONT
color=#000000>Abdulrahman</FONT></P> <BR><BR>
<HR>
Invite your mail contacts to join your friends list with Windows Live Spaces.
It's easy! <A
href="http://spaces.live.com/spacesapi.aspx?wx_action=create&wx_url=/friends.aspx&mkt=en-us">Try
it!</A><BR>
<HR>
Invite your mail contacts to join your friends list with Windows Live Spaces.
It's easy! <A
href="http://spaces.live.com/spacesapi.aspx?wx_action=create&wx_url=/friends.aspx&mkt=en-us">Try
it!</A> <BR>
<HR>
<FONT face=Arial color=gray size=1>PRIVILEGED AND CONFIDENTIAL
INFORMATION<BR>This
transmittal and any attachments may contain PRIVILEGED
AND<BR>CONFIDENTIAL information and is intended only for the use of
the<BR>addressee. If you are not the designated recipient, or an
employee<BR>or agent authorized to deliver such transmittals to the
designated<BR>recipient, you are hereby notified that any
dissemination,<BR>copying or publication of this transmittal is strictly
prohibited. If<BR>you have received this transmittal in error, please
notify us<BR>immediately by replying to the sender and delete this copy
from your<BR>system. You may also call us at (309) 827-6026 for
assistance.<BR></FONT><br /><hr />What can you do with
the new Windows Live? <a
href='http://www.microsoft.com/windows/windowslive/default.aspx'
target='_new'>Find
out</a></body>
</html>
--_ec278c25-8b9a-430b-a697-5dfaf47b04e3_--
------------------------------
Date: Mon, 11 May 2009 10:30:37 +0200
From: Luca Meyer <[hidden email]>
Subject: Export to NeoOffice/OpenOffice formats
Hi,
Is there someway to export SPSS output directly to NeoOffice or
OpenOffice formats without having to export to MS Office formats first?
Thanks,
Luca
Mr. Luca Meyer
www.lucameyer.com
------------------------------
Date: Mon, 11 May 2009 12:28:04 +0100
From: Peter Watson <[hidden email]>
Subject: SPSS SYNTAX AND MACROS WORKSHOPS FOR 1ST & 2ND JULY ARE NOW FULLY
BOOKED
Dear all,
Please note reservations I have notified people about are STILL VALID.
There are no places currently for people who have NOT heard anything
back from me thus far. If in doubt just
drop me a line.
Many thanks
Peter
--------------------------------------------------------------------------
Peter Watson
MRC Cognition and Brain Sciences Unit
15 Chaucer Road
Cambridge
CB2 7EF
Tel: +44 01223 355294 Ext. 801
Fax: +44 01223 359062
Email: [hidden email]
------------------------------
Date: Mon, 11 May 2009 13:51:24 +0200
From: uwe warner <[hidden email]>
Subject: Re: Export to NeoOffice/OpenOffice formats
Under: Export
under Document select Type Word/RTF
and save
Open with openoffice.
-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Luca
Meyer
Sent: Montag, 11. Mai 2009 10:31
To: [hidden email]
Subject: Export to NeoOffice/OpenOffice formats
Hi,
Is there someway to export SPSS output directly to NeoOffice
or
OpenOffice formats without having to export to MS Office formats first?
Thanks,
Luca
Mr. Luca Meyer
www.lucameyer.com
=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD
------------------------------
Date: Mon, 11 May 2009 06:40:09 -0600
From: ViAnn Beadle <[hidden email]>
Subject: Re: Export to NeoOffice/OpenOffice formats
Note that when you export to "Word" what you are really exporting is
just an
RTF file. The designers were afraid that few people would know what an RTF
file is.
-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Luca Meyer
Sent:
Monday, May 11, 2009 2:31 AM
To: [hidden email]
Subject: Export to NeoOffice/OpenOffice formats
Hi,
Is there someway to export SPSS output directly to NeoOffice or
OpenOffice formats without having to export to MS Office formats first?
Thanks,
Luca
Mr. Luca Meyer
www.lucameyer.com
=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD
------------------------------
Date: Sun, 10 May 2009 14:31:18 -0700
From: Caroline Davis <[hidden email]>
Subject: Regression Analysis
--0-1072059445-1241991078=:66243
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding:
quoted-printable
Hello list!=0A=0AI would like to perform a regression analysis for 4, howev=
er here are my constraints:=0A=0AVar 1: Prototype rating (Likert scale 1 to=
5), not normally distributed=0AVar 2: Influence rating (Likert scale 1 to =
5), not normally distributed=0AVar 3: Accurary (binary 0 or 1)=0AVar 4: Sco=
re on test (normally distributed).=0A=0AThe goal is to determine how well V=
ar 1-3 predict Var 4. Is a regression analysis the best way to get at this =
question? It seems tricky, because Var 1 & 2 are not normally distributed.
=
If I do a regression analysis for the accuracy and test variables, should =
it be a binary logistic regression, with accuracy as the dependent variable=
and score as the independent variable?=0A=0AThanks for any suggestions you=
may have.=0ACaroline
--0-1072059445-1241991078=:66243
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding:
quoted-printable
<html><head><style type=3D"text/css"><!-- DIV
{margin:0px;} --></style></he=
ad><body><div style=3D"font-family:arial, helvetica,
sans-serif;font-size:1=
0pt"><div>Hello
list!</div><div><br></div><div>I would like to
perform a re=
gression analysis for 4, however here are my
constraints:</div><div><br></d=
iv><div>Var 1: Prototype rating (Likert scale 1 to 5), not normally
distrib=
uted</div><div>Var 2: Influence rating (Likert scale 1 to 5), not
normally =
distributed</div><div>Var 3: Accurary (binary 0 or
1)</div><div>Var 4: Scor=
e on test (normally
distributed).</div><div><br></div><div>The goal is
to d=
etermine how well Var 1-3 predict Var 4. Is a regression analysis the best =
way to get at
this question? It seems tricky, because Var 1 & 2 are
not=
normally distributed. =A0If I do a regression analysis for the accuracy an=
d test variables, should it be a binary logistic regression, with accuracy =
as the dependent variable and score as the independent
variable?</div><div><br></div><div>Thanks for
any suggestions you may have=
.</div><div>Caroline</div><div
style=3D"position:fixed"></div></div></body>=
</html>
--0-1072059445-1241991078=:66243--
------------------------------
Date: Mon, 11 May 2009 15:09:56 +0100
From: Garry Gelade <[hidden email]>
Subject: Re: Regression Analysis
This is a multi-part message in MIME format.
------=_NextPart_000_0039_01C9D24A.8BAEEE80
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding:
7bit
Dear Caroline
It is not a requirement for regression that your independent variables be
normally distributed. (Remember for example that dummy variables, or binary
variables like your var3 are often used as IVs.)
The requirement is that your DV is normally distributed, so you should have
no problem.
Garry Gelade
Business Analytic Ltd
_____
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Caroline Davis
Sent: 10 May 2009 22:31
To: [hidden email]
Subject: Regression Analysis
Hello list!
I would like to perform a regression analysis for 4, however here are my
constraints:
Var 1: Prototype rating (Likert scale 1 to 5), not normally distributed
Var 2: Influence rating (Likert scale 1 to 5), not normally distributed
Var 3: Accurary (binary 0 or 1)
Var 4: Score on test (normally distributed).
The goal is to
determine how well Var 1-3 predict Var 4. Is a regression
analysis the best way to get at this question? It seems tricky, because Var
1 & 2 are not normally distributed. If I do a regression analysis for the
accuracy and test variables, should it be a binary logistic regression, with
accuracy as the dependent variable and score as the independent variable?
Thanks for any suggestions you may have.
Caroline
__________ Information from ESET NOD32 Antivirus, version of virus signature
database 4064 (20090511) __________
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
------=_NextPart_000_0039_01C9D24A.8BAEEE80
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV=3D"Content-Type"
CONTENT=3D"text/html; =
charset=3Dus-ascii">
<STYLE type=3Dtext/css>DIV {
MARGIN: 0px
}
</STYLE>
<META name=3DGENERATOR content=3D"MSHTML
8.00.6001.18702"></HEAD>
<BODY>
<DIV dir=3Dltr align=3Dleft><SPAN
class=3D640570514-11052009><FONT =
color=3D#0000ff=20
size=3D2 face=3DArial>Dear Caroline</FONT></SPAN></DIV>
<DIV dir=3Dltr align=3Dleft><SPAN
class=3D640570514-11052009><FONT =
color=3D#0000ff=20
size=3D2 face=3DArial></FONT></SPAN> </DIV>
<DIV dir=3Dltr align=3Dleft><SPAN
class=3D640570514-11052009><FONT =
color=3D#0000ff=20
size=3D2 face=3DArial>It is not a requirement for regression that =
your=20
independent variables be normally distributed. (Remember for =
example that=20
dummy variables, or binary
variables like your var3 are often used as=20
IVs.)</FONT></SPAN></DIV>
<DIV dir=3Dltr align=3Dleft><SPAN
class=3D640570514-11052009><FONT =
color=3D#0000ff=20
size=3D2 face=3DArial></FONT></SPAN> </DIV>
<DIV dir=3Dltr align=3Dleft><SPAN
class=3D640570514-11052009><FONT =
color=3D#0000ff=20
size=3D2 face=3DArial>The requirement is that your DV is normally =
distributed, so=20
you should have no problem.</FONT></SPAN></DIV>
<DIV dir=3Dltr align=3Dleft><SPAN
class=3D640570514-11052009><FONT =
color=3D#0000ff=20
size=3D2 face=3DArial></FONT></SPAN> </DIV>
<DIV dir=3Dltr align=3Dleft><SPAN
class=3D640570514-11052009><FONT =
color=3D#0000ff=20
size=3D2 face=3DArial>Garry Gelade</FONT></SPAN></DIV>
<DIV dir=3Dltr
align=3Dleft><SPAN
class=3D640570514-11052009><FONT =
color=3D#0000ff=20
size=3D2 face=3DArial>Business Analytic
Ltd</FONT></SPAN></DIV>
<DIV dir=3Dltr align=3Dleft><SPAN
class=3D640570514-11052009><FONT =
color=3D#0000ff=20
size=3D2 face=3DArial></FONT></SPAN> </DIV>
<DIV dir=3Dltr align=3Dleft>
<HR tabIndex=3D-1>
</DIV>
<DIV dir=3Dltr align=3Dleft><FONT size=3D2
face=3DTahoma><B>From:</B> =
SPSSX(r)=20
Discussion [mailto:[hidden email]] <B>On Behalf Of =
</B>Caroline=20
Davis<BR><B>Sent:</B> 10 May 2009
22:31<BR><B>To:</B>=20
[hidden email]<BR><B>Subject:</B> Regression=20
Analysis<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV style=3D"FONT-FAMILY:
arial, helvetica, sans-serif; FONT-SIZE: =
10pt">
<DIV>Hello list!</DIV>
<DIV><BR></DIV>
<DIV>I would like to perform a regression analysis for 4, however here =
are my=20
constraints:</DIV>
<DIV><BR></DIV>
<DIV>Var 1: Prototype rating (Likert scale 1 to 5), not normally=20
distributed</DIV>
<DIV>Var 2: Influence rating (Likert scale 1 to 5), not normally=20
distributed</DIV>
<DIV>Var 3: Accurary (binary 0 or 1)</DIV>
<DIV>Var 4: Score on test (normally distributed).</DIV>
<DIV><BR></DIV>
<DIV>The goal is to determine how well Var 1-3 predict Var 4. Is a =
regression=20
analysis the best way to get at this question? It seems tricky, because =
Var 1=20
& 2 are not normally distributed. If I do a regression =
analysis for=20
the accuracy and
test variables, should it be a binary logistic =
regression, with=20
accuracy as the dependent variable and score as the independent =
variable?</DIV>
<DIV><BR></DIV>
<DIV>Thanks for any suggestions you may have.</DIV>
<DIV>Caroline</DIV>
<DIV style=3D"POSITION:
fixed"></DIV></DIV><BR><BR>__________ =
Information from=20
ESET NOD32 Antivirus, version of virus signature database 4064 =
(20090511)=20
__________<BR><BR>The message was checked by ESET NOD32 =
Antivirus.<BR><BR><A=20
href=3D"http://www.eset.com">http://www.eset.com</A><BR>
=
<BR><BR>__________ Information from ESET NOD32 Antivirus, version
of =
virus signature database 4064 (20090511) __________<BR><BR>The
message =
was checked by ESET NOD32 Antivirus.<BR><BR><A
=
HREF=3D"http://www.eset.com">http://www.eset.com</A><BR>
</BODY></HTML>
------=_NextPart_000_0039_01C9D24A.8BAEEE80--
------------------------------
Date: Mon, 11 May 2009 16:14:03 +0200
From: =?ISO-8859-1?Q?Marta_Garc=EDa-Granero?=
<[hidden email]>
Subject: Re: Regression Analysis
Caroline Davis wrote:
> Hello list!
>
> I would like to perform a regression analysis for 4, however here are
> my constraints:
>
> Var 1: Prototype rating (Likert scale 1 to 5), not normally distributed
> Var 2: Influence rating (Likert scale 1 to 5), not normally distributed
> Var 3: Accuracy (binary 0 or 1)
> Var 4: Score on test (normally distributed).
>
> The goal is to determine how well Var 1-3 predict Var 4. Is a
> regression analysis the best way to get at this question? It seems
> tricky, because
Var 1 & 2 are not normally distributed.
Normality of the IV (or "predictor variables") is NOT a condition for
linear regression. Anyway, check for linearity in the response to your
Likert predictors. Binary (0/1 coded) variables are also OK, you don't
have to worry about Accuracy (Var 3).
> If I do a regression analysis for the accuracy and test variables,
> should it be a binary logistic regression, with accuracy as the
> dependent variable and score as the independent variable?
Then you would be predicting Accuracy as a function of the other
variables, including Var 4 (clearly not your goal).
>
> Thanks for any suggestions you may have.
1) Is sample size enough? (you don't mention it). As a rule of thumb,
there should be 10 to 20 cases for each IV (30 to 60 cases for your study)
2) Plot (scatter plot) Var 4 against Var1 first, then Var 4 against Var
2. Visually check for for
departures from linearity. Recode Var 1 and/or
Var 2 if necessary.
3) Are there any missing values? A listwise deletion might lower your
sample size a lot.
HTH,
Marta García-Granero
--
For miscellaneous SPSS related statistical stuff, visit:
http://gjyp.nl/marta/
------------------------------
Date: Mon, 11 May 2009 16:17:23 +0200
From: =?ISO-8859-1?Q?Marta_Garc=EDa-Granero?=
<[hidden email]>
Subject: Re: Regression Analysis
Garry Gelade wrote:
>
> It is not a requirement for regression that your independent variables
> be normally distributed. (Remember for example that dummy variables,
> or binary variables like your var3 are often used as IVs.)
>
> The requirement is that your DV is normally distributed, so you should
> have no problem.
Tiny correction: it is NOT the DV itself which should be normally
distributed,
but its residuals.
Caroline, I forgot to add that that to the list of suggestions. Save the
residuals for the final model and check its normality. Also, consider
the possibility of interaction terms: "is the effect of Var 1 (or Var 2)
modified by the effect of other variable (Var 3, for instance)?"
Best regards,
Marta
--
For miscellaneous SPSS related statistical stuff, visit:
http://gjyp.nl/marta/
------------------------------
Date: Mon, 11 May 2009 10:24:23 -0400
From: Art Kendall <[hidden email]>
Subject: Re: Regression Analysis
This is a multi-part message in MIME format.
--------------010203080105060707030404
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Normality of the predictors is not an issue.
Normality of the DV is not an issue. What you want to check is the
normality of the
residuals.
Using accuracy as a dv is not consistent with your first question. Is
there a reason to explore accuracy as a DV?
Art Kendall
Social Research Consultants
Caroline Davis wrote:
> Hello list!
>
> I would like to perform a regression analysis for 4, however here are
> my constraints:
>
> Var 1: Prototype rating (Likert scale 1 to 5), not normally distributed
> Var 2: Influence rating (Likert scale 1 to 5), not normally distributed
> Var 3: Accurary (binary 0 or 1)
> Var 4: Score on test (normally distributed).
>
> The goal is to determine how well Var 1-3 predict Var 4. Is a
> regression analysis the best way to get at this question? It seems
> tricky, because Var 1 & 2 are not normally distributed. If I do a
> regression analysis for the accuracy and test variables, should it be
> a binary logistic regression, with
accuracy as the dependent variable
> and score as the independent variable?
>
> Thanks for any suggestions you may have.
> Caroline
--------------010203080105060707030404
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Normality of the predictors is not an issue.<br>
Normality of the DV is not an issue. What you want to check is the
normality of the residuals.<br>
<br>
Using accuracy as a dv is not consistent with your first question. Is
there a reason to explore accuracy as a DV?<br>
<br>
Art Kendall<br>
Social Research
Consultants<br>
<br>
Caroline Davis wrote:
<blockquote cite="mid:[hidden email]"
type="cite">
<style type="text/css"><!-- DIV {margin:0px;}
--></style>
<div style="font-family: arial,helvetica,sans-serif; font-size:
10pt;">
<div>Hello list!</div>
<div><br>
</div>
<div>I would like to perform a regression analysis for 4, however
here are my constraints:</div>
<div><br>
</div>
<div>Var 1: Prototype rating (Likert scale 1 to 5), not normally
distributed</div>
<div>Var 2: Influence rating (Likert scale 1 to 5), not normally
distributed</div>
<div>Var 3: Accurary (binary 0 or 1)</div>
<div>Var 4: Score on test (normally distributed).</div>
<div><br>
</div>
<div>The goal is to determine how well Var 1-3 predict Var 4. Is a
regression analysis the best way to get at this question? It seems
tricky, because Var 1 & 2 are not normally distributed. If I
do a
regression analysis for the accuracy and test variables, should it be a
binary logistic regression, with accuracy as the dependent variable and
score as the independent variable?</div>
<div><br>
</div>
<div>Thanks for any suggestions you may have.</div>
<div>Caroline</div>
</div>
</blockquote>
</body>
</html>
--------------010203080105060707030404--
------------------------------
Date: Mon, 11 May 2009 16:39:05 +0200
From: =?ISO-8859-1?Q?Marta_Garc=EDa-Granero?=
<[hidden email]>
Subject: Re: Statistics Flow-chart updated
Poling, Taylor Leigh
wrote:
>
> I noticed rwg, an index of agreement commonly used in social science
research, was not listed on your chart. I've included pertinent references
below.
>
>
> James, L., Demaree, R. G., & Wolf, G. (1984). Estimating within group
interrater reliability with and without response bias. Journal of Applied
Psychology, 69, 85-98.
>
> James, L., Demaree, R. G., & Wolf, G (1993). r-sub(wg): An assessment
of within-group interrater agreement. Journal of Applied Psychology, 78,
306-309.
>
Thanks for the tip. Since I'm a biologist and work mainly with
biomedical data, my experience with Rwg is null. I'll have to read a bit
about it before I decide what to do with it.
Marta
--
For miscellaneous SPSS related statistical stuff, visit:
http://gjyp.nl/marta/
------------------------------
Date: Mon, 11 May 2009 07:46:27 -0700
From:
jimjohn <[hidden email]>
Subject: Re: hypothesis testing for difference between two means
Thanks for all the responses guys. Johnny, I appreciate you explaining how
the grouping variable works. Just one follow up question, I understand if I
go to Compare Means -> Independent Test, then this will conduct a t-test to
compare means. My sample size is about 36, I believe if the sample size is
>30, a z test should be used. Any ideas if SPSS can do a Z-test too to
compare means?
To the posters who posted before, thanks for the suggestions. I would
normally do exactly what you guys recommended, but the circumstances are
different here. Someone else has already performed an analysis claiming that
there is a difference between the two means, that the <$1000 certificate
customers are more sensitive to interest rate changes than the >$1000
certificate customers. Since this is not an
intuitive conclusion, I wanted
to run this test to see if the results are significant.
Johnny Amora wrote:
>
> At 10:32 AM 5/8/2009, jimjohn wrote:
>>does anyone here know how to compute hypothesis tests/confidence
intervals
>>for the difference between two means in SPSS? For example, I am
comparing
>>the volume growth of my certificates with balance less than $1000
versus
the
>>volume growth with balances greater than $1000. I want to see if the
>>difference in the two means is statistically significant. Any ideas? I
don't
>>think comparing means does it because it has something about grouping
and
>>factors. thanks!
>>--
>
> You can use the Independent Sample TTest procedure. You should have
> numeric variables for GROWTH and BALANCE where GROWTHÂ as your test
> variable and BALANCE as your
grouping variable. The BALANCE should be
> coded for example as follows: 1= balance less than $1000 and 2 =
greater
> than $1000. Then run the synax:
> Â
> T-TEST GROUPS=BALANCE(1 2)
> Â /MISSING=ANALYSIS
> Â /VARIABLES=GROWTH
> Â /CRITERIA=CI(.95).
>
> The confidence interval (CI) can be changed to what you want, say .99.Â
> Hope I understand correctly your need.
> Â
> Cheers,
> Johnny
>
>
> Yahoo! Mail Now Faster and Cleaner. Experience it at
> http://ph.mail.yahoo.com today!
>
--
View this message in context:
http://www.nabble.com/hypothesis-testing-for-difference-between-two-means-tp23452014p23484789.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.
------------------------------
Date: Mon, 11 May 2009 07:56:15 -0700
From: stace swayne
<[hidden email]>
Subject: Tetrachoric Correlations
--0-303989218-1242053775=:72422
Content-Type: text/plain; charset=us-ascii
Dear list,
I have 15 variables (v1-v15) and they are dichotomous items. I would like to
run an tetrachoric correlation, but I don't have an example of syntax for
doing that. Does anyone on the list have code for this or can you direct me to a
source?
All suggestions are appreciated,
Stace
--0-303989218-1242053775=:72422
Content-Type: text/html; charset=us-ascii
<html><head><style type="text/css"><!-- DIV
{margin:0px;} --></style></head><body><div
style="font-family:times new roman, new york, times,
serif;font-size:12pt"><DIV>Dear list,</DIV>
<DIV> </DIV>
<DIV>I have 15 variables (v1-v15) and they are dichotomous items. I would
like to run an
tetrachoric correlation, but I don't have an example of
syntax for doing that. Does anyone on the list have code for this or can you
direct me to a source?</DIV>
<DIV> </DIV>
<DIV>All suggestions are appreciated,</DIV>
<DIV> </DIV>
<DIV>Stace</DIV></div><br>
</body></html>
--0-303989218-1242053775=:72422--
------------------------------
Date: Mon, 11 May 2009 17:01:05 +0200
From: =?UTF-8?B?TWFydGEgR2FyY8OtYS1HcmFuZXJv?=
<[hidden email]>
Subject: Re: hypothesis testing for difference between two means
jimjohn wrote:
> Thanks for all the responses guys. Johnny, I appreciate you explaining how
> the grouping variable works. Just one follow up question, I understand if
I
> go to Compare Means -> Independent Test, then this will conduct a
t-test
to
> compare means. My sample size is about 36, I believe if the sample size is
>
> 30, a z test should be used.
Wrong: If sample size is >30, then a t test could (not should, notice
the difference) be replaced by a Z test. This is old statistical
thinking, from times when calculations were performed by hand, and
tricks to simplify them were common. The logic behind is that as sample
size increases, the t distribution tends asymptotically to a Z
distribution, therefore the error in the p-value is small under that
condition (big sample size). Today, since the hrd/boring job is done by
software, it is better to use a two samples t test and get the correct
p-value, not an estimation with low error.
> Any ideas if SPSS can do a Z-test too to compare means?
>
Chapter 5 of Statistics at Square One (available online at:
http://bmj.bmjjournals.com/collections/statsbk/5.dtl ) describes the
method.
My syntax file for the book, available at
http://gjyp.nl/marta/BMJ%20-%20Stats%20Square%20One.SPS , gives MATRIX
code get it, but, as I told you before, don't use it.
Marta
--
For miscellaneous SPSS related statistical stuff, visit:
http://gjyp.nl/marta/
------------------------------
Date: Mon, 11 May 2009 10:02:09 -0500
From: Ariel Barak <[hidden email]>
Subject: Re: creating new variables
--00504502c8632771c90469a44382
Content-Type: text/plain; charset=windows-1252
Content-Transfer-Encoding: quoted-printable
Hi Abdulrahman,
The syntax below works with the data you posted and will take care of
multiple repairs. If there are multiple repair types of 209 on a given day,
the syntax would not work properly. Basically I wrote code to create a tota=
l
cost for all repairs on a given day for an given ID number excluding the
cost of repair
type 209. I then added those variables to the original
dataset matched by ID and repair date. If the repair type was not 209, I se=
t
the new variables to zero.
Let me know if this works for your dataset...if not, maybe I can tweak it a
little.
Thanks,
Ari
DATA LIST LIST /ID (F8) RepairDate (ADATE10) RepairType (F8) Money (F8).
BEGIN DATA
16 04/30/2009 115 23
30 03/25/2009 103 62
30 01/24/2009 209 45
47 04/09/2009 101 69
47 04/09/2009 209 78
END DATA.
DATASET NAME Original.
SORT CASES BY ID RepairDate RepairType.
TEMP.
SELECT IF RepairType<>209.
DATASET DECLARE ExtraRepairs.
AGGREGATE
/OUTFILE=3D'ExtraRepairs'
/BREAK=3DID RepairDate
/MoreJobsPlus=3DN
/MoreMoneyPlus=3DSUM(Money).
MATCH FILES /FILE=3D*
/TABLE=3D'ExtraRepairs'
/BY ID RepairDate.
EXECUTE.
IF RepairType<>209 MoreJobsPlus=3D0.
IF
RepairType<>209 MoreMoneyPlus=3D0.
EXE.
RECODE MoreJobsPlus MoreMoneyPlus (SYSMIS=3D0).
EXE.
2009/5/11 abdelrhman elmubarak <[hidden email]>
> thanks Melissa
> I am finding difficulty if there are more than one possible extra repair =
on> the same day , your synatx work very fine if there are one repair on the
> same day...any help is higly appreciated.
> thanks
> Abdulrahman
>
> ------------------------------
> Date: Thu, 7 May 2009 09:14:37 -0500
> From:
[hidden email]> Subject: Re: creating new variables
>
> To:
[hidden email]>
> One way would be to use the sort function so that the 209 record is last.
> (it may help to create a dichotomy for rep209=3D1 or 0 if not--something =
> this would be needed if there are >2 repairs in a day)
> Then do a lag function to create
morejobs and moremoney.
>
> THE FOLLOWING ASSUMES that no client has >2 repairs in a day AND 209 is
t=
he
> highest repair value.
>
> sort cases by id repdate reptype.
> if (id=3Dlag(id) and repdate=3Dlag(repdate) and reptype=3D209) morejobs=
=3D1.
> if ((id ne lag(id) or repdate ne lag(repdate)) and reptype=3D209) morejob=
s=3D0.> if (id=3Dlag(id) and repdate=3Dlag(repdate) and reptype=3D209)
> moremoney=3Dlag(money).
>
>
> The actual syntax will differ if there are more than one possible extra
> repairs on the same date (i.e. one id could have 3+ per day), but similar
> logic should work.
>
> HTH,
> Melissa
>
> ------------------------------
> *From:* SPSSX(r) Discussion [mailto:
[hidden email]] *On Behalf
> Of *abdelrhman elmubarak
> *Sent:* Thursday, May 07, 2009 3:36 AM
> *To:*
[hidden email]> *Subject:* [SPSSX-L] creating new variables
>
>
>
>
> Hi
>
> my data looks as below
>
>
>
> *id*
>
> *Repair Date*
>
> *Repair Type*
>
> *money*
>
> 16
>
> 20090430
>
> 115
>
> 23
>
> 30
>
> 20090325
>
> 209
>
> 45
>
> 30
>
> 20090124
>
> 103
>
> 62
>
> 47
>
> 20090409
>
> 209
>
> 78
>
> 47
>
> 20090409
>
> 101
>
> 69
>
>
>
> I want to create two more variables for those who did repair type
> 209=85the purpose is to know did they did more jobs on the same day of th=
> visit and what the money generated from that =85.at the final my data
sho=
uld
> be look as below
>
>
>
> *id*
>
> *Repair Date*
>
> *Repair Type*
>
> *money*
>
> *more jobs plus *
>
> *more money plus*
>
> 16
>
> 20090430
>
> 115
>
> 23
>
>
>
>
>
> 30
>
> 20090325
>
> 209
>
> 45
>
> 0
>
>
>
> 30
>
> 20090124
>
> 103
>
> 62
>
>
>
>
>
> 47
>
> 20090409
>
> 209
>
> 78
>
> 1
>
> 69
>
> 47
>
> 20090409
>
> 101
>
> 69
>
>
>
>
>
>
>
> I can explain more if it is required
>
> Thanks in advance
>
>
>
>
Abdulrahman
>
>
> ------------------------------
> Invite your mail contacts to join your friends list with Windows Live
> Spaces. It's easy! Try
it!<http://spaces.live.com/spacesapi.aspx?wx_actio=
n=3Dcreate&wx_url=3D/friends.aspx&mkt=3Den-us>
> ------------------------------
> Invite your mail contacts to join your friends list with Windows Live
> Spaces. It's easy! Try
it!<http://spaces.live.com/spacesapi.aspx?wx_actio=
n=3Dcreate&wx_url=3D/friends.aspx&mkt=3Den-us>
> ------------------------------
> PRIVILEGED AND CONFIDENTIAL INFORMATION
> This transmittal and any attachments may contain PRIVILEGED AND
> CONFIDENTIAL information and is intended only for the use of the
> addressee. If you are not the designated recipient, or an employee
> or agent authorized to deliver such transmittals to the designated
> recipient, you
are hereby notified that any dissemination,
> copying or publication of this transmittal is strictly prohibited. If
> you have received this transmittal in error, please notify us
> immediately by replying to the sender and delete this copy from your
> system. You may also call us at (309) 827-6026 for assistance.
>
> ------------------------------
> What can you do with the new Windows Live? Find
out<http://www.microsoft.=
com/windows/windowslive/default.aspx>
>
--00504502c8632771c90469a44382
Content-Type: text/html; charset=windows-1252
Content-Transfer-Encoding: quoted-printable
<div>Hi Abdulrahman,</div>
<div>=A0</div>
<div>The syntax below works with the data you posted and will take care
of =
multiple repairs. If there are multiple repair types of 209 on a given day,=
the syntax would not work properly. Basically I wrote
code to create a tot=
al cost for all repairs on a given day for an given ID number excluding the=
cost of repair type 209. I then added those variables to the original data=
set matched by ID and repair date. If the repair type was not 209, I set th=
e new variables to zero.</div>
<div>=A0</div>
<div>Let me know if this works for your dataset...if not, maybe I can
tweak=
it a little.</div>
<div>=A0</div>
<div>Thanks,<br>Ari</div>
<div>=A0</div>
<div>=A0</div>
<div>DATA LIST LIST /ID (F8) RepairDate (ADATE10) RepairType (F8) Money
(F8=
).<br>BEGIN DATA<br>16 04/30/2009 115 23<br>30 03/25/2009 103
62<br>30 01/2=
4/2009 209 45<br>47 04/09/2009 101 69<br>47 04/09/2009 209
78<br>END DATA.<=
/div>
<div>=A0</div>
<div>DATASET NAME
Original.</div>
<div>=A0</div>
<div>SORT CASES BY ID RepairDate RepairType.</div>
<div>TEMP.<br>SELECT IF
RepairType<>209.<br>DATASET DECLARE ExtraRepa=
irs.<br>AGGREGATE<br>=A0
/OUTFILE=3D'ExtraRepairs'<br>=A0 /BREAK=3D=
ID RepairDate<br>=A0 /MoreJobsPlus=3DN<br>=A0
/MoreMoneyPlus=3DSUM(Money).<=
/div>
<div>=A0</div>
<div>MATCH FILES /FILE=3D*<br>=A0
/TABLE=3D'ExtraRepairs'<br>=A0 /B=
Y=A0 ID RepairDate.<br>EXECUTE.</div>
<div>=A0</div>
<div>IF RepairType<>209 MoreJobsPlus=3D0.<br>IF
RepairType<>209=
MoreMoneyPlus=3D0.<br>EXE.</div>
<div>=A0</div>
<div>RECODE MoreJobsPlus
MoreMoneyPlus
(SYSMIS=3D0).<br>EXE.<br><br></div>
<div class=3D"gmail_quote">2009/5/11 abdelrhman elmubarak
<span dir=3D"ltr"=
><<a
href=3D"mailto:[hidden email]">[hidden email]</a>>=
</span><br>
<blockquote class=3D"gmail_quote" style=3D"PADDING-LEFT: 1ex;
MARGIN: 0px 0=
px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<div>thanks Melissa <br>I am finding difficulty if there are more
than one =
possible extra repair on the same day , your synatx=A0work very fine if the=
re are one repair on the same day...any help is higly
appreciated.<br>thank=
s<br>
Abdulrahman<br>=A0<br>
<hr>
Date: Thu, 7 May 2009 09:14:37 -0500<br>From: <a
href=3D"mailto:mives@chest=
nut.org"
target=3D"_blank">[hidden email]</a><br>Subject:
Re: creating
=
new variables=20
<div>
<div></div>
<div class=3D"h5"><br>To: <a
href=3D"mailto:[hidden email]" targe=
t=3D"_blank">[hidden email]</a><br><br>
<div dir=3D"ltr" align=3D"left"><span><font
face=3D"Arial" color=3D"#0000ff=
">One way would be to u</font></span><span><font
face=3D"Arial" color=3D"#0=
000ff">se the sort function so that the 209 record is last.=A0 (it may
help=
to create a dichotomy for rep209=3D1 or 0 if not--something like this woul=
d be needed if there are >2 repairs in a
day)</font></span></div>
<div dir=3D"ltr" align=3D"left"><span><font
face=3D"Arial" color=3D"#0000ff=
">Then do a lag function to create morejobs and
moremoney.</font></span></d=
iv>
<div dir=3D"ltr"
align=3D"left"><span><font
face=3D"Arial" color=3D"#0000ff=
"></font></span>=A0</div>
<div dir=3D"ltr" align=3D"left"><span><font
face=3D"Arial" color=3D"#0000ff=
">THE FOLLOWING=A0ASSUMES that no client has >2 repairs in a day
AND 209=
is the highest repair value.</font></span></div>
<div dir=3D"ltr" align=3D"left"><span><font
face=3D"Arial" color=3D"#0000ff=
"></font></span>=A0</div>
<div dir=3D"ltr" align=3D"left"><span><font
face=3D"Arial" color=3D"#0000ff=
"><font size=3D"2">sort cases by id repdate
reptype.<br>if (id=3Dlag(id) an=
d repdate=3Dlag(repdate) and reptype=3D209) morejobs=3D1.<br>if ((id ne
lag=
(id) or repdate ne lag(repdate)) and reptype=3D209) morejobs=3D0.<br>
if (id=3Dlag(id) and repdate=3Dlag(repdate) and reptype=3D209)
moremoney=3D=
lag(money).<br>=A0<br>=A0<br></font></font></span><span><font
face=3D"Arial=
"
color=3D"#0000ff"><span></span></font></span></div>
<div dir=3D"ltr" align=3D"left">
<div dir=3D"ltr" align=3D"left"><span>The
actual syntax will differ if ther=
e are more than one possible extra repairs on the same date (i.e. one id co=
uld have 3+ per day), but similar logic should work.</span></div>
<div dir=3D"ltr"
align=3D"left"><span></span>=A0</div>
<div dir=3D"ltr"
align=3D"left"><span>HTH,</span></div>
<div dir=3D"ltr"
align=3D"left"><span>Melissa</span>=A0</div></div>
<div dir=3D"ltr" align=3D"left"><span><font
face=3D"Arial" color=3D"#0000ff=
"></font></span>=A0</div>
<div
dir=3D"ltr" align=3D"left">
<hr>
</div>
<div dir=3D"ltr" align=3D"left"><font
face=3D"Tahoma"><b>From:</b> SPSSX(r)=
Discussion [mailto:<a href=3D"mailto:[hidden email]"
target=3D"_=
blank">[hidden email]</a>] <b>On Behalf Of
</b>abdelrhman elmubar=
ak<br>
<b>Sent:</b> Thursday, May 07, 2009 3:36
AM<br><b>To:</b> <a href=3D"mailto=
:[hidden email]"
target=3D"_blank">[hidden email]</a><b=
r><b>Subject:</b> [SPSSX-L] creating new
variables<br></font><br></div>
<div></div><br>=A0=A0<br><br>
<p><font color=3D"#000000">Hi</font></p>
<p><font color=3D"#000000">my data looks as
below
</font></p>
<p><span><font
color=3D"#000000"></font></span>=A0</p>
<table style=3D"WIDTH: 308pt; BORDER-COLLAPSE: collapse"
cellspacing=3D"0" =
cellpadding=3D"0" width=3D"411" border=3D"0">
<tbody>
<tr style=3D"HEIGHT: 15pt">
<td style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORD=
ER-TOP: windowtext 1pt solid; PADDING-LEFT: 5.4pt; BACKGROUND: #666699; PAD=
DING-BOTTOM: 0in; BORDER-LEFT: windowtext 1pt solid; WIDTH: 84pt; PADDING-T=
OP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15pt"
width=3D"112">
<p style=3D"LINE-HEIGHT: normal; TEXT-ALIGN: center"
align=3D"center"><b><s=
pan style=3D"FONT-SIZE: 9pt; COLOR:
white">id</span></b><br></p></td>
<td style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORD=
ER-TOP:
windowtext 1pt solid; PADDING-LEFT: 5.4pt; BACKGROUND: #666699; PAD=
DING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 70pt; PADDING-TOP: 0in; BORD=
ER-BOTTOM: windowtext 1pt solid; HEIGHT: 15pt" width=3D"93">
<p style=3D"LINE-HEIGHT: normal; TEXT-ALIGN: center"
align=3D"center"><b><s=
pan style=3D"FONT-SIZE: 9pt; COLOR: white">Repair
Date</span></b></p></td>
<td style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORD=
ER-TOP: windowtext 1pt solid; PADDING-LEFT: 5.4pt; BACKGROUND: #666699; PAD=
DING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 77pt; PADDING-TOP: 0in; BORD=
ER-BOTTOM: windowtext 1pt solid; HEIGHT: 15pt" width=3D"103">
<p style=3D"LINE-HEIGHT: normal; TEXT-ALIGN: center"
align=3D"center"><b><s=
pan style=3D"FONT-SIZE: 9pt; COLOR: white">Repair
Type</span></b></p></td>
<td
style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORD=
ER-TOP: windowtext 1pt solid; PADDING-LEFT: 5.4pt; BACKGROUND: #666699; PAD=
DING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 77pt; PADDING-TOP: 0in; BORD=
ER-BOTTOM: windowtext 1pt solid; HEIGHT: 15pt" width=3D"103">
<p style=3D"LINE-HEIGHT: normal; TEXT-ALIGN: center"
align=3D"center"><b><s=
pan style=3D"FONT-SIZE: 9pt; COLOR:
white">money</span></b></p></td></tr>
<tr style=3D"HEIGHT: 15pt">
<td style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORD=
ER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0i=
n; BORDER-LEFT: windowtext 1pt solid; WIDTH: 84pt; PADDING-TOP: 0in; BORDER=
-BOTTOM: windowtext 1pt solid; HEIGHT: 15pt" width=3D"112">
<p style=3D"LINE-HEIGHT: normal; TEXT-ALIGN: center"
align=3D"center"><span=
style=3D"FONT-SIZE: 9pt; COLOR:
black">16</span></p></td>
<td style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORD=
ER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0i=
n; BORDER-LEFT: #ece9d8; WIDTH: 70pt; PADDING-TOP: 0in; BORDER-BOTTOM: wind=
owtext 1pt solid; HEIGHT: 15pt" width=3D"93">
<p style=3D"LINE-HEIGHT: normal; TEXT-ALIGN: center"
align=3D"center"><span=
style=3D"FONT-SIZE: 9pt; COLOR:
black">20090430</span></p></td>
<td style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORD=
ER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0i=
n; BORDER-LEFT: #ece9d8; WIDTH: 77pt; PADDING-TOP: 0in; BORDER-BOTTOM: wind=
owtext 1pt solid; HEIGHT: 15pt" width=3D"103">
<p style=3D"LINE-HEIGHT: normal; TEXT-ALIGN: center"
align=3D"center"><span=
style=3D"FONT-SIZE: 9pt; COLOR:
black">115</span></p></td>
<td style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORD=
ER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0i=
n; BORDER-LEFT: #ece9d8; WIDTH: 77pt; PADDING-TOP: 0in; BORDER-BOTTOM: wind=
owtext 1pt solid; HEIGHT: 15pt" width=3D"103">
<p style=3D"LINE-HEIGHT: normal; TEXT-ALIGN: center"
align=3D"center"><span=
style=3D"FONT-SIZE: 9pt; COLOR:
black">23</span></p></td></tr>
<tr style=3D"HEIGHT: 15pt">
<td style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORD=
ER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: yellow; PADDING-BOTTOM: 0=
in; BORDER-LEFT: windowtext 1pt solid; WIDTH: 84pt; PADDING-TOP: 0in; BORDE=
R-BOTTOM: windowtext 1pt solid; HEIGHT: 15pt" width=3D"112">
<p style=3D"LINE-HEIGHT: normal;
TEXT-ALIGN: center"
align=3D"center"><span=
style=3D"FONT-SIZE: 9pt; COLOR:
red">30</span></p></td>
<td style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORD=
ER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: yellow; PADDING-BOTTOM: 0=
in; BORDER-LEFT: #ece9d8; WIDTH: 70pt; PADDING-TOP: 0in; BORDER-BOTTOM: win=
dowtext 1pt solid; HEIGHT: 15pt" width=3D"93">
<p style=3D"LINE-HEIGHT: normal; TEXT-ALIGN: center"
align=3D"center"><span=
style=3D"FONT-SIZE: 9pt; COLOR:
red">20090325</span></p></td>
<td style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORD=
ER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: yellow; PADDING-BOTTOM: 0=
in; BORDER-LEFT: #ece9d8; WIDTH: 77pt; PADDING-TOP: 0in; BORDER-BOTTOM: win=
dowtext 1pt solid; HEIGHT: 15pt" width=3D"103">
<p style=3D"LINE-HEIGHT: normal;
TEXT-ALIGN: center"
align=3D"center"><span=
style=3D"FONT-SIZE: 9pt; COLOR:
red">209</span></p></td>
<td style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORD=
ER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: yellow; PADDING-BOTTOM: 0=
in; BORDER-LEFT: #ece9d8; WIDTH: 77pt; PADDING-TOP: 0in; BORDER-BOTTOM: win=
dowtext 1pt solid; HEIGHT: 15pt" width=3D"103">
<p style=3D"LINE-HEIGHT: normal; TEXT-ALIGN: center"
align=3D"center"><span=
style=3D"FONT-SIZE: 9pt; COLOR:
red">45</span></p></td></tr>
<tr style=3D"HEIGHT: 15pt">
<td style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORD=
ER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0i=
n; BORDER-LEFT: windowtext 1pt solid; WIDTH: 84pt; PADDING-TOP: 0in; BORDER=
-BOTTOM: windowtext 1pt solid; HEIGHT: 15pt"
width=3D"112">
<p style=3D"LINE-HEIGHT: normal; TEXT-ALIGN: center"
align=3D"center"><span=
style=3D"FONT-SIZE: 9pt; COLOR:
black">30</span></p></td>
<td style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORD=
ER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0i=
n; BORDER-LEFT: #ece9d8; WIDTH: 70pt; PADDING-TOP: 0in; BORDER-BOTTOM: wind=
owtext 1pt solid; HEIGHT: 15pt" width=3D"93">
<p style=3D"LINE-HEIGHT: normal; TEXT-ALIGN: center"
align=3D"center"><span=
style=3D"FONT-SIZE: 9pt; COLOR:
black">20090124</span></p></td>
<td style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORD=
ER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0i=
n; BORDER-LEFT: #ece9d8; WIDTH: 77pt; PADDING-TOP: 0in; BORDER-BOTTOM: wind=
owtext 1pt solid; HEIGHT: 15pt"
width=3D"103">
<p style=3D"LINE-HEIGHT: normal; TEXT-ALIGN: center"
align=3D"center"><span=
style=3D"FONT-SIZE: 9pt; COLOR:
black">103</span></p></td>
<td style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORD=
ER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0i=
n; BORDER-LEFT: #ece9d8; WIDTH: 77pt; PADDING-TOP: 0in; BORDER-BOTTOM: wind=
owtext 1pt solid; HEIGHT: 15pt" width=3D"103">
<p style=3D"LINE-HEIGHT: normal; TEXT-ALIGN: center"
align=3D"center"><span=
style=3D"FONT-SIZE: 9pt; COLOR:
black">62</span></p></td></tr>
<tr style=3D"HEIGHT: 15pt">
<td style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORD=
ER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: yellow; PADDING-BOTTOM: 0=
in; BORDER-LEFT: windowtext 1pt solid; WIDTH: 84pt; PADDING-TOP:
0in; BORDE=
R-BOTTOM: windowtext 1pt solid; HEIGHT: 15pt" width=3D"112">
<p style=3D"LINE-HEIGHT: normal; TEXT-ALIGN: center"
align=3D"center"><span=
style=3D"FONT-SIZE: 9pt; COLOR:
red">47</span></p></td>
<td style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORD=
ER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: yellow; PADDING-BOTTOM: 0=
in; BORDER-LEFT: #ece9d8; WIDTH: 70pt; PADDING-TOP: 0in; BORDER-BOTTOM: win=
dowtext 1pt solid; HEIGHT: 15pt" width=3D"93">
<p style=3D"LINE-HEIGHT: normal; TEXT-ALIGN: center"
align=3D"center"><span=
style=3D"FONT-SIZE: 9pt; COLOR:
red">20090409</span></p></td>
<td style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORD=
ER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: yellow; PADDING-BOTTOM: 0=
in; BORDER-LEFT: #ece9d8; WIDTH: 77pt; PADDING-TOP:
0in; BORDER-BOTTOM: win=
dowtext 1pt solid; HEIGHT: 15pt" width=3D"103">
<p style=3D"LINE-HEIGHT: normal; TEXT-ALIGN: center"
align=3D"center"><span=
style=3D"FONT-SIZE: 9pt; COLOR:
red">209</span></p></td>
<td style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORD=
ER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: yellow; PADDING-BOTTOM: 0=
in; BORDER-LEFT: #ece9d8; WIDTH: 77pt; PADDING-TOP: 0in; BORDER-BOTTOM: win=
dowtext 1pt solid; HEIGHT: 15pt" width=3D"103">
<p style=3D"LINE-HEIGHT: normal; TEXT-ALIGN: center"
align=3D"center"><span=
style=3D"FONT-SIZE: 9pt; COLOR:
red">78</span></p></td></tr>
<tr style=3D"HEIGHT: 15pt">
<td style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORD=
ER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: yellow; PADDING-BOTTOM: 0=
in;
BORDER-LEFT: windowtext 1pt solid; WIDTH: 84pt; PADDING-TOP: 0in; BORDE=
R-BOTTOM: windowtext 1pt solid; HEIGHT: 15pt" width=3D"112">
<p style=3D"LINE-HEIGHT: normal; TEXT-ALIGN: center"
align=3D"center"><span=
style=3D"FONT-SIZE: 9pt; COLOR:
red">47</span></p></td>
<td style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORD=
ER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: yellow; PADDING-BOTTOM: 0=
in; BORDER-LEFT: #ece9d8; WIDTH: 70pt; PADDING-TOP: 0in; BORDER-BOTTOM: win=
dowtext 1pt solid; HEIGHT: 15pt" width=3D"93">
<p style=3D"LINE-HEIGHT: normal; TEXT-ALIGN: center"
align=3D"center"><span=
style=3D"FONT-SIZE: 9pt; COLOR:
red">20090409</span></p></td>
<td style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORD=
ER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM:
0i=
n; BORDER-LEFT: #ece9d8; WIDTH: 77pt; PADDING-TOP: 0in; BORDER-BOTTOM: wind=
owtext 1pt solid; HEIGHT: 15pt" width=3D"103">
<p style=3D"LINE-HEIGHT: normal; TEXT-ALIGN: center"
align=3D"center"><span=
style=3D"FONT-SIZE: 9pt; COLOR:
black">101</span></p></td>
<td style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORD=
ER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0i=
n; BORDER-LEFT: #ece9d8; WIDTH: 77pt; PADDING-TOP: 0in; BORDER-BOTTOM: wind=
owtext 1pt solid; HEIGHT: 15pt" width=3D"103">
<p style=3D"LINE-HEIGHT: normal; TEXT-ALIGN: center"
align=3D"center"><span=
style=3D"FONT-SIZE: 9pt; COLOR:
black">69</span></p></td></tr></tbody></ta=
ble><br>
<p><font color=3D"#000000"></font>=A0</p>
<p><font color=3D"#000000">I
want to create two more
variables for those <s=
pan>=A0</span>who <span>=A0</span>did repair type
209=85the purpose is to k=
now did they did more jobs on the same day of their visit and what the mone=
y generated from that =85.at the final my data should be look as below</fon=
t></p>
<p><font color=3D"#000000"></font>=A0</p>
<table style=3D"WIDTH: 372pt; BORDER-COLLAPSE: collapse"
cellspacing=3D"0" =
cellpadding=3D"0" width=3D"496" border=3D"0">
<tbody>
<tr style=3D"HEIGHT: 15pt">
<td style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORD=
ER-TOP: windowtext 1pt solid; PADDING-LEFT: 5.4pt; BACKGROUND: #666699; PAD=
DING-BOTTOM: 0in; BORDER-LEFT: windowtext 1pt solid; WIDTH: 50pt; PADDING-T=
OP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15pt"
width=3D"67">
<p
style=3D"LINE-HEIGHT: normal; TEXT-ALIGN: center"
align=3D"center"><b><s=
pan style=3D"FONT-SIZE: 9pt; COLOR:
white">id</span></b><br></p></td>
<td style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORD=
ER-TOP: windowtext 1pt solid; PADDING-LEFT: 5.4pt; BACKGROUND: #666699; PAD=
DING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 56pt; PADDING-TOP: 0in; BORD=
ER-BOTTOM: windowtext 1pt solid; HEIGHT: 15pt" width=3D"75">
<p style=3D"LINE-HEIGHT: normal; TEXT-ALIGN: center"
align=3D"center"><b><s=
pan style=3D"FONT-SIZE: 9pt; COLOR: white">Repair
Date</span></b></p></td>
<td style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORD=
ER-TOP: windowtext 1pt solid; PADDING-LEFT: 5.4pt; BACKGROUND: #666699; PAD=
DING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 56pt; PADDING-TOP: 0in;
BORD=
ER-BOTTOM: windowtext 1pt solid; HEIGHT: 15pt" width=3D"75">
<p style=3D"LINE-HEIGHT: normal; TEXT-ALIGN: center"
align=3D"center"><b><s=
pan style=3D"FONT-SIZE: 9pt; COLOR: white">Repair
Type</span></b></p></td>
<td style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORD=
ER-TOP: windowtext 1pt solid; PADDING-LEFT: 5.4pt; BACKGROUND: #666699; PAD=
DING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 56pt; PADDING-TOP: 0in; BORD=
ER-BOTTOM: windowtext 1pt solid; HEIGHT: 15pt" width=3D"75">
<p style=3D"LINE-HEIGHT: normal; TEXT-ALIGN: center"
align=3D"center"><b><s=
pan style=3D"FONT-SIZE: 9pt; COLOR:
white">money</span></b></p></td>
<td style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORD=
ER-TOP: windowtext 1pt solid; PADDING-LEFT: 5.4pt; BACKGROUND: #666699;
PAD=
DING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 68pt; PADDING-TOP: 0in; BORD=
ER-BOTTOM: windowtext 1pt solid; HEIGHT: 15pt" width=3D"91">
<p style=3D"LINE-HEIGHT: normal; TEXT-ALIGN: center"
align=3D"center"><b><s=
pan style=3D"FONT-SIZE: 9pt; COLOR: white">more jobs plus
</span></b></p></=
td>
<td style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORD=
ER-TOP: windowtext 1pt solid; PADDING-LEFT: 5.4pt; BACKGROUND: #666699; PAD=
DING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 86pt; PADDING-TOP: 0in; BORD=
ER-BOTTOM: windowtext 1pt solid; HEIGHT: 15pt" width=3D"115">
<p style=3D"LINE-HEIGHT: normal; TEXT-ALIGN: center"
align=3D"center"><b><s=
pan style=3D"FONT-SIZE: 9pt; COLOR: white">more money
plus</span></b></p></=
td></tr>
<tr style=3D"HEIGHT: 15pt">
<td
style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORD=
ER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0i=
n; BORDER-LEFT: windowtext 1pt solid; WIDTH: 50pt; PADDING-TOP: 0in; BORDER=
-BOTTOM: windowtext 1pt solid; HEIGHT: 15pt" width=3D"67">
<p style=3D"LINE-HEIGHT: normal; TEXT-ALIGN: center"
align=3D"center"><span=
style=3D"FONT-SIZE: 9pt; COLOR:
black">16</span></p></td>
<td style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORD=
ER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0i=
n; BORDER-LEFT: #ece9d8; WIDTH: 56pt; PADDING-TOP: 0in; BORDER-BOTTOM: wind=
owtext 1pt solid; HEIGHT: 15pt" width=3D"75">
<p style=3D"LINE-HEIGHT: normal; TEXT-ALIGN: center"
align=3D"center"><span=
style=3D"FONT-SIZE: 9pt;
COLOR:
black">20090430</span></p></td>
<td style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORD=
ER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0i=
n; BORDER-LEFT: #ece9d8; WIDTH: 56pt; PADDING-TOP: 0in; BORDER-BOTTOM: wind=
owtext 1pt solid; HEIGHT: 15pt" width=3D"75">
<p style=3D"LINE-HEIGHT: normal; TEXT-ALIGN: center"
align=3D"center"><span=
style=3D"FONT-SIZE: 9pt; COLOR:
black">115</span></p></td>
<td style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORD=
ER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0i=
n; BORDER-LEFT: #ece9d8; WIDTH: 56pt; PADDING-TOP: 0in; BORDER-BOTTOM: wind=
owtext 1pt solid; HEIGHT: 15pt" width=3D"75">
<p style=3D"LINE-HEIGHT: normal; TEXT-ALIGN: center"
align=3D"center"><span=
style=3D"FONT-SIZE: 9pt;
COLOR:
black">23</span></p></td>
<td style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORD=
ER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ec=
e9d8; WIDTH: 68pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; H=
EIGHT: 15pt; BACKGROUND-COLOR: transparent" width=3D"91">
<p style=3D"LINE-HEIGHT: normal; TEXT-ALIGN: center"
align=3D"center"><span=
style=3D"COLOR:
black"><span></span></span>=A0</p></td>
<td style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORD=
ER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ec=
e9d8; WIDTH: 86pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; H=
EIGHT: 15pt; BACKGROUND-COLOR: transparent" width=3D"115">
<p style=3D"LINE-HEIGHT: normal; TEXT-ALIGN:
center"
align=3D"center"><span=
style=3D"COLOR:
black"></span>=A0</p></td></tr>
<tr style=3D"HEIGHT: 15pt">
<td style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORD=
ER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: yellow; PADDING-BOTTOM: 0=
in; BORDER-LEFT: windowtext 1pt solid; WIDTH: 50pt; PADDING-TOP: 0in; BORDE=
R-BOTTOM: windowtext 1pt solid; HEIGHT: 15pt" width=3D"67">
<p style=3D"LINE-HEIGHT: normal; TEXT-ALIGN: center"
align=3D"center"><span=
style=3D"FONT-SIZE: 9pt; COLOR:
red">30</span></p></td>
<td style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORD=
ER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: yellow; PADDING-BOTTOM: 0=
in; BORDER-LEFT: #ece9d8; WIDTH: 56pt; PADDING-TOP: 0in; BORDER-BOTTOM: win=
dowtext 1pt solid; HEIGHT: 15pt" width=3D"75">
<p
style=3D"LINE-HEIGHT: normal; TEXT-ALIGN: center"
align=3D"center"><span=
style=3D"FONT-SIZE: 9pt; COLOR:
red">20090325</span></p></td>
<td style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORD=
ER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: yellow; PADDING-BOTTOM: 0=
in; BORDER-LEFT: #ece9d8; WIDTH: 56pt; PADDING-TOP: 0in; BORDER-BOTTOM: win=
dowtext 1pt solid; HEIGHT: 15pt" width=3D"75">
<p style=3D"LINE-HEIGHT: normal; TEXT-ALIGN: center"
align=3D"center"><span=
style=3D"FONT-SIZE: 9pt; COLOR:
red">209</span></p></td>
<td style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORD=
ER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: yellow; PADDING-BOTTOM: 0=
in; BORDER-LEFT: #ece9d8; WIDTH: 56pt; PADDING-TOP: 0in; BORDER-BOTTOM: win=
dowtext 1pt solid; HEIGHT: 15pt" width=3D"75">
<p
style=3D"LINE-HEIGHT: normal; TEXT-ALIGN: center"
align=3D"center"><span=
style=3D"FONT-SIZE: 9pt; COLOR:
red">45</span></p></td>
<td style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORD=
ER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: yellow; PADDING-BOTTOM: 0=
in; BORDER-LEFT: #ece9d8; WIDTH: 68pt; PADDING-TOP: 0in; BORDER-BOTTOM: win=
dowtext 1pt solid; HEIGHT: 15pt" width=3D"91">
<p style=3D"LINE-HEIGHT: normal; TEXT-ALIGN: center"
align=3D"center"><span=
style=3D"COLOR: red">0</span></p></td>
<td style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORD=
ER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ec=
e9d8; WIDTH: 86pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; H=
EIGHT: 15pt; BACKGROUND-COLOR: transparent" width=3D"115">
<p
style=3D"LINE-HEIGHT: normal; TEXT-ALIGN: center"
align=3D"center"><span=
style=3D"COLOR:
black"></span>=A0</p></td></tr>
<tr style=3D"HEIGHT: 15pt">
<td style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORD=
ER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0i=
n; BORDER-LEFT: windowtext 1pt solid; WIDTH: 50pt; PADDING-TOP: 0in; BORDER=
-BOTTOM: windowtext 1pt solid; HEIGHT: 15pt" width=3D"67">
<p style=3D"LINE-HEIGHT: normal; TEXT-ALIGN: center"
align=3D"center"><span=
style=3D"FONT-SIZE: 9pt; COLOR:
black">30</span></p></td>
<td style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORD=
ER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0i=
n; BORDER-LEFT: #ece9d8; WIDTH: 56pt; PADDING-TOP: 0in; BORDER-BOTTOM: wind=
owtext 1pt solid;
HEIGHT: 15pt" width=3D"75">
<p style=3D"LINE-HEIGHT: normal; TEXT-ALIGN: center"
align=3D"center"><span=
style=3D"FONT-SIZE: 9pt; COLOR:
black">20090124</span></p></td>
<td style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORD=
ER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0i=
n; BORDER-LEFT: #ece9d8; WIDTH: 56pt; PADDING-TOP: 0in; BORDER-BOTTOM: wind=
owtext 1pt solid; HEIGHT: 15pt" width=3D"75">
<p style=3D"LINE-HEIGHT: normal; TEXT-ALIGN: center"
align=3D"center"><span=
style=3D"FONT-SIZE: 9pt; COLOR:
black">103</span></p></td>
<td style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORD=
ER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0i=
n; BORDER-LEFT: #ece9d8; WIDTH: 56pt; PADDING-TOP: 0in; BORDER-BOTTOM: wind=
owtext 1pt solid;
HEIGHT: 15pt" width=3D"75">
<p style=3D"LINE-HEIGHT: normal; TEXT-ALIGN: center"
align=3D"center"><span=
style=3D"FONT-SIZE: 9pt; COLOR:
black">62</span></p></td>
<td style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORD=
ER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ec=
e9d8; WIDTH: 68pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; H=
EIGHT: 15pt; BACKGROUND-COLOR: transparent" width=3D"91">
<p style=3D"LINE-HEIGHT: normal; TEXT-ALIGN: center"
align=3D"center"><span=
style=3D"COLOR: black"></span>=A0</p></td>
<td style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORD=
ER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ec=
e9d8; WIDTH: 86pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; H=
EIGHT: 15pt; BACKGROUND-COLOR:
transparent" width=3D"115">
<p style=3D"LINE-HEIGHT: normal; TEXT-ALIGN: center"
align=3D"center"><span=
style=3D"COLOR:
black"></span>=A0</p></td></tr>
<tr style=3D"HEIGHT: 15pt">
<td style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORD=
ER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: yellow; PADDING-BOTTOM: 0=
in; BORDER-LEFT: windowtext 1pt solid; WIDTH: 50pt; PADDING-TOP: 0in; BORDE=
R-BOTTOM: windowtext 1pt solid; HEIGHT: 15pt" width=3D"67">
<p style=3D"LINE-HEIGHT: normal; TEXT-ALIGN: center"
align=3D"center"><span=
style=3D"FONT-SIZE: 9pt; COLOR:
red">47</span></p></td>
<td style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORD=
ER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: yellow; PADDING-BOTTOM: 0=
in; BORDER-LEFT: #ece9d8; WIDTH: 56pt; PADDING-TOP: 0in;
BORDER-BOTTOM: win=
dowtext 1pt solid; HEIGHT: 15pt" width=3D"75">
<p style=3D"LINE-HEIGHT: normal; TEXT-ALIGN: center"
align=3D"center"><span=
style=3D"FONT-SIZE: 9pt; COLOR:
red">20090409</span></p></td>
<td style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORD=
ER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: yellow; PADDING-BOTTOM: 0=
in; BORDER-LEFT: #ece9d8; WIDTH: 56pt; PADDING-TOP: 0in; BORDER-BOTTOM: win=
dowtext 1pt solid; HEIGHT: 15pt" width=3D"75">
<p style=3D"LINE-HEIGHT: normal; TEXT-ALIGN: center"
align=3D"center"><span=
style=3D"FONT-SIZE: 9pt; COLOR:
red">209</span></p></td>
<td style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORD=
ER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: yellow; PADDING-BOTTOM: 0=
in; BORDER-LEFT: #ece9d8; WIDTH: 56pt; PADDING-TOP: 0in;
BORDER-BOTTOM: win=
dowtext 1pt solid; HEIGHT: 15pt" width=3D"75">
<p style=3D"LINE-HEIGHT: normal; TEXT-ALIGN: center"
align=3D"center"><span=
style=3D"FONT-SIZE: 9pt; COLOR:
red">78</span></p></td>
<td style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORD=
ER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: yellow; PADDING-BOTTOM: 0=
in; BORDER-LEFT: #ece9d8; WIDTH: 68pt; PADDING-TOP: 0in; BORDER-BOTTOM: win=
dowtext 1pt solid; HEIGHT: 15pt" width=3D"91">
<p style=3D"LINE-HEIGHT: normal; TEXT-ALIGN: center"
align=3D"center"><span=
style=3D"COLOR: red">1</span></p></td>
<td style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORD=
ER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: yellow; PADDING-BOTTOM: 0=
in; BORDER-LEFT: #ece9d8; WIDTH: 86pt; PADDING-TOP: 0in; BORDER-BOTTOM:
win=
dowtext 1pt solid; HEIGHT: 15pt" width=3D"115">
<p style=3D"LINE-HEIGHT: normal; TEXT-ALIGN: center"
align=3D"center"><span=
style=3D"FONT-SIZE: 9pt; COLOR:
red">69</span></p></td></tr>
<tr style=3D"HEIGHT: 15pt">
<td style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORD=
ER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: yellow; PADDING-BOTTOM: 0=
in; BORDER-LEFT: windowtext 1pt solid; WIDTH: 50pt; PADDING-TOP: 0in; BORDE=
R-BOTTOM: windowtext 1pt solid; HEIGHT: 15pt" width=3D"67">
<p style=3D"LINE-HEIGHT: normal; TEXT-ALIGN: center"
align=3D"center"><span=
style=3D"FONT-SIZE: 9pt; COLOR:
red">47</span></p></td>
<td style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORD=
ER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: yellow; PADDING-BOTTOM: 0=
in; BORDER-LEFT:
#ece9d8; WIDTH: 56pt; PADDING-TOP: 0in; BORDER-BOTTOM: win=
dowtext 1pt solid; HEIGHT: 15pt" width=3D"75">
<p style=3D"LINE-HEIGHT: normal; TEXT-ALIGN: center"
align=3D"center"><span=
style=3D"FONT-SIZE: 9pt; COLOR:
red">20090409</span></p></td>
<td style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORD=
ER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0i=
n; BORDER-LEFT: #ece9d8; WIDTH: 56pt; PADDING-TOP: 0in; BORDER-BOTTOM: wind=
owtext 1pt solid; HEIGHT: 15pt" width=3D"75">
<p style=3D"LINE-HEIGHT: normal; TEXT-ALIGN: center"
align=3D"center"><span=
style=3D"FONT-SIZE: 9pt; COLOR:
black">101</span></p></td>
<td style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORD=
ER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: white; PADDING-BOTTOM: 0i=
n; BORDER-LEFT:
#ece9d8; WIDTH: 56pt; PADDING-TOP: 0in; BORDER-BOTTOM: wind=
owtext 1pt solid; HEIGHT: 15pt" width=3D"75">
<p style=3D"LINE-HEIGHT: normal; TEXT-ALIGN: center"
align=3D"center"><span=
style=3D"FONT-SIZE: 9pt; COLOR:
black">69</span></p></td>
<td style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORD=
ER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ec=
e9d8; WIDTH: 68pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; H=
EIGHT: 15pt; BACKGROUND-COLOR: transparent" width=3D"91">
<p style=3D"LINE-HEIGHT: normal; TEXT-ALIGN: center"
align=3D"center"><span=
style=3D"COLOR: black"></span>=A0</p></td>
<td style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt;
BORD=
ER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ec=
e9d8; WIDTH: 86pt;
PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; H=
EIGHT: 15pt; BACKGROUND-COLOR: transparent" width=3D"115">
<p style=3D"LINE-HEIGHT: normal; TEXT-ALIGN: center"
align=3D"center"><span=
style=3D"COLOR:
black"></span>=A0</p></td></tr></tbody></table><br>
<p><span><font
color=3D"#000000"></font></span>=A0</p>
<p><font color=3D"#000000">I can explain more if it is
required</font></p>
<p><font color=3D"#000000">Thanks in
advance</font></p>
<p><font color=3D"#000000"></font>=A0</p>
<p><font
color=3D"#000000">Abdulrahman</font></p>=A0<br><br>
<hr>
Invite your mail contacts to join your friends list with Windows Live Space=
s. It's easy!
<a
href=3D"http://spaces.live.com/spacesapi.aspx?wx_actio=
n=3Dcreate&wx_url=3D/friends.aspx&mkt=3Den-us"
target=3D"_blank">Tr=
y it!</a><br>
<hr>
Invite your mail contacts to join your friends list with Windows Live Space=
s. It's easy! <a
href=3D"http://spaces.live.com/spacesapi.aspx?wx_actio=
n=3Dcreate&wx_url=3D/friends.aspx&mkt=3Den-us"
target=3D"_blank">Tr=
y it!</a> <br>
<hr>
<font face=3D"Arial" color=3D"gray"
size=3D"1">PRIVILEGED AND CONFIDENTIAL =
INFORMATION<br>This transmittal and any attachments may contain
PRIVILEGED =
AND<br>CONFIDENTIAL information and is intended only for the use of
the<br>=
addressee. If you are not the designated recipient, or an employee<br>
or agent authorized to deliver such transmittals to
the
designated<br>recip=
ient, you are hereby notified that any dissemination,<br>copying or
publica=
tion of this transmittal is strictly prohibited. If<br>you have received
th=
is transmittal in error, please notify us<br>
immediately by replying to the sender and delete this copy from
your<br>sys=
tem. You may also call us at (309) 827-6026 for
assistance.<br></font><br><=
/div></div>
<hr>
What can you do with the new Windows Live? <a
href=3D"http://www.microsoft.=
com/windows/windowslive/default.aspx" target=3D"_blank">Find
out</a></div><=
/blockquote></div><br>
--00504502c8632771c90469a44382--
------------------------------
Date: Mon, 11 May 2009 17:09:22 +0200
From: =?ISO-8859-1?Q?Marta_Garc=EDa-Granero?=
<[hidden email]>
Subject: Re: Tetrachoric
Correlations
stace swayne wrote:
>
> I have 15 variables (v1-v15) and they are dichotomous items. I would
> like to run an tetrachoric correlation, but I don't have an example of
> syntax for doing that. Does anyone on the list have code for this or
> can you direct me to a source?
>
Check Dirk Enzmann's page:
http://www2.jura.uni-hamburg.de/instkrim/kriminologie/Mitarbeiter/Enzmann/Software/Enzmann_Software.html
Close to the end (you'll have to scroll down quite a lot), you will find
this:
*TetCorr: *
DOS program and source code (Pascal) for computing a matrix of
tetrachoric correlation coefficients of up to 50 variables and a maximum
of 8,000 cases (see also: r_tetra).
Since the program reads text files, you can export them from SPSS, then
use Tetcorr, and import the output (a text file with the correlation
matrix) back into SPSS afterwards. Detailed instructions
for doing that
are provided too.
HTH,
Marta García-Granero
--
For miscellaneous SPSS related statistical stuff, visit:
http://gjyp.nl/marta/
------------------------------
Date: Mon, 11 May 2009 09:22:58 -0600
From: ViAnn Beadle <[hidden email]>
Subject: Re: Tetrachoric Correlations
Will tetrachoric really make much of a difference compared to the
point-biserial (Pearson Corr) with dichotomous variables?
-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Marta García-Granero
Sent: Monday, May 11, 2009 9:09 AM
To: [hidden email]
Subject: Re: Tetrachoric Correlations
stace swayne wrote:
>
> I have 15 variables (v1-v15) and they are dichotomous items. I would
> like to run an tetrachoric correlation, but I don't have an example of
> syntax for doing that. Does anyone on the
list have code for this or
> can you direct me to a source?
>
Check Dirk Enzmann's page:
http://www2.jura.uni-hamburg.de/instkrim/kriminologie/Mitarbeiter/Enzmann/So
ftware/Enzmann_Software.html
Close to the end (you'll have to scroll down quite a lot), you will find
this:
*TetCorr: *
DOS program and source code (Pascal) for computing a matrix of
tetrachoric correlation coefficients of up to 50 variables and a maximum
of 8,000 cases (see also: r_tetra).
Since the program reads text files, you can export them from SPSS, then
use Tetcorr, and import the output (a text file with the correlation
matrix) back into SPSS afterwards. Detailed instructions for doing that
are provided too.
HTH,
Marta García-Granero
--
For miscellaneous SPSS related statistical stuff, visit:
http://gjyp.nl/marta/
=====================
To manage your subscription to SPSSX-L, send a
message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD
------------------------------
Date: Mon, 11 May 2009 12:19:43 -0400
From: Michael Kruger <[hidden email]>
Subject: ROC Area under the Curve
Is anyone familiar with how to calculate the portion under an ROC curve
(AUC) for a specific FPR (false positive rate; 1 - specificity)) ?
I need to determine what the AUC is for various FPRs ranging from 5% to
25% from an ROC analysis.
Any help would be appreciated.
Michael Kruger
WSU School of Medicine
Dept. of OB/GYN
------------------------------
Date: Mon, 11 May 2009 18:39:38 +0200
From: =?ISO-8859-1?Q?Marta_Garc=EDa-Granero?=
<[hidden email]>
Subject: Re:
ROC Area under the Curve
Michael Kruger wrote:
> Is anyone familiar with how to calculate the portion under an ROC curve
> (AUC) for a specific FPR (false positive rate; 1 - specificity)) ?
>
> I need to determine what the AUC is for various FPRs ranging from 5% to
> 25% from an ROC analysis.
>
> Have you tried this link?
INFO: http://www.bio.ri.ccf.org/doc/partarea_help.txt
PROGRAM: http://www.bio.ri.ccf.org/doc/partarea.for
--
For miscellaneous SPSS related statistical stuff, visit:
http://gjyp.nl/marta/
------------------------------
Date: Mon, 11 May 2009 11:35:50 -0400
From: [hidden email]
Subject: Selection of cases based on date variable
This is a multipart message in MIME format.
--=_alternative 0055AD9C852575B3_=
Content-Type: text/plain; charset="US-ASCII"
Hello,
i have a simple question about the selection of cases
based on a date
variable. I have data collected every day for the last three month. I
would like to select cases based on the date variable (e.g. select only
those cases between March 3rd and 7th.). I just cant make it work somehow.
Among other things I tried "Select Cases / Based on time or case
range"
but I dont understand the input format that is needed for these fields.
Thanks alot,
Robinson
--------------------------------------------------------------------------------
Felix-Robinson Aschoff
Department of Informatics
University of Zurich
Binzmuehlestrasse 14
CH-8050 Zurich, Switzerland
E-Mail: [hidden email]
Phone: +41 (0)44 635 6690
Fax: +41 (0)44 635 6809
Room: 2.D.11
http://www.ifi.uzh.ch/im
--=_alternative 0055AD9C852575B3_=
Content-Type: text/html; charset="US-ASCII"
<br><font size=2
face="sans-serif">Hello,</font>
<br>
<br><font size=2 face="sans-serif">i have a simple
question about the selection
of cases based on a date variable. I have data collected every day for
the last three month. I would like to select cases based on the date variable
(e.g. select only those cases between March 3rd and 7th.). I just cant
make it work somehow. Among other things I tried "Select Cases / Based
on time or case range" but I dont understand the input format that
is needed for these fields.</font>
<br>
<br><font size=2 face="sans-serif">Thanks
alot,</font>
<br><font size=2 face="sans-serif">Robinson </font>
<br><font size=2
face="sans-serif">--------------------------------------------------------------------------------<br>
Felix-Robinson Aschoff<br>
Department of
Informatics<br>
University of Zurich<br>
Binzmuehlestrasse 14<br>
CH-8050 Zurich, Switzerland<br>
<br>
E-Mail: [hidden email]<br>
Phone: +41 (0)44 635 6690<br>
Fax: +41 (0)44 635 6809<br>
Room: 2.D.11<br>
</font><a href=http://www.ifi.uzh.ch/im><font size=2
face="sans-serif">http://www.ifi.uzh.ch/im<br>
<br>
</font></a>
--=_alternative 0055AD9C852575B3_=--
------------------------------
Date: Mon, 11 May 2009 12:19:50 -0500
From: Ariel Barak <[hidden email]>
Subject: Re: Selection of cases based on date variable
--0016364d1d9199dbf30469a62fcc
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Hi Robinson,
I don't use the GUI for selecting cases, so I can't help you with that.
But
here is some syntax that you can alter
and use as needed. In order for the
syntax below to work, the variables must be formated as date variables.
SELECT IF DateVariable>=DATE.MDY(3,3,2009) AND
DateVariable<=DATE.MDY(3,7,2009).
EXE.
This will drop all cases outside of these dates. If you are intersted in
summary statistics, you can use the temp command.
TEMP.
SELECT IF DateVariable>=DATE.MDY(3,3,2009 AND
DateVariable<=DATE.MDY(3,7,2009).
CROSSTABS Variable1 BY Variable2.
Good luck,
Ariel
On Mon, May 11, 2009 at 10:35 AM, <[hidden email]> wrote:
>
> Hello,
>
> i have a simple question about the selection of cases based on a date
> variable. I have data collected every day for the last three month. I
would
> like to select cases based on the date variable (e.g. select only those
> cases between March 3rd and 7th.). I just cant make it work somehow. Among
>
other things I tried "Select Cases / Based on time or case
range" but I dont
> understand the input format that is needed for these fields.
>
> Thanks alot,
> Robinson
>
>
--------------------------------------------------------------------------------> Felix-Robinson Aschoff
> Department of Informatics
> University of Zurich
> Binzmuehlestrasse 14
> CH-8050 Zurich, Switzerland
>
> E-Mail:
[hidden email]> Phone: +41 (0)44 635 6690
> Fax: +41 (0)44 635 6809
> Room: 2.D.11
> http://www.ifi.uzh.ch/im
>
>
--0016364d1d9199dbf30469a62fcc
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Hi Robinson,<br>=A0<br>I don't use the GUI for selecting
cases, so I ca=
n't help you with that. But here is some syntax that you can alter and
=
use as
needed. In order for the syntax below to work, the variables must be=
formated as date variables.<br>
=A0<br>SELECT IF DateVariable>=3DDATE.MDY(3,3,2009) AND
DateVariable<=
=3DDATE.MDY(3,7,2009).<br>EXE.<br>=A0<br>This will drop all
cases outside o=
f these dates. If you are intersted in summary statistics, you can use the =
temp command.<br>
=A0<br>TEMP.<br>SELECT IF DateVariable>=3DDATE.MDY(3,3,2009
AND DateVari=
able<=3DDATE.MDY(3,7,2009).<br>CROSSTABS Variable1 BY
Variable2.<br>=A0<=
br>Good luck,<br>Ariel<br><br>
<div class=3D"gmail_quote">On Mon, May 11, 2009 at 10:35 AM,
<span dir=3D"l=
tr"><<a
href=3D"mailto:[hidden email]">[hidden email]</a>></s=
pan> wrote:<br>
<blockquote class=3D"gmail_quote" style=3D"PADDING-LEFT:
1ex;
MARGIN: 0px 0=
px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid"><br><font
face=3D"sans-serif" si=
ze=3D"2">Hello,</font> <br><br><font
face=3D"sans-serif" size=3D"2">i have =
a simple question about the selection of cases based on a date variable. I =
have data collected every day for the last three month. I would like to sel=
ect cases based on the date variable (e.g. select only those cases between =
March 3rd and 7th.). I just cant make it work somehow. Among other things I=
tried "Select Cases / Based on time or case range" but I
dont un=
derstand the input format that is needed for these fields.</font>
<br>
<br><font face=3D"sans-serif" size=3D"2">Thanks
alot,</font> <br><font face=
=3D"sans-serif" size=3D"2">Robinson
</font><br><font face=3D"sans-serif"
si=
ze=3D"2">------------------------------------------------------------------=
--------------<br>
Felix-Robinson Aschoff<br>Department of Informatics<br>University
of Zurich=
<br>Binzmuehlestrasse 14<br>CH-8050 Zurich,
Switzerland<br><br>E-Mail: <a h=
ref=3D"mailto:[hidden email]"
target=3D"_blank">[hidden email]</a><=
br>
Phone: +41 (0)44 635 6690<br>Fax: +41 (0)44 635 6809<br>Room:
2.D.11<br></f=
ont><a href=3D"http://www.ifi.uzh.ch/im"
target=3D"_blank"><font face=3D"sa=
ns-serif"
size=3D"2">http://www.ifi.uzh.ch/im<br><br></font></a></blockquot=
e></div>
<br>
--0016364d1d9199dbf30469a62fcc--
------------------------------
Date: Mon, 11 May 2009 15:07:09 -0400
From: ksairam reddy
<[hidden email]>
Subject: <No subject given>
--_f1b996b3-5893-4113-b4c0-a9766f6eaf58_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
UNSUBSCRIBE SPSSX-L SAI RAM KEITHI REDDY
_________________________________________________________________
Insert movie times and more without leaving Hotmail=AE.
http://windowslive.com/Tutorial/Hotmail/QuickAdd?ocid=3DTXT_TAGLM_WL_HM_Tut=
orial_QuickAdd1_052009=
--_f1b996b3-5893-4113-b4c0-a9766f6eaf58_
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<html>
<head>
<style>
.hmmessage P
{
margin:0px=3B
padding:0px
}
body.hmmessage
{
font-size: 10pt=3B
font-family:Verdana
}
</style>
</head>
<body class=3D'hmmessage'>
UNSUBSCRIBE SPSSX-L SAI RAM KEITHI REDDY<br /><hr
/>Insert movie
times and =
more without leaving Hotmail=AE. <a
href=3D'http://windowslive.com/Tutorial=
/Hotmail/QuickAdd?ocid=3DTXT_TAGLM_WL_HM_Tutorial_QuickAdd1_052009' target=
=3D'_new'>See how.</a></body>
</html>=
--_f1b996b3-5893-4113-b4c0-a9766f6eaf58_--
------------------------------
Date: Mon, 11 May 2009 15:07:55 -0400
From: ksairam reddy <[hidden email]>
Subject: <No subject given>
--_247523ec-db34-4ffb-9951-7b6ec21f5655_
Content-Type: text/plain; charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
SIGNOFF SPSSX-L=20
_________________________________________________________________
Windows Live=99: Keep your life in sync.
http://windowslive.com/explore?ocid=3DTXT_TAGLM_BR_life_in_synch_052009=
--_247523ec-db34-4ffb-9951-7b6ec21f5655_
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
<html>
<head>
<style>
.hmmessage P
{
margin:0px=3B
padding:0px
}
body.hmmessage
{
font-size: 10pt=3B
font-family:Verdana
}
</style>
</head>
<body class=3D'hmmessage'>
<STRONG>SIGNOFF SPSSX-L</STRONG> <br /><hr />Windows
Live=99: Keep your lif=
e in sync. <a
href=3D'http://windowslive.com/explore?ocid=3DTXT_TAGLM_BR_li=
fe_in_synch_052009' target=3D'_new'>Check it
out.</a></body>
</html>=
--_247523ec-db34-4ffb-9951-7b6ec21f5655_--
------------------------------
Date: Mon, 11 May 2009 14:10:46 -0600
From: =?ISO-8859-1?Q?Rodrigo_Brice=F1o?= <[hidden email]>
Subject: about transposing-help
This is a multi-part message in MIME
format.
--------------060801060106020008030509
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
Dear SPSS listers. I have a database with information about expenditure
on a list of 45 products.
An identifier for each household is also provided.
The original format of my database is to have for example 45 rows for
the first household that have reported consume on each of the 45
products, however the number of products consumed by households could
vary between 1 and 45, and consequently varying number of rows.
The variables in my dataset are:
id: HH identifier
R802A: product name identifier
R805A: expenditure made in the product
What I need is to have each product as a column and each identifier as a
row. I was trying to use the restructuring function, but some errors
appeared: "The INDEX values for case 27964 have occurred before in the
cases with
the same ID values."
I also made a new empty database where I put ID in rows (so each line is
a HH) and 45 columns (where each column is a product) but the missing
part is how to put on each corresponding cell the expenditure made on
each product. I was trying some kind of merge, but I have no idea about
how to establish the filters to do it.
Any idea about how can I overcome this issue?
Thanks!
--
__________________________________________________________________
*Rodrigo Briceño*
Project Manager
Sanigest Internacional
+506 22-91-12-00 ext. 113 * Oficina* *Costa Rica*
+506 22-32-08-30 *Fax
*_rbriceno@sanigest.com_ <mailto:[hidden email]>
_www.sanigest.com_ <http://www.sanigest.com/>
MSN: _jbric98@hotmail.com_ <mailto:[hidden email]>
SKYPE: rbriceno1087
_____________________
This communication contains legal
information which is privileged and
confidential. It is for the exclusive use of the address and
distribution, dissemination, copying or use by others is strictly
prohibited. If you have received this communication by error, please
delete the original message and e-mail us.
Esta comunicación contiene información legal privilegiada y confidencial
para el uso exclusivo del destinatario. La distribución, diseminación,
copia u otro uso por terceras personas es estrictamente prohibida. Si
usted ha recibido esta comunicación por error, le rogamos borrar el
mensaje original y comunicárnoslo a esta misma dirección.
--------------060801060106020008030509
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
</head>
<body bgcolor="#ffffff"
text="#000000">
Dear SPSS listers. I have a database with information about expenditure
on a list of 45 products.<br>
An identifier for each household is also provided.<br>
The original format of my database is to have for example 45 rows for
the first household that have reported consume on each of the 45
products, however the number of products consumed by households could
vary between 1 and 45, and consequently varying number of rows.<br>
<br>
The variables in my dataset are: <br>
id: HH identifier<br>
R802A: product name identifier<br>
R805A: expenditure made in the product<br>
<br>
What I need is to have each product as a column and each identifier as
a row. I was trying to use the restructuring function, but some errors
appeared: "The INDEX values for case 27964 have occurred before in the
cases with the same ID
values."<br>
<br>
I also made a new empty database where I put ID in rows (so each line
is a HH) and 45 columns (where each column is a product) but the
missing part is how to put on each corresponding cell the expenditure
made on each product. I was trying some kind of merge, but I have no
idea about how to establish the filters to do it.<br>
<br>
Any idea about how can I overcome this issue?<br>
<br>
Thanks!<br>
<div class="moz-signature">-- <br>
<meta http-equiv="Content-Type" content="text/html;
">
<meta name="ProgId" content="Word.Document">
<meta name="Generator" content="Microsoft Word 11">
<meta name="Originator" content="Microsoft Word 11">
<link rel="File-List"
href="signature_files/filelist.xml">
<title>__________________________________________________________________</title>
<!--[if
gte mso 9]><xml>
<o:DocumentProperties>
<o:Author>Rodrigo Briceno</o:Author>
<o:Template>Normal</o:Template>
<o:LastAuthor>Rodrigo Briceno</o:LastAuthor>
<o:Revision>3</o:Revision>
<o:TotalTime>1</o:TotalTime>
<o:Created>2008-03-24T14:10:00Z</o:Created>
<o:LastSaved>2009-03-18T15:21:00Z</o:LastSaved>
<o:Pages>1</o:Pages>
<o:Words>184</o:Words>
<o:Characters>1053</o:Characters>
<o:Company>Sanigest</o:Company>
<o:Lines>8</o:Lines>
<o:Paragraphs>2</o:Paragraphs>
<o:CharactersWithSpaces>1235</o:CharactersWithSpaces>
<o:Version>11.9999</o:Version>
</o:DocumentProperties>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:WordDocument>
<w:SpellingState>Clean</w:SpellingState>
<w:GrammarState>Clean</w:GrammarState>
<w:ValidateAgainstSchemas/>
<w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid>
<w:IgnoreMixedContent>false</w:IgnoreMixedContent>
<w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText>
<w:BrowserLevel>MicrosoftInter
netExplorer4</w:BrowserLevel>
</w:WordDocument>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:LatentStyles DefLockedState="false"
LatentStyleCount="156">
</w:LatentStyles>
</xml><![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Sylfaen;
panose-1:1 10 5 2 5 3 6 3 3 3;
mso-font-charset:0;
mso-generic-font-family:roman;
mso-font-pitch:variable;
mso-font-signature:67110535 0 0 0 159 0;}
@font-face
{font-family:"Book Antiqua";
panose-1:2 4 6 2 5 3 5 3 3 4;
mso-font-charset:0;
mso-generic-font-family:roman;
mso-font-pitch:variable;
mso-font-signature:647 0 0 0 159 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-parent:"";
margin:0in;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";
color:black;}
a:link, span.MsoHyperlink
{color:blue;}
a:visited, span.MsoHyperlinkFollowed
{color:blue;}
span.SpellE
{mso-style-name:"";
mso-spl-e:yes;}
span.GramE
{mso-style-name:"";
mso-gram-e:yes;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;
mso-header-margin:35.4pt;
mso-footer-margin:35.4pt;
mso-paper-source:0;}
div.Section1
{page:Section1;}
-->
</style><!--[if gte mso 10]>
<style>
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:"Table Normal";
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-parent:"";
mso-padding-alt:0in 5.4pt 0in 5.4pt;
mso-para-margin:0in;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:10.0pt;
font-family:"Times New Roman";
mso-ansi-language:#0400;
mso-fareast-language:#0400;
mso-bidi-language:#0400;}
</style>
<![endif]--><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit"
spidmax="3074"/>
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1"/>
</o:shapelayout></xml><![endif]-->
<div class="Section1">
<p class="MsoNormal" style=""><span
style="font-size: 10pt; color: rgb(153, 204, 255);"
lang="PT-BR">__________________________________________________________________</span><span
style=""
lang="PT-BR"><u1:p></u1:p><o:p></o:p></span></p>
<p class="MsoNormal" style=""><b><span
style="font-size: 10pt; font-family: "Book
Antiqua";" lang="PT-BR">Rodrigo
Briceño</span></b><span
style="font-size: 10pt; font-family: "Book Antiqua";
color: rgb(153, 204, 255);"
lang="PT-BR"><br>
</span><span
style="font-size: 10pt; font-family: "Book
Antiqua";"
lang="PT-BR">Project Manager<br>
Sanigest Internacional</span><span style=""
lang="PT-BR"><u1:p></u1:p><o:p></o:p></span></p>
<p class="MsoNormal" style=""><span
style="font-size: 10pt; font-family: "Book
Antiqua";">+506<span
class="GramE">
22</span>-91-12-00 ext. 113 <b> <span
class="SpellE">Oficina</span></b>
<st1:place u2:st="on"><st1:country-region
u2:st="on"><b>Costa
Rica</b></st1:country-region></st1:place><br>
+506
22-32-08-30
<b>Fax<br>
</b></span><a href="mailto:[hidden email]"
title="blocked::mailto:[hidden email]"><u><span
style="font-size: 10pt; font-family:
Sylfaen;">[hidden email]</span></u></a><span
style="font-size: 10pt; font-family: Sylfaen; color: rgb(153, 204,
255);"><br>
</span><a href="http://www.sanigest.com/"
title="blocked::http://www.sanigest.com/"><u><span
style="font-size: 10pt; font-family:
Sylfaen;">www.sanigest.com</span></u></a><span
style="font-size: 10pt; font-family: Sylfaen; color: rgb(153, 204,
255);"><br>
</span><span
style="font-size: 10pt; font-family: "Book Antiqua";
color: navy;"><br>
MSN: </span><a href="mailto:[hidden email]"
title="blocked::mailto:[hidden email]
mailto:[hidden email]"><u><span
style="font-size: 10pt; font-family: "Book
Antiqua";">[hidden email]</span></u></a><span
style="font-size: 10pt; font-family: "Book Antiqua";
color: navy;"><br>
SKYPE: rbriceno1087</span></p>
<p class="MsoNormal" style=""><span
style="font-size: 10pt; color: rgb(153, 204,
255);">_____________________</span></p>
<p class="MsoNormal" style="text-align:
justify;"><span
style="font-size: 8pt; font-family: "Book
Antiqua";">This
communication contains legal information which is privileged and
confidential.
It is for the exclusive use of the address and distribution,
dissemination,
copying or use by others is strictly prohibited. If you have received
this
communication
by error, please delete the original message and e-mail
us.</span></p>
<p class="MsoNormal" style="text-align:
justify;"><span
style="font-size: 8pt; font-family: "Book Antiqua";
color: rgb(153, 204, 255);"
lang="ES-CR"><br>
</span><span style="font-size: 8pt; font-family: "Book
Antiqua";"
lang="ES-CR">Esta comunicación contiene
información
legal privilegiada y confidencial para el uso exclusivo del
destinatario. La
distribución, diseminación, copia u otro uso por terceras
personas es estrictamente prohibida. Si usted ha recibido esta
comunicación por error, le rogamos borrar el mensaje original y
comunicárnoslo a esta misma
dirección.</span><span
style=""
lang="ES-CR"><u1:p></u1:p><o:p></o:p></span></p>
</div>
</div>
</body>
</html>
--------------060801060106020008030509--
------------------------------
Date: Mon, 11 May 2009 16:30:22 -0400
From: Gene Maguin <[hidden email]>
Subject: V16 Examine procedure
I'm curious. Are there known problems with the examine procedure when
multiple dvs are listed, no factors and pairwise missing?
I think there is. Specifically, the box plots seem to be incorrect (and or
incorrectly labeled using the id options). I'm not sure which. Or the names
are incorrect. I'm not quite sure.
Switching back to nameing just one dv seems to fix the problem.
Also, and maybe this has always been true, the plots show variable labels
but not variable NAME.
Gene
Maguin
------------------------------
Date: Mon, 11 May 2009 18:58:15 -0500
From: Ariel Barak <[hidden email]>
Subject: Re: about transposing-help
--00504502d07c6cdc510469abc081
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Hi Rodrigo,
You are on the right track with looking to restructure the data. The error
you're describing is likely because you have two rows that are identical by
what you want the identifying variables to be, likely the HH identifier and
the produce name identifier.
For example, if you have two rows like this, you will get the error:
HH R802A R805A
0001 521 200
0001 521 125
So, the same family may have bought the same product twice and in your
database, you have it as two rows. If you aggregate the data and break by
HH, R802A, and then take the sum of R805A, you
should then be able to
restructure your data without the error(s) you observed. You want the row t=
o
look like:
HH R802A R805A_sum
0001 521 325
You could post a few lines of your data or some dummy data and what you'd
like the result to look like and the list may be able to give you a more
concrete solution.
Thanks,
Ariel
On Mon, May 11, 2009 at 3:10 PM, Rodrigo Brice=F1o
<[hidden email]>w=
rote:
> Dear SPSS listers. I have a database with information about expenditure =
on
> a list of 45 products.
> An identifier for each household is also provided.
> The original format of my database is to have for example 45 rows for the
> first household that have reported consume on each of the 45 products,
> however the number of products consumed by households could vary between =
1
> and 45, and consequently varying number of
rows.
>
> The variables in my dataset are:
> id: HH identifier
> R802A: product name identifier
> R805A: expenditure made in the product
>
> What I need is to have each product as a column and each identifier as a
> row. I was trying to use the restructuring function, but some errors
> appeared: "The INDEX values for case 27964 have occurred before in
the ca=
ses
> with the same ID values."
>
> I also made a new empty database where I put ID in rows (so each line is =
a
> HH) and 45 columns (where each column is a product) but the missing part =
is
> how to put on each corresponding cell the expenditure made on each produc=
t.
> I was trying some kind of merge, but I have no idea about how to establis=
h> the filters to do it.
>
> Any idea about how can I overcome this issue?
>
> Thanks!
> --
>
>
__________________________________________________________________
>
> *Rodrigo Brice=F1o*
> Project Manager
> Sanigest Internacional
>
> +506 22-91-12-00 ext. 113 * Oficina* *Costa Rica*
> +506 22-32-08-30 *Fax
> **
[hidden email]* <
[hidden email]>
> *www.sanigest.com* <http://www.sanigest.com/>
>
> MSN: *
[hidden email]* <
[hidden email]>
> SKYPE: rbriceno1087
>
> _____________________
>
> This communication contains legal information which is privileged and
> confidential. It is for the exclusive use of the address and distribution=
> dissemination, copying or use by others is strictly prohibited. If you ha=
ve
> received this communication by error, please delete the original message =
and
> e-mail us.
>
>
> Esta comunicaci=F3n contiene
informaci=F3n legal privilegiada y confidenc=
ial
> para el uso exclusivo del destinatario. La distribuci=F3n, diseminaci=F3n=
, copia
> u otro uso por terceras personas es estrictamente prohibida. Si usted ha
> recibido esta comunicaci=F3n por error, le rogamos borrar el mensaje orig=
inal
> y comunic=E1rnoslo a esta misma direcci=F3n.
>
--00504502d07c6cdc510469abc081
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Hi Rodrigo,<br><br>You are on the right track with looking to
restructure t=
he data. The error you're describing is likely because you have two
row=
s that are identical by what you want the identifying variables to be, like=
ly the HH identifier and the produce name identifier.<br>
<br>For example, if you have two rows like this, you will get the
error:<br=
><br>HH=A0=A0=A0
R802A=A0 R805A<br>0001=A0 521=A0=A0=A0=A0=A0
200<br>0001=
=A0 521=A0=A0=A0=A0=A0 125<br><br>So, the same family may have
bought the s=
ame product twice and in your database, you have it as two rows. If you agg=
regate the data and break by HH, R802A, and then take the sum of R805A, you=
should then be able to restructure your data without the error(s) you obse=
rved. You want the row to look like:<br>
<br>HH=A0=A0=A0 R802A=A0 R805A_sum<br>
0001=A0 521=A0=A0=A0=A0=A0 325<br><br>You could post a few lines of
your da=
ta or some dummy data and what you'd like the result to look like and
t=
he list may be able to give you a more concrete
solution.<br><br>Thanks,<br=
>Ariel<br>
<br><div class=3D"gmail_quote">On Mon, May 11, 2009 at
3:10 PM, Rodrigo Bri=
ce=F1o <span
dir=3D"ltr"><<a
href=3D"mailto:[hidden email]">rbric=
[hidden email]</a>></span> wrote:<br><blockquote
class=3D"gmail_quote"=
style=3D"border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt
0.=
8ex; padding-left: 1ex;">
<div bgcolor=3D"#ffffff" text=3D"#000000">
Dear SPSS listers. I have a database with information about expenditure
on a list of 45 products.<br>
An identifier for each household is also provided.<br>
The original format of my database is to have for example 45 rows for
the first household that have reported consume on each of the 45
products, however the number of products consumed by households could
vary between 1 and 45, and consequently varying number of rows.<br>
<br>
The variables in my dataset are: <br>
id: HH identifier<br>
R802A: product name
identifier<br>
R805A: expenditure made in the product<br>
<br>
What I need is to have each product as a column and each identifier as
a row. I was trying to use the restructuring function, but some errors
appeared: "The INDEX values for case 27964 have occurred before in the
cases with the same ID values."<br>
<br>
I also made a new empty database where I put ID in rows (so each line
is a HH) and 45 columns (where each column is a product) but the
missing part is how to put on each corresponding cell the expenditure
made on each product. I was trying some kind of merge, but I have no
idea about how to establish the filters to do it.<br>
<br>
Any idea about how can I overcome this issue?<br>
<br>
Thanks!<br>
<div>-- <br>
<div>
<p><span style=3D"font-size: 10pt;
color: rgb(153, 204,
255);" lang=3D"PT-B=
R">__________________________________________________________________</span=
><span lang=3D"PT-BR"></span></p>
<p><b><span style=3D"font-size: 10pt; font-family:
"Book Antiqua"=
;" lang=3D"PT-BR">Rodrigo
Brice=F1o</span></b><span style=3D"font-size: 10pt;
font-family: "Book=
Antiqua"; color: rgb(153, 204, 255);"
lang=3D"PT-BR"><br>
</span><span style=3D"font-size: 10pt; font-family:
"Book Antiqua"=
;;" lang=3D"PT-BR">Project Manager<br>
Sanigest Internacional</span><span
lang=3D"PT-BR"></span></p>
<p><span style=3D"font-size: 10pt; font-family: "Book
Antiqua";">=
+506<span>=A0
22</span>-91-12-00=A0ext. 113
=A0<b>
<span>Oficina</span></b>
<b>Costa Rica</b><br>
+506=A0
22-32-08-30=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0
=A0 <b>Fax<br>
</b></span><a href=3D"mailto:[hidden email]"
title=3D"blocked::mailto:ma=
[hidden email]" target=3D"_blank"><u><span
style=3D"font-size: 10pt; font-=
family:
Sylfaen;">[hidden email]</span></u></a><span
style=3D"font-s=
ize: 10pt; font-family: Sylfaen; color: rgb(153, 204, 255);"><br>
</span><a href=3D"http://www.sanigest.com/"
title=3D"blocked::http://www.sa=
nigest.com/" target=3D"_blank"><u><span
style=3D"font-size: 10pt; font-fami=
ly: Sylfaen;">www.sanigest.com</span></u></a><span
style=3D"font-size: 10pt=
; font-family: Sylfaen; color: rgb(153, 204,
255);"><br>
</span><span style=3D"font-size: 10pt; font-family:
"Book Antiqua"=
;; color: navy;"><br>
MSN: </span><a href=3D"mailto:[hidden email]"
title=3D"blocked::mailto=
:[hidden email]
mailto:[hidden email]"
target=3D"_blank"><u><span style=3D"font-size: =
10pt; font-family: "Book
Antiqua";">[hidden email]</span></u=
></a><span style=3D"font-size: 10pt; font-family:
"Book Antiqua";=
color: navy;"><br>
SKYPE: rbriceno1087</span></p>
<p><span style=3D"font-size: 10pt; color: rgb(153, 204,
255);">____________=
_________</span></p>
<p style=3D"text-align: justify;"><span
style=3D"font-size: 8pt; font-famil=
y: "Book Antiqua";">This
communication contains legal
information which is privileged and
confidential.
It is for the exclusive use of the address and distribution,
dissemination,
copying or use by others is strictly prohibited. If you have received
this
communication by error, please delete the original message and e-mail
us.</span></p>
<p style=3D"text-align: justify;"><span
style=3D"font-size: 8pt; font-famil=
y: "Book Antiqua"; color: rgb(153, 204, 255);"
lang=3D"ES-CR"><br=
>
</span><span style=3D"font-size: 8pt; font-family: "Book
Antiqua"=
;" lang=3D"ES-CR">Esta comunicaci=F3n contiene informaci=F3n
legal privilegiada y confidencial para el uso exclusivo del
destinatario. La
distribuci=F3n, diseminaci=F3n, copia u otro uso por terceras
personas es estrictamente prohibida. Si usted ha recibido esta
comunicaci=F3n por error, le rogamos borrar el mensaje original
y
comunic=E1rnoslo a esta misma direcci=F3n.</span><span
lang=3D"ES-CR"></spa=
n></p>
</div>
</div>
</div>
</blockquote></div><br>
--00504502d07c6cdc510469abc081--
------------------------------
Date: Tue, 12 May 2009 09:27:32 +0800
From: Johnny Amora <[hidden email]>
Subject: Z-test in SPSS (was: Re: hypothesis testing for difference between two
means)
--0-1535290727-1242091652=:76543
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
Jimjohn wrote:
<<Thanks for all the responses guys. Johnny, I appreciate you explaining
ho=
w
the grouping variable works. Just one follow up question, I understand if I
go to Compare Means -> Independent Test, then this will conduct a t-test to
compare means. My sample size is about 36, I
believe if the sample size is
>30, a z test should be used. Any ideas if SPSS can do a Z-test too to
compare means?
=A0
There is no (direct) Z-test in SPSS.=A0 Just use T-test, instead.=A0 You do=
nt need to use Z-test because=A0the T approaches Z as n approaches infinity=
. (That is,=A0the T=3DZ for large n).=A0 Is your sample size enough?=A0 The=
rule of thumb for sample size is 10 to 20 cases per variable.=A0 You shoul=
d also consider the outliers, missing values of your raw data.=A0 You shoul=
d not forget to do some diagnostic tests of your regression model,=A0 The r=
egression page of UCLA might be helpful to you: http://www.ats.ucla.edu/sta=
t/spss/webbooks/reg/default.htm
=A0
Hope this helps.
Johnny
=A0
=A0
--- On Mon, 5/11/09, jimjohn <[hidden email]> wrote:
From: jimjohn <[hidden email]>
Subject: Re: hypothesis testing for difference
between two means
To: [hidden email]
Date: Monday, 11 May, 2009, 10:46 PM
Thanks for all the responses guys. Johnny, I appreciate you explaining how
the grouping variable works. Just one follow up question, I understand if I
go to Compare Means -> Independent Test, then this will conduct a t-test to
compare means. My sample size is about 36, I believe if the sample size is
>30, a z test should be used. Any ideas if SPSS can do a Z-test too to
compare means?
To the posters who posted before, thanks for the suggestions. I would
normally do exactly what you guys recommended, but the circumstances are
different here. Someone else has already performed an analysis claiming tha=
t
there is a difference between the two means, that the <$1000 certificate
customers are more sensitive to interest rate changes than the >$1000
certificate customers. Since this is not an intuitive
conclusion, I wanted
to run this test to see if the results are significant.
Johnny Amora wrote:
>
> At 10:32 AM 5/8/2009, jimjohn wrote:
>>does anyone here know how to compute hypothesis tests/confidence
interval=
s
>>for the difference between two means in SPSS? For example, I am
comparing
>>the volume growth of my certificates with balance less than $1000
versus
the
>>volume growth with balances greater than $1000. I want to see if the
>>difference in the two means is statistically significant. Any ideas? I
don't
>>think comparing means does it because it has something about grouping
and
>>factors. thanks!
>>--
>
> You can use the Independent Sample TTest procedure. You should have
> numeric variables for GROWTH and BALANCE where GROWTH=C2 as your test
> variable and BALANCE as your grouping
variable.=C2=A0 The BALANCE=C2 shou=
ld be
> coded for example as follows: 1=3D balance=C2 less than $1000 and 2=C2 =
=3D greater
> than $1000.=C2=A0 Then run the synax:
> =C2
> T-TEST GROUPS=3DBALANCE(1 2)
> =C2=A0 /MISSING=3DANALYSIS
> =C2=A0 /VARIABLES=3DGROWTH
> =C2=A0 /CRITERIA=3DCI(.95).
>
> The confidence interval (CI) can be changed to=C2 what you want, say .99.=
=C2
> Hope I understand correctly your need.
> =C2
> Cheers,
> Johnny
>
>
>=A0 =A0 =A0=A0=A0Yahoo! Mail Now Faster and Cleaner. Experience it at
> http://ph.mail.yahoo.com=A0 today!
>
--
View this message in context: http://www.nabble.com/hypothesis-testing-for-=
difference-between-two-means-tp23452014p23484789.html
Sent from the SPSSX Discussion mailing list archive at
Nabble.com.
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD
=0A=0A=0A How can I tell if my jewelry is real silver? Find Out on Yah=
oo! Answers. http://ph.answers.yahoo.com/
--0-1535290727-1242091652=:76543
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
<table cellspacing=3D"0" cellpadding=3D"0"
border=3D"0" ><tr><td valign=3D"=
top" style=3D"font: inherit;"><DIV>Jimjohn
wrote:</DIV>
<DIV><BR><<Thanks for all the responses guys. Johnny,
I appreciate yo=
u explaining how<BR>the grouping variable works.
Just one follow up
questio=
n, I understand if I<BR>go to Compare Means -> Independent Test,
then th=
is will conduct a t-test to<BR>compare means. My sample size is about 36,
I=
believe if the sample size is<BR>>30, a z test should be used.
Any idea=
s if SPSS can do a Z-test too to<BR>compare means?</DIV>
<DIV> </DIV>
<DIV>There is no (direct) Z-test in SPSS. Just use T-test,
instead.&n=
bsp; You dont need to use Z-test because the T approaches Z as n
appro=
aches infinity. (That is, the T=3DZ for large n). Is your
sample=
size enough? The rule of thumb for sample size is 10 to 20 cases
per=
variable. You should also consider the outliers, missing values of
y=
our raw data. You should not forget to do some diagnostic tests of
yo=
ur regression
model, The regression page of UCLA might be helpful to
=
you: <A
href=3D"http://www.ats.ucla.edu/stat/spss/webbooks/reg/default.htm"=
>http://www.ats.ucla.edu/stat/spss/webbooks/reg/default.htm</A></DIV>
<DIV> </DIV>
<DIV>Hope this helps.</DIV>
<DIV>Johnny</DIV>
<DIV> </DIV>
<DIV><BR><BR> </DIV><BR><BR>--- On
<B>Mon, 5/11/09, jimjohn <I><aza=
[hidden email]></I></B> wrote:<BR>
<BLOCKQUOTE style=3D"PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT:
rgb(=
16,16,255) 2px solid"><BR>From: jimjohn
<[hidden email]><BR>Su=
bject: Re: hypothesis testing for difference between two means<BR>To:
SPSSX=
-[hidden email]<BR>Date: Monday, 11 May, 2009,
10:46
PM<BR><BR>
<DIV class=3DplainMail>Thanks for all the responses guys. Johnny, I
appreci=
ate you explaining how<BR>the grouping variable works. Just one follow up
q=
uestion, I understand if I<BR>go to Compare Means -> Independent
Test, t=
hen this will conduct a t-test to<BR>compare means. My sample size is
about=
36, I believe if the sample size is<BR>>30, a z test should be
used. An=
y ideas if SPSS can do a Z-test too to<BR>compare
means?<BR><BR>To the post=
ers who posted before, thanks for the suggestions. I would<BR>normally do
e=
xactly what you guys recommended, but the circumstances are<BR>different
he=
re. Someone else has already performed an analysis claiming that<BR>there
i=
s a difference between the two means, that the <$1000
certificate<BR>cus=
tomers are more
sensitive to interest rate changes than the
>$1000<BR>ce=
rtificate customers. Since this is not an intuitive conclusion, I wanted<BR=
>to run this test to see if the results are
significant.<BR><BR><BR><BR><BR><BR><BR>Johnny
Amora wrote:<BR>><BR>>=
; At 10:32 AM 5/8/2009, jimjohn wrote:<BR>>>does anyone
here know how=
to compute hypothesis tests/confidence intervals<BR>>>for
the differ=
ence between two means in SPSS? For example, I am
comparing<BR>>>the =
volume growth of my certificates with balance less than $1000
versus<BR>the=
<BR>>>volume growth with balances greater than $1000. I
want to see i=
f the<BR>>>difference in the two means is statistically
significant. =
Any ideas?
I<BR>don't<BR>>>think comparing means
does it because it h=
as something about grouping and<BR>>>factors.
thanks!<BR>>>--<B=
R>><BR>> You can use the Independent Sample TTest
procedure. You shou=
ld have<BR>> numeric variables for GROWTH and BALANCE where
GROWTH=C2 as=
your test<BR>> variable and BALANCE as your grouping
variable.=C2 =
The BALANCE=C2 should be<BR>> coded for example as follows: 1=3D
balance=C2 less than $1000 and 2=C2 =3D greater<BR>> than
$1000.=C2&nbs=
p; Then run the synax:<BR>> =C2<BR>> T-TEST
GROUPS=3DBALANCE(1 2)<BR>=
> =C2 /MISSING=3DANALYSIS<BR>> =C2
/VARIABLES=3DGROWTH<BR=
>>
=C2
/CRITERIA=3DCI(.95).<BR>><BR>> The confidence interva=
l (CI) can be changed to=C2 what you want, say .99.=C2<BR>> Hope I
under=
stand correctly your need.<BR>> =C2<BR>>
Cheers,<BR>> Johnny<BR>&g=
t;<BR>><BR>>
Yahoo! Mail Now Faster an=
d Cleaner. Experience it at<BR>> <A
href=3D"http://ph.mail.yahoo.com/" t=
arget=3D_blank>http://ph.mail.yahoo.com</A>
today!<BR>><BR><BR>--<=
BR>View this message in context:
<A
href=3D"http://www.nabble.com/hypothesi=
s-testing-for-difference-between-two-means-tp23452014p23484789.html"
target=
=3D_blank>http://www.nabble.com/hypothesis-testing-for-difference-between-t=
wo-means-tp23452014p23484789.html</A><BR>Sent from the SPSSX
Discussion mai=
ling list archive at
Nabble.com.<BR><BR>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D<BR>To manage your subscription to SPSSX-L, send a message
to<BR><=
A
href=3D"http://ph.mc764.mail.yahoo.com/mc/compose?to=3DLISTSERV@LISTSERV.=
UGA.EDU"
ymailto=3D"mailto:[hidden email]">[hidden email]=
.EDU</A> (not to SPSSX-L), with no body text except the<BR>command.
To leav=
e the list, send the command<BR>SIGNOFF SPSSX-L<BR>For a list of
commands t=
o manage subscriptions, send the
command<BR>INFO
REFCARD<BR></DIV></BLOCKQU=
OTE></td></tr></table><br>=0A <hr
size=3D1> <a href=3D"http://ph.answe=
rs.yahoo.com/question/index?qid=3D20080629165543AAcKnII">How do I quit
smok=
ing?</a> <br> Find out the ways on Yahoo! Answers!
--0-1535290727-1242091652=:76543--
------------------------------
End of SPSSX-L Digest - 10 May 2009 to 11 May 2009 (#2009-132)
**************************************************************
Locked
