PraxIS January 2004                    ISSN 1649-2374

04-01 Contents: Benford's law, phone scams, OpenUp to e-business, downloadable presentations on testing, Excel bug, PowerPointlessness, European affairs

This issue online at http://www.sysmod.com/praxis/prax0401.htm    [Previous] [Index] [Next]

Systems Modelling Ltd.: Managing reality in Information Systems - strategies for success

IN THIS ISSUE

1) Risk management
   Benford's Law - detecting fraud in invented numeric amounts
   Phone Fraudsters exploit a developing country's dialing code 
 
2) Internet and e-business
    Enterprise Ireland OpenUp campaign to promote e-business
3) Software Quality
   Lee Copeland & David Parnas presentations now online
   Excel 2003 RAND() bug
   Powerpoint considered harmful to communication?
4) European affairs
   Ireland's presidency
   News sources on the Euro
5) On the lighter side
   A model view of life      
   Pictures from Mars Rover
25 Web links in this newsletter
About this newsletter and Archives
Disclaimer
Subscribe and Unsubscribe information

_______________________________________________________

WELCOME TO 2004!

What do you find interesting in these newsletters? What would you like me to talk more about? I'm always ready to hear from you!

Patrick O'Beirne

_______________________________________________________

If you like this newsletter, a great way to show your support is to make your next book or CD purchase from our Amazon shop page!

_______________________________________________________

1) Risk management

Benford's Law - detecting fraud in invented numeric amounts

http://mathworld.wolfram.com/BenfordsLaw.html
A phenomenological law also called the first digit law, first digit phenomenon, or leading digit phenomenon. Benford's law states that in listings, tables of statistics, etc., the digit 1 tends to occur with probability 30%, much greater than the expected 11.1% (i.e., one digit out of 9).

No. Probability
1   0.30103 
2   0.176091 
3   0.124939 
4   0.09691 
5   0.0791812     
6   0.0669468 
7   0.0579919 
8   0.0511525 
9   0.0457575 

So why is this important?

Here is an article that shows how auditors can make use of this property. Nigrini, M. "I've Got Your Number." J. Accountancy 187, pp. 79-83, May 1999. www.aicpa.org/pubs/jofa/may1999/nigrini.htm
"Benford's law provides a data analysis method that can help alert CPAs to possible errors, potential fraud, manipulative biases, costly processing inefficiencies or other irregularities."

_______________________________________________________

Phone Fraudsters exploit a developing country's dialing code

I came across an intriguing piece of research by Brian King in Balancing Act's News Update 188 (21 Dec 2003) www.balancingact-africa.com 

"In 1989 the Government of Guinea-Bissau cemented a strategic partnership with Marconi (now part of the Portugal Telecom group) All international traffic to and from Guinea-Bissau would run through Marconi in Portugal. Marconi was also given the right to open and maintain bank accounts abroad in the name of Guine Telecom.

Critics of the company say that management of the company became increasingly chaotic and untransparent. Around 1996 Portugal Telecom managers set up a bank of computers at the earth station to receive pornographic calls from abroad. The calls were received at Guine Telecom and were immediately transmitted back without entering the national network. The practice reportedly generated significant new traffic to Guinea-Bissau, and the added revenue funded new investments in infrastructure.

On June 7, 1998 a failed coup d¹etat tipped the country into civil war; key infrastructure (such as the earth station) was destroyed and in the midst of it the bank of audiotext (read 'phone sex') computers. After their departure in 1998 Portugal Telecom began withholding settlement payments for international calls terminating in Guinea-Bissau, and has continued to do so.

A journalist from the major Spanish newspaper El País confirmed a so-called 'epidemic' of calls to Guinea-Bissau from Spain, appearing on the bills of people who had no relationship with the country. In all these instances the Spanish operator Telefonica responded that the calls were genuine.  "

For the rest of this story, go to: www.balancingact-africa.com

____________________________________________________________
____________________________________________________________

2) Internet

Enterprise Ireland OpenUp campaign to promote e-business

Tanaiste Mary Harney has launched a campaign to encourage Internet usage and e-business initiatives among Irish SMEs. The Enterprise Ireland-backed campaign, called OpenUp, will offer information and guidance to companies which want to take advantage of the benefits of e-business and IT, with a wide range of resources available on its website, www.openup.ie.  The take-up of e-business in this country is generally considered to be lagging behind our European neighbours.

