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.htmlSent 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.htmlunless 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.htmlSent 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. Copy the syntax from the email.
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>
001 17 18 19 1<br>
002 18 19 17 1<br>
003 19 17 18 1<br>
004 17 18 19 2<br>
005 18 19 17 2<br>
006 19 17 18 2<br>
007 17 0 0 1<br>
008 0 17 19 1<br>
009 17 18 0
1<br>
010 19 0 0 2<br>
011 0 0 0 2<br>
012 0 17 0 2<br>
end data.<br>
dataset name 'original'<br>
var labels<br>
age1 'age event type 1'<br>
age2 'age event type 2'<br>
age3 'age event type 3'.<br>
value labels gender<br>
1 'male'<br>
2
'female'.<br>
mult response<br>
/groups = ages 'ages for events' (age1 to age3 (1, 104))<br>
/variables = gender (1,2)<br>
/frequencies = ages<br>
/tables = ages by ages by ages /ages by gender<br>
/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.htmlSent 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. GETURI DATA does not support
CSV format. 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 "h")<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:
</font><font size=1 face="sans-serif">drfg2008 <
[hidden email]></font>
<br><font size=1 color=#5f5f5f face="sans-serif">To:
</font><font size=1 face="sans-serif">
[hidden email]</font>
<br><font size=1 color=#5f5f5f face="sans-serif">Date:
</font><font size=1 face="sans-serif">08/14/2011 12:43 AM</font>
<br><font size=1 color=#5f5f5f face="sans-serif">Subject:
</font><font size=1 face="sans-serif">[SPSSX-L] SPSSINC
GETURI DATA</font>
<br><font size=1 color=#5f5f5f face="sans-serif">Sent by:
</font><font size=1
face="sans-serif">"SPSSX(r)
Discussion" <
[hidden email]></font>
<br>
<hr noshade>
<br>
<br>
<br><tt><font size=2>Is it possible to read in CSV-files with "SPSSINC
GETURI DATA"?<br>
<br>
SAV-file works fine:<br>
<br>
SPSSINC GETURI DATA<br>
URI="</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>"<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>
/TYPE=TXT<br>
/FILE='C:\user\...\filename.csv'<br>
/DELCASE=LINE<br>
/DELIMITERS=";"<br>
/ARRANGEMENT=DELIMITED<br>
/FIRSTCASE=2<br>
/IMPORTCASE=ALL<br>
/VARIABLES=<br>
id F10.0<br>
name_de A45<br>
begin A16<br>
League A30<br>
StandardMarketVolume F15.0<br>
standard_Back_1 F15.2<br>
standard_Lay_1 F15.2<br>
standard_Back_2 F15.2<br>
standard_Lay_2 F15.2<br>
PB2SMarketVolume F15.0<br>
pointbet2sets02back
F15.2<br>
pointbet2sets02lay F15.2<br>
pointbet2sets12back F15.2<br>
pointbet2sets12lay F15.2<br>
pointbet2sets20back F15.2<br>
pointbet2sets20lay F15.2<br>
pointbet2sets21back F15.2<br>
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.htmlSent 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 is very very old. 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.
[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 -- how someone who uses Lotus Notes can send _ordinary email_
without privileges? <br>
2 -- what Thara should ask the IT department to set the overall
parameters to? or<br>
3 -- 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 </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 of type 'MULTIPART/ALTERNATIVE'. The SPSSX-L
list has been<br>
configured to reject such attachments; please contact the
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"> 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
'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 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 as
<br>
follows using Excel:<br>
<br>
which
translates to this in my Excel file<br>
<br>
=(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. 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.
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">).
Those provide a
number of conveniences not available on the listserv.</font>
<br><font size=2 face="sans-serif"><br>
Jon Peck (no "h")<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:
</font><font size=1 face="sans-serif">Art Kendall <
[hidden email]></font>
<br><font size=1 color=#5f5f5f face="sans-serif">To:
</font><font size=1 face="sans-serif">
[hidden email]</font>
<br><font size=1 color=#5f5f5f face="sans-serif">Date:
</font><font size=1 face="sans-serif">08/14/2011 09:43 AM</font>
<br><font size=1 color=#5f5f5f face="sans-serif">Subject:
</font><font size=1 face="sans-serif">Re: [SPSSX-L]
calculating average annual percentage change in
SPSS - reply
help please!!</font>
<br><font size=1 color=#5f5f5f face="sans-serif">Sent by:
</font><font size=1 face="sans-serif">"SPSSX(r)
Discussion" <
[hidden email]></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 is very very old. 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. [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 -- how someone who uses Lotus Notes can send _ordinary email_ without
privileges? <br>
2 -- what Thara should ask the IT department to set the overall
parameters
to? or<br>
3 -- 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 </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 of type 'MULTIPART/ALTERNATIVE'. The SPSSX-L
list has been<br>
configured to reject such attachments; please contact the 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 '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 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 as
<br>
follows using Excel:<br>
<br>
which translates to this in my Excel file<br>
<br>
=(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 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
>
-----
--
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.htmlSent 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 <
[hidden email]></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 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">"SPSSX(r) Discussion" <
[hidden email]></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. 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. 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">).
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 "h")<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: </font><font size=1 face="sans-serif">Art
Kendall <
[hidden email]></font><font size=3> </font><font size=1 color=#5f5f5f face="sans-serif"><br>
To: </font><font size=1 face="sans-serif">
[hidden email]</font><font size=3>
</font><font size=1 color=#5f5f5f face="sans-serif"><br>
Date: </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: </font><font size=1 face="sans-serif">Re:
[SPSSX-L] calculating average annual percentage change in
SPSS - reply
help please!!</font><font size=3> </font><font size=1 color=#5f5f5f face="sans-serif"><br>
Sent by: </font><font size=1 face="sans-serif">"SPSSX(r)
Discussion" <
[hidden email]></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 is very very old. 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. [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 -- how someone who uses Lotus Notes can send _ordinary email_ without
privileges? <br>
2 -- what Thara should ask the IT department to set the overall parameters
to? or<br>
3 -- 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 </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 of type 'MULTIPART/ALTERNATIVE'. The SPSSX-L
list has
been<br>
configured to reject such attachments; please contact the 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 '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 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 as
<br>
follows using Excel:<br>
<br>
which translates to this in my Excel file<br>
<br>
=(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? =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. =
=3B <br><br>On the other hand=2C with 7 groups=2C observational data=2C and=
a much<br>smaller N... =3B you could have a serious problem with power=
for some<br>analyses=2C especially if your group sizes are grossly unequal=
. =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. =3B That is the simplest<br>case. =
=3B Otherwise=2C corrections for multiple tests are needed for the <br>impo=
rtant tests. <br><br>
If you want to actually *conclude* =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. =3B As you describe it=2C there are dozens of possible hypotheses=
. <br>
These should be arranged in a hierarchy: =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 =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. =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. =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. =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> =3B- Of course=2C that organization of t=
ests should have been done before <br>you ever collected the data. =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>>=3B Date: Sun=2C 14 Au=
g 2011 12:52:01 -0400<br>>=3B From:
[hidden email]<br>>=3B Subject: =
How should I account for multiple comparisons when looking at p =
values?<br>>=3B To:
[hidden email]<br>>=3B <br>>=3B I am =
comparing 7 groups on multiple dimensions (demographics=2C attitudes=2C<br>=
>=3B actions). Some comparisons are across all groups and some are among=
2 or 3<br>>=3B or 4 of the groups. They include ANOVAs=2C chi-squares a=
nd t tests. I know<br>>=3B with so many comparisons some will be signifi=
cant by chance. How should
I<br>>=3B adjust for this? Also=2C should su=
ch an adjustment be made within types of<br>>=3B questions (e.g. within d=
emographics=2C within attitudes=2C and within actions)<br>>=3B or across =
all items compared?<br>>=3B <br>>=3B Thanks for any help you can provid=
e.<br>>=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. 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.)</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. 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.</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. </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 <
[hidden email]></font>
<tr valign=top>
<td><font size=1 color=#5f5f5f face="sans-serif">To:</font>
<td><font size=1 face="sans-serif"><
[hidden email]>, <
[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: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
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? If you have tens of thousands, a journal like NEJM<br>
will suggest
that you ignore all tests, and focus on "effect size",<br>
because your power would be so large. <br>
<br>
On the other hand, with 7 groups, observational data, and a much<br>
smaller N... you could have a serious problem with power for some<br>
analyses, especially if your group sizes are grossly unequal. 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. That is the simplest<br>
case. Otherwise, corrections for multiple tests are needed for the
<br>
important tests. <br>
<br>
If you want to actually *conclude* 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. As you describe it, there are dozens of possible hypotheses.
<br>
These should be arranged in a hierarchy: These few are *primary*,<br>
the main reason we collected the data; and (if any will be), these will
<br>
be tested with correction; 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. 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. "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."<br>
<br>
Some tests fall "under" 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. You
can point<br>
to the original, significant test as an "overall" 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. Then, you
probably would have done some<br>
things a little different. After the fact, you can only try to achieve
the<br>
same "fair" 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">> Date: Sun, 14 Aug 2011 12:52:01 -0400<br>
> From:
[hidden email]<br>
> Subject: How should I account for multiple comparisons when looking
at p values?<br>
> To:
[hidden email]<br>
> <br>
> I am
comparing 7 groups on multiple dimensions (demographics, attitudes,<br>
> actions). Some comparisons are across all groups and some are among
2 or 3<br>
> or 4 of the groups. They include ANOVAs, chi-squares and t tests.
I know<br>
> with so many comparisons some will be significant by chance. How should
I<br>
> adjust for this? Also, should such an adjustment be made within types
of<br>
> questions (e.g. within demographics, within attitudes, and within
actions)<br>
> or across all items compared?<br>
> <br>
> Thanks for any help you can provide.<br>
> <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> </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> </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> </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> </o:p></span></p><p class=3DMsoNorm=
al><span style=3D'font-size:11.0pt;font-family:"Arial","sans-serif";color:#=
1F497D'><o:p> </o:p></span></p><p class=3DMsoNormal><span style=3D'fon=
t-size:11.0pt;font-family:"Arial","sans-serif";color:#1F497D'><o:p> </=
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> </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 is very very old. 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. [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 -=
- how someone who uses Lotus Notes can send _ordinary email_ wi=
thout privileges? <br>2 -- what Thara should ask the IT department to=
set the overall parameters to? or<br>3 -- 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 </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 of type 'MULTIPART/ALTERNATIVE'. The SP=
SSX-L list has been</tt><br><tt>configured to reject such attac=
hments; please contact the 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"'> 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 '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 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 as </tt><br><tt>follow=
s using Excel:</tt><br><br><tt>which translates to this in my Excel
f=
ile</tt><br><br><tt> =
&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;"> </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;"> </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.htmlSent 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.htmlSent 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.htmlSent from the SPSSX Discussion mailing list archive at Nabble.com.
------------------------------
End of SPSSX-L Digest - 13 Aug
2011 to 14 Aug 2011 (#2011-228)
**************************************************************