help required

[saugata mandal]

Dear SPSS Support Team,

>
> I have been facing a problem while using you SPSS
> package, would be really happy if you could help me
> out.
>
>
> Issue:
>
> - My data set consists of the total hours worked by
> 100 people in the financial year in the following
> format(yyyy:mm:dd e.g.-110:40:20)
>
> - These hourly datas are now required to be grouped

to

> find out the mean,meadian,average
>
> - The output should be as per the groups given below
>      - less than 00:00:01 hours
>      - greater than 00:00:00 hours but less than
>        20:00:00 hours
>      - greater than 19:59:59 hours but less than
>        40:00:00 hours
>      - greater than 39:59:59 hours but less than
>        60:00:00 hours
>      - greater than 59:59:59 hours but less than
>        80:00:00 hours
>      - greater than 79:59:59 hours but less than
>        100:00:00 hours
>      - greater than 99:59:59 hours
>
> Waiting for your support
>
> Saugata

____________________________________________________________________________________
Be a PS3 game guru.
Get your game face on with the latest PS3 news and previews at Yahoo! Games.
http://videogames.yahoo.com/platform?platform=120121

[Albert-Jan Roskam]

Hi Sauguta,

Does this what you want?

if input lt time.hms( 0,0,1 ) output = 1.
if (input ge time.hms( 0,0,1 ) and input lt (20,0,0))
output = 2.
* etcetera*.
exe.

Cheers!
Albert-Jan



--- saugata mandal <[hidden email]> wrote:

> Dear SPSS Support Team,
> >
> > I have been facing a problem while using you SPSS
> > package, would be really happy if you could help
> me
> > out.
> >
> >
> > Issue:
> >
> > - My data set consists of the total hours worked
> by
> > 100 people in the financial year in the following
> > format(yyyy:mm:dd e.g.-110:40:20)
> >
> > - These hourly datas are now required to be
> grouped
> to
> > find out the mean,meadian,average
> >
> > - The output should be as per the groups given
> below
> >      - less than 00:00:01 hours
> >      - greater than 00:00:00 hours but less than
> >        20:00:00 hours
> >      - greater than 19:59:59 hours but less than
> >        40:00:00 hours
> >      - greater than 39:59:59 hours but less than
> >        60:00:00 hours
> >      - greater than 59:59:59 hours but less than
> >        80:00:00 hours
> >      - greater than 79:59:59 hours but less than
> >        100:00:00 hours
> >      - greater than 99:59:59 hours
> >
> > Waiting for your support
> >
> > Saugata
>
>
>
>
>

____________________________________________________________________________________
> Be a PS3 game guru.
> Get your game face on with the latest PS3 news and
> previews at Yahoo! Games.
> http://videogames.yahoo.com/platform?platform=120121
>


Cheers!
Albert-Jan

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Did you know that 87.166253% of all statistics claim a precision of results that is not justified by the method employed? [HELMUT RICHTER]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~



____________________________________________________________________________________
Need a quick answer? Get one in minutes from people who know.
Ask your question on www.Answers.yahoo.com

[Lemon, John S.]

I wonder if 'Visual Binning' in the Transform menu of version 15 will do
this easier ? If I remembercorrectly it was called 'Visual Recode' in
version 14. Follow the dialog and it gives a quick and easy way to group
how you want and generate the labels as well.


Best Wishes

John S. Lemon
DIT - University of Aberdeen
Edward Wright Building: Room G51
Tel:  [phone]
Fax: [phone]

