LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (May 2009)Back to main SPSSX-L pageJoin or leave SPSSX-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Tue, 12 May 2009 16:54:48 -0700
Reply-To:     shanta_griffin@yahoo.com
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         Shanta Griffin <shanta_griffin@yahoo.com>
Subject:      Unsubscribe
In-Reply-To:  <200905120400.n4C0fxlJ004986@malibu.cc.uga.edu>
Content-Type: multipart/alternative;

Please help, this is my fourth attempt to unsubscribe. I have sent emails to the address noted at the end of these emails for people who want to unsubscribe. However, my attempts have been ignored. Please drop me from the list. I dont know what else to do but ask help from people who view these emails. How do I stop these emails, because the unsubscribe option they advertise is not working. Is there a number I should call?

--- On Tue, 5/12/09, Automatic digest processor <LISTSERV@LISTSERV.UGA.EDU> wrote: From: Automatic digest processor <LISTSERV@LISTSERV.UGA.EDU> Subject: SPSSX-L Digest - 10 May 2009 to 11 May 2009 (#2009-132) To: "Recipients of SPSSX-L digests" <SPSSX-L@LISTSERV.UGA.EDU> 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 LISTSERV@LISTSERV.UGA.EDU (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 <ksairamreddy@hotmail.com> 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 <bertol.77@gmail.com> 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 <abdelrhmm@hotmail.com> 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: mives@chestnut.org Subject: Re: creating new variables To: SPSSX-L@LISTSERV.UGA.EDU

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:SPSSX-L@LISTSERV.UGA.EDU] On Behalf Of abdelrhman elmubarak Sent: Thursday, May 07, 2009 3:36 AM To: SPSSX-L@LISTSERV.UGA.EDU 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&nbsp;work very fine if there are one repair on the same day...any help is higly appreciated.<BR> thanks<BR> Abdulrahman<BR>&nbsp;<BR> <HR id=stopSpelling> Date: Thu, 7 May 2009 09:14:37 -0500<BR>From: mives@chestnut.org<BR>Subject: Re: creating new variables<BR>To: SPSSX-L@LISTSERV.UGA.EDU<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.&nbsp; (it may help to create a dichotomy for rep209=1 or 0 if not--something like this would be needed if there are &gt;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>&nbsp;</DIV> <DIV dir=ltr align=left><SPAN class=EC_353335913-07052009><FONT face=Arial color=#0000ff>THE FOLLOWING&nbsp;ASSUMES that no client has &gt;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>&nbsp;</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> &nbsp;<BR> &nbsp;<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>&nbsp;</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>&nbsp;</FONT></SPAN></DIV></DIV> <DIV dir=ltr align=left><SPAN class=EC_353335913-07052009><FONT face=Arial color=#0000ff></FONT></SPAN>&nbsp;</DIV> <DIV dir=ltr align=left> <HR> </DIV> <DIV dir=ltr align=left><FONT face=Tahoma><B>From:</B> SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU] <B>On Behalf Of </B>abdelrhman elmubarak<BR><B>Sent:</B> Thursday, May 07, 2009 3:36 AM<BR><B>To:</B> SPSSX-L@LISTSERV.UGA.EDU<BR><B>Subject:</B> [SPSSX-L] creating new variables<BR></FONT><BR></DIV> <DIV></DIV><BR>&nbsp;&nbsp;<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>&nbsp;</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>&nbsp;</P> <P class=EC_EC_MsoNormal><FONT color=#000000>I want to create two more variables for those <SPAN>&nbsp;</SPAN>who <SPAN>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</P></TD></TR></TBODY></TABLE><BR> <P class=EC_EC_MsoNormal><SPAN><FONT color=#000000></FONT></SPAN>&nbsp;</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>&nbsp;</P> <P class=EC_EC_MsoNormal><FONT color=#000000>Abdulrahman</FONT></P>&nbsp;<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&amp;wx_url=/friends.aspx&amp;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&amp;wx_url=/friends.aspx&amp;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 <lucameyer@vodafone.it> 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 <peter.watson@mrc-cbu.cam.ac.uk> 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: peter.watson@mrc-cbu.cam.ac.uk

------------------------------

Date: Mon, 11 May 2009 13:51:24 +0200 From: uwe warner <uwe.warner@ceps.lu> 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:SPSSX-L@LISTSERV.UGA.EDU] On Behalf Of Luca Meyer Sent: Montag, 11. Mai 2009 10:31 To: SPSSX-L@LISTSERV.UGA.EDU 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 LISTSERV@LISTSERV.UGA.EDU (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 <vab88011@gmail.com> 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:SPSSX-L@LISTSERV.UGA.EDU] On Behalf Of Luca Meyer Sent: Monday, May 11, 2009 2:31 AM To: SPSSX-L@LISTSERV.UGA.EDU 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 LISTSERV@LISTSERV.UGA.EDU (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 <cdavis1@U.NORTHWESTERN.EDU> 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 &amp; 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 <garry@business-analytic.co.uk> 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:SPSSX-L@LISTSERV.UGA.EDU] On Behalf Of Caroline Davis Sent: 10 May 2009 22:31 To: SPSSX-L@LISTSERV.UGA.EDU 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>&nbsp;</DIV> <DIV dir=3Dltr align=3Dleft><SPAN class=3D640570514-11052009><FONT = color=3D#0000ff=20 size=3D2 face=3DArial>It&nbsp;is not a requirement for regression that = your=20 independent variables be normally distributed.&nbsp; (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>&nbsp;</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>&nbsp;</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>&nbsp;</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:SPSSX-L@LISTSERV.UGA.EDU] <B>On Behalf Of = </B>Caroline=20 Davis<BR><B>Sent:</B> 10 May 2009 22:31<BR><B>To:</B>=20 SPSSX-L@LISTSERV.UGA.EDU<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 &amp; 2 are not normally distributed. &nbsp;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?= <mgarciagranero@gmail.com> 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?= <mgarciagranero@gmail.com> 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 <Art@DrKendall.org> 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.&nbsp; 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.&nbsp; Is there&nbsp; a reason to explore accuracy as a DV?<br> <br> Art Kendall<br> Social Research Consultants<br> <br> Caroline Davis wrote: <blockquote cite="mid:276732.66243.qm@web82808.mail.mud.yahoo.com" 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 &amp; 2 are not normally distributed. &nbsp;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?= <mgarciagranero@gmail.com> 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 <azam.khan@utoronto.ca> 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 <jladyl@yahoo.com> 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>&nbsp;</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>&nbsp;</DIV> <DIV>All suggestions are appreciated,</DIV> <DIV>&nbsp;</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?= <mgarciagranero@gmail.com> 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 <abarakabarak@gmail.com> 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 <abdelrhmm@hotmail.com>

