#1   Report Post  
jordon
 
Posts: n/a
Default Fourier Analysis

What is the form of the input required for a Fourier Analysis? Can someone
provide an example?
  #2   Report Post  
Gary's Student
 
Posts: n/a
Default

Fourier is part of Microsfot's Analysis Toolpack
See:

http://office.microsoft.com/en-us/as...038731033.aspx

--
Gary's Student


"jordon" wrote:

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

  #3   Report Post  
Harlan Grove
 
Posts: n/a
Default

Gary's Student wrote...
Fourier is part of Microsfot's Analysis Toolpack
See:

http://office.microsoft.com/en-us/as...038731033.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.

  #4   Report Post  
Dana DeLouis
 
Posts: n/a
Default

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. :)
--
Dana DeLouis
Win XP & Office 2003


"jordon" wrote in message
...
What is the form of the input required for a Fourier Analysis? Can
someone
provide an example?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel's Fourier Analysis should be a function, so that results upd BobM Excel Worksheet Functions 4 January 30th 06 03:06 PM
Why " data analysis plus " override " data analysis " once instal. Alfred H K Yip Excel Worksheet Functions 1 March 20th 05 08:10 AM
Analysis ToolPak installed but no Data Analysis option Eric Stephens Excel Discussion (Misc queries) 3 February 2nd 05 09:17 PM
Fourier Analysis Bruce Excel Worksheet Functions 1 January 13th 05 07:30 AM
Fourier analysis. engineergirl Excel Worksheet Functions 1 November 18th 04 09:47 PM


All times are GMT +1. The time now is 10:02 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"