Numbers & stats
Moderator: Board Moderators
- MetBlue
- Senior Poster
- Posts: 1421
- Joined: Sat Mar 24, 2018 21:00
- Model: Elite 74 & Excel 92 (SEish))
- Colour: Metalic Blue
- Year: 1974
- Location: Northampton
Numbers & stats
With lots of carp on television the last couple of days (touch of lysdexia there), I thought I'd do something more interesting and take a look around the "how Many Left" data on line for our cars, particular any trends since SORN records started being available around 2007.
No idea how to post anything other than Jpeg files, so ended up photographing my monitor to get the pictures below, but they seem readable.
The obvious and not surprising first observation is that number recorded generally increases year on year. Explained I guess by anyone buying a barn find having to put it on SORN as part of transferring the ownership in todays "we're watching you " world. At least Elites and Eclats do - Excels are pretty steady. Could that be that Excels are just too new still ???
It surprised me just how many Eclats are still known to the DVLA. In percentage terms, twice as many as either Elites or Excels.!
It also surprised me that Excels are least represented of the 3 models, both by known numbers and % on the road. !! Look at that trend!
And that only the Elite has an upwards trend regarding number on the road.
Tony
Disclaimer : Like all good statistics, I'll accept now that the data is not 100% factual, but it's supposed to be based on Gov data, and it's the same basic source for all three models, so they should all be wrong in the same way.
No idea how to post anything other than Jpeg files, so ended up photographing my monitor to get the pictures below, but they seem readable.
The obvious and not surprising first observation is that number recorded generally increases year on year. Explained I guess by anyone buying a barn find having to put it on SORN as part of transferring the ownership in todays "we're watching you " world. At least Elites and Eclats do - Excels are pretty steady. Could that be that Excels are just too new still ???
It surprised me just how many Eclats are still known to the DVLA. In percentage terms, twice as many as either Elites or Excels.!
It also surprised me that Excels are least represented of the 3 models, both by known numbers and % on the road. !! Look at that trend!
And that only the Elite has an upwards trend regarding number on the road.
Tony
Disclaimer : Like all good statistics, I'll accept now that the data is not 100% factual, but it's supposed to be based on Gov data, and it's the same basic source for all three models, so they should all be wrong in the same way.
What goes together.... Must come apart.
- Mr Locust
- Senior Poster
- Posts: 264
- Joined: Sun Aug 15, 2010 20:54
- Model: Excel EFI
- Colour: White
- Year: 1986
- Location: Stafford
Re: Numbers & stats
It could be explained by how many Excel are registered as Eclat with DVLA.It surprised me just how many Eclats are still known to the DVLA. In percentage terms, twice as many as either Elites or Excels.!
It also surprised me that Excels are least represented of the 3 models, both by known numbers and % on the road. !! Look at that trend!
- Lotus-e-Clan
- Senior Poster
- Posts: 4457
- Joined: Thu Nov 30, 2006 13:25
- Model: Excel SE - EWP/Waterless!
- Colour: Not Blue or Green
- Year: 1989
- Location: Swaledale
Re: Numbers & stats
On of the issues I have with Excel (spreadsheets!) charts and graphs is that the axis data range is set to 'dynamically auto-scale axis' by default. Which is OK-ish for a single standalone graph but not ideal when you want to compare rates of change in data between multiple charts/graphs.
If you manually set the y axis (car numbers) to the same data range (eg 0 to 700) for every graph then the rate of change ( line gradient) for car numbers 'sorned' or 'taxed' is easier to compare between car models. My kids would tell you I'm either a PITA or I'm clearly on the autistic spectrum for pointing that out...
If you manually set the y axis (car numbers) to the same data range (eg 0 to 700) for every graph then the rate of change ( line gradient) for car numbers 'sorned' or 'taxed' is easier to compare between car models. My kids would tell you I'm either a PITA or I'm clearly on the autistic spectrum for pointing that out...
Peter K
- hodders
- Senior Poster
- Posts: 452
- Joined: Mon Aug 28, 2006 22:13
- Model: Excel Celebration
- Colour: Calypso Red
- Year: 1992
- Location: Lambourn, West Berkshire
- Contact:
Re: Numbers & stats
Absolutely with you on that. My geography & maths teachers drummed that into me.Lotus-e-Clan wrote: ↑Sun Dec 27, 2020 20:58On of the issues I have with Excel (spreadsheets!) charts and graphs is that the axis data range is set to 'dynamically auto-scale axis' by default. Which is OK-ish for a single standalone graph but not ideal when you want to compare rates of change in data between multiple charts/graphs.
If you manually set the y axis (car numbers) to the same data range (eg 0 to 700) for every graph then the rate of change ( line gradient) for car numbers 'sorned' or 'taxed' is easier to compare between car models. My kids would tell you I'm either a PITA or I'm clearly on the autistic spectrum for pointing that out...
-- hodders
1992 Lotus Excel Celebration, Calypso Red
2021 BMW i3s, Blue Ridge Mountain
2020 Jaguar I-Pace, Eiger Grey
1992 Lotus Excel Celebration, Calypso Red
2021 BMW i3s, Blue Ridge Mountain
2020 Jaguar I-Pace, Eiger Grey
-
- Moderator
- Posts: 2226
- Joined: Wed Feb 06, 2013 15:06
- Model: Elite S2.2 Automatic
- Colour: Essex Blue
- Year: 1981
- Location: Worcestershire
Re: Numbers & stats
Yes, I’m often horrified at the abuse of statistics we see from government and media these days involving exactly this kind of misrepresentation. Even some academics are just as guilty!hodders wrote: ↑Mon Dec 28, 2020 13:01Absolutely with you on that. My geography & maths teachers drummed that into me.Lotus-e-Clan wrote: ↑Sun Dec 27, 2020 20:58On of the issues I have with Excel (spreadsheets!) charts and graphs is that the axis data range is set to 'dynamically auto-scale axis' by default. Which is OK-ish for a single standalone graph but not ideal when you want to compare rates of change in data between multiple charts/graphs.
If you manually set the y axis (car numbers) to the same data range (eg 0 to 700) for every graph then the rate of change ( line gradient) for car numbers 'sorned' or 'taxed' is easier to compare between car models. My kids would tell you I'm either a PITA or I'm clearly on the autistic spectrum for pointing that out...
Richard
- Lotus-e-Clan
- Senior Poster
- Posts: 4457
- Joined: Thu Nov 30, 2006 13:25
- Model: Excel SE - EWP/Waterless!
- Colour: Not Blue or Green
- Year: 1989
- Location: Swaledale
Re: Numbers & stats
You're spot-on.richardw wrote: ↑Mon Dec 28, 2020 18:50Yes, I’m often horrified at the abuse of statistics we see from government and media these days involving exactly this kind of misrepresentation. Even some academics are just as guilty!hodders wrote: ↑Mon Dec 28, 2020 13:01Absolutely with you on that. My geography & maths teachers drummed that into me.Lotus-e-Clan wrote: ↑Sun Dec 27, 2020 20:58On of the issues I have with Excel (spreadsheets!) charts and graphs is that the axis data range is set to 'dynamically auto-scale axis' by default. Which is OK-ish for a single standalone graph but not ideal when you want to compare rates of change in data between multiple charts/graphs.
If you manually set the y axis (car numbers) to the same data range (eg 0 to 700) for every graph then the rate of change ( line gradient) for car numbers 'sorned' or 'taxed' is easier to compare between car models. My kids would tell you I'm either a PITA or I'm clearly on the autistic spectrum for pointing that out...
Richard
I spent the last twenty years teaching biomed @ Durham University. Academics deliberately exaggerate scales to show small changes within data for impact. Sometimes this is appropriate if the experimental model is robustly designed. Climate scientists wanting to demonstrate significant trends within 1 deg C data ranges are a good example. But they sometimes mislead. Almost all undergrad dissertations contain this error. Post grads weren't much better either.
And then there's Chris Witty et.al.....
Peter K
- MetBlue
- Senior Poster
- Posts: 1421
- Joined: Sat Mar 24, 2018 21:00
- Model: Elite 74 & Excel 92 (SEish))
- Colour: Metalic Blue
- Year: 1974
- Location: Northampton
Re: Numbers & stats
I've set off a right discussion here about graphical representations. Must say I likewise get very annoyed when trends get exaggerated by changing the scale to try and prove a point ( Climate scientists and 1 degree example above the best example). I've even seen examples where even the numbers get left off the vertical scale !!
Anyway, back to Excel numbers....
Good Point Ian. I looked again and there are 283 "eclats" registered after 1983 !!!- So I've redone the graphs with those moved to Excels.
Also looked at the Elite data in a bit more detail and there are 101 models included manufactured in early 1960's. - The original Elites have crept in !!, so again, redone the graphs without those in.
- And for the record, I set all the scales to the same range
It would seem Elites are gradually returning to the road, but off set by fewer Eclats and Excels on the road each summer.
Time to get those restoration projects re-invigorated. - It'll soon be the 50 year anniversary. - What a taget.
Anyway, back to Excel numbers....
.It could be explained by how many Excel are registered as Eclat with DVLA.
Good Point Ian. I looked again and there are 283 "eclats" registered after 1983 !!!- So I've redone the graphs with those moved to Excels.
Also looked at the Elite data in a bit more detail and there are 101 models included manufactured in early 1960's. - The original Elites have crept in !!, so again, redone the graphs without those in.
- And for the record, I set all the scales to the same range
It would seem Elites are gradually returning to the road, but off set by fewer Eclats and Excels on the road each summer.
Time to get those restoration projects re-invigorated. - It'll soon be the 50 year anniversary. - What a taget.
What goes together.... Must come apart.
-
- Senior Poster
- Posts: 3720
- Joined: Tue Apr 04, 2006 21:28
- Model: Elite
- Colour: Monaco White
- Year: 1974
- Location: Nottingham
Re: Numbers & stats
Lies, damned lies, and statistics! That what they say! Interesting data though Tony.
Pete
Pete
- bash
- Senior Poster
- Posts: 2222
- Joined: Thu Nov 03, 2005 15:34
- Model: Se, V8
- Colour: white
- Year: 1986
- Location: Doncaster
- Contact:
Re: Numbers & stats
If the DvLA are so bad at adding up its a good job they dont do 'times bys' and 'guzinters'.
Bash
(BA hons. (Failed) university of life).
Ps, Im surprised that there are so many excels taxed seeing as there seem to be so few of us on here or on the facebook judean front page.
Bash
(BA hons. (Failed) university of life).
Ps, Im surprised that there are so many excels taxed seeing as there seem to be so few of us on here or on the facebook judean front page.
Two things are infinite: the universe and human stupidity; and I'm not sure about the universe.
-
- Moderator
- Posts: 2226
- Joined: Wed Feb 06, 2013 15:06
- Model: Elite S2.2 Automatic
- Colour: Essex Blue
- Year: 1981
- Location: Worcestershire
Re: Numbers & stats
Excel is 40 in 2022!
I have to say that your numbers reflect my impression that Eclats are the rarest of the breed. Excels are used more regularly than the earlier cars, and are seen more regularly, and Elites are hidden away somewhere. At Oliver’s funeral, all but one of the wedges were Excels.
Cheers Richard
-
- Regular Poster
- Posts: 100
- Joined: Mon Aug 28, 2017 04:35
- Model: Excel SE
- Colour: Ice Blue
- Year: 1986
- Location: East Yorkshire
Re: Numbers & stats
You should really also adjust the number produced to include the transferred eclats to excels assuming they have always been registered "incorrectly".
This comes from someone who may have previously used a log scale on a graph to hide an upwards trend!
This comes from someone who may have previously used a log scale on a graph to hide an upwards trend!
- Atking53
- Junior Poster
- Posts: 32
- Joined: Sat May 05, 2018 08:05
- Model: Excel LC
- Colour: White
- Year: 1985
- Location: Wilton NSW
Re: Numbers & stats
Thanks for the interesting data. Cant beat a good XL graph. Some of the cars may have drifted overseas in that time. I know mine did in 2012. As export regulations get tighter though due to asbestos etc this might slow.
Glenn
Lotus Excel
Mercedes SL350
Hyundai i30 SR
Lotus Excel
Mercedes SL350
Hyundai i30 SR
- Phantasm
- Senior Poster
- Posts: 647
- Joined: Tue Dec 08, 2015 21:16
- Model: Excel SE
- Colour: Silk Red
- Year: 1992
- Location: Jacksonville, FL, USA
- Contact:
Re: Numbers & stats
Yup, I know of 8 excels that have now skipped town to the u.s. that were mostly if not all u.k. cars.
-Bill
1991-92ish Lotus Excel SE Silk Red
2009 Jeep Wrangler X Unlimited 4X4
2015.5 Volvo V60 T5
Previous: 2005 Toyota Prius, 2002 Nissan Maxima SE 6 speed, 1988 Toyota 4Runner, 1989 Toyota 4Runner, 1995 Dodge Neon, 1986 Ford Mustang
1991-92ish Lotus Excel SE Silk Red
2009 Jeep Wrangler X Unlimited 4X4
2015.5 Volvo V60 T5
Previous: 2005 Toyota Prius, 2002 Nissan Maxima SE 6 speed, 1988 Toyota 4Runner, 1989 Toyota 4Runner, 1995 Dodge Neon, 1986 Ford Mustang