Excel - Adding and Graphing Sine Waves with Any Amplitude or Phase

Поделиться
HTML-код
  • Опубликовано: 6 окт 2024
  • At Level 3 or HNC Electrical and Electronic Engineering you'll be asked to add sine waves together and graph them. You'll possibly also do this in AS or A-Level Maths.
    Excel makes the process so much faster than using a calculator to find the sine of angles with or without phase shifts.
    This video shows you how to create a dynamic graph of sine waves that changes as you change amplitude and phase data. It's saved me loads of time in the past.
    For what it's worth, you can also type 'cos' or 'tan' instead of 'sin' to find the Cosine or Tangent functions.
    I do it my way, but you could also type...
    =sin(radians(x angle in degrees)+radians(phase shift in degrees)) [Enter]
    Don't forget the = sign for Excel formulas and don't forget the two $ signs to force an equation to look at just one cell's data for all rows of the formula.
    Happy graphing!

Комментарии •