Problems running data in spss

[nihalett]

CONTENTS DELETED

The author has deleted this message.

[nihalett]

CONTENTS DELETED

The author has deleted this message.

[John F Hall]

You don't say how many cases you have, or in what format.  Are they in
an Excel sheet or have you already entered them into the Data Editor
in SPSS?  
Have a look at
http://surveyresearch.weebly.com/summary-guide-to-spss-tutorials.html
but you've left it very late.

John F Hall (Mr)
[Retired academic survey researcher]

Email:   [hidden email]  
Website: www.surveyresearch.weebly.com  
SPSS start page:
www.surveyresearch.weebly.com/1-survey-analysis-workshop




-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf
Of nihalett
Sent: 10 January 2017 23:31
To: [hidden email]
Subject: Re: Problems running data in spss

The problem actually is that I need to analyze this while having two
values for each variable per respondent, since they have given their
attitude towards ad 1 and ad 2 , towards the model 1 and model 2, and
their targetedness by ad1 and ad2. It is so confusing I am losing my
mind over this !!
In the mean time the strength of ethnic identity has a (0/1) value
0=weak, 1=strong.



--
View this message in context:
http://spssx-discussion.1045642.n5.nabble.com/Problems-running-data-in
-spss-tp5733662p5733663.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

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

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

Lets back up a bit.

The answers to John's post are critical to understand what you are trying to do.

Did you assure the the data view was completed before trying the data? Please run the syntax DISPLAY DICTIONARY and post the results.


Are there values that are missing for some cases?


Please describe your procedure in more detail.

Do you have a less coarse measure of identity?

Do you have the ethnicity of the respondents?

How were your respondents chosen?

ads have 3 values. What are they
versions has two values. What are they?

Is it correct to say that every respondent saw the same 6 ads by version stimuli?

Please post the syntax that is resulting in the problem.  (if you are using the GUI to draft the syntax, exit the GUI via <paste>.)

[nihalett]

CONTENTS DELETED

The author has deleted this message.

[David Marso]

"But the problem is that i have different answers per respondent."
What in the Heck does this even mean?
Maybe you need to post your actual data rather that that useless png error message.
Looks like you left yourself a buttload time to do your analysis and write up?
Don't tell me, this is for an MBA degree?

nihalett wrote

Hello,
Thank you for your response.
My experiment was as follow: 15 moroccan respondents saw 2 versions of 3
ads (moroccan model, caucasian model), same procedure for 15 other
caucasian respondents. Their ethnic identity was measured using 5 scaled
questions then the means for their answer was calculated to have either
strong or weak output. Then their attitude towards the ad, attitude towards
the model and felt targetedness was measured for each ad. So now we have 6
attitudes towards the ad etc per respondents. The study is designed in a
way where I am running univariate analysis of variance for each dependent
variable per ethnic group. But the problem is that i have different answers
per respondent. I tried many data manipulations always getting error
message. What I want to study is the influence of the type of the ad and
the strength of ethnic identity on the dependent variable.
The values for the ads are categorical : meaning i have to put a number per
ad and its versions.
Strength of ethnic identity: strong/ weak

Le 11 janv. 2017 13:32, "Art Kendall [via SPSSX Discussion]" <
[hidden email]> a écrit :

> Lets back up a bit.
>
> The answers to John's post are critical to understand what you are trying
> to do.
>
> Did you assure the the data view was completed before trying the data?
> Please run the syntax DISPLAY DICTIONARY and post the results.
>
>
> Are there values that are missing for some cases?
>
>
> Please describe your procedure in more detail.
>
> Do you have a less coarse measure of identity?
>
> Do you have the ethnicity of the respondents?
>
> How were your respondents chosen?
>
> ads have 3 values. What are they
> versions has two values. What are they?
>
> Is it correct to say that every respondent saw the same 6 ads by version
> stimuli?
>
> Please post the syntax that is resulting in the problem.  (if you are
> using the GUI to draft the syntax, exit the GUI via <paste>.)
>
>
>
> Art Kendall
> Social Research Consultants
>
>
> ------------------------------
> If you reply to this email, your message will be added to the discussion
> below:
> http://spssx-discussion.1045642.n5.nabble.com/
> Problems-running-data-in-spss-tp5733662p5733669.html
> To unsubscribe from Problems running data in spss, click here
> <http://spssx-discussion.1045642.n5.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=5733662&code=bi5ldHRha2thbEBnbWFpbC5jb218NTczMzY2MnwzMTc3NDE5ODg=>
> .
> NAML
> <http://spssx-discussion.1045642.n5.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>
>


