How to Find Overall +/- Percentage Performance Over Several Quarters

[Jeff Earle]

I'm at a loss on this. I need to find the Overall +/- performance % of errors made over the 4 quarters of the year. I can get the performance +/- from the previous quarter but the overall is a mystery.

My data is:
1st 2nd 3rd 4th
50% 67% -55% -78%

Keep in mind that positive % = increase in errors & negative % = decrease in errors.

Also as time moves on I will be adding additional quarter % and want to show the entire history from the original 1st quarter.

Any help would be appreciated.

 

[BlueHornet]

You will have to revert your calculations back to the original data. You simply cannot "average" percentages in any meaningful way. If you do the same thing that you're doing quarterly (assuming that those results are valid!) but use the full year's data as the base set, then you can get to your answer, but counting or averaging percentages - though it can give "a number" - will not be a valid process.

 

[Jeff Earle]

You will have to revert your calculations back to the original data. You simply cannot "average" percentages in any meaningful way. If you do the same thing that you're doing quarterly (assuming that those results are valid!) but use the full year's data as the base set, then you can get to your answer, but counting or averaging percentages - though it can give "a number" - will not be a valid process.

I think I understand what your saying as I get erroneous % than does not look right. I have added the original data that might help:


[TABLE="width: 366"]
<tbody>[TR]
[TD]Starting Errors[/TD]
[TD]1st Qtr[/TD]
[TD]2nd Qtr[/TD]
[TD]3rd Qtr[/TD]
[TD]4th Qtr[/TD]
[/TR]
[TR]
[TD="align: right"]8[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]50%[/TD]
[TD="align: right"]67%[/TD]
[TD="align: right"]-55%[/TD]
[TD="align: right"]-78%[/TD]
[/TR]
</tbody>[/TABLE]

How do I show the overall +/- %?