how to do it using excel?Thanks.
2006-10-31 03:06:29 · 8 answers · asked by Ruth 1 in Science & Mathematics ➔ Mathematics
e^5 = 148.41
Excel info on logs and ln:
=ln(NUMBER)
Returns the natural log of NUMBER.
=log(NUMBER,BASE)
Returns the log of NUMBER to the designated BASE.
=log10(NUMBER)
Returns the base-10 log of NUMBER.
------------
For power:
=POWER(6, 3) = 6^3 for example.
Configure in spreadsheet this info and you can solve the equation.
2006-10-31 03:10:30 · answer #1 · answered by Centurion 2 · 0⤊ 0⤋
In ln or natural logarithms, the base is e which is approximately 2.713. So, to solve for x take both sides of the equation as powers of e. Thus, the base e to the power (ln(x)) = e to the power 5. (Sorry, unable to do exponents in my yahoo page).
Then, this just becomes x = e to the power 5. And the answer is 148.413. This is your x.
In using Excel, Use the Math Formulas Window, use drop-down choices to get e to the power x.
To check your work. Take the ln of 148.413. This should give you the original given of 5. Which it does. In Excel, use the ln function option.
2006-10-31 03:31:28 · answer #2 · answered by Aldo 5 · 0⤊ 0⤋
ln (x) in Excel is LN(x)
So then you can open the Help and search for "solve formula", where you will see the choice "Enter a formula to calculate a value".
The steps for this are (taken directly from Excel's Help):
xxx
Click the cell in which you want to enter the formula.
To start the formula with the function, click Edit Formula [ = ] in the formula bar.
Click the down arrow next to the Functions box [ SUM ].
Click the function you want to add to the formula. If the function does not appear in the list, click More Functions for a list of additional functions.
Enter the arguments.
When you complete the formula, press ENTER.
xxx
I just click the drop down box and choose LN(x) and when the dialog box comes up, I type 5 for "Number" and it gives me the answer 1.609437912. It's as easy as pie!
2006-10-31 03:32:03 · answer #3 · answered by Tom A 3 · 0⤊ 0⤋
ln has a base of e, just as log has a base of 10 unless otherwise specified
therefore, e^5=x just as in log(x)=5, 10^5=x
2006-10-31 04:22:05 · answer #4 · answered by jessi220542 1 · 0⤊ 0⤋
e^5
2006-10-31 04:30:18 · answer #5 · answered by toto 1 · 0⤊ 0⤋
x = e^5 = 148.41315910257660342111558004055
Doug
2006-10-31 03:11:30 · answer #6 · answered by doug_donaghue 7 · 0⤊ 0⤋
ln(x)=5
x=e^5=148.413
2006-10-31 03:46:13 · answer #7 · answered by yupchagee 7 · 0⤊ 0⤋
ln(x) = 5
x = e^5
x = 148.41
2006-10-31 03:36:05 · answer #8 · answered by ludacrusher 4 · 0⤊ 0⤋