Spectral Analysis – a Fourier transform tutorial – part #1

This is a basic tutorial about implementation of a standard Fourier transform model in Excel. It is not an introduction to Fourier analyis. You could choose to familiarize yourself with the subject before proceeding with this tutorial. Solving a few Fourier transform excersises would be of help too. Essentially, this part shows you how to adapt the general Fourier formula for a continuous real signal to a sampled signal having a limited number of samples.

6 Responses to “Spectral Analysis – a Fourier transform tutorial – part #1”

  1. Arup Mukerjee says:

    Just learning only

  2. RoGeorge says:

    This is the most concise, clear and intuitive representation I ever encountered until now and it elevated my understanding at a whole new level.
    After seeing this 6 slides, somebody could never possibly forget what FT is all about.


    • george says:

      Thanks for the comment RoGeorge. Actually I am rather concerned with the practical implementation than with the theoretical derivation. Numai bine, George

  3. Mir from Peshawar says:

    Sir so interesting work in excel can we get step by step videos of the tutorials Please tell me

  4. sagar says:

    Sir ,
    I am doing the FFT of time vs velocity,which is having sampling rate of 1000 Hz and no of samples are 1024 every time i am getting the maximum power at zero frequency.I am feeling there is something wrong going please help me in this regard.

RSS feed for comments on this post. And trackBack URL.

Leave a Reply