Numbers & stats

General Excel discussions. You may also post Eclat and Elite information here. If there is enough call I will set up new categories or even a new BB for them.

Moderator: Board Moderators

Post Reply
User avatar
MetBlue
Senior Poster
Posts: 403
Joined: Sat Mar 24, 2018 21:00
Model: Elite 74 & Excel 92 (SEish))
Colour: Metalic Blue
Year: 1974
Location: Northampton

Numbers & stats

Post by MetBlue »

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.

Image

Image

Image

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 ??? :D :D
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.

User avatar
Mr Locust
Senior Poster
Posts: 256
Joined: Sun Aug 15, 2010 20:54
Model: Excel EFI
Colour: White
Year: 1986
Location: Stafford

Re: Numbers & stats

Post by Mr Locust »

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!
It could be explained by how many Excel are registered as Eclat with DVLA.

User avatar
Lotus-e-Clan
Senior Poster
Posts: 3967
Joined: Thu Nov 30, 2006 13:25
Model: Excel SE - EWP/Waterless!
Colour: Not Blue or Green
Year: 1989
Location: Swaledale

Re: Numbers & stats

Post by Lotus-e-Clan »

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... :roll:
Peter K

User avatar
hodders
Senior Poster
Posts: 427
Joined: Mon Aug 28, 2006 22:13
Model: Excel Celebration
Colour: Calypso Red
Year: 1992
Location: Lambourn, West Berkshire
Contact:

Re: Numbers & stats

Post by hodders »

Lotus-e-Clan wrote:
Sun Dec 27, 2020 20:58
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... :roll:
Absolutely with you on that. My geography & maths teachers drummed that into me.
-- hodders

1992 Lotus Excel Celebration, Calypso Red
2016 BMW i3, Protonic Blue
2017 Audi S4 Avant, Navarra Blue

richardw
Senior Poster
Posts: 1468
Joined: Wed Feb 06, 2013 15:06
Model: Elite S2.2 Automatic
Colour: Essex Blue
Year: 1981

Re: Numbers & stats

Post by richardw »

hodders wrote:
Mon Dec 28, 2020 13:01
Lotus-e-Clan wrote:
Sun Dec 27, 2020 20:58
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... :roll:
Absolutely with you on that. My geography & maths teachers drummed that into me.
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!

Richard
Image

User avatar
Lotus-e-Clan
Senior Poster
Posts: 3967
Joined: Thu Nov 30, 2006 13:25
Model: Excel SE - EWP/Waterless!
Colour: Not Blue or Green
Year: 1989
Location: Swaledale

Re: Numbers & stats

Post by Lotus-e-Clan »

richardw wrote:
Mon Dec 28, 2020 18:50
hodders wrote:
Mon Dec 28, 2020 13:01
Lotus-e-Clan wrote:
Sun Dec 27, 2020 20:58
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... :roll:
Absolutely with you on that. My geography & maths teachers drummed that into me.
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!

Richard
You're spot-on.

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

User avatar
MetBlue
Senior Poster
Posts: 403
Joined: Sat Mar 24, 2018 21:00
Model: Elite 74 & Excel 92 (SEish))
Colour: Metalic Blue
Year: 1974
Location: Northampton

Re: Numbers & stats

Post by MetBlue »

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....
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 :D :D
Image

Image

Image

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. :wink: :wink: - What a taget.
What goes together.... Must come apart.

Pete Boole
Senior Poster
Posts: 2342
Joined: Tue Apr 04, 2006 21:28
Model: Elite
Colour: Monaco White
Year: 1974
Location: Nottingham

Re: Numbers & stats

Post by Pete Boole »

Lies, damned lies, and statistics! That what they say! Interesting data though Tony. :D
Pete

User avatar
bash
Senior Poster
Posts: 1306
Joined: Thu Nov 03, 2005 15:34
Model: Se, V8
Colour: white
Year: 1986
Location: Doncaster
Contact:

Re: Numbers & stats

Post by bash »

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.
You are only young once but you can be juvenile all your life !!

richardw
Senior Poster
Posts: 1468
Joined: Wed Feb 06, 2013 15:06
Model: Elite S2.2 Automatic
Colour: Essex Blue
Year: 1981

Re: Numbers & stats

Post by richardw »

MetBlue wrote:
Mon Dec 28, 2020 20:12

Time to get those restoration projects re-invigorated. - It'll soon be the 50 year anniversary. :wink: :wink: - What a taget.
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
Image

Zag
Junior Poster
Posts: 38
Joined: Mon Aug 28, 2017 04:35
Model: Excel SE
Colour: Ice Blue
Year: 1986
Location: East Yorkshire

Re: Numbers & stats

Post by Zag »

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!

User avatar
Atking53
Verified Poster
Posts: 23
Joined: Sat May 05, 2018 08:05
Model: Excel LC
Colour: White
Year: 1985
Location: Wilton NSW

Re: Numbers & stats

Post by Atking53 »

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 SLK230
Hyundai i30 SR

User avatar
Phantasm
Senior Poster
Posts: 646
Joined: Tue Dec 08, 2015 21:16
Model: Excel SE
Colour: Silk Red
Year: 1992
Location: Jacksonville, FL, USA
Contact:

Re: Numbers & stats

Post by Phantasm »

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

Post Reply