Using Excel for Fourier analysis Fourier

Fourier analysis is often used in engineering, and it is usually possible to study the frequency components of variables.

Use Excel to generate the data you want to study, with the formula: Y==2*sin (x*2) +cos (x) +rand () *0.1

These include two different frequency components, with a strength of twice times, and a noise signal component with a strength of 0.1.

Using the Fourier analysis tool

Modulus to be analyzed

Calculate power density using the Imabs function

Analysis results:

Comparing the original signal and spectrogram, we can see that there are two peaks at 0.3 and 0.6 respectively, and the strength is 60 and 120, which satisfies our input function.

Using Excel for Fourier analysis Fourier