This book demonstrates Microsoft EXCEL-based Fourier transform of selected physics examples. Spectral density of the auto-regression process is also described in relation to Fourier transform. Rather than offering rigorous mathematics, readers will "try and feel" Fourier transform for themselves through the examples. Readers can also acquire and analyze their own data following the step-by-step procedure explained in this book. A hands-on acoustic spectral analysis can be one of the ideal long-term student projects.

This book covers essential Microsoft EXCEL (R)'s computational skills while analyzing introductory physics projects. Topics of numerical analysis include; multiple graphs on the same sheet, calculation of descriptive statistical parameters, a 3-point interpolation, the Euler and the Runge-Kutter methods to solve equations of motion, the Fourier transform to calculate the normal modes of a double pendulum, matrix calculations to solve coupled linear equations of a DC circuit, animation of waves and Lissajous figures, electric and magnetic field calculations from the Poisson equation and its 3D surface graphs, variational calculus such as Fermat's least traveling time principle and the least action principle. Nelson's stochastic quantum dynamics is also introduced to draw quantum particle trajectories.

This book may be used as a companion for introductory laboratory courses, as well as possible STEM projects. It covers essential Microsoft EXCEL(R) computational skills while analyzing introductory physics projects. Topics of numerical analysis include: multiple graphs on the same sheet, calculation of descriptive statistical parameters, a 3-point interpolation, the Euler and the Runge-Kutter methods to solve equations of motion, the Fourier transform to calculate the normal modes of a double pendulum, matrix calculations to solve coupled linear equations of a DC circuit, animation of waves and Lissajous figures, electric and magnetic field calculations from the Poisson equation and its 3D surface graphs, variational calculus such as Fermat's least traveling time principle, and the least action principle. Nelson's stochastic quantum dynamics is also introduced to draw quantum particle trajectories.

This book demonstrates Microsoft EXCEL(R)-based Fourier transform of selected physics examples, as well as describing spectral density of the auto-regression process in relation to Fourier transform. Rather than offering rigorous mathematics, the book provides readers with an opportunity to gain an understanding of Fourier transform through the examples. They will acquire and analyze their own data following the step-by-step procedure outlined, and a hands-on acoustic spectral analysis is suggested as the ideal long-term student project.

This book covers essential Microsoft EXCEL (R)'s computational skills while analyzing introductory physics projects. Topics of numerical analysis include; multiple graphs on the same sheet, calculation of descriptive statistical parameters, a 3-point interpolation, the Euler and the Runge-Kutter methods to solve equations of motion, the Fourier transform to calculate the normal modes of a double pendulum, matrix calculations to solve coupled linear equations of a DC circuit, animation of waves and Lissajous figures, electric and magnetic field calculations from the Poisson equation and its 3D surface graphs, variational calculus such as Fermat's least traveling time principle and the least action principle. Nelson's stochastic quantum dynamics is also introduced to draw quantum particle trajectories.

This book demonstrates Microsoft EXCEL-based Fourier transform of selected physics examples. Spectral density of the auto-regression process is also described in relation to Fourier transform. Rather than offering rigorous mathematics, readers will "try and feel" Fourier transform for themselves through the examples. Readers can also acquire and analyze their own data following the step-by-step procedure explained in this book. A hands-on acoustic spectral analysis can be one of the ideal long-term student projects.