Forum Discussion
Array formula for FFT
Hello, I would like to know what is the equivalent array formula for the FFT analysis which is available in the pull-down menu and which gives the result in a form real +i*imag in a sinlge output c...
Hello,
After checking my results, I found the origin of the discrepency:
When you use the FFT function from the Data Analysis pull down menu, the output result is a single column with real and imaginary part NOT divided by the number of points of the FFT. If you use the array formula, the real and imaginary parts are available in two adjacent columns and both terms ARE already divided by the size.
Hoping this will hopeully help some excel users.
After checking my results, I found the origin of the discrepency:
When you use the FFT function from the Data Analysis pull down menu, the output result is a single column with real and imaginary part NOT divided by the number of points of the FFT. If you use the array formula, the real and imaginary parts are available in two adjacent columns and both terms ARE already divided by the size.
Hoping this will hopeully help some excel users.