Bad reporting and distorted numbers for a 4Sight

Page: « 1 2 3 »
Michael Mertens
Mertens IT Consulting
Member Since:
28th Apr 2008
Telephone:
01395 548243
Location:
near Exeter
Posts:
3174

My Links:
Posted: 5th Apr 2012 - 17:51 Quote

Surprisingly many people subtract 20% (say from 100), get their 80 and then can't figure out why they only get 96 once they add what they think are the "same 20%" back onto their result. They just about realise there is something wrong when they see such a trivial example, but won't even notice when the same happens with a base price of say £488.12

"My Excel is not working, has my computer cought a virus?"  Yes, I really had that one once. Shocked

 

Here is another one: British Gas invoices show a bar graph about your previous consumption. The bars only show the top 10% of any monthly consumption figure, slight variations therefore look much bigger than they are. Carl, I think that's a good one to show for a 4Sight.

 

MERTENS CONSULTING - Proper IT CONSULTING and support in the West Country for small businesses on Apple Mac and other fine systems.
eMail  contact on request (too much spam otherwise)

"For the first time ever, I could actually understand what a computer guy was talking about and why it was relevant for my business." That's what I do. I speak your language. I'm not just selling stuff.

View Profile Send Message Leave Testimonial Find Posts TWEET ME @MacManDevon
 
Carl Nixon
Excel Expert Ltd
Member Since:
18th Jan 2010
Telephone:
029 2125 1450
Location:
Tonypandy
Posts:
6455
Posted: 5th Apr 2012 - 18:04 Quote

Chris, this quote always makes me chuckle - "88.2% of Statistics are made up on the spot" - Vic Reeves quote for a Guiness advertising campaign

Peter - I hope to be doing a number of the South Wales 4 sights as a warm up for the tour, so Newport will probably have to suffer it as well

Michael - That is exactly the sort of thing. The other thing the big stores do (as pointed out by Trevor), is push the big family packs which you are supposed to think are cheaper, however if you look at the smaller packs you get more product per £ from the smaller packs.

Michelle - You will have to explain that one in more detail the next time we meet

Chris - You are right of course

View Profile Send Message Leave Testimonial Find Posts TWEET ME @CarlNixon
 
Carl Nixon
Excel Expert Ltd
Member Since:
18th Jan 2010
Telephone:
029 2125 1450
Location:
Tonypandy
Posts:
6455
Posted: 5th Apr 2012 - 18:17 Quote

BTW Thanks everyone for the requests for me to do a 4Sight at their meeting - I had no idea it would be so popular.

I havent worked out a route yet to maximise the number of meetings and meet ups yet (this calls for a spreadsheet). As soon as I have bottomed it all out I will of course put details up here

View Profile Send Message Leave Testimonial Find Posts TWEET ME @CarlNixon
 
Graham Smith
Graham Smith Business Services
Member Since:
30th Jan 2008
Telephone:
01993 771100
Location:
Witney
Posts:
3566

My Links:
Posted: 5th Apr 2012 - 18:29 Quote
Quote:

Chris, this quote always makes me chuckle - "88.2% of Statistics are made up on the spot" - Vic Reeves quote for a Guiness advertising campaign

 

I am afraid that after exhaustive research that stat has been found to be only 68% accurate!

The Fox graph you have shown is awful, I hadn't seen it before, and can see no justification for it. The other thing I always say that you should look at is the flip side of such a statistic - i.e. even at 9.0% unemployment, that is 91% employed - suddenly things look rosier. (especially as 5% unemployment is considered turnover!)

 

 

Graham Smith Business Services

Budgeting     Bookkeeping    Management Accounts

Graham Smith

T: 01993 771100

M: 07771 716588

E: graham.smith@gsbs.co.uk

W: http://www.gsbs.co.uk

Tw: @grahampsmith

 

View Profile Send Message Leave Testimonial Find Posts TWEET ME @grahampsmith
 
David Brin
DRB Secretarial
Member Since:
5th Aug 2011
Telephone:
07825 557 446
Location:
Bradford
Posts:
280

My Links:
Posted: 5th Apr 2012 - 18:31 Quote
Quote:

