95% conf. intervals for geometric means?

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

95% conf. intervals for geometric means?

Ian Martin-4
How can I calculate these for groups of observations?

Thanks for any suggestions.

regards,
Ian.

Ian D. Martin, Ph.D.

Tsuji Laboratory
University of Waterloo
Dept. of Environment & Resource Studies

=====================
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
Reply | Threaded
Open this post in threaded view
|

Re: 95% conf. intervals for geometric means?

Swank, Paul R
Calculate the 95% confidence interval in the log units and then back transform to the original units.

Paul R. Swank, Ph.D
Professor and Director of Research
Children's Learning Institute
University of Texas Health Science Center
Houston, TX 77038


-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Ian Martin
Sent: Friday, February 06, 2009 8:40 AM
To: [hidden email]
Subject: 95% conf. intervals for geometric means?

How can I calculate these for groups of observations?

Thanks for any suggestions.

regards,
Ian.

Ian D. Martin, Ph.D.

Tsuji Laboratory
University of Waterloo
Dept. of Environment & Resource Studies

=====================
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
Reply | Threaded
Open this post in threaded view
|

Re: 95% conf. intervals for geometric means?

Marta Garcia-Granero
In reply to this post by Ian Martin-4
Ian Martin wrote:
> How can I calculate these for groups of observations?
Hi Martin:

Log-transform your data, use EXAMINE to get 95%CI for group means, and
back-transform the limits. Since the anti-log of the mean of the
log(data) is the geometric mean, the anti-log of the confidence limits
will also be the 95%CI for the geometric mean.

HTH,
Marta García-Granero

--
For miscellaneous statistical stuff, visit:
http://gjyp.nl/marta/

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

Re: 95% conf. intervals for geometric means?

Burleson,Joseph A.
In reply to this post by Ian Martin-4
To follow up on the previous two comments: Marta and Paul's description
can include the further detail: the 2 resulting CI limits will not be
symmetrical in the original units.

One can do the same thing for standard deviations as for CI's: take the
mean of the transformed data and subtract (for -1 SD) and add (for + 1
SD) the SD's to the mean. Take these resultant values, symmetrically
different from the transformed mean, and back transform them. These will
be the non-symetrical SD's in the original units.

Joe Burleson

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Ian Martin
Sent: Friday, February 06, 2009 9:40 AM
To: [hidden email]
Subject: 95% conf. intervals for geometric means?

How can I calculate these for groups of observations?

Thanks for any suggestions.

regards,
Ian.

Ian D. Martin, Ph.D.

Tsuji Laboratory
University of Waterloo
Dept. of Environment & Resource Studies

=====================
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
Reply | Threaded
Open this post in threaded view
|

Re: 95% conf. intervals for geometric means?

Ian Martin-2
In reply to this post by Marta Garcia-Granero
Thanks to Marta, Paul, and others.  I was hoping that a
backtransformed CI was explicitly implemented somewhere, so that I'd
not have to transform and back transform for a large number of
variables.  Geometric mean is available through MEANS, so maybe SPSS
could consider adding the CI for this measure too?

There wouldn't be much point in adding (backtransformed) standard
deviation or SEM, as these would erroneously imply symmetry about the
mean.

regards,
Ian

Ian D. Martin, Ph.D.

Tsuji Laboratory
University of Waterloo
Dept. of Environment & Resource Studies


On 06 Feb, 2009, at 11:15 AM, Marta García-Granero wrote:

> Ian Martin wrote:
>> How can I calculate these for groups of observations?
> Hi Martin:
>
> Log-transform your data, use EXAMINE to get 95%CI for group means, and
> back-transform the limits. Since the anti-log of the mean of the
> log(data) is the geometric mean, the anti-log of the confidence limits
> will also be the 95%CI for the geometric mean.
>
> HTH,
> Marta García-Granero
>
> --
> For miscellaneous statistical stuff, visit:
> http://gjyp.nl/marta/
>
> =====================
> To manage your subscription to SPSSX-L, send a message to
> [hidden email] (not to SPSSX-L), with no body text
> except the
> command. To leave the list, send the command
> SIGNOFF SPSSX-L
> For a list of commands to manage subscriptions, send the command
> INFO REFCARD

=====================
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
Reply | Threaded
Open this post in threaded view
|

Re: 95% conf. intervals for geometric means?

Swank, Paul R
You could probably use OMS and arrays to reduce the drudgery.

Paul R. Swank, Ph.D
Professor and Director of Research
Children's Learning Institute
University of Texas Health Science Center
Houston, TX 77038


