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: 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 2897 times
Top
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
Top
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
Top
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 2886 times
Top
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 2890 times
Top
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)
Top
Please add www.kreslik.com to your ad blocker white list.
Thank you for your support.
Post Reply

Return to “beginners forum”