Fourier Analysis

[Guest]

What is the form of the input required for a Fourier Analysis? Can someone
provide an example?

 

[Guest]

Fourier is part of Microsfot's Analysis Toolpack
See:

http://office.microsoft.com/en-us/assistance/HP052038731033.aspx

 

[Harlan Grove]

Gary's Student wrote...

Fourier is part of Microsfot's Analysis Toolpack
See:

http://office.microsoft.com/en-us/assistance/HP052038731033.aspx

....

Did you read what LITTLE this site has to say about Fourier Analysis?
It's just the web version of online help, and it's pathetic.

The OP needs to run Tools > Data Analysis, Fourier Analysis, and then
click on the Help button in Fourier Analysis dialog. The help info that
displays is more useful than the link you provided, but still pretty
skimpy.

Excel's implementation is a toy. The OP would be better off using a
real stats package to perform Fourier Analysis.

 

[Dana DeLouis]

What is the form of the input required for a Fourier Analysis? Can

someone
provide an example?

Hi. If I understand the question, the most common form of input is just
real numbers like 3, 4, 5.3, etc.
However, Excel's FFt can also work with complex data as well. Other
examples of data input can be:
=COMPLEX(3,4,"i")
or
=COMPLEX(3,4,"j")

Just keep the i or j consistent. They can't be mixed. Note that i is the
default if not given.
You can also work with just imaginary data also as in other Fft programs:
=COMPLEX(0,7)

You can also work with string input if it represents a complex number:
="3+4i"
or
="8i"
(or ="8j" if you prefer "j". I personally like default of "i" to keep it
consistent with certain other programs.)

Note that Excel uses a Radix-2 algorithm, so the data size must be 2^n,
where n is a positive integer 1-12. (Max of 4,096)

HTH. :>)