Forum Discussion
Box-and-Whisker Plot from frequency table
Hello I am currently doing an math investigation for my school. There I need to graph a Box-and-Whisker Plot from a frequency table with grouped data. like this: level frequency grou...
One possible way to do this is to convert your frequency table into a list of raw data values by repeating each level as many times as its frequency.
For example, 20x 0, 60x 1, 210x 2 etc. Then you can use the Insert Chart dialog box to create a box and whisker chart from the raw data values.
Another possible way is to calculate the quartile values and differences for each group using formulas, and then create a stacked column chart that can be converted into a box plot style.
You can find more details and examples on how to do these methods by following the links in the search results.
I hope this helps.
Have fun completing the task.