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:
[TABLE="width: 1800"]
<tbody>[TR]
[TD]Participant[/TD]
[TD]Sex[/TD]
[TD]Age[/TD]
[TD]V1[/TD]
[TD]V2[/TD]
[TD]V3[/TD]
[TD]V4[/TD]
[TD]VT[/TD]
[TD]H1[/TD]
[TD]H2[/TD]
[TD]H3[/TD]
[TD]H4[/TD]
[TD]HT[/TD]
[TD]I1[/TD]
[TD]I2[/TD]
[TD]I3[/TD]
[TD]I4[/TD]
[TD]IT[/TD]
[TD]T1[/TD]
[TD]T2[/TD]
[TD]T3[/TD]
[TD]T4[/TD]
[TD]TT[/TD]
[TD]S1[/TD]
[TD]S2[/TD]
[TD]S3[/TD]
[TD]S4[/TD]
[TD]ST[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]13[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]16[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]17[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]16[/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]12[/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]16[/TD]
[/TR]
</tbody>[/TABLE]
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:
[TABLE="width: 1800"]
<tbody>[TR]
[TD]Participant[/TD]
[TD]Sex[/TD]
[TD]Age[/TD]
[TD]V1[/TD]
[TD]V2[/TD]
[TD]V3[/TD]
[TD]V4[/TD]
[TD]VT[/TD]
[TD]H1[/TD]
[TD]H2[/TD]
[TD]H3[/TD]
[TD]H4[/TD]
[TD]HT[/TD]
[TD]I1[/TD]
[TD]I2[/TD]
[TD]I3[/TD]
[TD]I4[/TD]
[TD]IT[/TD]
[TD]T1[/TD]
[TD]T2[/TD]
[TD]T3[/TD]
[TD]T4[/TD]
[TD]TT[/TD]
[TD]S1[/TD]
[TD]S2[/TD]
[TD]S3[/TD]
[TD]S4[/TD]
[TD]ST[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]13[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]16[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]17[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]16[/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]12[/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]16[/TD]
[/TR]
</tbody>[/TABLE]
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.