1
$\begingroup$

I have a real-time velocity measurement data set in a excel (.xlsx) file. I want to add the Gaussian noise signal with zero mean in this real-time data to create three set of pseudo measurements. Could you please tell me how to do this in the excel sheet?

$\endgroup$
0
1
$\begingroup$

You can use the following formula to produce the white noise for one cell.

= 0.5*NORM.S.INV(RAND())

Where:

  • 0.5 : can change to any non-zero number. It will control the range of the data.
  • NORM.S.INV(RAND()) : produces a random number from -inf to inf, with mean zero and standard deviation 1

you can create a column for noise with this equation, and then just add the data.

If you want to be thorough you can

$\endgroup$

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.