syntaxERROR.png (55K) <http://spssx-discussion.1045642.n5.nabble.com/attachment/5733670/0/syntaxERROR.png>

[nihalett]

CONTENTS DELETED

The author has deleted this message.

[Maguin, Eugene]

I’m looking at your excel file. It looks fine in excel, very pretty, nice color scheme. Spss isn’t so clever so you have to help it.

Row 1. Looks to be blank. Delete it.

Rows 2 and 3. Combine them into a single row (new row 1) such that each column name uniquely identifies the data in that column. I believe you are limited to 64 characters for column names but I suggest something informatively shorter. And, put a name in column A. It looks like it will then read in ok.

Perhaps you don’t know this but once spss has read the excel file you can go to the spss data window, ‘Variable’ tab and add a label for each variable and you can add value labels for the values of each variable (as well as identify the code[s] for missing values).

Gene Maguin

 

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

[David Marso]

I really did NOT want your raw Excel file.  The SPSS data file containing the exact variables referenced in the syntax error message would be far more suitable don't-cha think?
--

nihalett wrote

Thanks for your answer. Here is my actual data.

Le 11 janv. 2017 14:00, "David Marso [via SPSSX Discussion]" <
[hidden email]> a écrit :

> "But the problem is that i have different answers per respondent."
> What in the Heck does this even mean?
> Maybe you need to post your *actual data *rather that that useless png
> error message.
> Looks like you left yourself a buttload time to do your analysis and write
> up?
> Don't tell me, this is for an MBA degree?
>
> nihalett wrote
> Hello,
> Thank you for your response.
> My experiment was as follow: 15 moroccan respondents saw 2 versions of 3
> ads (moroccan model, caucasian model), same procedure for 15 other
> caucasian respondents. Their ethnic identity was measured using 5 scaled
> questions then the means for their answer was calculated to have either
> strong or weak output. Then their attitude towards the ad, attitude
> towards
> the model and felt targetedness was measured for each ad. So now we have 6
> attitudes towards the ad etc per respondents. The study is designed in a
> way where I am running univariate analysis of variance for each dependent
> variable per ethnic group. But the problem is that i have different
> answers
> per respondent. I tried many data manipulations always getting error
> message. What I want to study is the influence of the type of the ad and
> the strength of ethnic identity on the dependent variable.
> The values for the ads are categorical : meaning i have to put a number
> per
> ad and its versions.
> Strength of ethnic identity: strong/ weak
>
> Le 11 janv. 2017 13:32, "Art Kendall [via SPSSX Discussion]" <
> [hidden email] <http:///user/SendEmail.jtp?type=node&node=5733671&i=0>> a
> écrit :
>
> > Lets back up a bit.
> >
> > The answers to John's post are critical to understand what you are
> trying
> > to do.
> >
> > Did you assure the the data view was completed before trying the data?
> > Please run the syntax DISPLAY DICTIONARY and post the results.
> >
> >
> > Are there values that are missing for some cases?
> >
> >
> > Please describe your procedure in more detail.
> >
> > Do you have a less coarse measure of identity?
> >
> > Do you have the ethnicity of the respondents?
> >
> > How were your respondents chosen?
> >
> > ads have 3 values. What are they
> > versions has two values. What are they?
> >
> > Is it correct to say that every respondent saw the same 6 ads by version
> > stimuli?
> >
> > Please post the syntax that is resulting in the problem.  (if you are
> > using the GUI to draft the syntax, exit the GUI via <paste>.)
> >
> >
> >
> > Art Kendall
> > Social Research Consultants
> >
> >
> > ------------------------------
> > If you reply to this email, your message will be added to the discussion
> > below:
> > http://spssx-discussion.1045642.n5.nabble.com/
> > Problems-running-data-in-spss-tp5733662p5733669.html
> > To unsubscribe from Problems running data in spss, click here
> > <http://spssx-discussion.1045642.n5.nabble.com/template/
> NamlServlet.jtp?macro=unsubscribe_by_code&node=
> 5733662&code=bi5ldHRha2thbEBnbWFpbC5jb218NTczMzY2MnwzMTc3NDE5ODg=>
> > .
> > NAML
> > <http://spssx-discussion.1045642.n5.nabble.com/template/
> NamlServlet.jtp?macro=macro_viewer&id=instant_html%
> 21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNa
> mespace-nabble.view.web.template.NabbleNamespace-nabbl
> e.view.web.template.NodeNamespace&breadcrumbs=notify_
> subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%
> 3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>
> <http://spssx-discussion.1045642.n5.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml%3E>
> >
>
>
> syntaxERROR.png (55K) <http://spssx-discussion.10456
> 42.n5.nabble.com/attachment/5733670/0/syntaxERROR.png>
>
> Please reply to the list and not to my personal email.
> Those desiring my consulting or training services please feel free to
> email me.
> ---
> "Nolite dare sanctum canibus neque mittatis margaritas vestras ante porcos
> ne forte conculcent eas pedibus suis."
> Cum es damnatorum possederunt porcos iens ut salire off sanguinum cliff in
> abyssum?"
>
>
> ------------------------------
> If you reply to this email, your message will be added to the discussion
> below:
> http://spssx-discussion.1045642.n5.nabble.com/Problems-
> running-data-in-spss-tp5733662p5733671.html
> To unsubscribe from Problems running data in spss, click here
> <http://spssx-discussion.1045642.n5.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=5733662&code=bi5ldHRha2thbEBnbWFpbC5jb218NTczMzY2MnwzMTc3NDE5ODg=>
> .
> NAML
> <http://spssx-discussion.1045642.n5.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>
>


