PDA

View Full Version : How would I enter f(x) = 31.5 + 1.1 log(x + 1) in excel in order to graph it?


mlsilver21
Apr 10, 2010, 10:03 PM
how would I enter f(x) = 31.5 + 1.1 log(x + 1) in excel in order to graph it?

KISS
Apr 10, 2010, 10:21 PM
This is easier. y = 31.5 + 1.1 log(x + 1) - Wolfram|Alpha (http://www.wolframalpha.com/input/?i=y+%3D+31.5+%2B+1.1+log%28x+%2B+1%29+)

Problem though Is LOG() LOG base 10 or the natural log (base e).

galactus
Apr 11, 2010, 01:07 AM
Enter the values 0 - 10 in cells A1 to A10. Then, type the formula

=31.5+1.1*LOG(A1+1) in cell B1 and drag it down to cell B10.

Now, click on Insert, Graph, and follow the instructions. You will get a graph of said function.