Comparing percentages

[vbrush]

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

 

[David Biddulph]

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

 

[vbrush]

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.

 

[joeu2004]

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.