Ethnicity-and-Advertising-responses_January-3-2017_19.47-2-New-1-1 (4).xlsx (105K) <http://spssx-discussion.1045642.n5.nabble.com/attachment/5733672/0/Ethnicity-and-Advertising-responses_January-3-2017_19.47-2-New-1-1%20%284%29.xlsx>

[nihalett]

Hello ,
Thank you for your help. But the ad type or ad name is a variable itself.

[nihalett]

Sorry, I try to save my spss data file , but I cant. I don't know why.

[Maguin, Eugene]

I think I understand. Make a new variable name that combines your original row 2 and row 3 names.

I strongly suggest that you look around among your fellow students for a person that is familiar with spss and ask them to help you. It might be that the problem is just with setting up and reading data from excel. It's going to be easier on you, given your time limits, to have somebody sit with you and coach you through what you don't know. Pay them, if you need to.
Gene Maguin

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of nihalett
Sent: Wednesday, January 11, 2017 9:38 AM
To: [hidden email]
Subject: Re: Problems running data in spss

Hello ,
Thank you for your help. But the ad type or ad name is a variable itself.



--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/Problems-running-data-in-spss-tp5733662p5733676.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

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

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

[nihalett]

Thank you all for your help ... The problem has been solved . Thank you so much

[John F Hall]

This kind of problem is far too common in marketing and business studies courses.  Tight assignments and no real learning of SPSS.  Some overlap in these exchanges, but the data from the Excel file can be imported into SPSS.  With a bit if tweaking, variable labels can be copied one at a time and modified by hand.  I helped him to set up a file, but it's up to him to do the analysis using the GUI.  I wrote:

---

I copied the data from Excel to SPSS (very messy and uninformative).  The variable names are SPSS default.  You need labels on the Values for decent output and you need to get rid of the superfluous decimals for some variables.  You can do this inside the data editor.  Variable names need to begin with a letter.  I’ve done a simple analysis for you.  You need to double click on the *.sav file to open it: after that you can use the drop-down menus from the GUI.  You certainly have no time to learn enough syntax to do t-tests or multiple regression.  Good luck.

---

compute id = $casenum.

formats id (f3.0) ethnic (f1.0) strength to var00020 (f3.1).

variable labels id 'Case number'

    /ethnic 'Ethnicity'

    /strength 'Strength of ethnic identity'.

value labels id ethnic 1 'Moroccan' 2 'Caucasian'.

display labels.

frequencies ethnic.

descriptives  strength to var00020.

 

Variable Labels
Variable	Position	Label
id	1	Case number
ethnic	2	Ethnicity
strength	3	Strength of ethnic identity
VAR00003	4	Caucasian model in l'Oreal Attitude towards the Ad
VAR00004	5	Caucasian model in l'Oreal Attitude towards the Ad
VAR00005	6	Caucasian model in l'Oreal Felt targetedness
VAR00006	7	Moroccan model in l'Oreal Attitude towards the Ad
VAR00007	8	Moroccan model in l'Oreal Attitude towards the Ad
VAR00008	9	Moroccan model in l'Oreal Felt targetedness
VAR00009	10	Caucasian model in Coca-Cola Attitude towards the Ad
VAR00010	11	Caucasian model in Coca-Cola Attitude towards the Ad
VAR00011	12	Caucasian model in Coca-ColaFelt targetedness
VAR00012	13	Moroccan model in Coca-Cola Attitude towards the Ad
VAR00013	14	Moroccan model in Coca-Cola Attitude towards the Ad
VAR00014	15	Moroccan model in Coca-Cola Felt targetedness
VAR00015	16	Caucasian Model in Gillette: Attitude towards the Ad
VAR00016	17	Caucasian Model in Gillette Attitude towards the Ad
VAR00017	18	Caucasian Model in Gillette Felt targetedness
VAR00018	19	Moroccan Model in Gillette Attitude towards the Ad
VAR00019	20	Moroccan Model in Gillette Attitude towards the Ad
VAR00020	21	Moroccan Model in Gillette Felt targetedness
Variables in the working file

 

 

 

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of nihalett
Sent: 11 January 2017 17:05
To: [hidden email]
Subject: Re: Problems running data in spss

 