-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Ian Martin
Sent: Friday, February 06, 2009 12:09 PM
To: [hidden email]
Subject: Re: 95% conf. intervals for geometric means?

Thanks to Marta, Paul, and others.  I was hoping that a
backtransformed CI was explicitly implemented somewhere, so that I'd
not have to transform and back transform for a large number of
variables.  Geometric mean is available through MEANS, so maybe SPSS
could consider adding the CI for this measure too?

There wouldn't be much point in adding (backtransformed) standard
deviation or SEM, as these would erroneously imply symmetry about the
mean.

regards,
Ian

Ian D. Martin, Ph.D.

Tsuji Laboratory
University of Waterloo
Dept. of Environment & Resource Studies


On 06 Feb, 2009, at 11:15 AM, Marta García-Granero wrote:

> Ian Martin wrote:
>> How can I calculate these for groups of observations?
> Hi Martin:
>
> Log-transform your data, use EXAMINE to get 95%CI for group means, and
> back-transform the limits. Since the anti-log of the mean of the
> log(data) is the geometric mean, the anti-log of the confidence limits
> will also be the 95%CI for the geometric mean.
>
> HTH,
> Marta García-Granero
>
> --
> For miscellaneous statistical stuff, visit:
> http://gjyp.nl/marta/
>
> =====================
> To manage your subscription to SPSSX-L, send a message to
> [hidden email] (not to SPSSX-L), with no body text
> except the
> command. To leave the list, send the command
> SIGNOFF SPSSX-L
> For a list of commands to manage subscriptions, send the command
> INFO REFCARD

=====================
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
Reply | Threaded
Open this post in threaded view
|

Re: 95% conf. intervals for geometric means?

Marta Garcia-Granero
This is an implementation of Paul's idea of using OMS for the task (the
dataset used is "USA 1991 General Survey"):

* This step is important for the success of the code (data cleaning
steps are language dependent) *.
SET OLANG=ENGLISH.
* Variable to be transformed (replace by your own) *.
COMPUTE LogVar = LG10(age) .
* OMS (do not touch any line of code!) *.
DATASET DECLARE CIData.
OMS
 /SELECT TABLES
 /IF COMMANDS = ["Explore"]
     SUBTYPES = ["Descriptives"]
 /DESTINATION FORMAT = SAV
  OUTFILE = CIData
  VIEWER = NO.
* Replace grouping variable by your own (more than one can be used at
the same time) *.
EXAMINE
  VARIABLES=LogVar BY sex
  /PLOT NONE
  /STATISTICS DESCRIPTIVES
  /CINTERVAL 95
  /MISSING PAIRWISE
  /NOTOTAL.
OMSEND.
* Data cleaning and back-transform *.
DATASET ACTIVATE CIData.
IF Var4='' Var4=Var3.
SELECT IF Var4='Mean' OR Var4='Lower Bound' OR Var4='Upper Bound'.
EXE.
DELETE VARIABLES Command_ TO Var1 Std.Error Var3.
IF Var4='Lower Bound' Var4='LowerBound'.
IF Var4='Upper Bound' Var4='UpperBound'.
* Restructure output dataset *.
SORT CASES BY Var2 Var4.
CASESTOVARS
 /ID = Var2
 /INDEX = Var4
 /GROUPBY = VARIABLE .
* Backtransform *.
COMPUTE Geomean=10**Mean.
COMPUTE Lower=10**Lowerbound.
COMPUTE Upper=10**UpPerbound.
* Report *.
LIST VARIABLES Var2 Geomean Lower Upper.

HTH,
Marta García-Granero.


> -----Original Message-----
> From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Ian Martin
> Sent: Friday, February 06, 2009 12:09 PM
> To: [hidden email]
> Subject: Re: 95% conf. intervals for geometric means?
>
> Thanks to Marta, Paul, and others.  I was hoping that a
> backtransformed CI was explicitly implemented somewhere, so that I'd
> not have to transform and back transform for a large number of
> variables.  Geometric mean is available through MEANS, so maybe SPSS
> could consider adding the CI for this measure too?
>

---

For miscellaneous statistical stuff, visit:
http://gjyp.nl/marta/

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

conjoint syntax

E. Bernardo
Hi all,

 I encountered trouble in running the syntax below. 
 
CONJOINT PLAN 'c:\eins\Design2.sav'
   /DATA  'c:\eins\dataforanalysis.sav'
   /RANK = com_1 to com_12
   /SUBJECT=academe
   /FACTORS CurrOff(discrete) Tuition(discrete less) Location Program Prof Instruction Facility ClassSched
   /PLOT ALL.
 
