Tag Archives: graph

How to make nicer graphs in Microsoft Excel

I really hate it when I’m presented with a graph like this one: It’s instantly recog­nis­able as one created in Microsoft Excel. For some reason the default settings in Excel produce some of the the ugliest graphs I’ve ever seen. Step 1  —  Fix … Continue reading

Tagged | Leave a comment |

The dangers of extrapolation

Physics isn’t for everyone; every year there’s a pretty good chance that at least one person will drop out of a group (some­times you get drop ins too). This year one group in par­tic­ular has lost more pupils than average … Continue reading

Tagged , | Leave a comment |

Fruit Gums and graphs

All the data from my Fruit Gums exper­i­ment has one con­tinuous variable (the number of gums) and one discrete variable variable (either box number or flavour) so the physicist’s standard graph  —  the x-y scatter plot  —  isn’t suitable. This made it a good … Continue reading

Tagged , | 3 Comments |