John: The data file consists of one row for each resident and each resident has all of the variables. When a resident is missing a room a sysmis was used. Using count or multiple response will give me the number of hazards per room (and total) but again my concern is about the residents that do not have all five rooms (and have sysmis for those missing hazards per room). martin
From: John F Hall [mailto:[hidden email]]
Sent: Friday, February 08, 2013 1:54 AM
To: Martin Sherman; [hidden email]
Subject: RE: How to code hazards across house rooms
Martin
What does the data file actually look like? How many rows of data are there per residence? Is each room type in a separate data column or on a separate data row? Are the hazards coded on the same row? Does each hazard have a separate column or is there just a list of codes regardless of column?
You mention up to five room types: do any dwellings have more than one of each?
Sounds to me as if you need look at MULT RESPONSE to analyse the lists of hazards overall and for each room type. You can also use COUNT to create several indices by counting the number of different hazards in each room type, or the same hazard across all room types.
If you send me, in complete confidence and off-list, a copy of the original questionnaire/schedule and (an extract of) the Data Editor, I may be able to give more detailed help.
John F Hall (Mr)
[retired academic survey researcher]
Email: [hidden email]
Website: www.surveyresearch.weebly.com
From: SPSSX(r) Discussion [[hidden email]] On Behalf Of Martin Sherman
Sent: 08 February 2013 01:22
To: [hidden email]
Subject: How to code hazards across house rooms
Dear List: I have just received an SPSS data file from a colleague that contains responses from a City’s elderly residents who reported on safety hazards within their homes/apartments. Each room could have anywhere from 10 to 14 hazards that the residents had to check off. We are interested in getting a total hazards score for the five rooms (across the kitchen, living room, bedroom, dining room, and bathroom). However, I have noticed that not all of the residents had five rooms. Some lived in efficiency apartments and only had two rooms. If I totaled up the number of hazards across all rooms those with fewer rooms would automatically have lower hazards. If I obtained the mean across all of the rooms than residents could have the same mean number of hazards but it would be based upon a different number of rooms. I am trying to figure out how to factor in the number of rooms. Some way of weighting the scores but I am a bit dumbfounded on this. I realize that this is not an SPSS question but would appreciate suggestions (if you would like to chime in) as I begin to figure out how to analyze the data. Thanks in advance, martin
Martin F. Sherman, Ph.D.
Professor of Psychology
Director of Masters Education in Psychology: Thesis Track
Loyola University Maryland
Department of Psychology
222 B Beatty Hall
4501 North Charles Street
Baltimore, MD 21210
410-617-2417
| Free forum by Nabble | Edit this page |