Simple Query

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

Simple Query

sophiebsheard
Hi There,

I'm a University student who is trying to get their head around SPSS, having
never used it before. I have 71 questionnaire responses to a customer
research questionnaire.

Some of my questions allow multiple answers and I don't really know how to
input this data into SPSS. The photo below shows my attempt. Does this look
correct? Or do I need to do something with the 'other' response. What does
the 116.4% mean also?



<http://spssx-discussion.1045642.n5.nabble.com/file/t341423/Screen_Shot_2018-04-02_at_20.png>

Thanks in advance.
Sophie



--
Sent from: http://spssx-discussion.1045642.n5.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
Reply | Threaded
Open this post in threaded view
|

Re: Simple Query

bdates

Sophie,


It would be helpful is you if you could explain how you got the "Percent of Cases" column.


Brian Dates

From: SPSSX(r) Discussion <[hidden email]> on behalf of sophiebsheard <[hidden email]>
Sent: Monday, April 2, 2018 3:38:21 PM
To: [hidden email]
Subject: Simple Query
 
Hi There,

I'm a University student who is trying to get their head around SPSS, having
never used it before. I have 71 questionnaire responses to a customer
research questionnaire.

Some of my questions allow multiple answers and I don't really know how to
input this data into SPSS. The photo below shows my attempt. Does this look
correct? Or do I need to do something with the 'other' response. What does
the 116.4% mean also?



<http://spssx-discussion.1045642.n5.nabble.com/file/t341423/Screen_Shot_2018-04-02_at_20.png>

Thanks in advance.
Sophie



--
Sent from: http://spssx-discussion.1045642.n5.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

===================== 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: Simple Query

Jon Peck
In reply to this post by sophiebsheard
It is important to think about responses vs cases with multiple response analysis, since the number of cases need not equal the number of responses.  The last column measures responses as a percent of cases.  Depending on your purpose, either might be appropriate.

On Mon, Apr 2, 2018 at 1:38 PM sophiebsheard <[hidden email]> wrote:
Hi There,

I'm a University student who is trying to get their head around SPSS, having
never used it before. I have 71 questionnaire responses to a customer
research questionnaire.

Some of my questions allow multiple answers and I don't really know how to
input this data into SPSS. The photo below shows my attempt. Does this look
correct? Or do I need to do something with the 'other' response. What does
the 116.4% mean also?



<http://spssx-discussion.1045642.n5.nabble.com/file/t341423/Screen_Shot_2018-04-02_at_20.png>

Thanks in advance.
Sophie



--
Sent from: http://spssx-discussion.1045642.n5.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
--
Jon K Peck
[hidden email]

===================== 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: Simple Query

sophiebsheard
In reply to this post by bdates
I put all my data into SPSS. I then pressed analyse and multiple responses,
then define variable sets. Selected the dichotomies variables to put into a
set. Gave them a count of 1 and labelled the multiple response set.

I then went to analyse again, multiple response and then frequencies. I
finally selected the multiple response set and clicked ok, which gave me
that table.



--
Sent from: http://spssx-discussion.1045642.n5.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
Reply | Threaded
Open this post in threaded view
|

Re: Simple Query

Jon Peck
If you have the Custom Tables option (under Anayze), I suggest that you use that rather than the older Mult Response procedure.

On Mon, Apr 2, 2018 at 3:11 PM sophiebsheard <[hidden email]> wrote:
I put all my data into SPSS. I then pressed analyse and multiple responses,
then define variable sets. Selected the dichotomies variables to put into a
set. Gave them a count of 1 and labelled the multiple response set.

I then went to analyse again, multiple response and then frequencies. I
finally selected the multiple response set and clicked ok, which gave me
that table.



--
Sent from: http://spssx-discussion.1045642.n5.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
--
Jon K Peck
[hidden email]

===================== 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: Simple Query

Art Kendall
In reply to this post by sophiebsheard
The graphic user  interface (GUI) is a great way to do a *first draft* of
your syntax. (the syntax is set of commands that tell SPSS what you want it
to do.)

