Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Entering Ranking Questions in SPSS and Conjoint Analysis

6,800 views
Skip to first unread message

funkd...@gmail.com

unread,
Jun 13, 2013, 12:11:01 PM6/13/13
to
Hi there,

I´m doing a project for my MBA course and as part of choosing a conjoint analysis for our project (Í´m kicking myself for my ambition!), there´s a simple ranking question that I want to enter in SPSS. Respondents have to rank 6 different concepts from 1 to 6, 1 being the most preferred and so on.

Currently, I´m entering the question by creating 6 variables per concept, each variable denoting a ranking for that concept and using a nominal ranking of yes/no for each ranking. So 6 concepts that each receive rankings of 1 to 6 require 36 rows. Is there a simpler way. Apologies if this is a dumb question, but I´m a bit of an SPSS novice

Also, on the topic of conjoint analysis, I´d he glad to hook up with any experts in the field and pick their brain on the subject!

Art Kendall

unread,
Jun 13, 2013, 1:29:13 PM6/13/13
to
You just need 6 variables.
depending how your data gathering instrument is arranged
If the instrument presents the same list of concepts and the respondent
just puts in 1 to 6. Then just name the 6 variables and enter the rank
number. the variables might be apple orange banana cherry pear grapes.
you might enter 2 1 3 6 4 5

If the respondent writes in the concepts in their subjective rank order
then enter the data as a multiple response variable.
variables rankedfruit1 to rankedfruit6.
you might enter
grapes banana pear apple cherry orange

Be very sure that you proofread you data input with someone or have the
data entered by yourself and another person and compare the files.

Art Kendall
Social Research Consultants

On 6/13/2013 12:11 PM, funkd...@gmail.com wrote:
> Hi there,
>
> I磎 doing a project for my MBA course and as part of choosing a conjoint analysis for our project (痛m kicking myself for my ambition!), there磗 a simple ranking question that I want to enter in SPSS. Respondents have to rank 6 different concepts from 1 to 6, 1 being the most preferred and so on.
>
> Currently, I磎 entering the question by creating 6 variables per concept, each variable denoting a ranking for that concept and using a nominal ranking of yes/no for each ranking. So 6 concepts that each receive rankings of 1 to 6 require 36 rows. Is there a simpler way. Apologies if this is a dumb question, but I磎 a bit of an SPSS novice
>
> Also, on the topic of conjoint analysis, I磀 he glad to hook up with any experts in the field and pick their brain on the subject!
>

Rich Ulrich

unread,
Jun 13, 2013, 6:04:15 PM6/13/13
to
On Thu, 13 Jun 2013 09:11:01 -0700 (PDT), funkd...@gmail.com wrote:

>Hi there,
>
>I磎 doing a project for my MBA course and as part of choosing a conjoint analysis for our project (痛m kicking myself for my ambition!), there磗 a simple ranking question that I want to enter in SPSS. Respondents have to rank 6 different concepts from 1 to 6, 1 being the most preferred and so on.
>
>Currently, I磎 entering the question by creating 6 variables per concept, each variable denoting a ranking for that concept and using a nominal ranking of yes/no for each ranking. So 6 concepts that each receive rankings of 1 to 6 require 36 rows. Is there a simpler way. Apologies if this is a dumb question, but I磎 a bit of an SPSS novice
>
>Also, on the topic of conjoint analysis, I磀 he glad to hook up with any experts in the field and pick their brain on the subject!


If it is not too late -- Don't collect your data as ranks,
since that loses the sometimes-important information
about absolute level. (If you can't recover the ranks
by comparing scores, then "ranking" was giving you a
false notion of precision.)

As a bonus: besides giving you more information to
analyze, data on continuous scales are easier to analyze
and report.

--
Rich Ulrich

funkd...@gmail.com

unread,
Jun 17, 2013, 1:53:57 PM6/17/13
to
Thanks Rich,

I've collected the data as ranks; individual concept bundle) evaluated on likeability and likelihood of uptake, but after that I asked them to rank the bundles as well.

In order to do a conjoint, we want to derive the 'perfect bundle', picking and choosing from each concept. Thus the complicated entry system where each dummy variable has to be entered separately.

