View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default Percentage Increase Between 2 Percentages

It's both. Which one you want depends on what you're trying to examine.

The absolute increase in rate is 1%

=2%-1%

The relative increase in rate is 100%

=2%/1%-1

In article .com,
wrote:

Here's a scenario:

Week 1
Visits to store = 100
Purchases = 1
Purchase rate = 1%

Week 2
Visits to store = 200
Purchases = 4
Purchase rate = 2%

Here's the question:
What is the increase in my purchase rate?

Is it 1%? Is it 100%?

Thanks for your help!