# Statistics question re: percentages!

#### thorpyuk

##### Well-known Member
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

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

#### pompey007

##### New Member
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!

#### thorpyuk

##### Well-known Member
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 :<

#### scottylad2

##### Well-known Member
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

#### pompey007

##### New Member
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

Replies
3
Views
1K
Replies
5
Views
607
Replies
19
Views
2K

Threads
1,195,683
Messages
6,011,138
Members
441,587
Latest member
kbsgiri09

### 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

### 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