Martin
Do you have a variable; [Number of rooms]? Do you have a Yes/No code for each room type? If room type is coded 1/0 you could do something like:
COUNT rooms = living, kitchen, dining, bed, bath (1).
If it’s coded by type (eg 1 – 5) then:
Count rooms = living, kitchen, dining, bed, bath (1 thru 5).
. . . or whatever your room variables are called.
Assuming you have 1 column for each room type and 5 x 14 columns for the hazard types, and assuming the same coding list applies to each room type, you should have variables: [my names]
Livhaz1-14, kitchhaz 1-14, dinhaz1-14, bedhaz 1-14, bathhaz1-14
These may be coded 1,0 + sysmis or 1-14 + sysmis. If the latter then something like:
Mult resp groups = roomtype (living, kitchen, dining, bed, bath (1,5))
/hazardtype =
(Livhaz1 to livhaz14, kitchhaz1 to kitchhaz14, dinhaz1 to dinhaz14,
Bedhaz1 to bedhaz14, bathhaz1 to bathhaz14 (1,14))
/freq roomtype hazardtype
/tables = hazardtype by roomtype /cel cou col.
You can also get hazard type for each room by something like:
Mult resp groups
Khaz, (kitchhaz1 to kitchhaz14 (1,14))
/dhaz (dinhaz1 to dhaz14 (1,14))
/lhaz (livhaz1 to livhaz14 (1,14))
/behaz(bedhaz1 to bedhaz14 (1,14))
/bahaz (bathhaz1 to bathhaz14 (1,14))
/freq khaz to bahaz.
If your room types and hazard types are coded 0/1 you can run mult resp in dichotomous mode: just replace (1,14) with (1) in the above (all untested).
John F Hall (Mr)
[retired academic survey researcher]
Email: [hidden email]
Website: www.surveyresearch.weebly.com
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Martin Sherman
Sent: 08 February 2013 16:30
To: [hidden email]
Subject: Re: How to code hazards across house rooms
Martha: Thanks for the response. I did not think about the amount of time spent in the residence would basically be equated regardless of the number of rooms. Getting the average number of hazards across the rooms (equated all for five rooms) does that but I still worry about the sheer number. That is, it might be that only certain types of hazards are more likely in certain rooms than in others. Getting the average prorated across five rooms misses out on that. martin
From: Martha Hewett [[hidden email]]
Sent: Friday, February 08, 2013 10:15 AM
To: Martin Sherman
Cc: [hidden email]
Subject: Re: How to code hazards across house rooms
I like the percentage idea. What I keep thinking about is that if a person doesn't have a dining room, they do the things they would do in the dining room in the kitchen. If they don't have a bedroom, they do the things they would do in the bedroom in the living room. They still spend the same number of hours in their apartment. To some extent it makes conceptual sense to weight the rooms by the number of functions they perform. But I don't know that you could justify that rigorously.
Martha Hewett |
Director of Research | 612.335.5865 |
Center for Energy and Environment |
212 Third Avenue North, Suite 560 | Minneapolis, MN 55401 |
(cell) 612.839.2358 | (fax) 612.335.5888 | www.mncee.org |
On Fri, Feb 8, 2013 at 8:49 AM, Martin Sherman <[hidden email]> wrote:
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
This e-mail transmission and any attachments accompanying it may contain confidential and/or proprietary information and is intended only for the person or entity to whom it was originally addressed. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or other use of this information is strictly prohibited. Any unauthorized interception of this transmission is illegal. If you have received this transmission in error, please notify the sender by reply e-mail, and then destroy all copies of this transmission
| Free forum by Nabble | Edit this page |