Note that the GUI pages have a <paste> option.  When you do this you get
exactly what commands you are telling SPSS to do.  Using syntax helps you
keep track of what you are doing.  It shows you and your quality assurance
partner what you told the computer. As you develop your approach (i.e., what
you want) you re-draft the syntax until what you tell the computer you want
IS what you want.

Posting your syntax, any error messages, and the output provides a way for
potential helpers know what you did.  

It appears that you already have data in the data view.  
You say that some of your data is multiple response.  Did you have a "check
all that apply" type of questions?

If your syntax generated "MULT RESPONSE" click on <help> in SPSS and type
"MULT RESPONSE" in the edit box.  See the part about thebase for
percentages.




-----
Art Kendall
Social Research Consultants
--
Sent from: http://spssx-discussion.1045642.n5.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
Art Kendall
Social Research Consultants
Reply | Threaded
Open this post in threaded view
|

Re: Simple Query

sophiebsheard
1. Is your age between 18-35?
(Yes) (No)

2. Which ones do you think the AA’s brand stands for?

Courtesy
Collaboration
Care
Dynamism
Expertise
Other - Not Listed

3. Have you used any of the AA’s services before?
(Yes) (No)                                                                
If No, skip to question 6

4. If you answered yes - Which services?
(Breakdown) (Vehicle) (Home Insurance) (Money) (Travel)

5. Select all the factors that are important in influencing your decision to
purchase from the AA?


Trustworthiness
Brand loyalty
Recommendation
Advertising
Ease of use
Past use
Quality
Ethical Values
Innovation
Price

6. Have you seen the AA’s 2017 TV advertisements?
(Yes) (No)                                   If No, no need to answer
question 7 and 8

Did you notice these factors (yes or no)

7. Select all the factors that appeal to you from the TV Advertisement?
(Young)
(Fun)
(Reliable)
(Family-orientated)
(Cheerful)
(Innovative)
(Unique)

8. Would you consider using the AA’s services after watching the TV
advertisement?
(Yes) (No)



That is my questionnaire. I have had 71 responses. I am just trying to put
everything into SPSS as i've never used it before and its proving quite
difficult for me! It looks like this and on data view i've put it all in
too.

<http://spssx-discussion.1045642.n5.nabble.com/file/t341423/Screen_Shot_2018-04-02_at_22.png>



--
Sent from: http://spssx-discussion.1045642.n5.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
Reply | Threaded
Open this post in threaded view
|

Re: Simple Query

Jon Peck
I think you mean you have 71 cases, i.e., respondants, not responses.  That isn't enough to do much analysis, but what questions are you aiming to answer?

On Mon, Apr 2, 2018 at 3:39 PM sophiebsheard <[hidden email]> wrote:
1. Is your age between 18-35?
(Yes) (No)

2. Which ones do you think the AA’s brand stands for?

Courtesy
Collaboration
Care
Dynamism
Expertise
Other - Not Listed

3. Have you used any of the AA’s services before?
(Yes) (No)
If No, skip to question 6

4. If you answered yes - Which services?
(Breakdown) (Vehicle) (Home Insurance) (Money) (Travel)

5. Select all the factors that are important in influencing your decision to
purchase from the AA?


Trustworthiness
Brand loyalty
Recommendation
Advertising
Ease of use
Past use
Quality
Ethical Values
Innovation
Price

6. Have you seen the AA’s 2017 TV advertisements?
(Yes) (No)                                   If No, no need to answer
question 7 and 8

Did you notice these factors (yes or no)

7. Select all the factors that appeal to you from the TV Advertisement?
(Young)
(Fun)
(Reliable)
(Family-orientated)
(Cheerful)
(Innovative)
(Unique)

8. Would you consider using the AA’s services after watching the TV
advertisement?
(Yes) (No)



That is my questionnaire. I have had 71 responses. I am just trying to put
everything into SPSS as i've never used it before and its proving quite
difficult for me! It looks like this and on data view i've put it all in
too.

<http://spssx-discussion.1045642.n5.nabble.com/file/t341423/Screen_Shot_2018-04-02_at_22.png>