> 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: mives@chestnut.org > Subject: Re: creating new variables > > To: SPSSX-L@LISTSERV.UGA.EDU > > 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 = 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 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:SPSSX-L@LISTSERV.UGA.EDU] *On Behalf > Of *abdelrhman elmubarak > *Sent:* Thursday, May 07, 2009 3:36 AM > *To:* SPSSX-L@LISTSERV.UGA.EDU > *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= eir > 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&lt;&gt;209.<br>DATASET DECLARE ExtraRepa= irs.<br>AGGREGATE<br>=A0 /OUTFILE=3D&#39;ExtraRepairs&#39;<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&#39;ExtraRepairs&#39;<br>=A0 /B= Y=A0 ID RepairDate.<br>EXECUTE.</div> <div>=A0</div> <div>IF RepairType&lt;&gt;209 MoreJobsPlus=3D0.<br>IF RepairType&lt;&gt;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"= >&lt;<a href=3D"mailto:abdelrhmm@hotmail.com">abdelrhmm@hotmail.com</a>&gt;= </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">mives@chestnut.org</a><br>Subject: Re: creating = new variables=20 <div> <div></div> <div class=3D"h5"><br>To: <a href=3D"mailto:SPSSX-L@LISTSERV.UGA.EDU" targe= t=3D"_blank">SPSSX-L@LISTSERV.UGA.EDU</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 &gt;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 &gt;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:SPSSX-L@LISTSERV.UGA.EDU" target=3D"_= blank">SPSSX-L@LISTSERV.UGA.EDU</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= :SPSSX-L@LISTSERV.UGA.EDU" target=3D"_blank">SPSSX-L@LISTSERV.UGA.EDU</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&#39;s easy! <a href=3D"http://spaces.live.com/spacesapi.aspx?wx_actio= n=3Dcreate&amp;wx_url=3D/friends.aspx&amp;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&#39;s easy! <a href=3D"http://spaces.live.com/spacesapi.aspx?wx_actio= n=3Dcreate&amp;wx_url=3D/friends.aspx&amp;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?= <mgarciagranero@gmail.com> 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 <vab88011@gmail.com> 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:SPSSX-L@LISTSERV.UGA.EDU] On Behalf Of Marta García-Granero Sent: Monday, May 11, 2009 9:09 AM To: SPSSX-L@LISTSERV.UGA.EDU 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 LISTSERV@LISTSERV.UGA.EDU (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 <aa3657@wayne.edu> 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?= <mgarciagranero@gmail.com> 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: aschoff@IFI.UZH.CH 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: aschoff@ifi.uzh.ch 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 &quot;Select Cases / Based on time or case range&quot; 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: aschoff@ifi.uzh.ch<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 <abarakabarak@gmail.com> 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, <aschoff@ifi.uzh.ch> 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: aschoff@ifi.uzh.ch > 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&#39;t use the GUI for selecting cases, so I ca= n&#39;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&gt;=3DDATE.MDY(3,3,2009) AND DateVariable&lt;= =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&gt;=3DDATE.MDY(3,3,2009 AND DateVari= able&lt;=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">&lt;<a href=3D"mailto:aschoff@ifi.uzh.ch">aschoff@ifi.uzh.ch</a>&gt;</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 &quot;Select Cases / Based on time or case range&quot; 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:aschoff@ifi.uzh.ch" target=3D"_blank">aschoff@ifi.uzh.ch</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 <ksairamreddy@hotmail.com> 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 <ksairamreddy@hotmail.com> 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?= <rbriceno@sanigest.com> 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:mail@sanigest.com> _www.sanigest.com_ <http://www.sanigest.com/>