A lot of the "Bigger pack better value" flashes in supermarkets are outright lies. This article goes back a couple of years but the only change since then is the supermarkets have got better at conning customers (there's no blood left in the farmers or most other suppliers for them to get). Either they have useless programs/programmers or its deliberate.

Cheltenham isn't a million miles from you and has a 4Sight slot available in May or late June onwards at the time of writing Smiley

You just reminded me. I was in Tesco a few weeks ago and I could but 24 Ibuprofen for 52p or 48 for £1.18.

No guessing which I bought!

 

DRB Secretarial
Outputting quality documents whatever the input.

E-mail: secretarial@dfbrin.co.uk
Website: www.dfbrin.co.uk
Mobile: 07825 557 446

View Profile Send Message Leave Testimonial Find Posts TWEET ME @DRBSecretarial
 
Graham Smith
Graham Smith Business Services
Member Since:
30th Jan 2008
Telephone:
01993 771100
Location:
Witney
Posts:
3566

My Links:
Posted: 5th Apr 2012 - 18:32 Quote

My favourite abuse of statistics was in a presentation I went to about 20 years ago to a government funded agency who were running climate change models. Somebody asked how confident they were that there models were correct, and the answer was that they were 100% confident.

The reason being that they were running a scenario analysis, so that the central scenario gave 20% probability (say), but the tail ends of the probability went to infinity, therefore, the model was always going to be correct, just maybe not at the central point.

Graham Smith Business Services

Budgeting     Bookkeeping    Management Accounts

Graham Smith

T: 01993 771100

M: 07771 716588

E: graham.smith@gsbs.co.uk

W: http://www.gsbs.co.uk

Tw: @grahampsmith

 

View Profile Send Message Leave Testimonial Find Posts TWEET ME @grahampsmith
 
Member Since:
29th Oct 2010
Telephone:
07967 478272
Location:
Cheltenham
Posts:
1641

My Links:
Posted: 5th Apr 2012 - 18:45 Quote

For anyone who's short of ideas, How To Lie With Statistics is always there as a reference Geek

View Profile Send Message Leave Testimonial Find Posts TWEET ME @trevord92
 
Mike Edward
Energicert - The Home Energy Advisor
Member Since:
12th Jan 2010
Telephone:
01423 876307
Location:
Harrogate
Posts:
301

My Links:
Posted: 5th Apr 2012 - 19:51 Quote

 

My son who lives with us still keeps getting a reminder that he has not paid his £0.00 phone bill!!

Here’s a good venue for your tour.  I look after Leeds Bradford Airport breakfast and Harrogate evening on the same day, I am sure we would love to welcome you.  I am doing a similar 4Sight with words and how they can be misinterpreted.  You would be able to meet our very own Excel Addict Gail Webster into the bargin!!

Mike Edward

Energicert - The home energy advisors
EnergiCert - The Home Energy Audit Specialists

Mike Edward

01423 876 307

info@energicert.net

www.energicert.net

View Profile Send Message Leave Testimonial Find Posts
 
Julian Wellings
Expertise on Tap
Member Since:
4th Sep 2007
Telephone:
01242 696728
Location:
Cheltenham
Posts:
4508

My Links:
Posted: 5th Apr 2012 - 22:46 Quote
Quote: Carl

[SNIP] I would love to try and do a 4 sight at each of thses on how we shouldnt believe the numbers we read in advertising and more importantly the news.

Carl this is a great topic. Have you ever read Michael Blastland's "Go Figure - Seeing stats in a different way " columns on BBC News?  Here are some examples which may help for your 4SS...
Do we understand 'risk' of mobile phone use?
The youth unemployment mystery
Why nothing is really news at all
Are country roads more dangerous than city roads?

Hope I can catch one of your talks. You're one of those 4N forum regulars I would like to meet, but haven't yet.

Expertise On Tap - Email & Video Marketing

Call: 01242 696728

Visit: Expertiseontap.co.uk

View Profile Send Message Leave Testimonial Find Posts TWEET ME @expertiseontap
 
Graham Smith
Graham Smith Business Services
Member Since:
30th Jan 2008
Telephone:
01993 771100
Location:
Witney
Posts:
3566

My Links:
Posted: 6th Apr 2012 - 11:10 Quote
Quote:

 

My son who lives with us still keeps getting a reminder that he has not paid his £0.00 phone bill!!

Here’s a good venue for your tour.  I look after Leeds Bradford Airport breakfast and Harrogate evening on the same day, I am sure we would love to welcome you.  I am doing a similar 4Sight with words and how they can be misinterpreted.  You would be able to meet our very own Excel Addict Gail Webster into the bargin!!

Mike Edward

I kept on getting a bill for ages as I hadn't paid my £0 bill by direct debit -  I love systems!

 

Graham Smith Business Services

Budgeting     Bookkeeping    Management Accounts

Graham Smith

T: 01993 771100

M: 07771 716588

E: graham.smith@gsbs.co.uk

W: http://www.gsbs.co.uk

Tw: @grahampsmith

 

View Profile Send Message Leave Testimonial Find Posts TWEET ME @grahampsmith
 
Gareth Frensham
Asset Harbour
Member Since:
12th Jan 2012
Telephone:
0800 0935 993
Location:
Colchester
Posts:
405

My Links:
Posted: 6th Apr 2012 - 11:14 Quote
Quote:

Sorry Carl, but you may have a problem with your own numbers although you "can network 5 days a week" (from the script) I am not aware of any plans for Monday breakfasts or Friday Evening! meetings, so you may have to settle for 8 in the week. Sad

 

Could always arrange a one-off Monday or Friday Chris

 

 

 

 

www.ahwills.co.uk

0800 0935 993

View Profile Send Message Leave Testimonial Find Posts TWEET ME @financeGF
 
Steve Laing
Country Computers Ltd
Member Since:
23rd Mar 2010
Telephone:
01555 373018
Location:
Lanark
Posts:
415

My Links:
Posted: 6th Apr 2012 - 15:24 Quote

There's a whole series of podcasts on this sort of thing on  the BBC site : http://www.bbc.co.uk/podcasts/series/moreorless
Debunking headline grabbing stuff like Apple being worth more than Poland, red meat scare stories, etc

Jim Barker also posted this thread a few weeks ago, another '"insult the customer's intelligence" howler from Tesco :
http://www.4networking.biz/Forum/ViewTopic/115565

... and if your grand tour extends this far north, we'd be delighted to see you.

 
View Profile Send Message Leave Testimonial Find Posts
 
Christine Collen
C & C Business Services Ltd
Member Since:
5th Oct 2010
Telephone:
020 8462 0669
Location:
Bromley
Posts:
245

My Links:
Posted: 12th Apr 2012 - 19:25 Quote

Hi Carl, I don't have any examples of mis-represented numbers ...... but if you are doing a 4N-summer-tour .... are you coming dahn sarf?  Or to be precise .... hitting South London? If so, there are lots of groups that would lurve having that sort of 4Sight ... including my own group Beautiful Bromley :o)

Check out our South London portal site which lists all the 4N groups in the vicinity ... this should help you plan your tour in our neck of the 4N woods.

View Profile Send Message Leave Testimonial Find Posts TWEET ME @cjcollen
 
Member Since:
31st Aug 2011
Telephone:
01295 228406
Location:
Banbury
Posts:
488

My Links:
Posted: 13th Apr 2012 - 10:23 Quote

Hey Carl,

Great topic - there'll be no shortage of content! I'm sure Steve would welcome you to Banbury on your tour :)

Nat

View Profile Send Message Leave Testimonial Find Posts TWEET ME @P4D
 
Perry Bebbington
SEP Solutions Ltd
Member Since:
24th Apr 2009
Telephone:
0115 938 9685
Location:
Kimberley
Posts:
643

My Links:
Posted: 13th Apr 2012 - 20:50 Quote

I can't give you the exact words or even the charity but I have recently seen on a charity collection box on the bar of a pub something like: '90% of profits go to the xxx charity'. The issue here is not the percentage, but that no where does it say what percentage of the money collected is the profits.

View Profile Send Message Leave Testimonial Find Posts
Page: « 1 2 3 »

To reply to this topic please sign in or register.

Business Networking