Fourier Analysis in Excel

[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.

 

[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.

Use the IMABS, IMREAL and IMAGINARY engineering functions.

Ed Ferrero
www.edferrero.com

 

[Mitch T]

Thanks Ed, that was helpful.

Hi Mitch,


Use the IMABS, IMREAL and IMAGINARY engineering functions.

Ed Ferrero
www.edferrero.com