MSN: _jbric98@hotmail.com_ <mailto:jbric98@hotmail.com> 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: &quot;Book Antiqua&quot;;" lang="PT-BR">Rodrigo Brice&ntilde;o</span></b><span style="font-size: 10pt; font-family: &quot;Book Antiqua&quot;; color: rgb(153, 204, 255);" lang="PT-BR"><br> </span><span style="font-size: 10pt; font-family: &quot;Book Antiqua&quot;;" 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: &quot;Book Antiqua&quot;;">+506<span class="GramE">&nbsp; 22</span>-91-12-00&nbsp;ext. 113 &nbsp;<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&nbsp; 22-32-08-30&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; <b>Fax<br> </b></span><a href="mailto:mail@sanigest.com" title="blocked::mailto:mail@sanigest.com"><u><span style="font-size: 10pt; font-family: Sylfaen;">rbriceno@sanigest.com</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: &quot;Book Antiqua&quot;; color: navy;"><br> MSN: </span><a href="mailto:jbric98@hotmail.com" title="blocked::mailto:jbric98@hotmail.com mailto:jbric98@hotmail.com"><u><span style="font-size: 10pt; font-family: &quot;Book Antiqua&quot;;">jbric98@hotmail.com</span></u></a><span style="font-size: 10pt; font-family: &quot;Book Antiqua&quot;; 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: &quot;Book Antiqua&quot;;">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: &quot;Book Antiqua&quot;; color: rgb(153, 204, 255);" lang="ES-CR"><br> </span><span style="font-size: 8pt; font-family: &quot;Book Antiqua&quot;;" lang="ES-CR">Esta comunicaci&oacute;n contiene informaci&oacute;n legal privilegiada y confidencial para el uso exclusivo del destinatario. La distribuci&oacute;n, diseminaci&oacute;n, copia u otro uso por terceras personas es estrictamente prohibida. Si usted ha recibido esta comunicaci&oacute;n por error, le rogamos borrar el mensaje original y comunic&aacute;rnoslo a esta misma direcci&oacute;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 <emaguin@buffalo.edu> 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 <abarakabarak@gmail.com> 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 <rbriceno@sanigest.com>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 > **rbriceno@sanigest.com* <mail@sanigest.com> > *www.sanigest.com* <http://www.sanigest.com/> > > MSN: *jbric98@hotmail.com* <jbric98@hotmail.com> > 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&#39;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&#39;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">&lt;<a href=3D"mailto:rbriceno@sanigest.com">rbric= eno@sanigest.com</a>&gt;</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: &quot;The INDEX values for case 27964 have occurred before in the cases with the same ID values.&quot;<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: &quot;Book Antiqua&quot;= ;" lang=3D"PT-BR">Rodrigo Brice=F1o</span></b><span style=3D"font-size: 10pt; font-family: &quot;Book= Antiqua&quot;; color: rgb(153, 204, 255);" lang=3D"PT-BR"><br> </span><span style=3D"font-size: 10pt; font-family: &quot;Book Antiqua&quot= ;;" 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: &quot;Book Antiqua&quot;;">= +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:mail@sanigest.com" title=3D"blocked::mailto:ma= il@sanigest.com" target=3D"_blank"><u><span style=3D"font-size: 10pt; font-= family: Sylfaen;">rbriceno@sanigest.com</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: &quot;Book Antiqua&quot= ;; color: navy;"><br> MSN: </span><a href=3D"mailto:jbric98@hotmail.com" title=3D"blocked::mailto= :jbric98@hotmail.com mailto:jbric98@hotmail.com" target=3D"_blank"><u><span style=3D"font-size: = 10pt; font-family: &quot;Book Antiqua&quot;;">jbric98@hotmail.com</span></u= ></a><span style=3D"font-size: 10pt; font-family: &quot;Book Antiqua&quot;;= 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: &quot;Book Antiqua&quot;;">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: &quot;Book Antiqua&quot;; color: rgb(153, 204, 255);" lang=3D"ES-CR"><br= > </span><span style=3D"font-size: 8pt; font-family: &quot;Book Antiqua&quot;= ;" 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 <bayesian2001@yahoo.com> 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 <azam.khan@utoronto.ca> wrote:

