ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Finding the Natural Log ln(#) (https://www.excelbanter.com/excel-discussion-misc-queries/129888-finding-natural-log-ln.html)

Jen

Finding the Natural Log ln(#)
 
Can any one help explain to me how you would go about finding the natural log
of a set of data. For example, in my chemisrty class we used a Logger Pro to
record data of a chemical reaction that was taking place. The data we got was
concentration vs. time and we made a graph of it. I know need to make a graph
of the natural log of the concentration vs. time. Our TA told us we can do it
in Excel but I was hoping you could calculate the data through excel instead
of doing each value by hand. Any tips?
--
Thanks! Jen

Chip Pearson

Finding the Natural Log ln(#)
 
You can use the LN function to return the natural log of a value. E.g.,

=LN(A1)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)



"Jen" wrote in message
...
Can any one help explain to me how you would go about finding the natural
log
of a set of data. For example, in my chemisrty class we used a Logger Pro
to
record data of a chemical reaction that was taking place. The data we got
was
concentration vs. time and we made a graph of it. I know need to make a
graph
of the natural log of the concentration vs. time. Our TA told us we can do
it
in Excel but I was hoping you could calculate the data through excel
instead
of doing each value by hand. Any tips?
--
Thanks! Jen





All times are GMT +1. The time now is 03:05 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com