Psyc 515

PSYC 515

Survey Data Compilation Instructions

Overview

This document is a supplement to the Intro and Methods Assignment related to your Research Project in PSYC 515. Once you’ve collected your data, you will want to use this document as a guide to segue from data collection (surveys) to data analysis (preparing it for SPSS).

Instructions

Once you’ve completed data collection, gather your surveys. It will be necessary to enter data from each individual survey into SPSS. Open a new data file in SPSS. You will create a file and enter all of the raw data from each survey. The example used here demonstrates a survey created to examine a relationship between Organizational Religiosity (OR) and Anxiety. There is only ONE column for the OR variable since it was assessed using one question. The Anxiety subscale of DASS-21 (Lovibond & Lovibond, 1995) consists of seven questions, so you’d need to enter responses from those seven questions into 7 columns (one per question). Everyone must include descriptive statistics on at least one demographic variable as well, so you will have at least one more column in SPSS (one per demographic included on your survey).

Make sure you follow the directions on how each variable should be scored / interpreted exactly as provided in the Research Project Survey Instructions document. This information will be reiterated in your Method section. For instance, the DASS-21 Anxiety Subscale should be interpreted by summing all anxiety scores and then multiplying by 2 (this is per Lovibond & Lovibond, 1995, but for all variables you could choose, I provided this information for you in the aforementioned document). Thus, for my particular example I needed to create a Tot_Anxiety column in SPSS to reflect the sum multiplied by 2 (see Appendix B in the Kirkpatrick and Feeney textbook for guidance on how to compute a new variable). In my example, then, my SPSS file would thus have at least 10 columns (one demographic; one for OR; eight related to anxiety). You’d only end up analyzing your OR and TOT_Anxiety variables/columns for the Results, but including all questions and final variable columns is required to earn full points on this assignment. (Note if you want to examine the difference between low and high church attendance on anxiety, you’d have to create a second variable for OR in SPSS and categorize people into “high” and “low”, but there would need to be a sufficient rationale in your Introduction and then how this was done would be detailed in your Method section).

Remember, you are required to have at least 20 participants so you will have a minimum of 20 rows of data, and a minimum of 3 columns (but may have many more, it depends on what variables you chose and how many questions you have in your survey). Don’t forget to ensure your Scale of Measurement is correct in the Variable View!

The rest of this document continues using an example research project examining the relationship between organizational religiousity and anxiety. The following pages show three “completed” surveys and how they’d look entered into SPSS (both Variable View and Data View are shown).

Liberty University Online Example Survey #1 for PSYC 515

Disclosure: I am asking you to complete this survey as part of the requirements for my statistics project in a graduate level psychology course at Liberty University Online. Your answers will remain completely anonymous. No personal information about you will be linked to this survey. Please do not put your name or any other identifying information on the survey. The results of this survey will be used only for educational purposes and will not be published or released to the public. You must be 18 years old or older in order to complete this survey.

Directions: Please circle the number that best reflects your answer for each question.

1. What is your age? __ 35______

2. How often do you attend church or other religious meetings?

1 2 3 4 5 6

Never Once a year or less Few times/year Few times/month Once a week More than once/week

3. In the past week, I experienced breathing difficulty (e.g. excessively rapid breathing, breathlessness in the absence of physical exertion).

0	1	2	3
Did not apply to me at all	Applied to me to some degree, or some of the time	Applied to me to a considerable degree or a good part of time	Applied to me very much or most of the time

4. In the past week, I was worried about situations in which I might panic and make a fool of myself 0 1 2 3 Did not apply to me at all Applied to me to some degree, or some of the time Applied to me to a considerable degree or a good part of time Applied to me very much or most of the time 5. In the past week, I was aware of dryness of my mouth 0 1 2 3 Did not apply to me at all Applied to me to some degree, or some of the time Applied to me to a considerable degree or a good part of time Applied to me very much or most of the time 6. In the past week, I experienced trembling (e.g. in the hands) 0 1 2 3 Did not apply to me at all Applied to me to some degree, or some of the time Applied to me to a considerable degree or a good part of time Applied to me very much or most of the time 7. In the past week, I was aware of the action of my heart in the absence of physical exertion (e.g. sense of heart rate increase, heart missing a beat)

0 1 2 3 Did not apply to me at all Applied to me to some degree, or some of the time Applied to me to a considerable degree or a good part of time Applied to me very much or most of the time 8. In the past week, I felt scared without any good reason 0 1 2 3 Did not apply to me at all Applied to me to some degree, or some of the time Applied to me to a considerable degree or a good part of time Applied to me very much or most of the time 9. In the past week, I felt I was close to panic 0 1 2 3 Did not apply to me at all Applied to me to some degree, or some of the time Applied to me to a considerable degree or a good part of time Applied to me very much or most of the time

Liberty University Online Example Survey #2 for PSYC 515

Disclosure: I am asking you to complete this survey as part of the requirements for my statistics project in a graduate level psychology course at Liberty University Online. Your answers will remain completely anonymous. No personal information about you will be linked to this survey. Please do not put your name or any other identifying information on the survey. The results of this survey will be used only for educational purposes and will not be published or released to the public. You must be 18 years old or older in order to complete this survey.

Directions: Please circle the number that best reflects your answer for each question.

1. What is your age? _ 23____

2. How often do you attend church or other religious meetings?

1 2 3 4 5 6

Never Once a year or less Few times/year Few times/month Once a week More than once/week

3. In the past week, I experienced breathing difficulty (e.g. excessively rapid breathing, breathlessness in the absence of physical exertion).

0	1	2	3
Did not apply to me at all	Applied to me to some degree, or some of the time	Applied to me to a considerable degree or a good part of time	Applied to me very much or most of the time