The same syntax is doing well for my first data.  However, it fails for my second data.  Academe in the subject command is a group variable with 2 categories (academe, non-academe).  I am very surprised why the outputs in my second dataset are by subject within each category  Sample titles of outputs look like as follows:
Subject 1: Academe
Subject 2: Non-academe
Subject 3: Academe
....
....
...
Subject n: non-academe
 
Further more, the outputs show the reversal statistics.
What are these reversals?
 
Thank you in advance..
Eins


Design your own exclusive Pingbox today!
It's easy to create your personal chat space on your blogs
Reply | Threaded
Open this post in threaded view
|

Re: conjoint syntax

jpduarte
you must sort data by the variable used as subject
----- Original Message -----
Sent: Sunday, February 08, 2009 12:17 PM
Subject: conjoint syntax

Hi all,

 I encountered trouble in running the syntax below. 
 
CONJOINT PLAN 'c:\eins\Design2.sav'
   /DATA  'c:\eins\dataforanalysis.sav'
   /RANK = com_1 to com_12
   /SUBJECT=academe
   /FACTORS CurrOff(discrete) Tuition(discrete less) Location Program Prof Instruction Facility ClassSched
   /PLOT ALL.
 
The same syntax is doing well for my first data.  However, it fails for my second data.  Academe in the subject command is a group variable with 2 categories (academe, non-academe).  I am very surprised why the outputs in my second dataset are by subject within each category  Sample titles of outputs look like as follows:
Subject 1: Academe
Subject 2: Non-academe
Subject 3: Academe
....
....
...
Subject n: non-academe
 
Further more, the outputs show the reversal statistics.
What are these reversals?
 
Thank you in advance..
Eins


Design your own exclusive Pingbox today!
It's easy to create your personal chat space on your blogs



No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.0.233 / Virus Database: 270.10.19/1939 - Release Date: 02/07/09 13:39:00
Reply | Threaded
Open this post in threaded view
|

Re: conjoint syntax

E. Bernardo
In reply to this post by E. Bernardo
Thank you, João.
The problem has solved.
Eins.

--- On Sun, 2/8/09, João Duarte <[hidden email]> wrote:

From: João Duarte <[hidden email]>
Subject: Re: conjoint syntax
To: [hidden email]
Date: Sunday, 8 February, 2009, 1:39 PM

you must sort data by the variable used as subject
----- Original Message -----
Sent: Sunday, February 08, 2009 12:17 PM
Subject: conjoint syntax

Hi all,

 I encountered trouble in running the syntax below. 
 
CONJOINT PLAN 'c:\eins\Design2.sav'
   /DATA  'c:\eins\dataforanalysis.sav'
   /RANK = com_1 to com_12
   /SUBJECT=academe
   /FACTORS CurrOff(discrete) Tuition(discrete less) Location Program Prof Instruction Facility ClassSched
   /PLOT ALL.
 
The same syntax is doing well for my first data.  However, it fails for my second data.  Academe in the subject command is a group variable with 2 categories (academe, non-academe).  I am very surprised why the outputs in my second dataset are by subject within each category  Sample titles of outputs look like as follows:
Subject 1: Academe
Subject 2: Non-academe
Subject 3: Academe
....
....
...
Subject n: non-academe
 
Further more, the outputs show the reversal statistics.
What are these reversals?
 
Thank you in advance..
Eins


Design your own exclusive Pingbox today!
It's easy to create your personal chat space on your blogs


No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.0.233 / Virus Database: 270.10.19/1939 - Release Date: 02/07/09 13:39:00


Design your own exclusive Pingbox today!
It's easy to create your personal chat space on your blogs
Reply | Threaded
Open this post in threaded view
|

Re: 95% conf. intervals for geometric means?

Ian Martin-2
In reply to this post by Marta Garcia-Granero
Marta,

Thanks very much.  It is most kind of you to spend the time to
develop the OMS syntax.  I'm sure others will find it useful too.

best regards,
Ian

Ian D. Martin, Ph.D.
Aquatic Ecologist


On 08 Feb, 2009, at 5:26 AM, Marta García-Granero wrote:

