Re: summary distribution with multiple observations per respondent (2)

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

Re: summary distribution with multiple observations per respondent (2)

Barry
First, a request to all - *please do not send HTML mail to the list* - it comes out insanely long and hard to read,
and will be mixed in with plain text mail.

Amy,  

Try treating it as a 'growth curve' situation, and shoot a quadratic curve through each respondent's data.
Then you can summarize each subject's data as three parameters (intercept, linear and quadratic); four, if you'd like to include the r-squared as a summary of fit.


Barry


Amy Corning wrote:
    <blockquote cite="mid:[hidden email]"
      type="cite">
      <pre wrap="">I have SPSS data containing variables that identify each respondent's age
at the time of 8 different events. I would like to find a way in SPSS to
obtain a single summary distribution of ages over the 8 variables, but
measures of central tendency are not appropriate. For the moment I am
generating frequency distributions for each of the 8 variables, then
averaging them by hand, but I'm wondering whether anyone can suggest a more
efficient approach? (Essentially, I think I may need a way of treating each
respondent's 8 responses as 8 separate cases.)

Thank you! -Amy


From: Automatic digest processor <[hidden email]>
To: Recipients of SPSSX-L digests <[hidden email]>
Sent: Monday, August 15, 2011 12:01 AM
Subject: SPSSX-L Digest - 13 Aug 2011 to 14 Aug 2011 (#2011-228)

There are 19 messages totalling 2793 lines in this issue.

Topics of the day:

  1. SPSSINC GETURI DATA (4)
  2. summary distribution with multiple observations per respondent (2)
  3. calculating average annual percentage change in SPSS - reply help please!!
    (3)
  4. unsubscribe
  5. How should I account for multiple comparisons when looking at p values?
    (3)
  6. How should I account for multiple comparisons when looking at p         
    values?
  7. calculating average annual percentage change in SPSS - reply           
    help please!!
  8. calculating average annual percentage change in SPSS - reply help please!!
    [SEC: UNCLASSIFIED]
  9. Excluding a large number of cases easily (3)

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

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

Date:    Sat, 13 Aug 2011 23:40:39 -0700
From:    drfg2008 <[hidden email]>
Subject: SPSSINC GETURI DATA

Is it possible to read in CSV-files with "SPSSINC GETURI DATA"?

SAV-file works fine:

SPSSINC GETURI DATA
URI="http://spss-seminar.de/tu-berlin.sav"
FILETYPE=SAV DATASET=frank
/OPTIONS
SHEETNUMBER=1 READNAMES=YES ASSUMEDSTRWIDTH=32767.


... and this would be the csv file ...

GET DATA
  /TYPE=TXT
  /FILE='C:\user\...\filename.csv'
  /DELCASE=LINE
  /DELIMITERS=";"
  /ARRANGEMENT=DELIMITED
  /FIRSTCASE=2
  /IMPORTCASE=ALL
  /VARIABLES=
  id F10.0
  name_de A45
  begin A16
  League A30
  StandardMarketVolume F15.0
  standard_Back_1 F15.2
  standard_Lay_1 F15.2
  standard_Back_2 F15.2
  standard_Lay_2 F15.2
  PB2SMarketVolume F15.0
  pointbet2sets02back F15.2
  pointbet2sets02lay F15.2
  pointbet2sets12back F15.2
  pointbet2sets12lay F15.2
  pointbet2sets20back F15.2
  pointbet2sets20lay F15.2
  pointbet2sets21back F15.2
  pointbet2sets21lay F15.2.
CACHE.
EXECUTE.

... but however combining both, I only get error messages ...

-----
Dr. Frank Gaeth
FU-Berlin

--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/SPSSINC-GETURI-DATA-tp4697639p4697639.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

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

Date:    Sun, 14 Aug 2011 02:58:02 -0700
From:    David Marso <[hidden email]>
Subject: Re: SPSSINC GETURI DATA

As usual Frank,
You fail to provide the essential information necessary for others to assist
you!
How are you "combining" these?
What are the error messages?
From what I glean reading *THIS* thread which you initiated in Feb,
http://spssx-discussion.1045642.n5.nabble.com/get-data-td3403038.html
unless something has changed then SPSSINC GETURI DATA reads
SPSS,XLS,SAS,STATA...

From Jon Peck's post in that thread!
"Here is the beginning of the help (SPSSINC GETURI DATA /HELP).
spssinc geturi data/help.
SPSSINC GETURI DATA URI="uri including filename"
FILETYPE={SPSS* | XLS | SAS | STATA}  ....."
HTH, David
* Please be more complete with diagnostic information/error messages... in
future posts!
------


drfg2008 wrote:

>
> Is it possible to read in CSV-files with "SPSSINC GETURI DATA"?
>
> SAV-file works fine:
>
> SPSSINC GETURI DATA
> URI="http://spss-seminar.de/tu-berlin.sav"
> FILETYPE=SAV DATASET=frank
> /OPTIONS
> SHEETNUMBER=1 READNAMES=YES ASSUMEDSTRWIDTH=32767.
>
>
> ... and this would be the csv file ...
>
> GET DATA
>  /TYPE=TXT
>  /FILE='C:\user\...\filename.csv'
>  /DELCASE=LINE
>  /DELIMITERS=";"
>  /ARRANGEMENT=DELIMITED
>  /FIRSTCASE=2
>  /IMPORTCASE=ALL
>  /VARIABLES=
>  id F10.0
>  name_de A45
>  begin A16
>  League A30
>  StandardMarketVolume F15.0
>  standard_Back_1 F15.2
>  standard_Lay_1 F15.2
>  standard_Back_2 F15.2
>  standard_Lay_2 F15.2
>  PB2SMarketVolume F15.0
>  pointbet2sets02back F15.2
>  pointbet2sets02lay F15.2
>  pointbet2sets12back F15.2
>  pointbet2sets12lay F15.2
>  pointbet2sets20back F15.2
>  pointbet2sets20lay F15.2
>  pointbet2sets21back F15.2
>  pointbet2sets21lay F15.2.
> CACHE.
> EXECUTE.
>
> ... but however combining both, I only get error messages ...
>


--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/SPSSINC-GETURI-DATA-tp4697639p4697865.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

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

Date:    Sun, 14 Aug 2011 08:37:16 -0400
From:    Art Kendall <[hidden email]>
Subject: Re: summary distribution with multiple observations per respondent

<html>
  <head>
    <meta content="text/html; charset=ISO-8859-1"
      http-equiv="Content-Type">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    <font size="+1">see if the syntax below does the kind of thing you
      want.<br>
      Open a new instance of SPSS.&nbsp; Copy the syntax from the email.&nbsp;
      Paste it to a syntax window. Run it.<br>
      <br>
      Art Kendall<br>
      Social Research Consultants<br>
      <br>
      data list list /id (f4) age1 to age3 (3f2) gender (f1).<br>
      begin data<br>
      &nbsp;&nbsp;&nbsp; 001 17 18 19 1<br>
      &nbsp;&nbsp;&nbsp; 002 18 19 17 1<br>
      &nbsp;&nbsp;&nbsp; 003 19 17 18 1<br>
      &nbsp;&nbsp;&nbsp; 004 17 18 19 2<br>
      &nbsp;&nbsp;&nbsp; 005 18 19 17 2<br>
      &nbsp;&nbsp;&nbsp; 006 19 17 18 2<br>
      &nbsp;&nbsp;&nbsp; 007 17&nbsp; 0&nbsp; 0 1<br>
      &nbsp;&nbsp;&nbsp; 008 0&nbsp; 17 19 1<br>
      &nbsp;&nbsp;&nbsp; 009 17 18&nbsp; 0 1<br>
      &nbsp;&nbsp;&nbsp; 010 19&nbsp; 0&nbsp; 0 2<br>
      &nbsp;&nbsp;&nbsp; 011&nbsp; 0&nbsp; 0&nbsp; 0 2<br>
      &nbsp;&nbsp;&nbsp; 012&nbsp; 0 17&nbsp; 0 2<br>
      end data.<br>
      dataset name 'original'<br>
      &nbsp;&nbsp;&nbsp; var labels<br>
      &nbsp;&nbsp;&nbsp; age1 'age event type 1'<br>
      &nbsp;&nbsp;&nbsp; age2 'age event type 2'<br>
      &nbsp;&nbsp;&nbsp; age3 'age event type 3'.<br>
      value labels gender<br>
      &nbsp;&nbsp;&nbsp; 1 'male'<br>
      &nbsp;&nbsp;&nbsp; 2 'female'.<br>
      mult response<br>
      &nbsp;&nbsp;&nbsp; /groups = ages 'ages for events' (age1 to age3 (1, 104))<br>
      &nbsp;&nbsp;&nbsp; /variables = gender (1,2)<br>
      &nbsp;&nbsp;&nbsp; /frequencies = ages<br>
      &nbsp;&nbsp;&nbsp; /tables = ages by ages by ages /ages by gender<br>
      &nbsp;&nbsp;&nbsp; /cells = all.<br>
      <br>
    </font><br>
    <br>
    On 8/13/2011 4:28 PM, Amy Corning wrote:
    <blockquote cite="mid:[hidden email]"
      type="cite">
      <pre wrap="">I have SPSS data containing variables that identify each respondent's age
at the time of 8 different events. I would like to find a way in SPSS to
obtain a single summary distribution of ages over the 8 variables, but
measures of central tendency are not appropriate. For the moment I am
generating frequency distributions for each of the 8 variables, then
averaging them by hand, but I'm wondering whether anyone can suggest a more
efficient approach? (Essentially, I think I may need a way of treating each
respondent's 8 responses as 8 separate cases.)

Thank you! -Amy

=====================
To manage your subscription to SPSSX-L, send a message to
<a class="moz-txt-link-abbreviated" href="mailto:[hidden email]">[hidden email]</a> (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

</pre>
    </blockquote>
  </body>
</html>

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

Date:    Sun, 14 Aug 2011 07:22:57 -0600
From:    Jon K Peck <[hidden email]>
Subject: Re: SPSSINC GETURI DATA

This is a multipart message in MIME format.
--=_alternative 00498209872578EC_=
Content-Type: text/plain; charset="US-ASCII"

No.  GETURI DATA does not support CSV format.  It supports sav, SAS,
Stata, and Excel IIRC.

Regards,

Jon Peck (no "h")
Senior Software Engineer, IBM
[hidden email]
new phone: 720-342-5621




From:  drfg2008 <[hidden email]>
To:    [hidden email]
Date:  08/14/2011 12:43 AM
Subject:        [SPSSX-L] SPSSINC GETURI DATA
Sent by:        "SPSSX(r) Discussion" <[hidden email]>



Is it possible to read in CSV-files with "SPSSINC GETURI DATA"?

SAV-file works fine:

SPSSINC GETURI DATA
URI="http://spss-seminar.de/tu-berlin.sav"
FILETYPE=SAV DATASET=frank
/OPTIONS
SHEETNUMBER=1 READNAMES=YES ASSUMEDSTRWIDTH=32767.


... and this would be the csv file ...

GET DATA
  /TYPE=TXT
  /FILE='C:\user\...\filename.csv'
  /DELCASE=LINE
  /DELIMITERS=";"
  /ARRANGEMENT=DELIMITED
  /FIRSTCASE=2
  /IMPORTCASE=ALL
  /VARIABLES=
  id F10.0
  name_de A45
  begin A16
  League A30
  StandardMarketVolume F15.0
  standard_Back_1 F15.2
  standard_Lay_1 F15.2
  standard_Back_2 F15.2
  standard_Lay_2 F15.2
  PB2SMarketVolume F15.0
  pointbet2sets02back F15.2
  pointbet2sets02lay F15.2
  pointbet2sets12back F15.2
  pointbet2sets12lay F15.2
  pointbet2sets20back F15.2
  pointbet2sets20lay F15.2
  pointbet2sets21back F15.2
  pointbet2sets21lay F15.2.
CACHE.
EXECUTE.

... but however combining both, I only get error messages ...

-----
Dr. Frank Gaeth
FU-Berlin

--
View this message in context:
http://spssx-discussion.1045642.n5.nabble.com/SPSSINC-GETURI-DATA-tp4697639p4697639.html

Sent from the SPSSX Discussion mailing list archive at Nabble.com.

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD


--=_alternative 00498209872578EC_=
Content-Type: text/html; charset="US-ASCII"

<font size=2 face="sans-serif">No. &nbsp;GETURI DATA does not support
CSV format. &nbsp;It supports sav, SAS, Stata, and Excel IIRC.</font>
<br>
<br><font size=2 face="sans-serif">Regards,</font>
<br><font size=2 face="sans-serif"><br>
Jon Peck (no &quot;h&quot;)<br>
Senior Software Engineer, IBM<br>
[hidden email]<br>
new phone: 720-342-5621<br>
</font>
<br>
<br>
<br>
<br><font size=1 color=#5f5f5f face="sans-serif">From: &nbsp; &nbsp; &nbsp;
&nbsp;</font><font size=1 face="sans-serif">drfg2008 &lt;[hidden email]&gt;</font>
<br><font size=1 color=#5f5f5f face="sans-serif">To: &nbsp; &nbsp; &nbsp;
&nbsp;</font><font size=1 face="sans-serif">[hidden email]</font>
<br><font size=1 color=#5f5f5f face="sans-serif">Date: &nbsp; &nbsp; &nbsp;
&nbsp;</font><font size=1 face="sans-serif">08/14/2011 12:43 AM</font>
<br><font size=1 color=#5f5f5f face="sans-serif">Subject: &nbsp; &nbsp;
&nbsp; &nbsp;</font><font size=1 face="sans-serif">[SPSSX-L] SPSSINC
GETURI DATA</font>
<br><font size=1 color=#5f5f5f face="sans-serif">Sent by: &nbsp; &nbsp;
&nbsp; &nbsp;</font><font size=1 face="sans-serif">&quot;SPSSX(r)
Discussion&quot; &lt;[hidden email]&gt;</font>
<br>
<hr noshade>
<br>
<br>
<br><tt><font size=2>Is it possible to read in CSV-files with &quot;SPSSINC
GETURI DATA&quot;?<br>
<br>
SAV-file works fine:<br>
<br>
SPSSINC GETURI DATA<br>
URI=&quot;</font></tt><a href="http://spss-seminar.de/tu-berlin.sav"><tt><font size=2>http://spss-seminar.de/tu-berlin.sav</font></tt></a><tt><font size=2>&quot;<br>
FILETYPE=SAV DATASET=frank<br>
/OPTIONS<br>
SHEETNUMBER=1 READNAMES=YES ASSUMEDSTRWIDTH=32767.<br>
<br>
<br>
... and this would be the csv file ...<br>
<br>
GET DATA<br>
&nbsp;/TYPE=TXT<br>
&nbsp;/FILE='C:\user\...\filename.csv'<br>
&nbsp;/DELCASE=LINE<br>
&nbsp;/DELIMITERS=&quot;;&quot;<br>
&nbsp;/ARRANGEMENT=DELIMITED<br>
&nbsp;/FIRSTCASE=2<br>
&nbsp;/IMPORTCASE=ALL<br>
&nbsp;/VARIABLES=<br>
&nbsp;id F10.0<br>
&nbsp;name_de A45<br>
&nbsp;begin A16<br>
&nbsp;League A30<br>
&nbsp;StandardMarketVolume F15.0<br>
&nbsp;standard_Back_1 F15.2<br>
&nbsp;standard_Lay_1 F15.2<br>
&nbsp;standard_Back_2 F15.2<br>
&nbsp;standard_Lay_2 F15.2<br>
&nbsp;PB2SMarketVolume F15.0<br>
&nbsp;pointbet2sets02back F15.2<br>
&nbsp;pointbet2sets02lay F15.2<br>
&nbsp;pointbet2sets12back F15.2<br>
&nbsp;pointbet2sets12lay F15.2<br>
&nbsp;pointbet2sets20back F15.2<br>
&nbsp;pointbet2sets20lay F15.2<br>
&nbsp;pointbet2sets21back F15.2<br>
&nbsp;pointbet2sets21lay F15.2.<br>
CACHE.<br>
EXECUTE.<br>
<br>
... but however combining both, I only get error messages ...<br>
<br>
-----<br>
Dr. Frank Gaeth<br>
FU-Berlin<br>
<br>
--<br>
View this message in context: </font></tt><a href="http://spssx-discussion.1045642.n5.nabble.com/SPSSINC-GETURI-DATA-tp4697639p4697639.html"><tt><font size=2>http://spssx-discussion.1045642.n5.nabble.com/SPSSINC-GETURI-DATA-tp4697639p4697639.html</font></tt></a><tt><font size=2><br>
Sent from the SPSSX Discussion mailing list archive at Nabble.com.<br>
<br>
=====================<br>
To manage your subscription to SPSSX-L, send a message to<br>
[hidden email] (not to SPSSX-L), with no body text except the<br>
command. To leave the list, send the command<br>
SIGNOFF SPSSX-L<br>
For a list of commands to manage subscriptions, send the command<br>
INFO REFCARD<br>
</font></tt>
<br>
--=_alternative 00498209872578EC_=--

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

Date:    Sun, 14 Aug 2011 07:48:07 -0700
From:    drfg2008 <[hidden email]>
Subject: Re: SPSSINC GETURI DATA

Thanks Jon

@David:

/As usual Frank,
You fail to provide the essential information necessary for others to assist
you! /

- as usual?

-----
Dr. Frank Gaeth
FU-Berlin

--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/SPSSINC-GETURI-DATA-tp4697639p4698287.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

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

Date:    Sun, 14 Aug 2011 11:38:00 -0400
From:    Art Kendall <[hidden email]>
Subject: Re: calculating average annual percentage change in SPSS - reply help
        please!!

<html>
  <head>
    <meta content="text/html; charset=ISO-8859-1"
      http-equiv="Content-Type">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    <font size="+1">It must be a real handicap in doing your work is you
      cannot get on listserv lists, forums, etc.<br>
      <br>
      The listserv SPSSX-L uses&nbsp; is very very old.&nbsp; I guess nobody at a
      university or agency has volunteered to bring the archives to
      his/her system.<br>
      UGA has not updated its listserve or archives in a long time. They
      are running version 1.8d. The current version is at least 15.0.&nbsp;
      [this is surprising since lists are very helpful in educational
      settings. UGA's page says it has 2000 lists!]<br>
      <br>
      <br>
    </font><tt><font size="2"><a class="moz-txt-link-abbreviated" href="mailto:[hidden email]">[hidden email]</a> </font></tt>is
    where to send a message to the list manager.<br>
    <font size="+1"><br>
      <br>
      I am including the list to see if others can help you.<br>
      <br>
      I seem to recall that the problem of non-standard email has come
      up before. Does anyone on the list know <br>
      1 --&nbsp; how someone who uses Lotus Notes can send _ordinary email_&nbsp;
      without privileges? <br>
      2 --&nbsp; what Thara should ask the IT department to set the overall
      parameters to? or<br>
      3 --&nbsp; what Thara </font><font size="+1">should ask the IT
      department to set the her/his parameters to?</font><br>
    <font size="+1"><br>
      <br>
      <br>
      Art Kendall<br>
      Social Research Consultants<br>
      <br>
      <br>
    </font><br>
    On 8/11/2011 10:48 PM, Thara Vardhan wrote:
    <blockquote
cite="mid:%20%[hidden email]"
      type="cite"><tt><font size="2">Hi Art</font></tt>
      <br>
      <br>
      <font face="sans-serif" size="2">I sent a message to the SPSS list
        and
        I get the following message. </font>
      <br>
      <br>
      <font face="sans-serif" size="2">I do not have the administrator's
        email
        address. Can you sent it to me please?</font>
      <br>
      <br>
      <font face="sans-serif" size="2">Also my agency uses IBM Lotus
        notes
        as the official email software. I personally cannot change any
        settings
        or &nbsp;</font>
      <br>
      <font face="sans-serif" size="2">features on it.</font>
      <br>
      <br>
      <tt><font size="2">Your posting to the SPSSX-L list has been
          rejected
          because it contains an<br>
          attachment &nbsp;of type &nbsp;'MULTIPART/ALTERNATIVE'. The &nbsp;SPSSX-L
          list &nbsp;has been<br>
          configured to reject &nbsp;such attachments; please contact the
          &nbsp;list
          owner at<br>
          <a class="moz-txt-link-abbreviated" href="mailto:[hidden email]">[hidden email]</a> for more information.</font></tt>
      <br>
      <br>
      <font face="sans-serif" size="2">Can you help me please? There is
        no
        other way I can access the list serve.</font>
      <br>
      <br>
      <font face="sans-serif" size="2">&nbsp;I am not authorised to use the
        SPSS discussion list through the internet since it is forum. </font>
      <br>
      <br>
      <font face="sans-serif" size="2">many thanks</font>
      <br>
      <font face="sans-serif" size="2">regards</font>
      <br>
      <font face="sans-serif" size="2">thara</font>
      <br>
      <br>
      <font face="sans-serif" size="2">My message:</font>
      <br>
      <br>
      <tt><font size="2">Hi Maurice, David and Art<br>
          <br>
          Thank you so much for helping me with the syntax to calculate
          &nbsp;'average
          <br>
          annual percentage change in SPSS'.<br>
          <br>
          My apologies if i was not clear in explaining what i wanted to
          calculate.<br>
          <br>
          I wanted to measure the &nbsp;avgchange over the 5 years. <br>
          <br>
          Art - the syntax you sent me worked perfectly. This is
          extremely useful.
          <br>
          You are absolutely right in your observation that the average
          change and
          <br>
          annual growth rate can be different. <br>
          <br>
          Prior to sending my request to the list I managed to calculate
          it &nbsp;as
          <br>
          follows using &nbsp;Excel:<br>
          <br>
          which translates to this in my Excel file<br>
          <br>
          &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
          &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;=(C9/C5)^(1/5)-1<br>
          <br>
          I was wondering if there is way in SPSS to do this without the
          aggregate
          <br>
          process.<br>
          <br>
          many thanks <br>
          thara</font></tt><br>
      <br>
      <table style="color:black" bgcolor="white">
        <tbody>
          <tr>
            <td>_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
              _ _ _ _ _ _ _ _ _ _ _ _ _<br>
              <br>
              The information contained in this email is intended for
              the named recipient(s) <br>
              only. It may contain private, confidential, copyright or
              legally privileged <br>
              information. If you are not the intended recipient or you
              have received this <br>
              email by mistake, please reply to the author and delete
              this email immediately. <br>
              You must not copy, print, forward or distribute this
              email, nor place reliance <br>
              on its contents. This email and any attachment have been
              virus scanned. However, <br>
              you are requested to conduct a virus scan as well. No
              liability is accepted <br>
              for any loss or damage resulting from a computer virus, or
              resulting from a delay<br>
              or defect in transmission of this email or any attached
              file. This email does not <br>
              constitute a representation by the NSW Police Force unless
              the author is legally <br>
              entitled to do so.<br>
              <br>
              <br>
            </td>
          </tr>
        </tbody>
      </table>
    </blockquote>
  </body>
</html>

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

Date:    Sun, 14 Aug 2011 08:53:35 -0700
From:    manmit shrimali <[hidden email]>
Subject: unsubscribe


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

Date:    Sun, 14 Aug 2011 12:52:01 -0400
From:    Martha Hewett <[hidden email]>
Subject: How should I account for multiple comparisons when looking at p values?

I am comparing 7 groups on multiple dimensions (demographics, attitudes,
actions).  Some comparisons are across all groups and some are among 2 or 3
or 4 of the groups.  They include ANOVAs, chi-squares and t tests.  I know
with so many comparisons some will be significant by chance.  How should I
adjust for this?  Also, should such an adjustment be made within types of
questions (e.g. within demographics, within attitudes, and within actions)
or across all items compared?

Thanks for any help you can provide.

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

Date:    Sun, 14 Aug 2011 14:10:21 -0400
From:    Gene Maguin <[hidden email]>
Subject: Re: summary distribution with multiple observations per respondent

Ok, glad it worked for you. On to the next question. Although you don't say
so, I'm going to assume that you are thinking of t-test or Anovas. I'd
suggest you look at the mixed command because you have what looks like a two
level analysis. However, more experienced list-folks may have better advice.

Gene Maguin

-----Original Message-----
From: Amy Corning [mailto:[hidden email]]
Sent: Sunday, August 14, 2011 11:23 AM
To: Gene Maguin
Subject: Re: summary distribution with multiple observations per respondent


Thank you, Gene! I was not aware that such a command even existed, but it
does just what I need and is simple to use. One further question: does SPSS
provide any way to adjust for the clustering that now occurs (e.g., if I
were to use any significance tests on the summary variable in the
restructured data)? Not essential, but I am wondering if you might know.
Again, thanks so much for your help! Best, Amy

On Sat, 13 Aug 2011 16:46:16 -0400, Gene Maguin <[hidden email]>
wrote:
> Amy,
>
> I think you need to restructure your file from wide to long. Read up on
the

> varstocases command.
>
> Gene Maguin
>
>
>
> -----Original Message-----
> From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
> Amy
> Corning
> Sent: Saturday, August 13, 2011 4:29 PM
> To: [hidden email]
> Subject: summary distribution with multiple observations per respondent
>
> I have SPSS data containing variables that identify each respondent's age
> at the time of 8 different events. I would like to find a way in SPSS to
> obtain a single summary distribution of ages over the 8 variables, but
> measures of central tendency are not appropriate. For the moment I am
> generating frequency distributions for each of the 8 variables, then
> averaging them by hand, but I'm wondering whether anyone can suggest a
more
> efficient approach? (Essentially, I think I may need a way of treating
each

> respondent's 8 responses as 8 separate cases.)
>
> Thank you! -Amy
>
> =====================
> To manage your subscription to SPSSX-L, send a message to
> [hidden email] (not to SPSSX-L), with no body text except the
> command. To leave the list, send the command
> SIGNOFF SPSSX-L
> For a list of commands to manage subscriptions, send the command
> INFO REFCARD
>
> =====================
> To manage your subscription to SPSSX-L, send a message to
> [hidden email] (not to SPSSX-L), with no body text except the
> command. To leave the list, send the command
> SIGNOFF SPSSX-L
> For a list of commands to manage subscriptions, send the command
> INFO REFCARD

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

Date:    Sun, 14 Aug 2011 14:42:42 -0400
From:    Gene Maguin <[hidden email]>
Subject: Re: How should I account for multiple comparisons when looking at p
        values?

Hi Martha,

I don't claim to be an expert about what follows; others know more. If you
step back a minute and think about your results, I think there two things to
consider, in addition to the multiple comparisons per se. One is correlation
among results and the other is independent variables subset comparisons,
i.e., comparions involving differing numbers of groups. My only thought on
that is to ignore the subset element and treat them as full set
coparisons--unless the set of all results includes both subset comparisons
and full set comparions of the same DV. To the extant that the DVs are
correlated, the test statistics will be correlated.

The traditional way of controlling for muliple comparisons has been the
Bonferroni adjustment--if the nomial significance threshold is set at .05
and you do 10 tests, reset the threshold to .05/10=.005. Bonferroni is
criticized because power is (much) reduced. An alternative is the false
discovery rate (FDR). I think the procedures have undergone some development
since first being published. The key names are Benjamini, Yoav and Hochberg,
Yosef. I have also seen a reference to Holm, S. Look at the Wikipedia
article on false discovery rate. It's important to understand that there is
a difference between Bonferroni and FDR in terms of what is being controlled
for. The wiki article shows an adjustement to the FDR computation for
correlated tests that I don't recall seeing in the Benjamini et al.
articles. The FDR procedure for uncorrelated tests is to rank the test
results from most significant to least significant and then test the first
at .05 (the assumed threshold), the second at .05/2=.025, the third at
.05/3=.01667, etc until a result fails to pass the threshold.

I think there was a discussion on the list sometime earlier this year on FDR
and correlated tests and you might find something about it in the archives.

Gene Maguin


-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Martha Hewett
Sent: Sunday, August 14, 2011 12:52 PM
To: [hidden email]
Subject: How should I account for multiple comparisons when looking at p
values?

I am comparing 7 groups on multiple dimensions (demographics, attitudes,
actions).  Some comparisons are across all groups and some are among 2 or 3
or 4 of the groups.  They include ANOVAs, chi-squares and t tests.  I know
with so many comparisons some will be significant by chance.  How should I
adjust for this?  Also, should such an adjustment be made within types of
questions (e.g. within demographics, within attitudes, and within actions)
or across all items compared?

Thanks for any help you can provide.

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

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

Date:    Sun, 14 Aug 2011 12:59:15 -0600
From:    Jon K Peck <[hidden email]>
Subject: Re: calculating average annual percentage change in SPSS - reply
        help please!!

This is a multipart message in MIME format.
--=_alternative 00684C60872578EC_=
Content-Type: text/plain; charset="US-ASCII"

I used Lotus Notes all the time to send email to the list, including this
message, and I have no problems with it.  Notes does sometimes encapsulate
the earlier part of a message when you reply in a twisty, but I haven't
seen this cause any problems.

The only thing I can think of is that you have a signature file that has
an image or some complex formatting.  Ask your systems administrator for
help.

Note also that you can use the forums attached to the SPSS Community (
www.ibm.com/developerworks/spssdevcentral).  Those provide a number of
conveniences not available on the listserv.

Jon Peck (no "h")
Senior Software Engineer, IBM
[hidden email]
new phone: 720-342-5621




From:  Art Kendall <[hidden email]>
To:    [hidden email]
Date:  08/14/2011 09:43 AM
Subject:        Re: [SPSSX-L] calculating average annual percentage change
in              SPSS - reply              help please!!
Sent by:        "SPSSX(r) Discussion" <[hidden email]>



It must be a real handicap in doing your work is you cannot get on
listserv lists, forums, etc.

The listserv SPSSX-L uses  is very very old.  I guess nobody at a
university or agency has volunteered to bring the archives to his/her
system.
UGA has not updated its listserve or archives in a long time. They are
running version 1.8d. The current version is at least 15.0.  [this is
surprising since lists are very helpful in educational settings. UGA's
page says it has 2000 lists!]


[hidden email] is where to send a message to the list
manager.


I am including the list to see if others can help you.

I seem to recall that the problem of non-standard email has come up
before. Does anyone on the list know
1 --  how someone who uses Lotus Notes can send _ordinary email_  without
privileges?
2 --  what Thara should ask the IT department to set the overall
parameters to? or
3 --  what Thara should ask the IT department to set the her/his
parameters to?



Art Kendall
Social Research Consultants



On 8/11/2011 10:48 PM, Thara Vardhan wrote:
Hi Art

I sent a message to the SPSS list and I get the following message.

I do not have the administrator's email address. Can you sent it to me
please?

Also my agency uses IBM Lotus notes as the official email software. I
personally cannot change any settings or
features on it.

Your posting to the SPSSX-L list has been rejected because it contains an
attachment  of type  'MULTIPART/ALTERNATIVE'. The  SPSSX-L list  has been
configured to reject  such attachments; please contact the  list owner at
[hidden email] for more information.

Can you help me please? There is no other way I can access the list serve.


I am not authorised to use the SPSS discussion list through the internet
since it is forum.

many thanks
regards
thara

My message:

Hi Maurice, David and Art

Thank you so much for helping me with the syntax to calculate  'average
annual percentage change in SPSS'.

My apologies if i was not clear in explaining what i wanted to calculate.

I wanted to measure the  avgchange over the 5 years.

Art - the syntax you sent me worked perfectly. This is extremely useful.
You are absolutely right in your observation that the average change and
annual growth rate can be different.

Prior to sending my request to the list I managed to calculate it  as
follows using  Excel:

which translates to this in my Excel file

                                    =(C9/C5)^(1/5)-1

I was wondering if there is way in SPSS to do this without the aggregate
process.

many thanks
thara

_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
_ _ _ _

The information contained in this email is intended for the named
recipient(s)
only. It may contain private, confidential, copyright or legally
privileged
information. If you are not the intended recipient or you have received
this
email by mistake, please reply to the author and delete this email
immediately.
You must not copy, print, forward or distribute this email, nor place
reliance
on its contents. This email and any attachment have been virus scanned.
However,
you are requested to conduct a virus scan as well. No liability is
accepted
for any loss or damage resulting from a computer virus, or resulting from
a delay
or defect in transmission of this email or any attached file. This email
does not
constitute a representation by the NSW Police Force unless the author is
legally
entitled to do so.


===================== To manage your subscription to SPSSX-L, send a
message to [hidden email] (not to SPSSX-L), with no body text
except the command. To leave the list, send the command SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command INFO
REFCARD

--=_alternative 00684C60872578EC_=
Content-Type: text/html; charset="US-ASCII"

<font size=2 face="sans-serif">I used Lotus Notes all the time to send
email to the list, including this message, and I have no problems with
it. &nbsp;Notes does sometimes encapsulate the earlier part of a message
when you reply in a twisty, but I haven't seen this cause any problems.</font>
<br>
<br><font size=2 face="sans-serif">The only thing I can think of is that
you have a signature file that has an image or some complex formatting.
&nbsp;Ask your systems administrator for help.</font>
<br>
<br><font size=2 face="sans-serif">Note also that you can use the forums
attached to the SPSS Community (</font><a href=www.ibm.com/developerworks/spssdevcentral><font size=2 face="sans-serif">www.ibm.com/developerworks/spssdevcentral</font></a><font size=2 face="sans-serif">).
&nbsp;Those provide a number of conveniences not available on the listserv.</font>
<br><font size=2 face="sans-serif"><br>
Jon Peck (no &quot;h&quot;)<br>
Senior Software Engineer, IBM<br>
[hidden email]<br>
new phone: 720-342-5621<br>
</font>
<br>
<br>
<br>
<br><font size=1 color=#5f5f5f face="sans-serif">From: &nbsp; &nbsp; &nbsp;
&nbsp;</font><font size=1 face="sans-serif">Art Kendall &lt;[hidden email]&gt;</font>
<br><font size=1 color=#5f5f5f face="sans-serif">To: &nbsp; &nbsp; &nbsp;
&nbsp;</font><font size=1 face="sans-serif">[hidden email]</font>
<br><font size=1 color=#5f5f5f face="sans-serif">Date: &nbsp; &nbsp; &nbsp;
&nbsp;</font><font size=1 face="sans-serif">08/14/2011 09:43 AM</font>
<br><font size=1 color=#5f5f5f face="sans-serif">Subject: &nbsp; &nbsp;
&nbsp; &nbsp;</font><font size=1 face="sans-serif">Re: [SPSSX-L]
calculating average annual percentage change in &nbsp; &nbsp; &nbsp; &nbsp;
&nbsp; &nbsp; &nbsp;SPSS - reply &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
&nbsp;help please!!</font>
<br><font size=1 color=#5f5f5f face="sans-serif">Sent by: &nbsp; &nbsp;
&nbsp; &nbsp;</font><font size=1 face="sans-serif">&quot;SPSSX(r)
Discussion&quot; &lt;[hidden email]&gt;</font>
<br>
<hr noshade>
<br>
<br>
<br><font size=4>It must be a real handicap in doing your work is you cannot
get on listserv lists, forums, etc.<br>
<br>
The listserv SPSSX-L uses &nbsp;is very very old. &nbsp;I guess nobody
at a university or agency has volunteered to bring the archives to his/her
system.<br>
UGA has not updated its listserve or archives in a long time. They are
running version 1.8d. The current version is at least 15.0. &nbsp;[this
is surprising since lists are very helpful in educational settings. UGA's
page says it has 2000 lists!]<br>
<br>
</font><tt><font size=2 color=blue><u><br>
</u></font></tt><a href="mailto:[hidden email]"><tt><font size=2 color=blue><u>[hidden email]</u></font></tt></a><tt><font size=2>
</font></tt><font size=3>is where to send a message to the list manager.</font><font size=4><br>
<br>
<br>
I am including the list to see if others can help you.<br>
<br>
I seem to recall that the problem of non-standard email has come up before.
Does anyone on the list know <br>
1 -- &nbsp;how someone who uses Lotus Notes can send _ordinary email_ &nbsp;without
privileges? <br>
2 -- &nbsp;what Thara should ask the IT department to set the overall parameters
to? or<br>
3 -- &nbsp;what Thara should ask the IT department to set the her/his parameters
to?<br>
<br>
<br>
<br>
Art Kendall<br>
Social Research Consultants<br>
<br>
</font><font size=3><br>
<br>
On 8/11/2011 10:48 PM, Thara Vardhan wrote: </font>
<br><tt><font size=2>Hi Art</font></tt><font size=3> <br>
</font><font size=2 face="sans-serif"><br>
I sent a message to the SPSS list and I get the following message. </font><font size=3><br>
</font><font size=2 face="sans-serif"><br>
I do not have the administrator's email address. Can you sent it to me
please?</font><font size=3> <br>
</font><font size=2 face="sans-serif"><br>
Also my agency uses IBM Lotus notes as the official email software. I personally
cannot change any settings or &nbsp;</font><font size=3> </font><font size=2 face="sans-serif"><br>
features on it.</font><font size=3> <br>
</font><tt><font size=2><br>
Your posting to the SPSSX-L list has been rejected because it contains
an<br>
attachment &nbsp;of type &nbsp;'MULTIPART/ALTERNATIVE'. The &nbsp;SPSSX-L
list &nbsp;has been<br>
configured to reject &nbsp;such attachments; please contact the &nbsp;list
owner at</font></tt><tt><font size=2 color=blue><u><br>
</u></font></tt><a href="mailto:[hidden email]"><tt><font size=2 color=blue><u>[hidden email]</u></font></tt></a><tt><font size=2>
for more information.</font></tt><font size=3> <br>
</font><font size=2 face="sans-serif"><br>
Can you help me please? There is no other way I can access the list serve.</font><font size=3>
<br>
</font><font size=2 face="sans-serif"><br>
I am not authorised to use the SPSS discussion list through the internet
since it is forum. </font><font size=3><br>
</font><font size=2 face="sans-serif"><br>
many thanks</font><font size=3> </font><font size=2 face="sans-serif"><br>
regards</font><font size=3> </font><font size=2 face="sans-serif"><br>
thara</font><font size=3> <br>
</font><font size=2 face="sans-serif"><br>
My message:</font><font size=3> <br>
</font><tt><font size=2><br>
Hi Maurice, David and Art<br>
<br>
Thank you so much for helping me with the syntax to calculate &nbsp;'average
<br>
annual percentage change in SPSS'.<br>
<br>
My apologies if i was not clear in explaining what i wanted to calculate.<br>
<br>
I wanted to measure the &nbsp;avgchange over the 5 years. <br>
<br>
Art - the syntax you sent me worked perfectly. This is extremely useful.
<br>
You are absolutely right in your observation that the average change and
<br>
annual growth rate can be different. <br>
<br>
Prior to sending my request to the list I managed to calculate it &nbsp;as
<br>
follows using &nbsp;Excel:<br>
<br>
which translates to this in my Excel file<br>
<br>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; =(C9/C5)^(1/5)-1<br>
<br>
I was wondering if there is way in SPSS to do this without the aggregate
<br>
process.<br>
<br>
many thanks <br>
thara</font></tt><font size=3><br>
</font>
<table>
<tr>
<td bgcolor=white><font size=3>_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _<br>
<br>
The information contained in this email is intended for the named recipient(s)
<br>
only. It may contain private, confidential, copyright or legally privileged
<br>
information. If you are not the intended recipient or you have received
this <br>
email by mistake, please reply to the author and delete this email immediately.
<br>
You must not copy, print, forward or distribute this email, nor place reliance
<br>
on its contents. This email and any attachment have been virus scanned.
However, <br>
you are requested to conduct a virus scan as well. No liability is accepted
<br>
for any loss or damage resulting from a computer virus, or resulting from
a delay<br>
or defect in transmission of this email or any attached file. This email
does not <br>
constitute a representation by the NSW Police Force unless the author is
legally <br>
entitled to do so.<br>
<br>
</font></table>
<br><font size=3>===================== To manage your subscription to SPSSX-L,
send a message to [hidden email] (not to SPSSX-L), with no body
text except the command. To leave the list, send the command SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command INFO REFCARD
</font>
<br>
--=_alternative 00684C60872578EC_=--

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

Date:    Sun, 14 Aug 2011 12:00:18 -0700
From:    Bruce Weaver <[hidden email]>
Subject: Re: calculating average annual percentage change in SPSS - reply help
        please!!

Has Thara tried posting to the list via Nabble?

  http://spssx-discussion.1045642.n5.nabble.com/

HTH.



Art Kendall wrote:

>
> It must be a real handicap in doing your work is you
>      cannot get on listserv lists, forums, etc.
>
>      The listserv SPSSX-L uses&nbsp; is very very old.&nbsp; I guess
> nobody at a
>      university or agency has volunteered to bring the archives to
>      his/her system.
>      UGA has not updated its listserve or archives in a long time. They
>      are running version 1.8d. The current version is at least
> 15.0.&nbsp;
>      [this is surprising since lists are very helpful in educational
>      settings. UGA's page says it has 2000 lists!]
>
>
>    [hidden email]  is
>    where to send a message to the list manager.
>
>
>      I am including the list to see if others can help you.
>
>      I seem to recall that the problem of non-standard email has come
>      up before. Does anyone on the list know
>      1 --&nbsp; how someone who uses Lotus Notes can send _ordinary
> email_&nbsp;
>      without privileges?
>      2 --&nbsp; what Thara should ask the IT department to set the
> overall
>      parameters to? or
>      3 --&nbsp; what Thara should ask the IT
>      department to set the her/his parameters to?
>
>
>
>      Art Kendall
>      Social Research Consultants
>
>
>
>    On 8/11/2011 10:48 PM, Thara Vardhan wrote:
>    Hi Art
>
>
>      I sent a message to the SPSS list
>        and
>        I get the following message.
>
>
>      I do not have the administrator's
>        email
>        address. Can you sent it to me please?
>
>
>      Also my agency uses IBM Lotus
>        notes
>        as the official email software. I personally cannot change any
>        settings
>        or &nbsp;
>
>      features on it.
>
>
>      Your posting to the SPSSX-L list has been
>          rejected
>          because it contains an
>          attachment &nbsp;of type &nbsp;'MULTIPART/ALTERNATIVE'. The
> &nbsp;SPSSX-L
>          list &nbsp;has been
>          configured to reject &nbsp;such attachments; please contact the
>          &nbsp;list
>          owner at
>          [hidden email]  for more information.
>
>
>      Can you help me please? There is
>        no
>        other way I can access the list serve.
>
>
>      &nbsp;I am not authorised to use the
>        SPSS discussion list through the internet since it is forum.
>
>
>      many thanks
>
>      regards
>
>      thara
>
>
>      My message:
>
>
>      Hi Maurice, David and Art
>
>          Thank you so much for helping me with the syntax to calculate
>          &nbsp;'average
>
>          annual percentage change in SPSS'.
>
>          My apologies if i was not clear in explaining what i wanted to
>          calculate.
>
>          I wanted to measure the &nbsp;avgchange over the 5 years.
>
>          Art - the syntax you sent me worked perfectly. This is
>          extremely useful.
>
>          You are absolutely right in your observation that the average
>          change and
>
>          annual growth rate can be different.
>
>          Prior to sending my request to the list I managed to calculate
>          it &nbsp;as
>
>          follows using &nbsp;Excel:
>
>          which translates to this in my Excel file
>
>          &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
> &nbsp;
>          &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
> &nbsp;=(C9/C5)^(1/5)-1
>
>          I was wondering if there is way in SPSS to do this without the
>          aggregate
>
>          process.
>
>          many thanks
>          thara
>
>
>
>
>            _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
>              _ _ _ _ _ _ _ _ _ _ _ _ _
>
>              The information contained in this email is intended for
>              the named recipient(s)
>              only. It may contain private, confidential, copyright or
>              legally privileged
>              information. If you are not the intended recipient or you
>              have received this
>              email by mistake, please reply to the author and delete
>              this email immediately.
>              You must not copy, print, forward or distribute this
>              email, nor place reliance
>              on its contents. This email and any attachment have been
>              virus scanned. However,
>              you are requested to conduct a virus scan as well. No
>              liability is accepted
>              for any loss or damage resulting from a computer virus, or
>              resulting from a delay
>              or defect in transmission of this email or any attached
>              file. This email does not
>              constitute a representation by the NSW Police Force unless
>              the author is legally
>              entitled to do so.
>
>
>
>
>
>
>
>
>
>
> =====================
> To manage your subscription to SPSSX-L, send a message to
> [hidden email] (not to SPSSX-L), with no body text except the
> command. To leave the list, send the command
> SIGNOFF SPSSX-L
> For a list of commands to manage subscriptions, send the command
> INFO REFCARD
>


-----
--
Bruce Weaver
[hidden email]
http://sites.google.com/a/lakeheadu.ca/bweaver/

"When all else fails, RTFM."

NOTE: My Hotmail account is not monitored regularly.
To send me an e-mail, please use the address shown above.

--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/Re-calculating-average-annual-percentage-change-in-SPSS-reply-help-please-tp4698382p4698764.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

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

Date:    Sun, 14 Aug 2011 14:09:30 -0500
From:    Martha Hewett <[hidden email]>
Subject: Re: calculating average annual percentage change in SPSS - reply help
        please!!

This is a multipart message in MIME format.
--=_alternative 00693E4D862578EC_=
Content-Type: text/plain; charset="US-ASCII"

That's probably right - I have to delete my signature block to get my
Lotus Notes e-mail to be accepted by the Listserv.








From:
Jon K Peck <[hidden email]>
To:
[hidden email]
Date:
08/14/2011 02:06 PM
Subject:
Re: calculating average annual percentage change in SPSS - reply    help
please!!
Sent by:
"SPSSX(r) Discussion" <[hidden email]>



I used Lotus Notes all the time to send email to the list, including this
message, and I have no problems with it.  Notes does sometimes encapsulate
the earlier part of a message when you reply in a twisty, but I haven't
seen this cause any problems.

The only thing I can think of is that you have a signature file that has
an image or some complex formatting.  Ask your systems administrator for
help.

Note also that you can use the forums attached to the SPSS Community (
www.ibm.com/developerworks/spssdevcentral).  Those provide a number of
conveniences not available on the listserv.

Jon Peck (no "h")
Senior Software Engineer, IBM
[hidden email]
new phone: 720-342-5621




From:        Art Kendall <[hidden email]>
To:        [hidden email]
Date:        08/14/2011 09:43 AM
Subject:        Re: [SPSSX-L] calculating average annual percentage change
in              SPSS - reply              help please!!
Sent by:        "SPSSX(r) Discussion" <[hidden email]>



It must be a real handicap in doing your work is you cannot get on
listserv lists, forums, etc.

The listserv SPSSX-L uses  is very very old.  I guess nobody at a
university or agency has volunteered to bring the archives to his/her
system.
UGA has not updated its listserve or archives in a long time. They are
running version 1.8d. The current version is at least 15.0.  [this is
surprising since lists are very helpful in educational settings. UGA's
page says it has 2000 lists!]


[hidden email] is where to send a message to the list
manager.


I am including the list to see if others can help you.

I seem to recall that the problem of non-standard email has come up
before. Does anyone on the list know
1 --  how someone who uses Lotus Notes can send _ordinary email_  without
privileges?
2 --  what Thara should ask the IT department to set the overall
parameters to? or
3 --  what Thara should ask the IT department to set the her/his
parameters to?



Art Kendall
Social Research Consultants



On 8/11/2011 10:48 PM, Thara Vardhan wrote:
Hi Art

I sent a message to the SPSS list and I get the following message.

I do not have the administrator's email address. Can you sent it to me
please?

Also my agency uses IBM Lotus notes as the official email software. I
personally cannot change any settings or
features on it.

Your posting to the SPSSX-L list has been rejected because it contains an
attachment  of type  'MULTIPART/ALTERNATIVE'. The  SPSSX-L list  has been
configured to reject  such attachments; please contact the  list owner at
[hidden email] for more information.

Can you help me please? There is no other way I can access the list serve.


I am not authorised to use the SPSS discussion list through the internet
since it is forum.

many thanks
regards
thara

My message:

Hi Maurice, David and Art

Thank you so much for helping me with the syntax to calculate  'average
annual percentage change in SPSS'.

My apologies if i was not clear in explaining what i wanted to calculate.

I wanted to measure the  avgchange over the 5 years.

Art - the syntax you sent me worked perfectly. This is extremely useful.
You are absolutely right in your observation that the average change and
annual growth rate can be different.

Prior to sending my request to the list I managed to calculate it  as
follows using  Excel:

which translates to this in my Excel file

                                    =(C9/C5)^(1/5)-1

I was wondering if there is way in SPSS to do this without the aggregate
process.

many thanks
thara
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
_ _ _ _

The information contained in this email is intended for the named
recipient(s)
only. It may contain private, confidential, copyright or legally
privileged
information. If you are not the intended recipient or you have received
this
email by mistake, please reply to the author and delete this email
immediately.
You must not copy, print, forward or distribute this email, nor place
reliance
on its contents. This email and any attachment have been virus scanned.
However,
you are requested to conduct a virus scan as well. No liability is
accepted
for any loss or damage resulting from a computer virus, or resulting from
a delay
or defect in transmission of this email or any attached file. This email
does not
constitute a representation by the NSW Police Force unless the author is
legally
entitled to do so.


===================== To manage your subscription to SPSSX-L, send a
message to [hidden email] (not to SPSSX-L), with no body text
except the command. To leave the list, send the command SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command INFO
REFCARD


--=_alternative 00693E4D862578EC_=
Content-Type: text/html; charset="US-ASCII"


<br><font size=2 face="sans-serif">That's probably right - I have to delete
my signature block to get my Lotus Notes e-mail to be accepted by the Listserv.</font>
<br><font size=3><br>
<br>
<br>
<br>
</font>
<br>
<br>
<br>
<table width=100%>
<tr valign=top>
<td><font size=1 color=#5f5f5f face="sans-serif">From:</font>
<td><font size=1 face="sans-serif">Jon K Peck &lt;[hidden email]&gt;</font>
<tr valign=top>
<td><font size=1 color=#5f5f5f face="sans-serif">To:</font>
<td><font size=1 face="sans-serif">[hidden email]</font>
<tr valign=top>
<td><font size=1 color=#5f5f5f face="sans-serif">Date:</font>
<td><font size=1 face="sans-serif">08/14/2011 02:06 PM</font>
<tr valign=top>
<td><font size=1 color=#5f5f5f face="sans-serif">Subject:</font>
<td><font size=1 face="sans-serif">Re: calculating average annual percentage
change in SPSS - reply &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;help
please!!</font>
<tr valign=top>
<td><font size=1 color=#5f5f5f face="sans-serif">Sent by:</font>
<td><font size=1 face="sans-serif">&quot;SPSSX(r) Discussion&quot; &lt;[hidden email]&gt;</font></table>
<br>
<hr noshade>
<br>
<br>
<br><font size=2 face="sans-serif">I used Lotus Notes all the time to send
email to the list, including this message, and I have no problems with
it. &nbsp;Notes does sometimes encapsulate the earlier part of a message
when you reply in a twisty, but I haven't seen this cause any problems.</font><font size=3>
<br>
</font><font size=2 face="sans-serif"><br>
The only thing I can think of is that you have a signature file that has
an image or some complex formatting. &nbsp;Ask your systems administrator
for help.</font><font size=3> <br>
</font><font size=2 face="sans-serif"><br>
Note also that you can use the forums attached to the SPSS Community (</font><a href=www.ibm.com/developerworks/spssdevcentral><font size=2 color=blue face="sans-serif"><u>www.ibm.com/developerworks/spssdevcentral</u></font></a><font size=2 face="sans-serif">).
&nbsp;Those provide a number of conveniences not available on the listserv.</font><font size=3>
</font><font size=2 face="sans-serif"><br>
<br>
Jon Peck (no &quot;h&quot;)<br>
Senior Software Engineer, IBM<br>
[hidden email]<br>
new phone: 720-342-5621</font><font size=3><br>
<br>
<br>
<br>
</font><font size=1 color=#5f5f5f face="sans-serif"><br>
From: &nbsp; &nbsp; &nbsp; &nbsp;</font><font size=1 face="sans-serif">Art
Kendall &lt;[hidden email]&gt;</font><font size=3> </font><font size=1 color=#5f5f5f face="sans-serif"><br>
To: &nbsp; &nbsp; &nbsp; &nbsp;</font><font size=1 face="sans-serif">[hidden email]</font><font size=3>
</font><font size=1 color=#5f5f5f face="sans-serif"><br>
Date: &nbsp; &nbsp; &nbsp; &nbsp;</font><font size=1 face="sans-serif">08/14/2011
09:43 AM</font><font size=3> </font><font size=1 color=#5f5f5f face="sans-serif"><br>
Subject: &nbsp; &nbsp; &nbsp; &nbsp;</font><font size=1 face="sans-serif">Re:
[SPSSX-L] calculating average annual percentage change in &nbsp; &nbsp;
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;SPSS - reply &nbsp; &nbsp; &nbsp; &nbsp;
&nbsp; &nbsp; &nbsp;help please!!</font><font size=3> </font><font size=1 color=#5f5f5f face="sans-serif"><br>
Sent by: &nbsp; &nbsp; &nbsp; &nbsp;</font><font size=1 face="sans-serif">&quot;SPSSX(r)
Discussion&quot; &lt;[hidden email]&gt;</font><font size=3> <br>
</font>
<hr noshade><font size=3><br>
<br>
</font><font size=4><br>
It must be a real handicap in doing your work is you cannot get on listserv
lists, forums, etc.<br>
<br>
The listserv SPSSX-L uses &nbsp;is very very old. &nbsp;I guess nobody
at a university or agency has volunteered to bring the archives to his/her
system.<br>
UGA has not updated its listserve or archives in a long time. They are
running version 1.8d. The current version is at least 15.0. &nbsp;[this
is surprising since lists are very helpful in educational settings. UGA's
page says it has 2000 lists!]<br>
</font><tt><font size=2 color=blue><u><br>
</u></font></tt><font size=3 color=blue><u><br>
</u></font><a href="mailto:[hidden email]"><tt><font size=2 color=blue><u>[hidden email]</u></font></tt></a><tt><font size=2>
</font></tt><font size=3>is where to send a message to the list manager.</font><font size=4><br>
<br>
<br>
I am including the list to see if others can help you.<br>
<br>
I seem to recall that the problem of non-standard email has come up before.
Does anyone on the list know <br>
1 -- &nbsp;how someone who uses Lotus Notes can send _ordinary email_ &nbsp;without
privileges? <br>
2 -- &nbsp;what Thara should ask the IT department to set the overall parameters
to? or<br>
3 -- &nbsp;what Thara should ask the IT department to set the her/his parameters
to?<br>
<br>
<br>
<br>
Art Kendall<br>
Social Research Consultants<br>
</font><font size=3><br>
<br>
<br>
On 8/11/2011 10:48 PM, Thara Vardhan wrote: </font><tt><font size=2><br>
Hi Art</font></tt><font size=3> </font><font size=2 face="sans-serif"><br>
<br>
I sent a message to the SPSS list and I get the following message. <br>
<br>
I do not have the administrator's email address. Can you sent it to me
please?</font><font size=3> </font><font size=2 face="sans-serif"><br>
<br>
Also my agency uses IBM Lotus notes as the official email software. I personally
cannot change any settings or &nbsp;</font><font size=3> </font><font size=2 face="sans-serif"><br>
features on it.</font><font size=3> </font><tt><font size=2><br>
<br>
Your posting to the SPSSX-L list has been rejected because it contains
an<br>
attachment &nbsp;of type &nbsp;'MULTIPART/ALTERNATIVE'. The &nbsp;SPSSX-L
list &nbsp;has been<br>
configured to reject &nbsp;such attachments; please contact the &nbsp;list
owner at</font></tt><font size=3 color=blue><u><br>
</u></font><a href="mailto:[hidden email]"><tt><font size=2 color=blue><u>[hidden email]</u></font></tt></a><tt><font size=2>
for more information.</font></tt><font size=3> </font><font size=2 face="sans-serif"><br>
<br>
Can you help me please? There is no other way I can access the list serve.</font><font size=3>
</font><font size=2 face="sans-serif"><br>
<br>
I am not authorised to use the SPSS discussion list through the internet
since it is forum. <br>
<br>
many thanks</font><font size=3> </font><font size=2 face="sans-serif"><br>
regards</font><font size=3> </font><font size=2 face="sans-serif"><br>
thara</font><font size=3> </font><font size=2 face="sans-serif"><br>
<br>
My message:</font><font size=3> </font><tt><font size=2><br>
<br>
Hi Maurice, David and Art<br>
<br>
Thank you so much for helping me with the syntax to calculate &nbsp;'average
<br>
annual percentage change in SPSS'.<br>
<br>
My apologies if i was not clear in explaining what i wanted to calculate.<br>
<br>
I wanted to measure the &nbsp;avgchange over the 5 years. <br>
<br>
Art - the syntax you sent me worked perfectly. This is extremely useful.
<br>
You are absolutely right in your observation that the average change and
<br>
annual growth rate can be different. <br>
<br>
Prior to sending my request to the list I managed to calculate it &nbsp;as
<br>
follows using &nbsp;Excel:<br>
<br>
which translates to this in my Excel file<br>
<br>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;=(C9/C5)^(1/5)-1<br>
<br>
I was wondering if there is way in SPSS to do this without the aggregate
<br>
process.<br>
<br>
many thanks <br>
thara</font></tt>
<table>
<tr>
<td bgcolor=white><font size=3>_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _<br>
<br>
The information contained in this email is intended for the named recipient(s)
<br>
only. It may contain private, confidential, copyright or legally privileged
<br>
information. If you are not the intended recipient or you have received
this <br>
email by mistake, please reply to the author and delete this email immediately.
<br>
You must not copy, print, forward or distribute this email, nor place reliance
<br>
on its contents. This email and any attachment have been virus scanned.
However, <br>
you are requested to conduct a virus scan as well. No liability is accepted
<br>
for any loss or damage resulting from a computer virus, or resulting from
a delay<br>
or defect in transmission of this email or any attached file. This email
does not <br>
constitute a representation by the NSW Police Force unless the author is
legally <br>
entitled to do so.<br>
</font></table>
<br><font size=3><br>
===================== To manage your subscription to SPSSX-L, send a message
to [hidden email] (not to SPSSX-L), with no body text except
the command. To leave the list, send the command SIGNOFF SPSSX-L For a
list of commands to manage subscriptions, send the command INFO REFCARD
</font>
<br>
<br>
--=_alternative 00693E4D862578EC_=--

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

Date:    Sun, 14 Aug 2011 15:56:36 -0400
From:    Rich Ulrich <[hidden email]>
Subject: Re: How should I account for multiple comparisons when looking at p
        values?

--_b7c5cf0d-c9a8-4385-bb4d-9efd589425c4_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable


What kind of statement are you making?
Who are you making it to=2C and what do they expect?

What is the N?  If you have tens of thousands=2C a journal like NEJM
will suggest that you ignore all tests=2C and focus on "effect size"=2C
because your power would be so large. =20

On the other hand=2C with 7 groups=2C observational data=2C and a much
smaller N...  you could have a serious problem with power for some
analyses=2C especially if your group sizes are grossly unequal.  I'll skip
by those concerns.

If the study is exploratory=2C then it is probably fair to report the strai=
ght
p-values -- with suitable warning to the readers.  That is the simplest
case.  Otherwise=2C corrections for multiple tests are needed for the=20
important tests.=20


If you want to actually *conclude*  something=2C about *hypotheses*=2C

then you should draw up your small number of hypotheses in advance=2C

and figure out what variables or composite scores will be able to test

them.  As you describe it=2C there are dozens of possible hypotheses.=20

These should be arranged in a hierarchy:  These few are *primary*=2C

the main reason we collected the data=3B and (if any will be)=2C these will=
=20

be tested with correction=3B  these next are also interesting in an explora=
tory=20

mode=2C and are reported without correction.

When you are looking at a variable that might *bias* the other=20
tests or comparisons=2C then it is proper=2C if not mandatory=2C to report =
the
single test with its nominal p-value -- These are warnings=2C and you don't
want to under-rate a warning.  If a variable plays both roles (being a
possible bias-factor=2C and being of intrinsic interest)=2C you need to rep=
ort
both sorts of test-outcome if they are different.  "Sex shows enough
difference between groups that it could be an important biasing factor=2C
even though the p-value is not significant after it is corrected for the=20
multiple testing."

Some tests fall "under" the original important tests=2C so that they may
be regarded as (say) explaining or detailing the reasons for the=20
significant (or non-significant) results in the primary tests.  You can poi=
nt
to the original=2C significant test as an "overall" test on the area=2C whi=
ch=20
then justifies using the nominal test size in followup.

- Of course=2C that organization of tests should have been done before=20
you ever collected the data.  Then=2C you probably would have done some
things a little different.  After the fact=2C you can only try to achieve t=
he
same "fair" state of mind=3B do not try to draw on what you have seen in
the results=2C because whatever critics exist will probably catch you at it=
.=20

Hope this helps.
--=20
Rich Ulrich=20


> Date: Sun=2C 14 Aug 2011 12:52:01 -0400
> From: [hidden email]
> Subject: How should I account for multiple comparisons when looking at p =
            values?
> To: [hidden email]
>=20
> I am comparing 7 groups on multiple dimensions (demographics=2C attitudes=
=2C
> actions).  Some comparisons are across all groups and some are among 2 or=
3
> or 4 of the groups.  They include ANOVAs=2C chi-squares and t tests.  I k=
now
> with so many comparisons some will be significant by chance.  How should =
I
> adjust for this?  Also=2C should such an adjustment be made within types =
of
> questions (e.g. within demographics=2C within attitudes=2C and within act=
ions)
> or across all items compared?
>=20
> Thanks for any help you can provide.
>=20

                                          =

--_b7c5cf0d-c9a8-4385-bb4d-9efd589425c4_
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:Tahoma
}
--></style>
</head>
<body class=3D'hmmessage'><div dir=3D'ltr'>
What kind of statement are you making?<br>Who are you making it to=2C and w=
hat do they expect?<br><br>What is the N?&nbsp=3B If you have tens of thous=
ands=2C a journal like NEJM<br>will suggest that you ignore all tests=2C an=
d focus on "effect size"=2C<br>because your power would be so large.&nbsp=
=3B <br><br>On the other hand=2C with 7 groups=2C observational data=2C and=
a much<br>smaller N...&nbsp=3B you could have a serious problem with power=
for some<br>analyses=2C especially if your group sizes are grossly unequal=
.&nbsp=3B I'll skip<br>by those concerns.<br><br>If the study is explorator=
y=2C then it is probably fair to report the straight<br>p-values -- with su=
itable warning to the readers.&nbsp=3B That is the simplest<br>case.&nbsp=
=3B Otherwise=2C corrections for multiple tests are needed for the <br>impo=
rtant tests. <br><br>
If you want to actually *conclude*&nbsp=3B something=2C about *hypotheses*=
=2C<br>
then you should draw up your small number of hypotheses in advance=2C<br>
and figure out what variables or composite scores will be able to test<br>
them.&nbsp=3B As you describe it=2C there are dozens of possible hypotheses=
. <br>
These should be arranged in a hierarchy:&nbsp=3B These few are *primary*=2C=
<br>
the main reason we collected the data=3B and (if any will be)=2C these will=
<br>
be tested with correction=3B&nbsp=3B these next are also interesting in an =
exploratory <br>
mode=2C and are reported without correction.<br><br>When you are looking at=
a variable that might *bias* the other <br>tests or comparisons=2C then it=
is proper=2C if not mandatory=2C to report the<br>single test with its nom=
inal p-value -- These are warnings=2C and you don't<br>want to under-rate a=
warning.&nbsp=3B If a variable plays both roles (being a<br>possible bias-=
factor=2C and being of intrinsic interest)=2C you need to report<br>both so=
rts of test-outcome if they are different.&nbsp=3B "Sex shows enough<br>dif=
ference between groups that it could be an important biasing factor=2C<br>e=
ven though the p-value is not significant after it is corrected for the <br=
>multiple testing."<br><br>Some tests fall "under" the original important t=
ests=2C so that they may<br>be regarded as (say) explaining or detailing th=
e reasons for the <br>significant (or non-significant) results in the prima=
ry tests.&nbsp=3B You can point<br>to the original=2C significant test as a=
n "overall" test on the area=2C which <br>then justifies using the nominal =
test size in followup.<br><br>&nbsp=3B- Of course=2C that organization of t=
ests should have been done before <br>you ever collected the data.&nbsp=3B =
Then=2C you probably would have done some<br>things a little different.&nbs=
p=3B After the fact=2C you can only try to achieve the<br>same "fair" state=
of mind=3B do not try to draw on what you have seen in<br>the results=2C b=
ecause whatever critics exist will probably catch you at it. <br><br>Hope t=
his helps.<br>-- <br>Rich Ulrich <br><br><br><div>&gt=3B Date: Sun=2C 14 Au=
g 2011 12:52:01 -0400<br>&gt=3B From: [hidden email]<br>&gt=3B Subject: =
How should I account for multiple comparisons when looking at p            =
  values?<br>&gt=3B To: [hidden email]<br>&gt=3B <br>&gt=3B I am =
comparing 7 groups on multiple dimensions (demographics=2C attitudes=2C<br>=
&gt=3B actions).  Some comparisons are across all groups and some are among=
2 or 3<br>&gt=3B or 4 of the groups.  They include ANOVAs=2C chi-squares a=
nd t tests.  I know<br>&gt=3B with so many comparisons some will be signifi=
cant by chance.  How should I<br>&gt=3B adjust for this?  Also=2C should su=
ch an adjustment be made within types of<br>&gt=3B questions (e.g. within d=
emographics=2C within attitudes=2C and within actions)<br>&gt=3B or across =
all items compared?<br>&gt=3B <br>&gt=3B Thanks for any help you can provid=
e.<br>&gt=3B <br><br></div>                                      </div></body>
</html>=

--_b7c5cf0d-c9a8-4385-bb4d-9efd589425c4_--

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

Date:    Sun, 14 Aug 2011 15:10:41 -0500
From:    Martha Hewett <[hidden email]>
Subject: Re: How should I account for multiple comparisons when looking at p
        values?

This is a multipart message in MIME format.
--=_alternative 006ED8A7862578EC_=
Content-Type: text/plain; charset="US-ASCII"

Rich - Thanks very much for your input.

The respondent n's for the 7 groups surveyed range from 380 to 569.
Mailout for each group was 800, except for the smallest group where the
max possible mailout was 441.  Excluding that group, respondent ns range
from 467 to 569 (We worked very hard to get these high response rates.)

A key question is whether the treatments caused people to take any actions
that fall within a broad category of actions.  To examine this we asked
about many actions (circa 40 without actually counting them).  These are
being tested individually and will probably also be put into groups of
about 3 or 4 broad types of actions and tested as composites.

I should explain that there is an objective measure of the impact of the
treatments, and that is also being analyzed, but the examination of the
self-reported actions attempts to determine why there is or isn't a
measurable impact.






From:
Rich Ulrich <[hidden email]>
To:
<[hidden email]>, <[hidden email]>
Date:
08/14/2011 02:56 PM
Subject:
RE: How should I account for multiple comparisons when looking at p
values?



What kind of statement are you making?
Who are you making it to, and what do they expect?

What is the N?  If you have tens of thousands, a journal like NEJM
will suggest that you ignore all tests, and focus on "effect size",
because your power would be so large.

On the other hand, with 7 groups, observational data, and a much
smaller N...  you could have a serious problem with power for some
analyses, especially if your group sizes are grossly unequal.  I'll skip
by those concerns.

If the study is exploratory, then it is probably fair to report the
straight
p-values -- with suitable warning to the readers.  That is the simplest
case.  Otherwise, corrections for multiple tests are needed for the
important tests.

If you want to actually *conclude*  something, about *hypotheses*,
then you should draw up your small number of hypotheses in advance,
and figure out what variables or composite scores will be able to test
them.  As you describe it, there are dozens of possible hypotheses.
These should be arranged in a hierarchy:  These few are *primary*,
the main reason we collected the data; and (if any will be), these will
be tested with correction;  these next are also interesting in an
exploratory
mode, and are reported without correction.

When you are looking at a variable that might *bias* the other
tests or comparisons, then it is proper, if not mandatory, to report the
single test with its nominal p-value -- These are warnings, and you don't
want to under-rate a warning.  If a variable plays both roles (being a
possible bias-factor, and being of intrinsic interest), you need to report
both sorts of test-outcome if they are different.  "Sex shows enough
difference between groups that it could be an important biasing factor,
even though the p-value is not significant after it is corrected for the
multiple testing."

Some tests fall "under" the original important tests, so that they may
be regarded as (say) explaining or detailing the reasons for the
significant (or non-significant) results in the primary tests.  You can
point
to the original, significant test as an "overall" test on the area, which
then justifies using the nominal test size in followup.

- Of course, that organization of tests should have been done before
you ever collected the data.  Then, you probably would have done some
things a little different.  After the fact, you can only try to achieve
the
same "fair" state of mind; do not try to draw on what you have seen in
the results, because whatever critics exist will probably catch you at it.


Hope this helps.
--
Rich Ulrich


> Date: Sun, 14 Aug 2011 12:52:01 -0400
> From: [hidden email]
> Subject: How should I account for multiple comparisons when looking at p
values?
> To: [hidden email]
>
> I am comparing 7 groups on multiple dimensions (demographics, attitudes,
> actions). Some comparisons are across all groups and some are among 2 or
3
> or 4 of the groups. They include ANOVAs, chi-squares and t tests. I know
> with so many comparisons some will be significant by chance. How should
I
> adjust for this? Also, should such an adjustment be made within types of
> questions (e.g. within demographics, within attitudes, and within
actions)
> or across all items compared?
>
> Thanks for any help you can provide.
>



--=_alternative 006ED8A7862578EC_=
Content-Type: text/html; charset="US-ASCII"


<br><font size=2 face="sans-serif">Rich - Thanks very much for your input.</font>
<br>
<br><font size=2 face="sans-serif">The respondent n's for the 7 groups
surveyed range from 380 to 569. &nbsp;Mailout for each group was 800, except
for the smallest group where the max possible mailout was 441. &nbsp;Excluding
that group, respondent ns range from 467 to 569 (We worked very hard to
get these high response rates.)</font>
<br>
<br><font size=2 face="sans-serif">A key question is whether the treatments
caused people to take any actions that fall within a broad category of
actions. &nbsp;To examine this we asked about many actions (circa 40 without
actually counting them). &nbsp;These are being tested individually and
will probably also be put into groups of about 3 or 4 broad types of actions
and tested as composites.</font>
<br>
<br><font size=2 face="sans-serif">I should explain that there is an objective
measure of the impact of the treatments, and that is also being analyzed,
but the examination of the self-reported actions attempts to determine
why there is or isn't a measurable impact. &nbsp;</font>
<br>
<br><font size=3><br>
</font>
<br>
<br>
<br>
<table width=100%>
<tr valign=top>
<td><font size=1 color=#5f5f5f face="sans-serif">From:</font>
<td><font size=1 face="sans-serif">Rich Ulrich &lt;[hidden email]&gt;</font>
<tr valign=top>
<td><font size=1 color=#5f5f5f face="sans-serif">To:</font>
<td><font size=1 face="sans-serif">&lt;[hidden email]&gt;, &lt;[hidden email]&gt;</font>
<tr valign=top>
<td><font size=1 color=#5f5f5f face="sans-serif">Date:</font>
<td><font size=1 face="sans-serif">08/14/2011 02:56 PM</font>
<tr valign=top>
<td><font size=1 color=#5f5f5f face="sans-serif">Subject:</font>
<td><font size=1 face="sans-serif">RE: How should I account for multiple
comparisons when looking at p &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
&nbsp;values?</font></table>
<br>
<hr noshade>
<br>
<br>
<br><font size=2 face="Tahoma">What kind of statement are you making?<br>
Who are you making it to, and what do they expect?<br>
<br>
What is the N? &nbsp;If you have tens of thousands, a journal like NEJM<br>
will suggest that you ignore all tests, and focus on &quot;effect size&quot;,<br>
because your power would be so large. &nbsp;<br>
<br>
On the other hand, with 7 groups, observational data, and a much<br>
smaller N... &nbsp;you could have a serious problem with power for some<br>
analyses, especially if your group sizes are grossly unequal. &nbsp;I'll
skip<br>
by those concerns.<br>
<br>
If the study is exploratory, then it is probably fair to report the straight<br>
p-values -- with suitable warning to the readers. &nbsp;That is the simplest<br>
case. &nbsp;Otherwise, corrections for multiple tests are needed for the
<br>
important tests. <br>
<br>
If you want to actually *conclude* &nbsp;something, about *hypotheses*,<br>
then you should draw up your small number of hypotheses in advance,<br>
and figure out what variables or composite scores will be able to test<br>
them. &nbsp;As you describe it, there are dozens of possible hypotheses.
<br>
These should be arranged in a hierarchy: &nbsp;These few are *primary*,<br>
the main reason we collected the data; and (if any will be), these will
<br>
be tested with correction; &nbsp;these next are also interesting in an
exploratory <br>
mode, and are reported without correction.<br>
<br>
When you are looking at a variable that might *bias* the other <br>
tests or comparisons, then it is proper, if not mandatory, to report the<br>
single test with its nominal p-value -- These are warnings, and you don't<br>
want to under-rate a warning. &nbsp;If a variable plays both roles (being
a<br>
possible bias-factor, and being of intrinsic interest), you need to report<br>
both sorts of test-outcome if they are different. &nbsp;&quot;Sex shows
enough<br>
difference between groups that it could be an important biasing factor,<br>
even though the p-value is not significant after it is corrected for the
<br>
multiple testing.&quot;<br>
<br>
Some tests fall &quot;under&quot; the original important tests, so that
they may<br>
be regarded as (say) explaining or detailing the reasons for the <br>
significant (or non-significant) results in the primary tests. &nbsp;You
can point<br>
to the original, significant test as an &quot;overall&quot; test on the
area, which <br>
then justifies using the nominal test size in followup.<br>
<br>
- Of course, that organization of tests should have been done before <br>
you ever collected the data. &nbsp;Then, you probably would have done some<br>
things a little different. &nbsp;After the fact, you can only try to achieve
the<br>
same &quot;fair&quot; state of mind; do not try to draw on what you have
seen in<br>
the results, because whatever critics exist will probably catch you at
it. <br>
<br>
Hope this helps.<br>
-- <br>
Rich Ulrich <br>
<br>
</font>
<br><font size=2 face="Tahoma">&gt; Date: Sun, 14 Aug 2011 12:52:01 -0400<br>
&gt; From: [hidden email]<br>
&gt; Subject: How should I account for multiple comparisons when looking
at p values?<br>
&gt; To: [hidden email]<br>
&gt; <br>
&gt; I am comparing 7 groups on multiple dimensions (demographics, attitudes,<br>
&gt; actions). Some comparisons are across all groups and some are among
2 or 3<br>
&gt; or 4 of the groups. They include ANOVAs, chi-squares and t tests.
I know<br>
&gt; with so many comparisons some will be significant by chance. How should
I<br>
&gt; adjust for this? Also, should such an adjustment be made within types
of<br>
&gt; questions (e.g. within demographics, within attitudes, and within
actions)<br>
&gt; or across all items compared?<br>
&gt; <br>
&gt; Thanks for any help you can provide.<br>
&gt; <br>
</font>
<br>
<br>
--=_alternative 006ED8A7862578EC_=--

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

Date:    Mon, 15 Aug 2011 07:32:30 +1000
From:    "Gosse, Michelle" <[hidden email]>
Subject: Re: calculating average annual percentage change in SPSS - reply help
        please!! [SEC: UNCLASSIFIED]

--_000_12E932690323AB4EBEEB21BAA28D90DE369A74F159EXCHANGE07foo_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hi Art,

I have this issue as well as my work requires a security classification on =
emails - so I can't do blank subject links - and enters what I think is htm=
l text into the email as it is sent.

The method I use to join is to use my home email address to join my work em=
ail address. Can your person use someone else's text email to join their Lo=
tus Notes-based email? Alternatively, can they set up a Hotmail or gmail ac=
count to do this? All they need to do is put their Lotus Notes email addres=
s in as the address which is subscribing, the address from which the subscr=
iption request is sent is ignored.

HTH

Cheers
Michelle




UNCLASSIFIED
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Ar=
t Kendall
Sent: Monday, 15 August 2011 3:38 AM
To: [hidden email]
Subject: Re: calculating average annual percentage change in SPSS - reply h=
elp please!!

It must be a real handicap in doing your work is you cannot get on listserv=
lists, forums, etc.

The listserv SPSSX-L uses  is very very old.  I guess nobody at a universit=
y or agency has volunteered to bring the archives to his/her system.
UGA has not updated its listserve or archives in a long time. They are runn=
ing version 1.8d. The current version is at least 15.0.  [this is surprisin=
g since lists are very helpful in educational settings. UGA's page says it =
has 2000 lists!]


[hidden email]<mailto:[hidden email]> i=
s where to send a message to the list manager.


I am including the list to see if others can help you.

I seem to recall that the problem of non-standard email has come up before.=
Does anyone on the list know
1 --  how someone who uses Lotus Notes can send _ordinary email_  without p=
rivileges?
2 --  what Thara should ask the IT department to set the overall parameters=
to? or
3 --  what Thara should ask the IT department to set the her/his parameters=
to?



Art Kendall
Social Research Consultants



On 8/11/2011 10:48 PM, Thara Vardhan wrote:
Hi Art

I sent a message to the SPSS list and I get the following message.

I do not have the administrator's email address. Can you sent it to me plea=
se?

Also my agency uses IBM Lotus notes as the official email software. I perso=
nally cannot change any settings or
features on it.

Your posting to the SPSSX-L list has been rejected because it contains an
attachment  of type  'MULTIPART/ALTERNATIVE'. The  SPSSX-L list  has been
configured to reject  such attachments; please contact the  list owner at
[hidden email]<mailto:[hidden email]> f=
or more information.

Can you help me please? There is no other way I can access the list serve.

I am not authorised to use the SPSS discussion list through the internet s=
ince it is forum.

many thanks
regards
thara

My message:

Hi Maurice, David and Art

Thank you so much for helping me with the syntax to calculate  'average
annual percentage change in SPSS'.

My apologies if i was not clear in explaining what i wanted to calculate.

I wanted to measure the  avgchange over the 5 years.

Art - the syntax you sent me worked perfectly. This is extremely useful.
You are absolutely right in your observation that the average change and
annual growth rate can be different.

Prior to sending my request to the list I managed to calculate it  as
follows using  Excel:

which translates to this in my Excel file

                                    =3D(C9/C5)^(1/5)-1

I was wondering if there is way in SPSS to do this without the aggregate
process.

many thanks
thara
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _=
_ _ _

The information contained in this email is intended for the named recipient=
(s)
only. It may contain private, confidential, copyright or legally privileged
information. If you are not the intended recipient or you have received this
email by mistake, please reply to the author and delete this email immediat=
ely.
You must not copy, print, forward or distribute this email, nor place relia=
nce
on its contents. This email and any attachment have been virus scanned. How=
ever,
you are requested to conduct a virus scan as well. No liability is accepted
for any loss or damage resulting from a computer virus, or resulting from a=
delay
or defect in transmission of this email or any attached file. This email do=
es not
constitute a representation by the NSW Police Force unless the author is le=
gally
entitled to do so.

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D To manage y=
our subscription to SPSSX-L, send a message to [hidden email]<ma=
ilto:[hidden email]> (not to SPSSX-L), with no body text except =
the command. To leave the list, send the command SIGNOFF SPSSX-L For a list=
of commands to manage subscriptions, send the command INFO REFCARD

**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This footnote also confirms that this email message has been swept by MIMEs=
weeper for the presence of computer viruses.
**********************************************************************


--_000_12E932690323AB4EBEEB21BAA28D90DE369A74F159EXCHANGE07foo_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" xmlns:o=3D"urn:schemas-micr=
osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" xmlns=3D"http:=
//www.w3.org/TR/REC-html40"><head><meta http-equiv=3DContent-Type content=
=3D"text/html; charset=3Dus-ascii"><meta name=3DGenerator content=3D"Micros=
oft Word 14 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
        {font-family:"Arial Unicode MS";
        panose-1:2 11 6 4 2 2 2 2 2 4;}
@font-face
        {font-family:Calibri;
        panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
        {font-family:Tahoma;
        panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
        {font-family:"\@Arial Unicode MS";
        panose-1:2 11 6 4 2 2 2 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
        {margin:0cm;
        margin-bottom:.0001pt;
        font-size:12.0pt;
        font-family:"Times New Roman","serif";
        color:black;}
h1
        {mso-style-priority:9;
        mso-style-link:"Heading 1 Char";
        margin-top:24.0pt;
        margin-right:0cm;
        margin-bottom:0cm;
        margin-left:0cm;
        margin-bottom:.0001pt;
        page-break-after:avoid;
        font-size:14.0pt;
        font-family:"Times New Roman","serif";
        color:#365F91;
        font-weight:bold;}
h2
        {mso-style-priority:9;
        mso-style-link:"Heading 2 Char";
        margin-top:10.0pt;
        margin-right:0cm;
        margin-bottom:0cm;
        margin-left:0cm;
        margin-bottom:.0001pt;
        page-break-after:avoid;
        font-size:13.0pt;
        font-family:"Times New Roman","serif";
        color:#4F81BD;
        font-weight:bold;}
p.MsoTitle, li.MsoTitle, div.MsoTitle
        {mso-style-priority:10;
        mso-style-link:"Title Char";
        margin-top:0cm;
        margin-right:0cm;
        margin-bottom:15.0pt;
        margin-left:0cm;
        mso-add-space:auto;
        font-size:26.0pt;
        font-family:"Times New Roman","serif";
        color:#17365D;
        letter-spacing:.25pt;}
p.MsoTitleCxSpFirst, li.MsoTitleCxSpFirst, div.MsoTitleCxSpFirst
        {mso-style-priority:10;
        mso-style-link:"Title Char";
        mso-style-type:export-only;
        margin:0cm;
        margin-bottom:.0001pt;
        mso-add-space:auto;
        font-size:26.0pt;
        font-family:"Times New Roman","serif";
        color:#17365D;
        letter-spacing:.25pt;}
p.MsoTitleCxSpMiddle, li.MsoTitleCxSpMiddle, div.MsoTitleCxSpMiddle
        {mso-style-priority:10;
        mso-style-link:"Title Char";
        mso-style-type:export-only;
        margin:0cm;
        margin-bottom:.0001pt;
        mso-add-space:auto;
        font-size:26.0pt;
        font-family:"Times New Roman","serif";
        color:#17365D;
        letter-spacing:.25pt;}
p.MsoTitleCxSpLast, li.MsoTitleCxSpLast, div.MsoTitleCxSpLast
        {mso-style-priority:10;
        mso-style-link:"Title Char";
        mso-style-type:export-only;
        margin-top:0cm;
        margin-right:0cm;
        margin-bottom:15.0pt;
        margin-left:0cm;
        mso-add-space:auto;
        font-size:26.0pt;
        font-family:"Times New Roman","serif";
        color:#17365D;
        letter-spacing:.25pt;}
p.MsoSubtitle, li.MsoSubtitle, div.MsoSubtitle
        {mso-style-priority:11;
        mso-style-link:"Subtitle Char";
        margin:0cm;
        margin-bottom:.0001pt;
        font-size:12.0pt;
        font-family:"Times New Roman","serif";
        color:#4F81BD;
        letter-spacing:.75pt;
        font-style:italic;}
a:link, span.MsoHyperlink
        {mso-style-priority:99;
        color:blue;
        text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
        {mso-style-priority:99;
        color:purple;
        text-decoration:underline;}
p
        {mso-style-priority:99;
        mso-margin-top-alt:auto;
        margin-right:0cm;
        mso-margin-bottom-alt:auto;
        margin-left:0cm;
        font-size:12.0pt;
        font-family:"Times New Roman","serif";}
tt
        {mso-style-priority:99;
        font-family:"Courier New";}
span.Heading1Char
        {mso-style-name:"Heading 1 Char";
        mso-style-priority:9;
        mso-style-link:"Heading 1";
        font-family:"Arial","sans-serif";
        color:#365F91;
        font-weight:bold;}
span.TitleChar
        {mso-style-name:"Title Char";
        mso-style-priority:10;
        mso-style-link:Title;
        font-family:"Arial","sans-serif";
        color:#17365D;
        letter-spacing:.25pt;}
span.SubtitleChar
        {mso-style-name:"Subtitle Char";
        mso-style-priority:11;
        mso-style-link:Subtitle;
        font-family:"Arial","sans-serif";
        color:#4F81BD;
        letter-spacing:.75pt;
        font-style:italic;}
span.Heading2Char
        {mso-style-name:"Heading 2 Char";
        mso-style-priority:9;
        mso-style-link:"Heading 2";
        font-family:"Arial","sans-serif";
        color:#4F81BD;
        font-weight:bold;}
span.EmailStyle24
        {mso-style-type:personal-reply;
        font-family:"Arial","sans-serif";
        color:#1F497D;}
.MsoChpDefault
        {mso-style-type:export-only;
        font-size:10.0pt;}
@page WordSection1
        {size:612.0pt 792.0pt;
        margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
        {page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]--></head><body bgcolor=3Dwhite lang=3DEN-AU=
link=3Dblue vlink=3Dpurple><div class=3DWordSection1><p class=3DMsoNormal>=
<span style=3D'font-size:11.0pt;font-family:"Arial","sans-serif";color:#1F4=
97D'>Hi Art,<o:p></o:p></span></p><p class=3DMsoNormal><span style=3D'font-=
size:11.0pt;font-family:"Arial","sans-serif";color:#1F497D'><o:p>&nbsp;</o:=
p></span></p><p class=3DMsoNormal><span style=3D'font-size:11.0pt;font-fami=
ly:"Arial","sans-serif";color:#1F497D'>I have this issue as well as my work=
requires a security classification on emails – so I can’t do b=
lank subject links – and enters what I think is html text into the em=
ail as it is sent.<o:p></o:p></span></p><p class=3DMsoNormal><span style=3D=
'font-size:11.0pt;font-family:"Arial","sans-serif";color:#1F497D'><o:p>&nbs=
p;</o:p></span></p><p class=3DMsoNormal><span style=3D'font-size:11.0pt;fon=
t-family:"Arial","sans-serif";color:#1F497D'>The method I use to join is to=
use my home email address to join my work email address. Can your person u=
se someone else’s text email to join their Lotus Notes-based email? A=
lternatively, can they set up a Hotmail or gmail account to do this? All th=
ey need to do is put their Lotus Notes email address in as the address whic=
h is subscribing, the address from which the subscription request is sent i=
s ignored.<o:p></o:p></span></p><p class=3DMsoNormal><span style=3D'font-si=
ze:11.0pt;font-family:"Arial","sans-serif";color:#1F497D'><o:p>&nbsp;</o:p>=
</span></p><p class=3DMsoNormal><span style=3D'font-size:11.0pt;font-family=
:"Arial","sans-serif";color:#1F497D'>HTH<o:p></o:p></span></p><p class=3DMs=
oNormal><span style=3D'font-size:11.0pt;font-family:"Arial","sans-serif";co=
lor:#1F497D'><o:p>&nbsp;</o:p></span></p><p class=3DMsoNormal><span style=
=3D'font-size:11.0pt;font-family:"Arial","sans-serif";color:#1F497D'>Cheers=
<o:p></o:p></span></p><p class=3DMsoNormal><span style=3D'font-size:11.0pt;=
font-family:"Arial","sans-serif";color:#1F497D'>Michelle<o:p></o:p></span><=
/p><p class=3DMsoNormal><span style=3D'font-size:11.0pt;font-family:"Arial"=
,"sans-serif";color:#1F497D'><o:p>&nbsp;</o:p></span></p><p class=3DMsoNorm=
al><span style=3D'font-size:11.0pt;font-family:"Arial","sans-serif";color:#=
1F497D'><o:p>&nbsp;</o:p></span></p><p class=3DMsoNormal><span style=3D'fon=
t-size:11.0pt;font-family:"Arial","sans-serif";color:#1F497D'><o:p>&nbsp;</=
o:p></span></p><p><b><span style=3D'font-size:10.0pt;font-family:"Arial Uni=
code MS","sans-serif";color:black'>UNCLASSIFIED</span></b><o:p></o:p></p><d=
iv><div style=3D'border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0=
cm 0cm 0cm'><p class=3DMsoNormal><b><span lang=3DEN-US style=3D'font-size:1=
0.0pt;font-family:"Tahoma","sans-serif";color:windowtext'>From:</span></b><=
span lang=3DEN-US style=3D'font-size:10.0pt;font-family:"Tahoma","sans-seri=
f";color:windowtext'> SPSSX(r) Discussion [mailto:[hidden email]]=
<b>On Behalf Of </b>Art Kendall<br><b>Sent:</b> Monday, 15 August 2011 3:3=
8 AM<br><b>To:</b> [hidden email]<br><b>Subject:</b> Re: calculat=
ing average annual percentage change in SPSS - reply help please!!<o:p></o:=
p></span></p></div></div><p class=3DMsoNormal><o:p>&nbsp;</o:p></p><p class=
=3DMsoNormal><span style=3D'font-size:13.5pt'>It must be a real handicap in=
doing your work is you cannot get on listserv lists, forums, etc.<br><br>T=
he listserv SPSSX-L uses&nbsp; is very very old.&nbsp; I guess nobody at a =
university or agency has volunteered to bring the archives to his/her syste=
m.<br>UGA has not updated its listserve or archives in a long time. They ar=
e running version 1.8d. The current version is at least 15.0.&nbsp; [this i=
s surprising since lists are very helpful in educational settings. UGA's pa=
ge says it has 2000 lists!]<br><br><br></span><tt><span style=3D'font-size:=
10.0pt'><a href=3D"mailto:[hidden email]">SPSSX-L-request=
@LISTSERV.UGA.EDU</a> </span></tt>is where to send a message to the list ma=
nager.<br><span style=3D'font-size:13.5pt'><br><br>I am including the list =
to see if others can help you.<br><br>I seem to recall that the problem of =
non-standard email has come up before. Does anyone on the list know <br>1 -=
-&nbsp; how someone who uses Lotus Notes can send _ordinary email_&nbsp; wi=
thout privileges? <br>2 --&nbsp; what Thara should ask the IT department to=
set the overall parameters to? or<br>3 --&nbsp; what Thara should ask the =
IT department to set the her/his parameters to?</span><br><span style=3D'fo=
nt-size:13.5pt'><br><br><br>Art Kendall<br>Social Research Consultants<br><=
br><br></span><br>On 8/11/2011 10:48 PM, Thara Vardhan wrote: <o:p></o:p></=
p><p class=3DMsoNormal style=3D'margin-bottom:12.0pt'><tt><span style=3D'fo=
nt-size:10.0pt'>Hi Art</span></tt> <br><br><span style=3D'font-size:10.0pt;=
font-family:"Arial","sans-serif"'>I sent a message to the SPSS list and I g=
et the following message. </span><br><br><span style=3D'font-size:10.0pt;fo=
nt-family:"Arial","sans-serif"'>I do not have the administrator's email add=
ress. Can you sent it to me please?</span> <br><br><span style=3D'font-size=
:10.0pt;font-family:"Arial","sans-serif"'>Also my agency uses IBM Lotus not=
es as the official email software. I personally cannot change any settings =
or &nbsp;</span> <br><span style=3D'font-size:10.0pt;font-family:"Arial","s=
ans-serif"'>features on it.</span> <br><br><tt><span style=3D'font-size:10.=
0pt'>Your posting to the SPSSX-L list has been rejected because it contains=
an</span></tt><span style=3D'font-size:10.0pt;font-family:"Courier New"'><=
br><tt>attachment &nbsp;of type &nbsp;'MULTIPART/ALTERNATIVE'. The &nbsp;SP=
SSX-L list &nbsp;has been</tt><br><tt>configured to reject &nbsp;such attac=
hments; please contact the &nbsp;list owner at</tt><br><tt><a href=3D"mailt=
o:[hidden email]">[hidden email]</a> fo=
r more information.</tt></span> <br><br><span style=3D'font-size:10.0pt;fon=
t-family:"Arial","sans-serif"'>Can you help me please? There is no other wa=
y I can access the list serve.</span> <br><br><span style=3D'font-size:10.0=
pt;font-family:"Arial","sans-serif"'>&nbsp;I am not authorised to use the S=
PSS discussion list through the internet since it is forum. </span><br><br>=
<span style=3D'font-size:10.0pt;font-family:"Arial","sans-serif"'>many than=
ks</span> <br><span style=3D'font-size:10.0pt;font-family:"Arial","sans-ser=
if"'>regards</span> <br><span style=3D'font-size:10.0pt;font-family:"Arial"=
,"sans-serif"'>thara</span> <br><br><span style=3D'font-size:10.0pt;font-fa=
mily:"Arial","sans-serif"'>My message:</span> <br><br><tt><span style=3D'fo=
nt-size:10.0pt'>Hi Maurice, David and Art</span></tt><span style=3D'font-si=
ze:10.0pt;font-family:"Courier New"'><br><br><tt>Thank you so much for help=
ing me with the syntax to calculate &nbsp;'average </tt><br><tt>annual perc=
entage change in SPSS'.</tt><br><br><tt>My apologies if i was not clear in =
explaining what i wanted to calculate.</tt><br><br><tt>I wanted to measure =
the &nbsp;avgchange over the 5 years. </tt><br><br><tt>Art - the syntax you=
sent me worked perfectly. This is extremely useful. </tt><br><tt>You are a=
bsolutely right in your observation that the average change and </tt><br><t=
t>annual growth rate can be different. </tt><br><br><tt>Prior to sending my=
request to the list I managed to calculate it &nbsp;as </tt><br><tt>follow=
s using &nbsp;Excel:</tt><br><br><tt>which translates to this in my Excel f=
ile</tt><br><br><tt>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;=
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbs=
p;=3D(C9/C5)^(1/5)-1</tt><br><br><tt>I was wondering if there is way in SPS=
S to do this without the aggregate </tt><br><tt>process.</tt><br><br><tt>ma=
ny thanks </tt><br><tt>thara</tt></span><o:p></o:p></p><table class=3DMsoNo=
rmalTable border=3D0 cellpadding=3D0 style=3D'background:white'><tr><td sty=
le=3D'padding:.75pt .75pt .75pt .75pt'><p class=3DMsoNormal style=3D'margin=
-bottom:12.0pt'>_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _=
_ _ _ _ _ _ _ _ _ _ _<br><br>The information contained in this email is in=
tended for the named recipient(s) <br>only. It may contain private, confide=
ntial, copyright or legally privileged <br>information. If you are not the =
intended recipient or you have received this <br>email by mistake, please r=
eply to the author and delete this email immediately. <br>You must not copy=
, print, forward or distribute this email, nor place reliance <br>on its co=
ntents. This email and any attachment have been virus scanned. However, <br=
>you are requested to conduct a virus scan as well. No liability is accepte=
d <br>for any loss or damage resulting from a computer virus, or resulting =
from a delay<br>or defect in transmission of this email or any attached fil=
e. This email does not <br>constitute a representation by the NSW Police Fo=
rce unless the author is legally <br>entitled to do so.<o:p></o:p></p></td>=
</tr></table><p class=3DMsoNormal><span style=3D'color:windowtext'>=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D To manage your su=
bscription to SPSSX-L, send a message to <a href=3D"mailto:LISTSERV@LISTSER=
V.UGA.EDU">[hidden email]</a> (not to SPSSX-L), with no body tex=
t except the command. To leave the list, send the command SIGNOFF SPSSX-L F=
or a list of commands to manage subscriptions, send the command INFO REFCAR=
D <o:p></o:p></span></p></div>
<p><span style=3D"font-family:'Arial';font-size:8pt;">*********************=
*************************************************</span></p>
<p><span style=3D"font-family:'Arial';font-size:8pt;">This email and any fi=
les transmitted with it are confidential and</span></p>
<p><span style=3D"font-family:'Arial';font-size:8pt;">intended solely for t=
he use of the individual or entity to whom they</span></p>
<p><span style=3D"font-family:'Arial';font-size:8pt;">are addressed. If you=
have received this email in error please notify</span></p>
<p><span style=3D"font-family:'Arial';font-size:8pt;">the system manager.</=
span></p>
<p><span style=3D"font-family:'Arial';font-size:8pt;"></span></p>
<p><span style=3D"font-family:'Arial';font-size:8pt;">&nbsp;</span></p>
<p><span style=3D"font-family:'Arial';font-size:8pt;">This footnote also co=
nfirms that this email message has been swept by MIMEsweeper for the presen=
ce of computer viruses.</span></p>
<p><span style=3D"font-family:'Arial';font-size:8pt;">*********************=
*************************************************</span></p>
<p><span style=3D"font-family:'Arial';font-size:8pt;">&nbsp;</span></p></bo=
dy></html>

--_000_12E932690323AB4EBEEB21BAA28D90DE369A74F159EXCHANGE07foo_--

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

Date:    Sun, 14 Aug 2011 18:31:17 -0700
From:    cysp <[hidden email]>
Subject: Excluding a large number of cases easily

Hi,

I have a subjectID column and an exclusion column that includes all the
subjectIDs that I want excluded. There is about 500 subjectIDs to be
excluded. What would be the easiest way to exclude them without manually
typing each subjectID as a conditional?

Thanks in advance

--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/Excluding-a-large-number-of-cases-easily-tp4699497p4699497.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

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

Date:    Sun, 14 Aug 2011 19:17:05 -0700
From:    David Marso <[hidden email]>
Subject: Re: Excluding a large number of cases easily

Please define your situation a bit more clearly!
What do you mean by an "exclusion column"?
What is the relationship between this "exclusion column" wrt the cases/rows
in your data file?
Maybe post a few cases with the subjectID and Exclusion column listed.
I will resist any temptations to attempt InterneTelepathy at the moment.

cysp wrote:

>
> Hi,
>
> I have a subjectID column and an exclusion column that includes all the
> subjectIDs that I want excluded. There is about 500 subjectIDs to be
> excluded. What would be the easiest way to exclude them without manually
> typing each subjectID as a conditional?
>
> Thanks in advance
>


--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/Excluding-a-large-number-of-cases-easily-tp4699497p4699566.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

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

Date:    Sun, 14 Aug 2011 20:59:25 -0700
From:    cysp <[hidden email]>
Subject: Re: Excluding a large number of cases easily

I'm not sure how to explain it any clearer. I'll paste a few rows:

subjectID                    exclude
206.80211.14:34          208.80211.14:34
207.80211.14:34          211.80211.14:34
208.80211.14:34                    .
209.80211.14:34                    .
210.80211.14:34                    .
211.80211.14:34                    .
            .                                .
            .                                .
            .                                .


What I want to do: If any subjectID is in the exclude column, delete that
row. I'm aware of the problem that deleting a row will also delete a value
that's in the exclusion column.

--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/Excluding-a-large-number-of-cases-easily-tp4699497p4699806.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

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

End of SPSSX-L Digest - 13 Aug 2011 to 14 Aug 2011 (#2011-228)
**************************************************************


Reply | Threaded
Open this post in threaded view
|

Re: summary distribution with multiple observations per respondent (2)

David Marso
Administrator
TO Barry!
HTML is trivial compared to what you just did!!!
PLEASE DON'T QUOTE THE WHOLE DAMNED DIGEST!!!!!
David
Please reply to the list and not to my personal email.
Those desiring my consulting or training services please feel free to email me.
---
"Nolite dare sanctum canibus neque mittatis margaritas vestras ante porcos ne forte conculcent eas pedibus suis."
Cum es damnatorum possederunt porcos iens ut salire off sanguinum cliff in abyssum?"
Reply | Threaded
Open this post in threaded view
|

Re: summary distribution with multiple observations per respondent (2)

Art Kendall
In reply to this post by Barry
The inability of the listserv to deal with HTML is due to the fact that UGA is running version 1.8b (a very old version) of listserv. The current version is at least 15.0.

Art

On 8/15/2011 8:31 AM, Barry DeCicco wrote:
First, a request to all - *please do not send HTML mail to the list* - it comes out insanely long and hard to read,
and will be mixed in with plain text mail.

<snip>
===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD
Art Kendall
Social Research Consultants