Forum Discussion
Box-and-Whisker Plot from frequency table
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.
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)