> This is an implementation of Paul's idea of using OMS for the task
> (the
> dataset used is "USA 1991 General Survey"):
>
> * This step is important for the success of the code (data cleaning
> steps are language dependent) *.
> SET OLANG=ENGLISH.
> * Variable to be transformed (replace by your own) *.
> COMPUTE LogVar = LG10(age) .
> * OMS (do not touch any line of code!) *.
> DATASET DECLARE CIData.
> OMS
> /SELECT TABLES
> /IF COMMANDS = ["Explore"]
>     SUBTYPES = ["Descriptives"]
> /DESTINATION FORMAT = SAV
>  OUTFILE = CIData
>  VIEWER = NO.
> * Replace grouping variable by your own (more than one can be used at
> the same time) *.
> EXAMINE
>  VARIABLES=LogVar BY sex
>  /PLOT NONE
>  /STATISTICS DESCRIPTIVES
>  /CINTERVAL 95
>  /MISSING PAIRWISE
>  /NOTOTAL.
> OMSEND.
> * Data cleaning and back-transform *.
> DATASET ACTIVATE CIData.
> IF Var4='' Var4=Var3.
> SELECT IF Var4='Mean' OR Var4='Lower Bound' OR Var4='Upper Bound'.
> EXE.
> DELETE VARIABLES Command_ TO Var1 Std.Error Var3.
> IF Var4='Lower Bound' Var4='LowerBound'.
> IF Var4='Upper Bound' Var4='UpperBound'.
> * Restructure output dataset *.
> SORT CASES BY Var2 Var4.
> CASESTOVARS
> /ID = Var2
> /INDEX = Var4
> /GROUPBY = VARIABLE .
> * Backtransform *.
> COMPUTE Geomean=10**Mean.
> COMPUTE Lower=10**Lowerbound.
> COMPUTE Upper=10**UpPerbound.
> * Report *.
> LIST VARIABLES Var2 Geomean Lower Upper.
>
> HTH,
> Marta García-Granero.
>
>
>> -----Original Message-----
>> From: SPSSX(r) Discussion [mailto:[hidden email]] On
>> Behalf Of Ian Martin
>> Sent: Friday, February 06, 2009 12:09 PM
>> To: [hidden email]
>> Subject: Re: 95% conf. intervals for geometric means?
>>
>> Thanks to Marta, Paul, and others.  I was hoping that a
>> backtransformed CI was explicitly implemented somewhere, so that I'd
>> not have to transform and back transform for a large number of
>> variables.  Geometric mean is available through MEANS, so maybe SPSS
>> could consider adding the CI for this measure too?
>>
>
> ---
>
> For miscellaneous statistical stuff, visit:
> http://gjyp.nl/marta/
>
> =====================
> To manage your subscription to SPSSX-L, send a message to
> [hidden email] (not to SPSSX-L), with no body text
> except the
> command. To leave the list, send the command
> SIGNOFF SPSSX-L
> For a list of commands to manage subscriptions, send the command
> INFO REFCARD

=====================
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
Reply | Threaded
Open this post in threaded view
|

Re: conjoint syntax

E. Bernardo
In reply to this post by E. Bernardo
Hi João,
 
The following syntax creates and saves files containing utilities and SCOREs for each respondent.  I dont know what the SCOREs are. Are they the "importance"?  If not how to compute importance?
 
CONJOINT PLAN 'c:\eins\Design2.sav'
  /DATA 'c:\agor\dataforanalysis.sav'
  /RANK = com_1 to com_12
  /SUBJECT=Respondent#
  /FACTORS CurrOff Tuition Location Program Prof Instruction Facility ClassSched
  /PLOT SUMMARY
  /UTILITY='c:\eins\utility2.sav'.
 
Eins


Bring your friends to the fun.
Invite your friends from Hotmail, Gmail to Yahoo! Mail today!
Reply | Threaded
Open this post in threaded view
|

Re: conjoint syntax

jpduarte
Hi Eins
 

The scores of the utility file are the global utility of the cards used in experiment.

They are computed by adding the constant + the part-worth utilities of each level/attribute of each card

 

The importance is the relative weight (%) of the amplitude of the utilities of each attribute.  

 

João

 

----- Original Message -----
Sent: Wednesday, February 11, 2009 1:45 AM
Subject: Re: conjoint syntax

Hi João,
 
The following syntax creates and saves files containing utilities and SCOREs for each respondent.  I dont know what the SCOREs are. Are they the "importance"?  If not how to compute importance?
 
CONJOINT PLAN 'c:\eins\Design2.sav'
  /DATA 'c:\agor\dataforanalysis.sav'
  /RANK = com_1 to com_12
  /SUBJECT=Respondent#
  /FACTORS CurrOff Tuition Location Program Prof Instruction Facility ClassSched
  /PLOT SUMMARY
  /UTILITY='c:\eins\utility2.sav'.
 
Eins


Bring your friends to the fun.
Invite your friends from Hotmail, Gmail to Yahoo! Mail today!



No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.0.233 / Virus Database: 270.10.20/1944 - Release Date: 02/10/09 17:44:00