macgregorsd
New Member
- Joined
- Aug 9, 2011
- Messages
- 5
Hi, I hope someone can help.
I have analysed free text comments from a survey and split them into positive and negative comments and into six different comment categories. I have done this for 27 different schools. This was simply a case of frequencies. I have plotted the data in a bar chart of each of 27 schools, where by on y-axes we have no. of comments, and on x axis we have the 6 different categories and above each is a green bar for the positve comments and a red bar for the negative comments. Since in each school there were a different number of comment responses I have now done the same as above but using percentages.
Now, in order to compare across all different schools I have calculated the quartiles in percent for each of the 6 different categories and for positive and negative using the data for all 27 schools. What i want to now be able to do, is plot on each of the 27 schools bar chart the school wide box plot for that category showing how that school has compared to the schoolswide minimum, lower quartile, median, upper quartile and max value.
Basically on each of the individual schools graphs i wish there to be a box plot on top of each comment catgeory with all schools wide quartiles data for comparison purposes.
Can anyone help me with this?
I have analysed free text comments from a survey and split them into positive and negative comments and into six different comment categories. I have done this for 27 different schools. This was simply a case of frequencies. I have plotted the data in a bar chart of each of 27 schools, where by on y-axes we have no. of comments, and on x axis we have the 6 different categories and above each is a green bar for the positve comments and a red bar for the negative comments. Since in each school there were a different number of comment responses I have now done the same as above but using percentages.
Now, in order to compare across all different schools I have calculated the quartiles in percent for each of the 6 different categories and for positive and negative using the data for all 27 schools. What i want to now be able to do, is plot on each of the 27 schools bar chart the school wide box plot for that category showing how that school has compared to the schoolswide minimum, lower quartile, median, upper quartile and max value.
Basically on each of the individual schools graphs i wish there to be a box plot on top of each comment catgeory with all schools wide quartiles data for comparison purposes.
Can anyone help me with this?
