Fourier Analysis in Excel

M

Mitch T

I am using the Fourier analysis in excel. The output of the analysis is a
column of real and imaginary numbers formatted in text. Is there any simple
way of separating the output to a column of real numbers and another column
of imaginary numbers? I need the magnitude of the output and cannot do
calculations on the text output.
 
E

Ed Ferrero

Hi Mitch,
I am using the Fourier analysis in excel. The output of the analysis is a
column of real and imaginary numbers formatted in text. Is there any
simple
way of separating the output to a column of real numbers and another
column
of imaginary numbers? I need the magnitude of the output and cannot do
calculations on the text output.
Click to expand...

Use the IMABS, IMREAL and IMAGINARY engineering functions.

Ed Ferrero
www.edferrero.com
 
Top