It is somewhat ironic, then, that an Information Society initiative in the South-East of Ireland www.seiss.ie came to an end on the same date, December 2003. On the other hand, at least the South-East Regional Authority www.sera.ie and the South East Business & Innovation Centre (SEBIC) are still going: www.sebic.ie

Further comment on the technical market scene in Ireland can be found on www.siliconrepublic.com :

A national imperative "One of the reasons e-business has been slow to take off, it could be argued, is that it is a concept we find it difficult to grasp and put a tangible value on. The same woolliness could be said to apply to another well-worn term, broadband, which has long been portrayed as essential to Ireland's future economic prosperity. Part of the reason for our apparent ambivalence towards broadband is the failure so far to put a value on it. Until now. A report entitled Ireland's Broadband Future, published last month by the Information Society Commission (ISC), goes some way towards remedying this situation."
http://newsweaver.ie/eletra/go.cfm?z=ezineitnm%2C44675%2Ca1bTsK8m%2C119361%2Ca2t05TH

____________________________________________________________
____________________________________________________________

3) Software quality

Lee Copeland & David Parnas presentation notes

Now available at www.SoftTest.ie :
The Banana Principle For Testers: Knowing When To Stop Testing by Lee Copeland SQE
Documentation Based Software Testing by David Lorge Parnas SQRL. ____________________________________________________________

 

Excel 2003 RAND() bug

I reported this in my blog on 9 December.

More than two months ago, Don Peters posted a message on a Microsoft public newsgroup describing the problem. Microsoft didn’t do anything about it.
http://groups.google.ie/groups?threadm=%23QzBp%23ZvDHA.1996%40TK2MSFTNGP12.phx.gbl
The random number function in Excel is relied upon by Monte Carlo simulation modellers (huge financial risk models) and office syndicate lottery number pickers. It is specified to create only positive numbers 0-1; now it occasionally produces negative numbers.
Woody Leonhard commented: "I can’t even begin to imagine the financial impact of this bug. " www.woodyswatch.com/office2003/archtemplate.asp?1-n11
"Microsoft replaced the RAND() function in Excel 2003. The company says that 'the new generator passes all standard tests of randomness...'"
It's not even random, as Don Peters shows in a nice scatter diagram. But to return negatives is going to break a lot of models!
The lesson for us is that regression testing applies to spreadsheet users too - you have to validate that your models still work correctly when you change versions of Excel.

____________________________________________________________

Powerpoint considered harmful to communication?

Bernie Goldbach's blog http://irish.typepad.com/irisheyes/best_practise/index.html  links a few articles on sloppy writing which casts doubts on the quality of the thinking :

Jeffrey McManus's article "Use of Powerpoint considered harmful" picks up on the style theme:  http://mcmanus.typepad.com/grind/2003/09/use_of_powerpoi.html
It has provoked satire sites like Peter Norvig's "PowerPoint Rendition of the Gettysburg Address" at  www.norvig.com/Gettysburg
Tim Ward coined the term "PowerPointlessness" in the Guardian (UK) Education supplement:  http://education.guardian.co.uk/higher/comment/story/0,9828,959242,00.html
John Naughton of the Observer Business section considers that  "PowerPoint panders to our weaker points" http://observer.guardian.co.uk/business/story/0,6903,872912,00.html
Clive Thompson in the New York Times concluded that "PowerPoint Makes You Dumb' from the report of the Columbia Accident Investigation Board at NASA that criticised a confusing PowerPoint slide. http://partners.nytimes.com/2003/12/14/magazine/14POWER.html (free registration required)

_______________________________________________________ _______________________________________________________

4) European affairs

Quoted from the EUBusiness.com newsletter:

www.eubusiness.com/afp/040101000331.6yg4m9o9 

'Europeans - Working Together' is the theme of Ireland's six-month presidency of the EU, which began on 1 January. Ireland's main task will be to preside over the expansion of the EU in May, when ten new members will boost the bloc's population to about 450 million.

"Irish Prime Minister Bertie Ahern has vowed that Ireland will push ahead with work on the Union's first constitution, despite the failure of EU leaders to agree at last month's summit. Ireland is also committed to pursuing the Lisbon Strategy to make Europe the most competitive economy in the world, improving strained relations between the EU and the United States and moving African issues higher up the EU's agenda. "

The impact of the Parmalat scandal - "Italy's Enron" should also provoke some effort into the same kind of regulation here as Sarbanes-Oxley in the USA.