Mageswari R

unread,
Jun 19, 2013, 2:52:47 AM6/19/13
to
hi friends,
How to find the recency of last 5 purchase in SPSS?

Bruce Weaver

unread,
Jun 20, 2013, 8:37:57 AM6/20/13
to
On 19/06/2013 2:52 AM, Mageswari R wrote:
> hi friends,
> How to find the recency of last 5 purchase in SPSS?
>

InterneTelepathy and ESPss (TM, D. Marso) suggest that you have a data
file that includes multiple purchase dates for each individual, and you
want to compute elapsed time since some reference date (possibly current
date) to each of the 5 most recent purchase dates. Am I at all close?

Anyway, whatever it is you want, you'll stand a better chance of getting
some good help if you show:

1. An example of what the data file looks like now.
2. What you want it to look like after the computations.
3. What you've tried so far.

HTH.

--
Bruce Weaver
bwe...@lakeheadu.ca
http://sites.google.com/a/lakeheadu.ca/bweaver/Home
"When all else fails, RTFM."

funkd...@gmail.com

unread,
Jun 24, 2013, 5:14:33 AM6/24/13
to
On Wednesday, June 19, 2013 8:52:47 AM UTC+2, Mageswari R wrote:
> hi friends,
>
> How to find the recency of last 5 purchase in SPSS?

Stop hijacking my thread, friend :-)

mayr...@gmail.com

unread,
Jul 20, 2013, 9:10:31 AM7/20/13
to
Hey! Are you done? Did you get the results you expected? I am using conjoint in my Masters and I am entering the command for ranking (1-9) in SPSS this weekend.

hemadh...@gmail.com

unread,
Sep 12, 2013, 9:16:23 AM9/12/13
to
Well i am also in dilemma while entering the ranking variables in SPSS.

Can anyone help to know and understand how to enter rank variables and derive its output as well.

Case example:
Suppose you have six friends and you are asked to rank them from 1 to 6 as 1 for first priority to 6 for least priority.

eg:
name of friends

1. John
2. Micheal
3. Jobs
4. Harry
5. Hari
6. Mary

now 10 respondents are asked to answer the question to rank each of these persons....

I believe that it is complete question. Can anyone please help me :
1. How to enter the input variables in SPSS.
2. How to find out the output through SPSS.

Please let me asap....

Hem Adhikari
Researcher

Art Kendall

unread,
Sep 12, 2013, 11:00:13 AM9/12/13
to
try something like this.
You can generate the ctables command
by clickin <analyze><tables><custom tables>
then dragging the names to the row stubs and using the "category
position" drop down list to "row labels in columns"

data list list /Id(f2) John Micheal Jobs Harry Hari Mary(6f1).
begin data
01 1 2 3 4 5 6
02 6 5 4 3 2 1
03 4 5 6 1 2 3
04 1 4 2 5 3 6
end data.
descriptives varibles = John to Mary.
variable level john to mary (ordinal).
* Custom Tables.
CTABLES
/VLABELS VARIABLES=John Micheal Jobs Harry Hari Mary DISPLAY=BOTH
/TABLE John [COUNT F40.0] + Micheal [COUNT F40.0] + Jobs [COUNT
F40.0] + Harry [COUNT F40.0] +
Hari [COUNT F40.0] + Mary [COUNT F40.0]
/CLABELS ROWLABELS=OPPOSITE
/CATEGORIES VARIABLES=John Micheal Jobs Harry Hari Mary ORDER=A
KEY=VALUE EMPTY=EXCLUDE.


Art Kendall
Social Research Consultants

sanjub...@gmail.com

unread,
Jun 6, 2014, 2:29:42 AM6/6/14
to
then which statistics test need to use to analyze these ranked 6 variable

aniesfa...@gmail.com

unread,
May 17, 2015, 11:05:17 PM5/17/15
to
Greetings,

do you find the solution,really need your help on this.

sheri...@gmail.com

unread,
Jun 10, 2015, 2:39:13 AM6/10/15
to
hey can you just post a mail on that please

obiaj...@gmail.com

unread,
Sep 8, 2016, 8:58:36 AM9/8/16
to
Please can I get a help too here
0 new messages