LinkExchange Member

Free Home Pages at GeoCities

Building a Sine Wave

A wave has an amplitude and a frequency. We can use the formula shown below to describe a wave:

y = A sin(n pi x)


• y is the dependent variable
• x is the independent variable
• A is the constant that controls amplitude
• n is the constant that controls the frequency
• pi is the constant 3.1415926

In the above spreadsheet, notice that the cell C3 is highlighted, and that formula corresponding to C3, shown above,

=+$A$3*SIN($A$A*$A$2*B3)

makes use of $ symbols in three instances in order to use cells as constants.

A1 is pi

A2 is the constant related to frequency

A3 is the amplitude

the B column is for x values

the C column calculates y values






Next Page

Return to Master Alchemist Index



Last Revised 02/21/98.
Copyright ©1998 by William L. Dechent. All rights reserved.