> -----Original Message-----
> From: SPSSX(r) Discussion [mailto:[hidden email]]
> On Behalf Of Albert-jan Roskam
> Sent: Tuesday, February 27, 2007 9:08 AM
> To: [hidden email]
> Subject: Re: help required
>
> Hi Sauguta,
>
> Does this what you want?
>
> if input lt time.hms( 0,0,1 ) output = 1.
> if (input ge time.hms( 0,0,1 ) and input lt (20,0,0))
> output = 2.
> * etcetera*.
> exe.
>
> Cheers!
> Albert-Jan
>
>
>
> --- saugata mandal <[hidden email]> wrote:
>
> > Dear SPSS Support Team,
> > >
> > > I have been facing a problem while using you SPSS
> > > package, would be really happy if you could help
> > me
> > > out.
> > >
> > >
> > > Issue:
> > >
> > > - My data set consists of the total hours worked
> > by
> > > 100 people in the financial year in the following
> > > format(yyyy:mm:dd e.g.-110:40:20)
> > >
> > > - These hourly datas are now required to be
> > grouped
> > to
> > > find out the mean,meadian,average
> > >
> > > - The output should be as per the groups given
> > below
> > >      - less than 00:00:01 hours
> > >      - greater than 00:00:00 hours but less than
> > >        20:00:00 hours
> > >      - greater than 19:59:59 hours but less than
> > >        40:00:00 hours
> > >      - greater than 39:59:59 hours but less than
> > >        60:00:00 hours
> > >      - greater than 59:59:59 hours but less than
> > >        80:00:00 hours
> > >      - greater than 79:59:59 hours but less than
> > >        100:00:00 hours
> > >      - greater than 99:59:59 hours
> > >
> > > Waiting for your support
> > >
> > > Saugata
> >
> >
> >
> >
> >
> ______________________________________________________________
> ______________________
> > Be a PS3 game guru.
> > Get your game face on with the latest PS3 news and
> > previews at Yahoo! Games.
> > http://videogames.yahoo.com/platform?platform=120121
> >
>
>
> Cheers!
> Albert-Jan
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Did you know that 87.166253% of all statistics claim a
> precision of results that is not justified by the method
> employed? [HELMUT RICHTER]
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
>
>
> ______________________________________________________________
> ______________________
> Need a quick answer? Get one in minutes from people who know.
> Ask your question on www.Answers.yahoo.com
>

[Melissa Ives]

It was Visual Banding in Version 14.  It basically creates a Recode
statement for you based on cutpoints you define as you look at a graph
of the item in question, or based on automatic splits using one of the 3
options (size, percentages, s.d.s)

It also looks like it would help to reformat your date field into just
hours.

Melissa
The bubbling brook would lose its song if you removed the rocks.


-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Lemon, John S.
Sent: Tuesday, February 27, 2007 3:11 AM
To: [hidden email]
Subject: Re: [SPSSX-L] help required

I wonder if 'Visual Binning' in the Transform menu of version 15 will do
this easier ? If I remembercorrectly it was called 'Visual Recode' in
version 14. Follow the dialog and it gives a quick and easy way to group
how you want and generate the labels as well.


Best Wishes

John S. Lemon
DIT - University of Aberdeen
Edward Wright Building: Room G51
Tel:  [phone]
Fax: [phone]

> -----Original Message-----
> From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf
> Of Albert-jan Roskam
> Sent: Tuesday, February 27, 2007 9:08 AM
> To: [hidden email]
> Subject: Re: help required
>
> Hi Sauguta,
>
> Does this what you want?
>
> if input lt time.hms( 0,0,1 ) output = 1.
> if (input ge time.hms( 0,0,1 ) and input lt (20,0,0)) output = 2.
> * etcetera*.
> exe.
>
> Cheers!
> Albert-Jan
>
>
>
> --- saugata mandal <[hidden email]> wrote:
>
> > Dear SPSS Support Team,
> > >
> > > I have been facing a problem while using you SPSS package, would
> > > be really happy if you could help
> > me
> > > out.
> > >
> > >
> > > Issue:
> > >
> > > - My data set consists of the total hours worked
> > by
> > > 100 people in the financial year in the following
> > > format(yyyy:mm:dd e.g.-110:40:20)
> > >
> > > - These hourly datas are now required to be
> > grouped
> > to
> > > find out the mean,meadian,average
> > >
> > > - The output should be as per the groups given
> > below
> > >      - less than 00:00:01 hours
> > >      - greater than 00:00:00 hours but less than
> > >        20:00:00 hours
> > >      - greater than 19:59:59 hours but less than
> > >        40:00:00 hours
> > >      - greater than 39:59:59 hours but less than
> > >        60:00:00 hours
> > >      - greater than 59:59:59 hours but less than
> > >        80:00:00 hours
> > >      - greater than 79:59:59 hours but less than
> > >        100:00:00 hours
> > >      - greater than 99:59:59 hours
> > >
> > > Waiting for your support
> > >
> > > Saugata
> >
> >
> >
> >
> >
> ______________________________________________________________
> ______________________
> > Be a PS3 game guru.
> > Get your game face on with the latest PS3 news and previews at
> > Yahoo! Games.
> > http://videogames.yahoo.com/platform?platform=120121
> >
>
>
> Cheers!
> Albert-Jan
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Did you know that 87.166253% of all statistics claim a precision of
> results that is not justified by the method employed? [HELMUT RICHTER]

> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
>
>
> ______________________________________________________________
> ______________________
> Need a quick answer? Get one in minutes from people who know.
> Ask your question on www.Answers.yahoo.com
>


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 [phone] for assistance.