Hi!
I am researching the effect of cosmetic combinations on the perception of leadership characteristics. I collected data on 24 images: 6 treatment versions of 4 images. The data that I collected consists of ratings of each photo on 6 leadership characteristics, hence 6 dependent variables. I, therefore, collected 24x6=144 rating values, each rating being given by approximately 25 respondents. The 6 treatment versions consist of 2 independent variables: brow enhancement (yes or no) and lipstick colour (none, pink, red).
Since I basically collected 144 ratings, Stata has imported the data as 144 variables.
How can I transform the data such that I obtain 6 dependent variables and 2 independent variables from the 144 var's?
I think the problem with my data currently is that the variables pertain to the images rather than to the subject, which would be the case for e.g. control variables like gender, age etc.
Rather than having the current variables in Stata listed as separate variables, I need to ensure that I group the data such that I obtain:
Dependent variables:
Intelligence
Dominance
Honesty&integrity
Self-confidence
Leadership effectiveness
Attractiveness
Independent variables:
Brows
Lipstick colour
NB: the data from the four images can be aggregated.
Hope someone can help!
Related Posts with Data transformation from survey ratings to variables
DEA for banks.Hello everyone, I want to study the efficiency of banks using Data Envelopment Analysis (DEA). When …
Spatial Panel Econometric Analysis Omitted Variable problem.Hello. I want to do spatial panel econometric analysis. I'm using gravity model. In the gravitationa…
Significance starsHello, I would like to know if it is possible to display significance stars for the mean which I ha…
How to do a logit random effects in mata?Dear statalists: I want to do a logit random effects in mata.I have refered the xtlogit ,re in Camer…
T-test for cross sectional time series dataHi, I have weather data for a specific time period 2010-2017 for two cities I was wondering how to…
Subscribe to:
Post Comments (Atom)
0 Response to Data transformation from survey ratings to variables
Post a Comment