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...
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.
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)