nomalizing numbers charting...

[Brent]

hi- I have a list of numbers starting at 1300 and decrmenting all the way
down 1
ie
1300,540,300,225,..,5,3,1

I want to use these numbers to draw circles, but the variance between them
is very large and the circles would be too big on one end and too small on
the other end.

I was wondering if I could nomralize these numbers so the variance is not so
large... how would you go about doing this? Is there a formula that does
this?

Thanks
brent

 

[Earl Kiosterud]

Brent,

Normalizing them isn't exactly what you want, I don't think. You could use some kind of
logarithmic function (sort of like the Richter Scale, or decibels). It depends on how
you'd like to see them. Try something like one of these:

=A2^0.2
=A2^0.4
=log(A2)
=log(A2*2)

Then chart from this column, and see which suits you the best.

 

[Dana DeLouis]

I was wondering if I could nomralize these numbers

If I am not mistaken...To Normalize a vector, here is one idea.
If your numbers are in A1:A4, then enter this in B1 and copy down.

=A1/SQRT(SUMSQ($A$1:$A$4))

Not sure if that is what you had in mind though.