Hi,

You could consider using the RAND() function which generates random numbers
between 0 and 1. If these are too large you can multiply them by a number
less than one such as 0.5: =0.5*RAND() which would generate random numbers
between 0 and .5. Create a range identical in size and shape to your data
range with these formulas. Select all the formulas and choose Copy. Select
the data range and choose Edit, Paste Special, and turn on both Values and
Add. Then click OK.

You can also generate random number by using the =RANDBETWEEN function or
the Analysis ToolPak's Data Analysis, Random Number Generation tool, or by
using VBA.

There are a number of books on handling noise with Excel. Check out books
like Excel For Scientists and Engineers - there are a number of these at
Amazon.

Cheers,
Shane Devenshire


"Augabog" wrote:

I am doing a scatterplot where a bunch of data points fall into the
exact same values. I would like to spread them out a little bit w/o
falling into the next bin, just to show that they are all there. Is
there any way in Excel to add some random noise to my data so that I
can stochastically automate this process?

Thanks,

Hosley