_______________________________________________________

The Euro

Here are some recent headlines from www.eubusiness.com/topics/Euro

- Hungary's 2008 target for joining the eurozone may have to be delayed
- Belgium to fete Tintin with silver 10-euro coin
- Up to 200 people a day are still turning up at the Central Bank of Ireland headquarters carrying stockpiles of old notes and coins to change into the new currency.
- Prime Minister Silvio Berlusconi said Italy's economy had suffered since the adoption of the euro single currency and indicated his government would have kept the country out of the 12-nation eurozone.
- The euro's record surge against the dollar and feared oil price rises threaten to pour cold water on a long-hoped for recovery in Europe even before it really gets underway.
- Swedish opposition to the European single currency has strengthened since voters in the Scandinavian country rejected the euro in a referendum two months ago.

_______________________________________________________ _______________________________________________________

FEEDBACK

Simply send your comments to FEEDBACK (at) SYSMOD (dot) COM

Thank you! Patrick O'Beirne, Editor

_______________________________________________________ _______________________________________________________

5) On the lighter side

A model view of life

www.lionhrtpub.com/orms/orms-12-00/meyer.html October 2000: Analyze This, by Brad C. Meyer in the Operations Research & Management Science Journal. "What happens when a modeling mindset takes over our everyday activities? Lifestyle management science." It reminds me of the "you might be an engineer if..." stories.

_______________________________________________________

Pictures from Mars Rover

Unfortunately the Japanese Mars probe went off course and the European Space Administration's Beagle 2 did not survive its landing, but pictures are now becoming available from the successful landing of the NASA Mars Rover: marsrover.nasa.gov
Here is a spectacular large (eight megabytes) image you can download if you have a fast connection: http://marsrovers.jpl.nasa.gov/gallery/press/spirit/20040106a/PIA04995.jpg (8 MB)
If the NASA web site gets overloaded, they may remove these images. Let me know if you can't get it and I can put it on my server and give you the link .. until mine gets overloaded!

_______________________________________________________
_______________________________________________________

Copyright 2004 Systems Modelling Limited, http://www.sysmod.com . Reproduction allowed provided the newsletter is copied in its entirety and with this copyright notice.

We appreciate any feedback or suggestions for improvement. If you have received this newsletter from anybody else, we urge you to sign up for your personal copy by sending a blank email to   EuroIS-subscribe (at) yahoogroups (dot) com - it's free!

For those who would like to do more than receive the monthly newsletter, the EuroIS list makes it easy for you to discuss issues raised, to share experiences with the rest of the group, and to contribute files to a common user community pool independent of the sysmod.com web site. I will be moderating posts to the EuroIS list, to screen out inappropriate material.

Patrick O'Beirne, Editor
_______________________________________________________
ABOUT THIS NEWSLETTER
"Praxis" means model or example, from the Greek verb "to do". The name is chosen to reflect our focus on practical solutions to IS problems, avoiding hype. If you like acronyms, think of it as "Patrick's reports and analysis across Information Systems".
Please tell a friend about this newsletter.
We especially appreciate a link to www.sysmod.com from your web site!
______________________________________________________
ARCHIVES
To read previous issues of this newsletter please visit our web site at http://www.sysmod.com/praxis.htm

DISCLAIMER
This newsletter is prepared in good faith and the information has been taken from observation and other sources believed to be reliable. Systems Modelling Ltd. (SML) does not represent expressly or by implication the accuracy, truthfulness or reliability of any information provided. It is a condition of use that users accept that SML has no liability for any errors, inaccuracies or omissions. The information is not intended to constitute legal or professional advice. You should consult a professional at Systems Modelling Ltd. directly for advice that is specifically tailored to your particular circumstances.
_______________________________________________________
PRIVACY POLICY:
We guarantee not to sell, trade or give your e-mail address to anyone.
To subscribe to this Newsletter send an email to
EuroIS-subscribe (at) yahoogroups (dot) com
To unsubscribe from this Newsletter send an email to
EuroIS-unsubscribe (at) yahoogroups (dot) com
EuroIS is the distribution list server of the PraxIS newsletter. It also offers a moderated discussion list for readers and a free shared storage area for user-contributed files. The archives of this group are on YahooGroups website http://groups.yahoo.com/group/EuroIS/ 
_______________________________________________________

   [Previous] [Index] [Next]