How do i compare the overage/slippage of one percent vs another?

You're probably going to need to define what you mean by "overage" and
"slippage".
--
David Biddulph

"vbrush" wrote in message
...
How do i compare the overage/slippage of one percent vs another?

Thank you-
Sales person closing at 60% for November and 42% for December... What is the
% change(slippage, in this case)...not the % change of basis points...in this
case 18% points.

"David Biddulph" wrote:

You're probably going to need to define what you mean by "overage" and
"slippage".
--
David Biddulph

"vbrush" wrote in message
...
How do i compare the overage/slippage of one percent vs another?

On Jan 13, 10:04*am, vbrush wrote:
Sales person closing at 60% for November and 42%
for December... What is the % change(slippage, in
this case)...not the % change of basis points...in
this case 18% points.

"What is the % change" of what? Customers? Closed sales?

In either case, you cannot determine it from the sales closing ratio
alone. Consider these examples:

Customers: 100 Closed Sales: 42 Ratio: 42%
Customers: 200 Closed Sales: 120 Ratio: 60%
Customers: 400 Closed Sales: 168 Ratio: 42%

Note that the lower sales ratio could arise from either an increase or
a decrease in customers and/or closed sales.

Suppose you want to compute the percentage change in closed sales. If
the Dec number of closed sales is in B2 and the Nov number is in B1,
the percentage change is B2/B1 - 1, formatted as Percentage.

If you are trying to ask how to get 18% as the difference between 60% and
42%, the answer is =A3-A2, if those are the cells with the data. Format the
result as a percentage.
--
David Biddulph

vbrush wrote:
Thank you-
Sales person closing at 60% for November and 42% for December... What
is the % change(slippage, in this case)...not the % change of basis
points...in this case 18% points.

"David Biddulph" wrote:

You're probably going to need to define what you mean by "overage"
and "slippage".
--
David Biddulph

"vbrush" wrote in message
...
How do i compare the overage/slippage of one percent vs another?