Vol. 10, No. 1

January 2008

PQ Systems

When Excel isn't enough

Quality Quiz: With a video!

Data in everyday life

Six Sigma

Bytes and pieces

FYI: Current releases


Send Quality eLine
to a friend!

Just type in your friend's email below:


Sign up
If you received this newsletter from a friend and want your own subscription to Quality eLine, click below.

Subscribe to Quality eLine




Quality Quiz:

Ms. Collette D. Bills, patient accounting, has gathered data related to accounts receivable, entering it to an Excel spreadsheet. In fact, she has several years’ worth of data in her Excel files, but has not been able to understand what it means, except to see that accounts receivable sometimes go up and sometimes go down. At the end of the year, she usually files the spreadsheets along with earlier records and gives them no further thought.

Her new assistant, Anne A. Lytical, is appalled at this waste. “Why, if you had charted this data, you’d be able to see trends,” she exclaimed. Collette points out that she has seen trends. “Sometimes receivables are up, sometimes they’re down.” That was enough of a trend to suit her.

Anne, however, uses CHARTrunner to chart the Excel data, and within minutes, she brings Collette the following chart:

At Anne’s urging, Collette enrolls in a professional training session with Dr. Noah Tahl, who explains the meaning of “in-control” and “out of control,” and picks up Collette’s chart to examine it. “Your accounts receivable process is definitely out of control, he says, as his finger follows the downward trend of the data. “You’ve got to get this process back under control!”

“But,” says Colette, “we’ve made so much improvement; how can it be a bad thing that the data is out of control?” she sends follow-up letters to all customers three weeks after they have been billed; if there is no response, Colette then makes an additional phone call. But true to his name, Dr. Noah Tahl insists that his job is to bring processes into control, and since hers is definitely not, it must be changed.

Who is right? Click on your choice below, and see the correct response. If you select the right answer, you will be eligible to win a free copy of Quality Gamebox, our lighthearted collection of quality-related experiments and simulations.

a) Dr. Noah Tahl

b) Ms. Collette D. Bills


Click here for a more complete video explanation

Copyright 2008 PQ Systems.
Please direct questions or problems regarding this web site to the Webmaster.