I need to create a "true" scatter graph in excel.
Just like school were you plotted variable x against variable y.
That way, you just get a feel for the trend, if any.
I need to do this in excel as I have 200 variables to plot,
and they come from excel in the first place.
Scatter diagram would be perfect for this, as it will show outliers.
I thought that I would do a test in excel
with car data, as we all live & breathe cars.
Basically 0-100 mph times should *generally* be related (correlated ??) to bhp per tonne.
I would expect a scatter diagram to show this quite well.
In fact my manual plot of 12 cars does this very well - except the CCX.
(the CCX is slow in relation to it's power)
However, on the below data, excel fails to produce what I want.
I want Excel to produce 'the school plot' as mentioned above.
Any ideas ?
Make 0-100 mph bhp / tonne
Ultima 5.5 666
Enzo 6.7 484
CCX 7.7 694
GT3 996 10.3 271
RS 993 11.2 240
M3 E36 12.8 215
330ci 16.6 154
M3 E30 17.8 178
Elise si 18.5 164
x Type 3L 19.8 151
MR2 21.2 141
Puma R 23.2 132
What I dont want, (and what excel produces) is a 'scattergraph' but with both values plotted
- which is meaningless.