Learning Fourier Transform with Excel (in Japanese)

About
Learning Fourier Transform with Excel (cover) Author:Takashi Kanamaru
Publisher: Softbank Creative
ISBN:9784797338270
ASIN:479733827X
Published:27 January, 2007
Price:2940 yen
Contents: The readers can learn Fourier transform with Excel.
Besides "Fourier series", "Fourier transform",
"discrete Fourier transform", and "FFT",
many experiments to observe the spectra
of various sounds can be performed
by reading sound files with Excel.

The experiments of "guitar-sound analysis",
"engine-sound analysis", "speaking-sound analysis",
"echo effects", and "noise reduction" can be performed.

Moreover, "Fourier transform of Lorenz chaos" and
"sound of Lorenz chaos" are also explained.

* for Excel 2000 / 2003 / 2007 for Windows
Purchase:Amazon.co.jp

Example
The figure below shows an example of Excel files contained in this book, which performs the Fourier analysis of an engine sound (wav file) with Excel (CHAPTER05). With this file, the analysis can be performed only by clicking your mouse.

The method of the manual navigation of the analysis tools of Excel is also explained (CHAPTER04).

Fourier analysis of engine sound with Excel 2007 on Windows XP
Fourier analysis of engine sound with Excel


Fourier series analysis with Excel 2004 on Mac OS X 10.5 (Intel) (Click to expand)
Fourier series analysis with Excel 2004 on Mac OS X 10.5 (Intel)


Fourier analysis of Lorenz chaos with OpenOffice.org on Linux (Click to expand)
Fourier analysis of Lorenz chaos with OpenOffice.org on Linux

Contents
  • CHAPTER00 Setup of Excel environment
    • Setup of analysis tools and macro

  • CHAPTER01 Preliminaries
    • Periodic functions and trigonometric functions
    • Exponential functions and logarithmic functions
    • Differential calculus and integral calculus
    • Complex numbers
    • Other notes

  • CHAPTER02 Fourier series
    • Concept of Fourier series
    • Examples of Fourier series
    • Fourier series with Excel
    • Derivation of Fourier series
    • Complex Fourier series
    • Examples of complex Fourier series
    • Complex Fourier series with Excel
    • Derivation of complex Fourier series

  • CHAPTER03 Fourier transform
    • Concept of Fourier transform
    • Definition of Fourier transform
    • Calculus of Fourier transform
    • Fourier transform with Excel
    • Derivation of Fourier transform
    • Additivity and symmetry
    • Fourier transform of even functions and odd functions
    • Fourier transform of even functions and odd functions with Excel
    • Derivation of Fourier transform of even functions
    • Parseval's theorem
    • Parseval's theorem with Excel
    • Fourier transform of convolution
    • Fourier transform of convolution with Excel
    • Derivation of Fourier transform of convolution
    • Power spectrum
    • Examples of power spectrum
    • Power spectrum of Ornstein-Uhlenbeck process with Excel
    • Fourier transform of periodic functions
    • Fourier transform of periodic functions with Excel
    • Fourier transform of aperiodic functions
    • Fourier transform of Lorenz chaos with Excel

  • CHAPTER04 Discrete Fourier transform and FFT
    • Sampling theorem
    • Fourier transform of sampled data with Excel
    • Derivation of sampling theorem
    • Discrete Fourier transform (DFT)
    • Fourier transform with analysis tools of Excel
    • FFT
    • Experiencing the speed of FFT with Excel
    • Algorithm of FFT
    • Discrete cosine transform (DCT)

  • CHAPTER05 Application of Fourier transform to sound analysis
    • Sound signals and wave files
    • Calculating the frequencies of the sound with Excel
    • Making sound files Excel with Excel
    • Sound analysis with Excel (1) guitar sound
    • Sound analysis with Excel (2) engine sound
    • Sound analysis with Excel (3) speaking sound
    • Voice change with Excel
    • Echo effect with Excel
    • Noise reduction with Excel

Back to Takashi Kanamaru's web page