bodmas.org

Superposition of two sine waves

Filed in Maths, ILT on March 27th 06 .

Phase angle illustration

You can use a simple MS Excel spreadsheet to illustrate the effect of adding two sine waves with various amounts of phase shift between the waves. Using a scroll bar allows a degree of interaction, although the way the scroll bar control works in MS Excel is not good for interactive graphs – you have to adjust the slider and let go before the spreadsheet recalculates to show the effect of the change.

  • Download the MS Excel spreadsheet 148 Kb, Excel 2004 but compatible with Excel 1997+
  • FERL video by Alistair McNaught on how to link a scroll bar to a cell value in Excel

The blue trace is the original sine wave, the red trace is the phase shifted sine wave (both of amplitude 1) and the yellow trace is the superposition of the two waves. The graph extends over two cycles (720 degrees) and the phase shift slider allows phase shifts between 0 and 360 degrees. Rescaling the spreadsheet for Radians would be the work of minutes.

This is filed under Maths, ILT. You can follow any responses to this entry through the RSS 2.0 feed. Both comments and pings are closed for this post.

[ bodmas home ]

Subscribe to bodmas.org using RSS

offline blogging tool ecto in use on bodmas

Site delivered by WordPress

Entries and comments feeds.

© Content Keith Burnett, 2006. This old school table-based layout was devised to support a Web authoring module. Mind you, it loads quicker than Kubrick in Safari...