Thread
:
Percentage Increase Between 2 Percentages
View Single Post
#
4
Posted to microsoft.public.excel.misc
JE McGimpsey
external usenet poster
Posts: 4,624
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!
Reply With Quote
JE McGimpsey
View Public Profile
Find all posts by JE McGimpsey