alramsey Posted June 30, 2011 Report Share Posted June 30, 2011 Hello guys,I am currently doing my physics IAs and i am stuck at processing the graphs. I have performed the experiments and have generated several graphs, which are all exponential. Now, how can I turn that exponential line into a straight line on excel? I know I have to log it, but i am not sure how to do it. I've tried changing the scale of the graph to logarithmic scale and converting the data one by one with =ln(), but both methods failed to give me a proper straight-line-with-proper-axes-and-proper-linear-trendline graph.Anyone has experience in this? Can you tell me how to do it on excel, if not, on other applications?I really need your help, my IA final draft is due in 3 weeks.Thanks in advance! Reply Link to post Share on other sites More sharing options...
dessskris Posted June 30, 2011 Report Share Posted June 30, 2011 sorry, do you want to plot a linear graph or an exponential graph? what you do is tabulate the data on excel, select it and create a graph, choose scatter graph. then you'll see the data points. look for menu Format, select Trendline. add a trendline. right click on the line on the graph, choose Format Trendline and choose Exponential. tick show equation and R^2 value if you like. Reply Link to post Share on other sites More sharing options...
alramsey Posted July 1, 2011 Author Report Share Posted July 1, 2011 i already have the exponential graph. Now i want to calculate the gradient of that graph, which i can only find if i log it (making the graph a straight line). Do you know how to do that? Reply Link to post Share on other sites More sharing options...
dessskris Posted July 1, 2011 Report Share Posted July 1, 2011 oh. don't plot x against y then. try plotting e^x against y? you should perhaps get a linear graph. Reply Link to post Share on other sites More sharing options...
alramsey Posted July 2, 2011 Author Report Share Posted July 2, 2011 ohh...i found a way, it seems that i have to log both axes first, it works the second time... hehehe but it was great recommendation from you desy to do e^x...thanks! Reply Link to post Share on other sites More sharing options...
Rigel Posted July 3, 2011 Report Share Posted July 3, 2011 You have to log both sides, and then you can find the intercepts and the gradient. Reply Link to post Share on other sites More sharing options...
alramsey Posted July 3, 2011 Author Report Share Posted July 3, 2011 yes, i finally found a way to do that... now, do you have any idea what to do when after logging both sides, the graph is not linear? Reply Link to post Share on other sites More sharing options...
dessskris Posted July 3, 2011 Report Share Posted July 3, 2011 graphing e^x against y instead of graphing x against y haha Reply Link to post Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.