COMPUTE strength = Strengthofethnicidentity LE 1.7.

VALUE LABELS strength 1 "Strong" 0 "Weak".

 

 

 

--

View this message in context: http://spssx-discussion.1045642.n5.nabble.com/Problems-running-data-in-spss-tp5733662p5733683.html

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

 

=====================

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

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

[nihalett]

Oh thank you sir for your help, I have finally finished the analysis .. but please delete these posts for plagiarism issues.

Thank you sooo much for your help.

Le 11 janv. 2017 18:05, "John F Hall [via SPSSX Discussion]" <[hidden email]> a écrit :

This kind of problem is far too common in marketing and business studies courses.  Tight assignments and no real learning of SPSS.  Some overlap in these exchanges, but the data from the Excel file can be imported into SPSS.  With a bit if tweaking, variable labels can be copied one at a time and modified by hand.  I helped him to set up a file, but it's up to him to do the analysis using the GUI.  I wrote:

---

I copied the data from Excel to SPSS (very messy and uninformative).  The variable names are SPSS default.  You need labels on the Values for decent output and you need to get rid of the superfluous decimals for some variables.  You can do this inside the data editor.  Variable names need to begin with a letter.  I’ve done a simple analysis for you.  You need to double click on the *.sav file to open it: after that you can use the drop-down menus from the GUI.  You certainly have no time to learn enough syntax to do t-tests or multiple regression.  Good luck.

---

compute id = $casenum.

formats id (f3.0) ethnic (f1.0) strength to var00020 (f3.1).

variable labels id 'Case number'

    /ethnic 'Ethnicity'

    /strength 'Strength of ethnic identity'.

value labels id ethnic 1 'Moroccan' 2 'Caucasian'.

display labels.

frequencies ethnic.

descriptives  strength to var00020.

 

Variable Labels
Variable	Position	Label
id	1	Case number
ethnic	2	Ethnicity
strength	3	Strength of ethnic identity
VAR00003	4	Caucasian model in l'Oreal Attitude towards the Ad
VAR00004	5	Caucasian model in l'Oreal Attitude towards the Ad
VAR00005	6	Caucasian model in l'Oreal Felt targetedness
VAR00006	7	Moroccan model in l'Oreal Attitude towards the Ad
VAR00007	8	Moroccan model in l'Oreal Attitude towards the Ad
VAR00008	9	Moroccan model in l'Oreal Felt targetedness
VAR00009	10	Caucasian model in Coca-Cola Attitude towards the Ad
VAR00010	11	Caucasian model in Coca-Cola Attitude towards the Ad
VAR00011	12	Caucasian model in Coca-ColaFelt targetedness
VAR00012	13	Moroccan model in Coca-Cola Attitude towards the Ad
VAR00013	14	Moroccan model in Coca-Cola Attitude towards the Ad
VAR00014	15	Moroccan model in Coca-Cola Felt targetedness
VAR00015	16	Caucasian Model in Gillette: Attitude towards the Ad
VAR00016	17	Caucasian Model in Gillette Attitude towards the Ad
VAR00017	18	Caucasian Model in Gillette Felt targetedness
VAR00018	19	Moroccan Model in Gillette Attitude towards the Ad
VAR00019	20	Moroccan Model in Gillette Attitude towards the Ad
VAR00020	21	Moroccan Model in Gillette Felt targetedness
Variables in the working file

 

 

 

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of nihalett
Sent: 11 January 2017 17:05
To: [hidden email]
Subject: Re: Problems running data in spss

 

COMPUTE strength = Strengthofethnicidentity LE 1.7.

VALUE LABELS strength 1 "Strong" 0 "Weak".

 

 

 

--

View this message in context: http://spssx-discussion.1045642.n5.nabble.com/Problems-running-data-in-spss-tp5733662p5733683.html

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

 

=====================

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

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

---

If you reply to this email, your message will be added to the discussion below:

http://spssx-discussion.1045642.n5.nabble.com/Problems-running-data-in-spss-tp5733662p5733684.html

To unsubscribe from Problems running data in spss, click here.
NAML