4. In the past week, I was worried about situations in which I might panic and make a fool of myself 0 1 2 3 Did not apply to me at all Applied to me to some degree, or some of the time Applied to me to a considerable degree or a good part of time Applied to me very much or most of the time 5. In the past week, I was aware of dryness of my mouth 0 1 2 3 Did not apply to me at all Applied to me to some degree, or some of the time Applied to me to a considerable degree or a good part of time Applied to me very much or most of the time 6. In the past week, I experienced trembling (e.g. in the hands) 0 1 2 3 Did not apply to me at all Applied to me to some degree, or some of the time Applied to me to a considerable degree or a good part of time Applied to me very much or most of the time 7. In the past week, I was aware of the action of my heart in the absence of physical exertion (e.g. sense of heart rate increase, heart missing a beat)

0 1 2 3 Did not apply to me at all Applied to me to some degree, or some of the time Applied to me to a considerable degree or a good part of time Applied to me very much or most of the time 8. In the past week, I felt scared without any good reason 0 1 2 3 Did not apply to me at all Applied to me to some degree, or some of the time Applied to me to a considerable degree or a good part of time Applied to me very much or most of the time 9. In the past week, I felt I was close to panic 0 1 2 3 Did not apply to me at all Applied to me to some degree, or some of the time Applied to me to a considerable degree or a good part of time Applied to me very much or most of the time

Liberty University Online Example Survey #3 for PSYC 515

Disclosure: I am asking you to complete this survey as part of the requirements for my statistics project in a graduate level psychology course at Liberty University Online. Your answers will remain completely anonymous. No personal information about you will be linked to this survey. Please do not put your name or any other identifying information on the survey. The results of this survey will be used only for educational purposes and will not be published or released to the public. You must be 18 years old or older in order to complete this survey.

Directions: Please circle the number that best reflects your answer for each question.

1. What is your age? __ 44______

2. How often do you attend church or other religious meetings?

1 2 3 4 5 6

Never Once a year or less Few times/year Few times/month Once a week More than once/week

3. In the past week, I experienced breathing difficulty (e.g. excessively rapid breathing, breathlessness in the absence of physical exertion).

0	1	2	3
Did not apply to me at all	Applied to me to some degree, or some of the time	Applied to me to a considerable degree or a good part of time	Applied to me very much or most of the time

4. In the past week, I was worried about situations in which I might panic and make a fool of myself 0 1 2 3 Did not apply to me at all Applied to me to some degree, or some of the time Applied to me to a considerable degree or a good part of time Applied to me very much or most of the time 5. In the past week, I was aware of dryness of my mouth 0 1 2 3 Did not apply to me at all Applied to me to some degree, or some of the time Applied to me to a considerable degree or a good part of time Applied to me very much or most of the time 6. In the past week, I experienced trembling (e.g. in the hands) 0 1 2 3 Did not apply to me at all Applied to me to some degree, or some of the time Applied to me to a considerable degree or a good part of time Applied to me very much or most of the time 7. In the past week, I was aware of the action of my heart in the absence of physical exertion (e.g. sense of heart rate increase, heart missing a beat)

0 1 2 3 Did not apply to me at all Applied to me to some degree, or some of the time Applied to me to a considerable degree or a good part of time Applied to me very much or most of the time 8. In the past week, I felt scared without any good reason 0 1 2 3 Did not apply to me at all Applied to me to some degree, or some of the time Applied to me to a considerable degree or a good part of time Applied to me very much or most of the time 9. In the past week, I felt I was close to panic 0 1 2 3 Did not apply to me at all Applied to me to some degree, or some of the time Applied to me to a considerable degree or a good part of time Applied to me very much or most of the time

How to go from surveys to data entry in SPSS - Example

1. Now, to input this data into SPSS, I’ll start in the Variable View and enter names for all questions included on the survey. I’m naming them in a manner that will help me remember my variables – age, organizational religiousity, and anxiety. So, I’m naming my variables: Age, OrgRel, Anxiety1, Anxiety2, Anxiety3, Anxiety4, Anxiety5, Anxiety6, and Anxiety7 (note I will create an “AnxietyTOTAL” in a minute). Here’s what it looks like in Variable View:

2. Then, I go to Data View to enter data. Each survey will be one row, so I have three rows. Survey 1 is shown on row 1; survey 2 on row 2, and survey 3 on row 3. Once I enter all my surveys, I will create any summed, reverse scored, or averaged columns as necessary. In my specific research example, the variable Depression is quantified using the subscale “depression” from the DASS-21. And, per the original article, I need to sum all 7 questions and multiple it by two. I can do this by hand, in excel, or in SPSS but SPSS is preferred and required in this course. To do it in SPSS I will select the “Transform” tab and “Compute Variable”. I can name this new variable whatever I want – “AnxietyTOTAL”. Keeping the function group “all”, I can scroll alphabetically to “Sum” and select it. I then add each relevant question (Anxiety1-Anxiety7), separated by commas. Now, I surround the entire formula thus far in parenthesis so I can tell it to take the sum and then multiply it by 2, by entered a star and 2 (star = multiply), as shown in the image below.

3. Once I select “OK”, then new variable is created. SPSS identified its scale of measurement as nominal, which is wrong (I double checked in the Variable View). So, I manually changed it back to “Scale” in the Variable View. The other variables did not need combined, so I am now ready to analyze my data (except I only have three people in my sample, so obviously that isn’t enough! ). You must have at least 20 people complete your survey, so you will have at least 20 rows of data. Here is what my example data looks like in Data View:

4. Don’t forget you will upload your SPSS data file AND a word document to submit together (yes you can submit two files within a single attempt!) for this phase of the assignment!

Page 2 of 2