Math / Excel question

Questions about MultiCharts and user contributed studies.
Tresor
Posts: 1104
Joined: 29 Mar 2008
Has thanked: 12 times
Been thanked: 51 times

Math / Excel question

Postby Tresor » 24 Jul 2010

Hi,

Could a kind sould help a math layman generate an Excel formula for the function that is presented in the picture?

Thanks
Attachments
graph of function.png
graph of function.png (8.48 KiB) Viewed 131 times

Tresor
Posts: 1104
Joined: 29 Mar 2008
Has thanked: 12 times
Been thanked: 51 times

Postby Tresor » 24 Jul 2010

I already have the formula for the above (previous) picture: 1.0001^(-x)

Now I am looking for a formula for the below picture (picture attached).

Help apprecitaed.
Attachments
graph of function B.png
graph of function B.png (7.26 KiB) Viewed 127 times

User avatar
geizer
Posts: 375
Joined: 16 Jun 2008
Has thanked: 40 times
Been thanked: 38 times

Postby geizer » 24 Jul 2010

I already have the formula for the above (previous) picture: 1.0001^(-x)

Now I am looking for a formula for the below picture (picture attached).

Help apprecitaed.


Your picture suggests an exponential function. The real world example would be a Voltage (Vc) across a capacitor to which the Input Voltage (V) has been applied.

Take a look at the following link - it is a good tutorial and it contains the formula. The 'Time Constant' (T=RC) determines how fast (or slow) the output goes from 0 to V. In your case V=1. The output will never reach 1, since RC must be greater than zero.

http://www.electronics-tutorials.ws/rc/rc_1.html
http://www.electronics-tutorials.ws/rc/rc_3.html

Regards,
Pavel
Last edited by geizer on 24 Jul 2010, edited 1 time in total.

Tresor
Posts: 1104
Joined: 29 Mar 2008
Has thanked: 12 times
Been thanked: 51 times

Postby Tresor » 24 Jul 2010

Hi Pavel,

Solution to the latter picture is: 1-1.0001^(-x)


Return to “MultiCharts”