ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Graphing (https://www.excelbanter.com/excel-discussion-misc-queries/181977-graphing.html)

Suz

Graphing
 
i am having difficulty graphing y=y0.e^-at[cos(t.square rootB^2-a^2 +t.O)].
In this case y0=-0.010m, a=0.80 1/s, B=6.000 1/s, O=0.485 1/s.

David Biddulph[_2_]

Graphing
 
A couple of things you'll need to clarify.
Is your cos treating the number in parentheses as being in radians or
degrees? Excel defaults to radians.
You may need further parentheses, for example for which term you are going
to take the square root. With some dimensional analysis I guess that pehaps
the sqrt is of (B^2-a^2) ?

If your four constants are in C$1 to C$4, and your values of t from A2
downwards, your values of y in B2 downwards could be
=C$1*EXP(-C$2*A2*COS(A2*SQRT(C$3^2-C$2^2)+A2*C$4))
--
David Biddulph

"suz" wrote in message
...
i am having difficulty graphing y=y0.e^-at[cos(t.square rootB^2-a^2 +t.O)].
In this case y0=-0.010m, a=0.80 1/s, B=6.000 1/s, O=0.485 1/s.





All times are GMT +1. The time now is 11:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com