Hello everyone,
I am really knew to excel and do not have much experience. I was really hoping some people can help me out. I have tried to do this myself but can't seem to figure it out.
Basically, I distributed a survey for Parking enforcement officers and Workplace Violence and Harassment.
I want to generate a graph one for low harassment and high harassment (x-axis) and then stress is the y axis
second graph low training and high training (x-axis) and then stress is the y axis.
I would be really grateful in the help, and would certainly compensate somehow.
thanks.
My results are the following.
V stands for the Violence questions
VT is the total points for each participant in that section
H is harassment questions
I is interaction
T is training
S is stress
my survey is the following:
<tbody>
</tbody>
Please refer to the scales in each section to rate your response to the questions.
1 = strongly disagree
2 = disagree
3 = neutral
4 = agree
5 = strongly agree
1.I do not feel safe at work at all times 1 2 3 4 5
2.My workplace does not make me feel secure when I am at work 1 2 3 4 5
3.I understand that I may encounter violent individuals in my workplace 1 2 3 4 5
4.I know someone that has encountered a violent individual 1 2 3 4 5
***************1= never
2= rarely
3= sometimes
4 = not always
5 = always
5. I am harassed at least once a week during my shift 1 2 3 4 5
6. Harassment in the workplace affects my personal life 1 2 3 4 5
7. I cannot prevent harassment while at work 1 2 3 4 5
8. Harassment has affected my behaviour at home 1 2 3 4 5
How often has a stranger interacted with you while at work?
1 = daily
2 = weekly
3 = monthly
4 = once
5= never
9. Smile at you when passing by 1 2 3 4 5
10. Said Hello 1 2 3 4 5
11. Swore at you 1 2 3 4 5
12. Made a comment about you while passing by 1 2 3 4 5
1 = strongly disagree
2 = disagree
3 = neutral
4 = agree
5 = strongly agree
13. The violence and harassment training that I have received is not helpful 1 2 3 4 5
14. I feel like my workplace is not supportive and unresponsive 1 2 3 4 5
15. Procedures regarding violence are in place and easy to follow 1 2 3 4 5
16. I have been adequately trained in dealing with harassment 1 2 3 4 5
**********************************************
1 = strongly disagree
2 = disagree
3 = neutral
4 = agree
5 = strongly agree
17. Workplace stress contributes to my behaviour at home 1 2 3 4 5
18. I have trouble sleeping at night 1 2 3 4 5
19. I think about my job during my family time 1 2 3 4 5
20. My job is stressful 1 2 3 4 5
21. Sex (Please circle) Male Female
22. Age (Please circle) 20 – 30 31 – 40 41 – 50 over 50
Thank you for your participation.
I am really knew to excel and do not have much experience. I was really hoping some people can help me out. I have tried to do this myself but can't seem to figure it out.
Basically, I distributed a survey for Parking enforcement officers and Workplace Violence and Harassment.
I want to generate a graph one for low harassment and high harassment (x-axis) and then stress is the y axis
second graph low training and high training (x-axis) and then stress is the y axis.
I would be really grateful in the help, and would certainly compensate somehow.
thanks.
My results are the following.
V stands for the Violence questions
VT is the total points for each participant in that section
H is harassment questions
I is interaction
T is training
S is stress
my survey is the following:
| Participant | Sex | Age | V1 | V2 | V3 | V4 | VT | H1 | H2 | H3 | H4 | HT | I1 | I2 | I3 | I4 | IT | T1 | T2 | T3 | T4 | TT | S1 | S2 | S3 | S4 | ST |
| 1 | 1 | 2 | 4 | 3 | 5 | 4 | 18 | 3 | 1 | 3 | 2 | 9 | 2 | 1 | 4 | 2 | 9 | 4 | 4 | 3 | 5 | 16 | 4 | 3 | 1 | 5 | 13 |
| 2 | 1 | 1 | 4 | 2 | 5 | 4 | 16 | 2 | 4 | 3 | 4 | 13 | 2 | 2 | 4 | 1 | 9 | 3 | 5 | 2 | 4 | 14 | 5 | 4 | 3 | 4 | 16 |
| 3 | 1 | 2 | 3 | 2 | 4 | 4 | 15 | 4 | 1 | 5 | 2 | 12 | 1 | 1 | 3 | 2 | 7 | 3 | 5 | 5 | 5 | 18 | 5 | 4 | 4 | 4 | 17 |
| 4 | 1 | 2 | 4 | 3 | 5 | 2 | 16 | 4 | 4 | 3 | 3 | 14 | 1 | 1 | 4 | 1 | 7 | 4 | 2 | 4 | 5 | 15 | 5 | 3 | 3 | 5 | 16 |
| 5 | 1 | 1 | 1 | 3 | 5 | 4 | 14 | 3 | 4 | 5 | 3 | 15 | 2 | 2 | 4 | 3 | 11 | 2 | 2 | 4 | 4 | 12 | 2 | 3 | 3 | 4 | 12 |
| 6 | 1 | 1 | 1 | 1 | 5 | 2 | 10 | 4 | 4 | 5 | 4 | 17 | 3 | 1 | 4 | 1 | 9 | 2 | 4 | 3 | 4 | 13 | 4 | 4 | 3 | 5 | 16 |
<tbody>
</tbody>
Please refer to the scales in each section to rate your response to the questions.
1 = strongly disagree
2 = disagree
3 = neutral
4 = agree
5 = strongly agree
1.I do not feel safe at work at all times 1 2 3 4 5
2.My workplace does not make me feel secure when I am at work 1 2 3 4 5
3.I understand that I may encounter violent individuals in my workplace 1 2 3 4 5
4.I know someone that has encountered a violent individual 1 2 3 4 5
***************1= never
2= rarely
3= sometimes
4 = not always
5 = always
5. I am harassed at least once a week during my shift 1 2 3 4 5
6. Harassment in the workplace affects my personal life 1 2 3 4 5
7. I cannot prevent harassment while at work 1 2 3 4 5
8. Harassment has affected my behaviour at home 1 2 3 4 5
How often has a stranger interacted with you while at work?
1 = daily
2 = weekly
3 = monthly
4 = once
5= never
9. Smile at you when passing by 1 2 3 4 5
10. Said Hello 1 2 3 4 5
11. Swore at you 1 2 3 4 5
12. Made a comment about you while passing by 1 2 3 4 5
1 = strongly disagree
2 = disagree
3 = neutral
4 = agree
5 = strongly agree
13. The violence and harassment training that I have received is not helpful 1 2 3 4 5
14. I feel like my workplace is not supportive and unresponsive 1 2 3 4 5
15. Procedures regarding violence are in place and easy to follow 1 2 3 4 5
16. I have been adequately trained in dealing with harassment 1 2 3 4 5
**********************************************
1 = strongly disagree
2 = disagree
3 = neutral
4 = agree
5 = strongly agree
17. Workplace stress contributes to my behaviour at home 1 2 3 4 5
18. I have trouble sleeping at night 1 2 3 4 5
19. I think about my job during my family time 1 2 3 4 5
20. My job is stressful 1 2 3 4 5
21. Sex (Please circle) Male Female
22. Age (Please circle) 20 – 30 31 – 40 41 – 50 over 50
Thank you for your participation.
