| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 57637 | 2005-05-08 10:19:00 | BOX and whisker plot in microsoft excel | Ninjabear (2948) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 353308 | 2005-05-08 10:19:00 | Hi I want to make a box and whisker graph in microsoft excel.I've found the option to plot the data but the graph doesn't turn out rite Here is the data College St South College St North Botanical St West Botanical St East 3 6 4 3 4 3 5 2 1 3 3 2 2 0 1 6 6 0 1 0 2 1 3 2 2 3 4 7 2 2 1 8 2 4 2 1 7 2 2 0 0 1 3 3 4 0 5 4 6 7 7 3 2 1 1 3 2 0 2 2 3 2 2 3 3 1 3 2 5 3 2 1 1 0 5 1 2 2 2 2 Each number represents each street but the copy and paste obviously doesn't work The data is of the amount of cars going through each intersection. The row represent each phase which is the traffic light going from green to red. I have provided a link of the graph.It's not rite.What I want the graph is 1 box per street.There are 20 phases and 4 streets and i would this to be presented using a box and whisker chart CAn somebody please help? Ahh will post the link in a moment.Getting a program to convert bmp to jpeg cos image f1 won't take bitmap!! |
Ninjabear (2948) | ||
| 353309 | 2005-05-08 10:24:00 | So the first data is 3,6,4,3 3 is for college st south 6 is for college st north 4 is for botanical road west 3 is for botanical road east The column which is going down are the phases.So Green light to red light is one phase.Did 20 phases and need to present this using a box and whisker plot.I've just plot what i've copied and paste but its not working properly.Can anyone help? Please? |
Ninjabear (2948) | ||
| 353310 | 2005-05-08 10:31:00 | As you can see from this link sal.neoburn.net The graph isn't a box and whisker but I chose box and whisker ploit.Does anybody know how to make the graph so it displays properly? Excel should've been able to calculate the mean median and mode for the box and whisker rite? |
Ninjabear (2948) | ||
| 353311 | 2005-05-08 10:45:00 | I'm not sure I completely understand what you're trying to achieve but I suspect that you need to make the calculations in excel and make the graph from the calculated data. | Capt Jimbo (17) | ||
| 1 | |||||