--
Sent from: http://spssx-discussion.1045642.n5.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
--
Jon K Peck
[hidden email]

===================== 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: Simple Query

John F Hall
In reply to this post by sophiebsheard

Sophie

The SPSS tutorials on my website are aimed specifically at SPSS newbies. 

Check out especially page:

Block 1 From questionnaire to SPSS saved file

(http://surveyresearch.weebly.com/block-1-from-questionnaire-to-spss-saved-file.html ). 

On multiple response see page:

3.3 Multiple response

(http://surveyresearch.weebly.com/33-multiple-response.html )

Hope this helps

 

John F Hall

[Retired academic survey researcher]

IBM-SPSS Academic Author 9900074

 

Email:             [hidden email]

Website:          http://surveyresearch.weebly.com/

SPSS course:   http://surveyresearch.weebly.com/1-survey-analysis-workshop-spss.html

Research:        http://surveyresearch.weebly.com/3-subjective-social-indicators-quality-of-life.html

 

-----Original Message-----
From: SPSSX(r) Discussion <[hidden email]> On Behalf Of sophiebsheard
Sent: 02 April 2018 21:38
To: [hidden email]
Subject: Simple Query

 

Hi There,

 

I'm a University student who is trying to get their head around SPSS, having never used it before. I have 71 questionnaire responses to a customer research questionnaire.

 

Some of my questions allow multiple answers and I don't really know how to input this data into SPSS. The photo below shows my attempt. Does this look correct? Or do I need to do something with the 'other' response. What does the 116.4% mean also?

 

 

 

<http://spssx-discussion.1045642.n5.nabble.com/file/t341423/Screen_Shot_2018-04-02_at_20.png>

 

Thanks in advance.

Sophie

 

 

 

--

Sent from: http://spssx-discussion.1045642.n5.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

===================== 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: Simple Query

John F Hall
In reply to this post by Jon Peck

My previous message was sent before the latest batch arrived on this topic.  As Jon says, 71 cases aren't many, but you can get some sensible analysis from frequencies and simple cross-tabs.  I'm surprised you haven't asked for gender!!

 

Assuming you have a decent set of variable labels and that your responses are coded  Yes / No, a quick way of analysing your multiple response lists is to use MULT RESPONSE in binary mode;

 

MULT RESPONSE

            groups = <groupname>  '<group label>' ( <varlist> (<value>))

            /frequencies = <groupname> .

 

For example, the 2014 British Social Attitudes Survey carried a set of questions about whether R has heard of various bodies (coded 1 = Yes 2 = No 3 = Not sure)

 

MULT RESPONSE

groups = heard 'Heard of bodies . .'   (AwGP to AwONS (1))

/frequencies heard.

 

 

Case Summary

 

Cases

Valid

Missing

Total

N

Percent

N

Percent

N

Percent

hearda

1901

66.1%

977

33.9%

2878

100.0%

a. Dichotomy group tabulated at value 1.

 

 

heard Frequencies

 

Responses

Percent of Cases

N

Percent

heard Heard of bodies . .a

AwGP Ever heard of Greenpeace on radio, TV, newspapers, or somewhere else?

1784

17.7%

93.8%

AwBoE Ever heard of the Bank of England on radio, TV, newspapers, or somewhere else?

1874

18.6%

98.6%

AwRCN Ever heard of the Royal College of Nursing on radio, TV, newspapers, or somewhere else?

1661

16.5%

87.4%

AwIBM Ever heard of IBM on radio, TV, newspapers, or somewhere else?

1547

15.3%

81.4%

AwDWP Ever heard of the Department for Work and Pensions on radio, TV, newspapers, or somewhere else?

1838

18.2%

96.7%

AwONS Ever heard of the Office for National Statistics (ONS) on radio, TV, newspapers, or somewhere else?

1379

13.7%

72.5%

Total

10083

100.0%

530.4%

a. Dichotomy group tabulated at value 1.

 

John F Hall

[Retired academic survey researcher]

IBM-SPSS Academic Author 9900074

 

Email:             [hidden email]

Website:          http://surveyresearch.weebly.com/

SPSS course:   http://surveyresearch.weebly.com/1-survey-analysis-workshop-spss.html

Research:        http://surveyresearch.weebly.com/3-subjective-social-indicators-quality-of-life.html

 

 

 

 

 

           

 

From: SPSSX(r) Discussion <[hidden email]> On Behalf Of Jon Peck
Sent: 02 April 2018 23:47
To: [hidden email]
Subject: Re: Simple Query

 

I think you mean you have 71 cases, i.e., respondants, not responses.  That isn't enough to do much analysis, but what questions are you aiming to answer?

 

On Mon, Apr 2, 2018 at 3:39 PM sophiebsheard <[hidden email]> wrote:

1. Is your age between 18-35?
(Yes) (No)

2. Which ones do you think the AA’s brand stands for?

Courtesy
Collaboration
Care
Dynamism
Expertise
Other - Not Listed

3. Have you used any of the AA’s services before?
(Yes) (No)
If No, skip to question 6

4. If you answered yes - Which services?
(Breakdown) (Vehicle) (Home Insurance) (Money) (Travel)

5. Select all the factors that are important in influencing your decision to
purchase from the AA?


Trustworthiness
Brand loyalty
Recommendation
Advertising
Ease of use
Past use
Quality
Ethical Values
Innovation
Price

6. Have you seen the AA’s 2017 TV advertisements?
(Yes) (No)                                   If No, no need to answer
question 7 and 8

Did you notice these factors (yes or no)

7. Select all the factors that appeal to you from the TV Advertisement?
(Young)
(Fun)
(Reliable)
(Family-orientated)
(Cheerful)
(Innovative)
(Unique)

8. Would you consider using the AA’s services after watching the TV
advertisement?
(Yes) (No)



That is my questionnaire. I have had 71 responses. I am just trying to put
everything into SPSS as i've never used it before and its proving quite
difficult for me! It looks like this and on data view i've put it all in
too.

<http://spssx-discussion.1045642.n5.nabble.com/file/t341423/Screen_Shot_2018-04-02_at_22.png>



--
Sent from: http://spssx-discussion.1045642.n5.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

--

Jon K Peck
[hidden email]

===================== 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: Simple Query

MLIves
In reply to this post by sophiebsheard
Sophie,

It looks to me like you did well with entering your data into SPSS.
Each response in a series gets its own variable with values 0/1.

Then you setup a multiple dichotomy analysis in MultResponse.

116.4% is the sum of the Percent of Cases--it is an indicator of how many of your respondents reported more than 1 response.

71 is the number of responses provided by your respondents.  This represents 116.4% of the number of respondents--which appears to be 61.  (71/1.164). So you know that there were 10 more responses than respondents.

The most common brand definitions are Care, Expertise, and Courtesy.

As Jon Peck noted, where you go next depends on the question you are answering.

Melissa

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of sophiebsheard
Sent: Monday, April 02, 2018 3:38 PM
To: [hidden email]
Subject: [SPSSX-L] Simple Query

Hi There,

I'm a University student who is trying to get their head around SPSS, having never used it before. I have 71 questionnaire responses to a customer research questionnaire.

Some of my questions allow multiple answers and I don't really know how to input this data into SPSS. The photo below shows my attempt. Does this look correct? Or do I need to do something with the 'other' response. What does the 116.4% mean also?



<http://spssx-discussion.1045642.n5.nabble.com/file/t341423/Screen_Shot_2018-04-02_at_20.png>

Thanks in advance.
Sophie



--
Sent from: http://spssx-discussion.1045642.n5.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

________________________________

This correspondence contains proprietary information some or all of which may be legally privileged; it is for the intended recipient only. If you are not the intended recipient you must not use, disclose, distribute, copy, print, or rely on this correspondence and completely dispose of the correspondence immediately. Please notify the sender if you have received this email in error. NOTE: Messages to or from the State of Connecticut domain may be subject to the Freedom of Information statutes and regulations.

=====================
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