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 group1 | frequency group2 |
| 0 | 0.02 | 0 |
| 1 | 0.06 | 0.02 |
| 2 | 0.21 | 0.115 |
| 3 | 0.38 | 0.32 |
| 4 | 0.24 | 0.37 |
| 5 | 0.09 | 0.16 |
| 6 | 0 | 0.025 |
However I know only how to do an Box-and-Whisker Plot with raw data (without in a cumulative frquency table). Is there a way to do a Box-and-Whisker Plot from thsi table in Excel?
Or it would also work if I would write put my frequency into promile and then write for example 20x 0, 60x 1, 210x 2 etc. If there is no possibility to do it direct and I need to do it this way, is there a possible command in Excel to say that 20 cells should be with the number 0, 60 with the number 1 and 210 with the number 2 etc. as drop down is there not really an option.
Thank you so much for your help
3 Replies
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.
- Thank you for this suggestions NikolinoDE.
Your first suggestion sounds straight streight forward. However, as I need to repeat all the values often I want to ask if there is any command to fill, for example that in 60 cells the value of 2 is inserted and so on. This would be really handy, as the drop-down function isn't that handy for so many egal values.
Thank you so much for your help.If you want to enter the same value in a certain cell range, you can use the Ctrl+Enter shortcut. This will insert the same data into all the selected cells at once.
Here are the steps to use Ctrl+Enter:
- Select all the cells where you want to enter the same value. You can use Ctrl+Space to select the entire column or Shift+Space to select the entire row.
- Type the value you want to enter and do not press Enter yet.
- Press Ctrl+Enter and the value will be entered into all the selected cells.
For example, if you want to enter 100 into cells A1:A10, you can select A1:A10, type 100 and press Ctrl+Enter.
Hope I could help.
I know I don't know anything (Socrates)
