Tuesday, December 20, 2011

How To... Draw a Basic Scatter Diagram in Excel 2010

One of the shortest videos I have created for the Learn with Dr Eugene O'Loughlin channel is about creating a scatter diagram in Excel 2010 (see below). Creating a scatter diagram is really easy to do, and it is a useful diagram if you want a simple visual look at a comparison of two variables. In this video I use data comparing on-line course ratings against age. This is based in part on an example from the book Managing Information Technology Projects (Schwalbe, 2011), which I use in my Project Management classes.



For my PhD thesis (1988), I produced many scatter diagrams for data analysis such as multi-variate analysis. Unlike Excel 2010 where a diagram can be created with a few clicks from a mouse, back in 1988 I had to write a FORTRAN programme to read the data file. I then had to send the result for batch processing overnight, and pick up a printout of the diagram the next day. Practically stone age stuff!

No comments:

Post a comment