From: jimjohn <azam.khan@utoronto.ca> Subject: Re: hypothesis testing for difference between two means To: SPSSX-L@LISTSERV.UGA.EDU 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 LISTSERV@LISTSERV.UGA.EDU (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>&lt;&lt;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 -&gt; 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>&gt;30, a z test should be used. Any idea= s if SPSS can do a Z-test too to<BR>compare means?</DIV> <DIV>&nbsp;</DIV> <DIV>There is no (direct) Z-test in SPSS.&nbsp; Just use T-test, instead.&n= bsp; You dont need to use Z-test because&nbsp;the T approaches Z as n appro= aches infinity. (That is,&nbsp;the T=3DZ for large n).&nbsp; Is your sample= size enough?&nbsp; The rule of thumb for sample size is 10 to 20 cases per= variable.&nbsp; You should also consider the outliers, missing values of y= our raw data.&nbsp; You should not forget to do some diagnostic tests of yo= ur regression model,&nbsp; 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>&nbsp;</DIV> <DIV>Hope this helps.</DIV> <DIV>Johnny</DIV> <DIV>&nbsp;</DIV> <DIV><BR><BR>&nbsp;</DIV><BR><BR>--- On <B>Mon, 5/11/09, jimjohn <I>&lt;aza= m.khan@utoronto.ca&gt;</I></B> wrote:<BR> <BLOCKQUOTE style=3D"PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: rgb(= 16,16,255) 2px solid"><BR>From: jimjohn &lt;azam.khan@utoronto.ca&gt;<BR>Su= bject: Re: hypothesis testing for difference between two means<BR>To: SPSSX= -L@LISTSERV.UGA.EDU<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 -&gt; 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>&gt;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 &lt;$1000 certificate<BR>cus= tomers are more sensitive to interest rate changes than the &gt;$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>&gt;<BR>&gt= ; At 10:32 AM 5/8/2009, jimjohn wrote:<BR>&gt;&gt;does anyone here know how= to compute hypothesis tests/confidence intervals<BR>&gt;&gt;for the differ= ence between two means in SPSS? For example, I am comparing<BR>&gt;&gt;the = volume growth of my certificates with balance less than $1000 versus<BR>the= <BR>&gt;&gt;volume growth with balances greater than $1000. I want to see i= f the<BR>&gt;&gt;difference in the two means is statistically significant. = Any ideas? I<BR>don't<BR>&gt;&gt;think comparing means does it because it h= as something about grouping and<BR>&gt;&gt;factors. thanks!<BR>&gt;&gt;--<B= R>&gt;<BR>&gt; You can use the Independent Sample TTest procedure. You shou= ld have<BR>&gt; numeric variables for GROWTH and BALANCE where GROWTH=C2 as= your test<BR>&gt; variable and BALANCE as your grouping variable.=C2&nbsp;= The BALANCE=C2 should be<BR>&gt; coded for example as follows: 1=3D balance=C2 less than $1000 and 2=C2 =3D greater<BR>&gt; than $1000.=C2&nbs= p; Then run the synax:<BR>&gt; =C2<BR>&gt; T-TEST GROUPS=3DBALANCE(1 2)<BR>= &gt; =C2&nbsp; /MISSING=3DANALYSIS<BR>&gt; =C2&nbsp; /VARIABLES=3DGROWTH<BR= >&gt; =C2&nbsp; /CRITERIA=3DCI(.95).<BR>&gt;<BR>&gt; The confidence interva= l (CI) can be changed to=C2 what you want, say .99.=C2<BR>&gt; Hope I under= stand correctly your need.<BR>&gt; =C2<BR>&gt; Cheers,<BR>&gt; Johnny<BR>&g= t;<BR>&gt;<BR>&gt;&nbsp; &nbsp; &nbsp;&nbsp;&nbsp;Yahoo! Mail Now Faster an= d Cleaner. Experience it at<BR>&gt; <A href=3D"http://ph.mail.yahoo.com/" t= arget=3D_blank>http://ph.mail.yahoo.com</A>&nbsp; today!<BR>&gt;<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:LISTSERV@LISTSERV.UGA.EDU">LISTSERV@LISTSERV.UGA= .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) **************************************************************


[text/html]


Back to: Top of message | Previous page | Main SPSSX-L page