An average problem. Well not average, it's a tricky one. About average!

[darro]

Hello

I an trying to figure out a formula to tell me how much above or below an average a set of scores are.

I have a column containing a list of numbers. Below I have averaged these. What I would like is to be able to show by each number how much above or below the average they are.

So if average is 1. Then a score of 2 is I above. Etc.

Obviously the average may not be a whole number.

Any help very welcome.

Thanks

 

[VoG]

Maybe like this

Excel Workbook
	A	B
1	10	3.2
2	4	-2.8
3	6	-0.8
4	10	3.2
5	10	3.2
6	3	-3.8
7	6	-0.8
8	6	-0.8
9	5	-1.8
10	8	1.2
11	6.8
Sheet1

 

[darro]

Thanks for answering. I did do this. Any idea how to express the difference As a percentage?

 

[VoG]

Try in B1 copied down

=(A1-A$11)/A$11

and format as %