View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MrShorty
 
Posts: n/a
Default drawing rect function graph in excel


Consider porperties of y=sin(x) (x in radians)

maximum values (amplitude): 1, -1
0 values (crosses x axis): 0, pi, 2pi, 3pi,... (period=2pi)

Pick a starting point (0,0) and plot the series:

x y
0 0
0 1
pi 1
pi -1
2pi -1
2pi 1
. .
. .
. .

From there it's not too difficult to relate x and y to the generic
y=Asin(Bx) where A=amplitude (y=A or -A) and 2pi*B=period
(x=i*period/2)


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=487122