Might be quite easy for some but I'm scratching my head a bit.
Basicaly I have 3 collumns of data.Collumn A just gives a name to what is in collumn B. Collumn B contains an average based on weekly data from the last year, their just values. Now what I want to do is have collumn C show a deviation of +5%. So if I have next weeks set of data I want to be able to say against the average in collumn B, show me how many results have increased by more than 5% and if so what their value is for the week. If this works out then I also want additional collumns showing +10%, -5% and -10%.
I've found stuff about standard deviation but it doesn't seem to quite apply to what I'm doing. Either that or I'm just being thick.
Any help is appreciated.
Basicaly I have 3 collumns of data.Collumn A just gives a name to what is in collumn B. Collumn B contains an average based on weekly data from the last year, their just values. Now what I want to do is have collumn C show a deviation of +5%. So if I have next weeks set of data I want to be able to say against the average in collumn B, show me how many results have increased by more than 5% and if so what their value is for the week. If this works out then I also want additional collumns showing +10%, -5% and -10%.
I've found stuff about standard deviation but it doesn't seem to quite apply to what I'm doing. Either that or I'm just being thick.
Any help is appreciated.