Statistics question re: percentages!

thorpyuk

Well-known Member
Joined
Mar 14, 2006
Messages
1,453
Hi all,

I was wondering if anyone could clarify something for me?!!

Having recently run a campaign, we had sales figures last year of 3,125,000

This year we forecasted 4,304,475 (a 37.7% increase)

We actually ended up with 3,682,408 (a 17.84% increase)

This means we are 19.9% down on forecast....

However, a differing way of looking at things could be saying if you uplift last year by 37.7%, you end up with 4,303,125. Compare this to my actual this year (3,682,408), means down 14.42%!

So which is the correct figure? -19.9% or -14.42% ?!

Thanks!
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.
Hi all,

I was wondering if anyone could clarify something for me?!!

Having recently run a campaign, we had sales figures last year of 3,125,000

This year we forecasted 4,304,475 (a 37.7% increase)

We actually ended up with 3,682,408 (a 17.84% increase)

This means we are 19.9% down on forecast....

However, a differing way of looking at things could be saying if you uplift last year by 37.7%, you end up with 4,303,125. Compare this to my actual this year (3,682,408), means down 14.42%!

So which is the correct figure? -19.9% or -14.42% ?!

Thanks!

It is confusing, but your sales are 622,067 down on forecast; which expressed as a % is -14.4%.

The 19.9 is not a percentage movement it is just 37.7 - 17.8!
 
Upvote 0
Correct, but are they both right?


For eg, say last year = £100, this year forecast = £150 (+50%)

If this years actual sales is £125, does that mean I am -25% from forecast, or -16.6%?

I'm confused :<
 
Upvote 0
As a a forecaster, you'd forget the assumption you made in the first instance and qualify the actual increase you did make by pointing out the current Credit Crunch.....then lower your sights a little for next year....Both are right, just depends on what one you want to concentrate on :)
 
Upvote 0
In your example you want to express how much you are down from forecast. So you need to show as a denomination of £150. Therefore (150-125)= 25/150 = 16.67%.

The other result is using different denominators, you are not comparing apples with apples! You ask if you are 25% down on forecast, but that would be £150 - 25% = £112.50



This may help...or not!!

http://en.wikipedia.org/wiki/Percentages
 
Upvote 0

Forum statistics

Threads
1,213,494
Messages
6,113,986
Members
448,538
Latest member
alex78

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top