Hello.
I did a survey in which residents of a public housing project were asked questions about whether or not they wanted educational programs and whether or not they would attend any on-site educational classes were they made available, such as GED classes and computer classes; and, whether or not they would enroll their chidren in an after school program if it were available. The answers they had to choose from were yes, no, maybe and N/A (N/A = not applicable).
So, I created an Excel spreadsheet with their names, phones, unit numbers, and columns entitled "Wants GED," "Wants Computer," "Wants After School," "Attend GED," "Attend Computer," "Enroll After School," etc.
I want to assign a value for these survey answers such that, in each column, 1 = Yes, 2 = No, 3 = Maybe and 4 = N/A. Afterward entering all the data, I want to do a data analysis of these survey answers.
How do I do this? Or, am I going about it all wrong?
Sorry I'm so lame, but the residents of this public housing project are counting on me to produce these numbers to present to the entities they are petitioning to bring these programs to their community!
Thanks for any help.
I did a survey in which residents of a public housing project were asked questions about whether or not they wanted educational programs and whether or not they would attend any on-site educational classes were they made available, such as GED classes and computer classes; and, whether or not they would enroll their chidren in an after school program if it were available. The answers they had to choose from were yes, no, maybe and N/A (N/A = not applicable).
So, I created an Excel spreadsheet with their names, phones, unit numbers, and columns entitled "Wants GED," "Wants Computer," "Wants After School," "Attend GED," "Attend Computer," "Enroll After School," etc.
I want to assign a value for these survey answers such that, in each column, 1 = Yes, 2 = No, 3 = Maybe and 4 = N/A. Afterward entering all the data, I want to do a data analysis of these survey answers.
How do I do this? Or, am I going about it all wrong?
Sorry I'm so lame, but the residents of this public housing project are counting on me to produce these numbers to present to the entities they are petitioning to bring these programs to their community!
Thanks for any help.
