Math / Excel question

If you don't know where to start, start here! Don't be afraid to ask questions.

Moderator: moderators

Post Reply
Tresor
rank: 50+ posts
rank: 50+ posts
Posts: 93
Joined: Sat Mar 15, 2008 2:30 pm
Reputation: 0
Location: Davy Jones' Locker
Gender:

Math / Excel question

Post by Tresor »

Hi,

Could a kind sould help a math layman produce 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 3203 times
User avatar
blubbb
rank: 150+ posts
rank: 150+ posts
Posts: 219
Joined: Mon Sep 29, 2008 8:07 pm
Reputation: 0
Location: Europe
Gender:

Post by blubbb »

What about

1.0001^(-x)

Don't know if Excel understands that, but that's what I first thought of.

Image
Tresor
rank: 50+ posts
rank: 50+ posts
Posts: 93
Joined: Sat Mar 15, 2008 2:30 pm
Reputation: 0
Location: Davy Jones' Locker
Gender:

Post by Tresor »

Perfect. Thank you so much :smt026
Tresor
rank: 50+ posts
rank: 50+ posts
Posts: 93
Joined: Sat Mar 15, 2008 2:30 pm
Reputation: 0
Location: Davy Jones' Locker
Gender:

Post by Tresor »

I hve one more and last favour to ask. Could you please have a look at this picture and suggest the formula?

Thanks
Attachments
graph of function B.png
graph of function B.png (7.26 KiB) Viewed 3192 times
User avatar
blubbb
rank: 150+ posts
rank: 150+ posts
Posts: 219
Joined: Mon Sep 29, 2008 8:07 pm
Reputation: 0
Location: Europe
Gender:

Post by blubbb »

One minus what I wrote above? ;-)
Attachments
b.gif
b.gif (8.2 KiB) Viewed 3196 times
Tresor
rank: 50+ posts
rank: 50+ posts
Posts: 93
Joined: Sat Mar 15, 2008 2:30 pm
Reputation: 0
Location: Davy Jones' Locker
Gender:

Post by Tresor »

Thank you very much. It does the job 8)
Post Reply