SciRep: Graphing Test2

Software Trial

[ SciRep | Test 2 | Test 3 | Software | Glossary ]

Test 1: Simple pre-GCSE data

Let us look at a simple selection of data that everything should be able to handle! I require to plot the data Current against Voltage (we control the voltage... and the control variable is always on the x-axis), with a bestfit line through the data (rather than joined points). I also want to view the origin.

Voltage (V)Current (A)
Table 1: Simple Electrical Data

This is how GraphDraw coped with it:

GraphDraw’s graph of current against voltage

This is how Colton Software's (November 1993!) !Resultz spreadsheet copes with it, after countless menus...

Resultz’s graph of current against voltage

This is Insight2's effort (PC version), although data entry was manually as it doesn't read CSV files!

Insight’s attempt at a graph

This is Excel’s effort at a simple scatter graph, with bestfit:

Excel’s graph of current against voltage

Lastly, this is how Lotus 123 coped with is - note no bestfit option was available!

Lotus 123's graph of current against voltage

Conclusion: Test 1

All the software used coped adequately with the task of plotting the graph, even the bestfit line. However, doing so often takes much longer, via many non-intuitive menus. Automatic titling of graphs is easiest in !GraphDraw. In !Resultz, titles of axes and graph are only possible by writing into cells behind (bad idea), or by annotating the exported DRAWfile in !Draw (easy task).

Insight2 coped very well with the simple data, although I plotted the axes the wrong way around! Its bitmap output leaves a great deal to be desired, but it serves its purpose - but at a price!

Excel's attempt is adequate, but it does require its axes resizing: the default scale has chosen a negative value of I to start with! Also by default, it gives a horrible grid, and the legend is pointless. Nevertheless, a useful graph. It compares badly in its abruptness to the 123 version, however the latter had no bestfit capability. Notice how badly Windows™ fonts are displayed compared to RISC OS. This is due to Microsoft's apparent inability to produce anti-aliased text.

Overall GraphDraw would appear to offer the simplest approach to handling basic data of this sort, yet providing the highest-quality output in a format that is easily embedded into any reports. Excellent!

Page design by Andrew P. Harmsworth
Last updated Sunday 25th February 2001