Ask Experts Questions for FREE Help !
Ask
    mlsilver21's Avatar
    mlsilver21 Posts: 1, Reputation: 1
    New Member
    		  
    #1

    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?
    how would I enter f(x) = 31.5 + 1.1 log(x + 1) in excel in order to graph it?
    KISS's Avatar
    KISS Posts: 12,510, Reputation: 839
    Uber Member
    		  
    #2

    Apr 10, 2010, 10:21 PM

    This is easier. y = 31.5 + 1.1 log(x + 1) - Wolfram|Alpha

    Problem though Is LOG() LOG base 10 or the natural log (base e).
    galactus's Avatar
    galactus Posts: 2,271, Reputation: 282
    Ultra Member
    		  
    #3

    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.
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search


Check out some similar questions!

Link excel graph why axis min/max scale to cells [ 1 Answers ]

Hi , Thank you for allowing me to even ask a question. I hope I can make this simple and clear as to not confuse you. I am currently building an excel file. I will have 2 graphs on a sheet. One of the graphs I need to link the Y axis minimum and maximum scale, (and major unit if possible)...

Excel line graph [ 5 Answers ]

I have a line graph which that's its data from a separate worksheet. On that sheet I have displayed the days of which ever month I select down column "A". Obviously some month have 30 days and other have 31. Column "B" has total hours flown that day (format: 00:00) and column "C" has a running...

Excel 07 - Pressing enter won't bring me to the A column [ 4 Answers ]

I'm new to excel and learning it at my local college but am stuck with a small problem. say I enter info in A2, then B2... and so on until I get to say... E2. If I hit enter after inputting info into E2 my next active cell is random. its going between all the letters in the next row down,...

Can't find the third zero on a log graph [ 1 Answers ]

howdy, I've been working on this problem for the longest time and can't figure it out. I was given this problem: (log x )^3 = 9 log x and was told to find the zeros. The program I'm using is asking for 3 zeros and I can only find two. It tells me which zeros are the biggest and smallest. I...

Excel 2003 - using Enter key has unexpected results [ 3 Answers ]

When I press the Enter key in Excel 2003 the entire page moves instead of moving the cell location. The Tab key also moves the page instead of moving the cell location. Any help with this would be appreciated. Thanks

View more questions Search