Math / Excel question

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

Moderator: moderators

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

Math / Excel question

Postby Tresor » Sat Jul 24, 2010 1:08 pm

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 147 times

Please add www.kreslik.com to your ad blocker white list.
Thank you for your support.

User avatar
blubbb
rank: 150+ posts
rank: 150+ posts
Posts: 219
Joined: Mon Sep 29, 2008 8:07 pm
Reputation: 0
Location: Europe
Gender: Male

Postby blubbb » Sat Jul 24, 2010 1:33 pm

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: Male

Postby Tresor » Sat Jul 24, 2010 1:46 pm

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: Male

Postby Tresor » Sat Jul 24, 2010 2:19 pm

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 136 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: Male

Postby blubbb » Sat Jul 24, 2010 3:11 pm

One minus what I wrote above? ;-)
Attachments
b.gif
b.gif (8.2 KiB) Viewed 140 times

Please add www.kreslik.com to your ad blocker white list.
Thank you for your support.

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

Postby Tresor » Sat Jul 24, 2010 4:21 pm

Thank you very much. It does the job 8)

Please add www.kreslik.com to your ad blocker white list.
Thank you for your support.


Return to “beginners forum”