Q 1. Given the survey information as shown , you are required to produce a Pareto Chart using Excel
Food Service Customer Survey Data Collection
Complaint type Count Cumulative Cumulative %
Wait time 60 60 47
Soup not hot 30 90 71
Food too salty 10 100 79
Food portion too small 5 105 83
Food items overpriced 6 111 87
Salad not fresh 7 118 93
Staff not well trained 9 127 100
The result of this exercise/answer is a Pareto Chart, showing the following: the bar chart and a curve line and 80% cut off ( 80/20 rule)
Y axis on the left side =frequency / count
Y axis on the right side = cumulative %
X axis shows the types of complaint clearly label.
Each column shows the complaint with the count number on the top of the bar
Title : Customer complaint survey data over 30 days
Please show your excel calculations step by step. I tried the following steps provided by my tutor but I was stuck.
- I selected columns Complaint Type, Count and Cumulative %
- On the Insert tab, in the Charts group, click the Column symbol.
- Click Clustered Column , select the 2 D column
s regarding environmental issues as a threat but this do by a referent object in a specific social, political, linguistic structure. (Stritzel, 2007) The vague conceptualisation of the specific referent object as mentioned by the Copenhagen School – need the post-structural position created by the second generation of securitisation scholars where they stress the importance of the role the audience play along with setting the socio-political environment. (Salter, 2008) The purpose of this essay was to assess critically the strengths and weaknesses of the securitisation theory. After discussing the concept of the securitisation theory as conceptualised by the Copenhagen School, the essay went on to discuss how the theory was developed by second generation of securitization scholars by focusing on “what conditions the social content and meaning of security produced threats.” (Balzacq, 2010) The essay then went on to discuss the stance the Aberystwyth School had on the voice of the audience and finally, the idea of environmental securitisation was discussed. It can be argued that security may not be a negative practice, which as discussed above involves the use of hard power but instead the emancipation from the “relative objectivism” affecting both traditional stance on security and the Copenhagen School work. Therefore, it can be said that the concept of security can be revised to provide a unified position on security. In regard to the securitisation of environmental degradation, environmental issues can be tackled rather than those issues being exploited politically. This essay has provided a range of strength and weaknesses to the Securitisation theory.>GET ANSWER