Question about Microsoft Excel for PC

How to formulate log function with excel

Hi,

im doing a particle size analysis and i couldnt make a formulation for inverse log calculations using excel

Posted by on

• duradz Nov 22, 2007

its inverse log that i am talking about... how to do it in a pc is my question so if there is anybody who knows how to do it please tell me.. if there is a cost so be it..

×

Ad

1 Answer

• Level 2:

An expert who has achieved level 2 by getting 100 points

MVP:

An expert that gotĀ 5 achievements.

Governor:

An expert whose answer gotĀ voted for 20 times.

Scholar:

An expert who has written 20 answers of more than 400 characters.

• Expert
• 58 Answers

Here try this link

http://support.microsoft.com/kb/214116

Posted on Nov 20, 2007

• Job Cacka Nov 20, 2007

hey you may want to check and make sure your version of Excel is up to date. At least check the math on several calculations. Several versions of excel have had math problems. These were fixed in updates.

Check it out:
http://www.physics.uoguelph.ca/tutorials...

Updates:
http://office.microsoft.com/en-us/downlo...

• Job Cacka Dec 16, 2007

The inverse of a log is the power of the base to x. So if I have log 1000 = 3 then the inverse is 10^3=1000, assuming base ten. The link I provided to Microsoft's web site describes how to do this in Excel.

×

Ad

1 Suggested Answer

• 2 Answers

Hi,
A 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
The service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Good luck!

Posted on Jan 02, 2017

Ad

Add Your Answer

×

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video.

×

Loading...

Related Questions:

1 Answer

How do I calculate inverse logs on casio fx-82au plus?

The inverse of log functions are power functions.
Inv of ln is exponential (e^x)
Inv of log in base 10 is 10^(x)
A function and its inverse usually share the same physical key. One function is accessed directly, the other by using the SHIFT or 2ndF key.

Aug 18, 2014 | Casio Office Equipment & Supplies

2 Answers

Im pressing the buttom that everyone is saying is the inverse key but it is saying error. i really need help with this.

It is much more enlightning to tell us what you want to do rather than talk about something that does not exist. And one thing that does not mean anything is that ellusive INVERSE key that everyone and his dog is looking for.
The additive inverse of a number a is its opposite (-a). The key to use is the change key (-).
The multiplicative inverse of non-zero number a is its reciprocal 1/a
The inverse of the natural log (LN) function is the EXPONENTIAL function e^(x). On most calculators if one function is accessed diectly (the marking is on the key), its inverse is accessed by pressing [SHIF] (Casio, or [2nd] (TI) or [2ndF] (Sharp).
The inverse of the function raise 10 to a power [10^x] is [LOG]
Similarly, the inverse of the sine function SIN is the arcsine [sin^-1]. To access the latter, it you press [2nd][SIN]. The same is true for arcosine [2nd][COS], and arctangent [2nd][TAN]

The inverse of the square functions [x^2] is the square root function [2nd][x^2]
Inverse of x^3 is cubic root
This is just a quick overview.

Feb 16, 2012 | Texas Instruments TI-84 Plus Silver...

1 Answer

Hi, how do i calculate log^-1(-2) on my ti-30xa? thank u.

The inverse of the log function is the power function.
For log in base 10 that inverse is 10 to a power of
More generally, let b be the base of the logarithm. If y=log_b (x) then x=b^y
For your case log=log_10, to calculate the inverse you perform 10^(-2)=0.01=1/100
On calculators the log in base 10 and its inverse share the same physical key. One is accessed directly, the other is the shifted key function.

Sep 09, 2011 | Texas Instruments TI-30XA Calculator

1 Answer

How to take anti log in casio fx 991 ms and give example?

Depending on the actual log function you are talking about, the inverse function (what you call the anti log) can be one of several things.
The inverse of the natural log (LN) is the exponential function e^x.
If y= ln(x) then x=e^y
On a calculator functions that are inverse of one another share the same physical key. If one function is marked on a key, the inverse function is usually the SHIFTED (or 2nd) key
The inverse of the common (decimal logarithm) is the power function with 10 as base.
Example: if y= log(x) then x=10^y
For an arbitrary base (must be positive) if y= log_b(x) then x=b^y.
Note: I do not think that the FX-300ms can perform log calculations in bases other than e (natural log) or 10 (common decimal log).

Aug 13, 2011 | Casio FX-300MS Calculator

1 Answer

How do i perform log and log inverse or antilog calculations on my sharp EL W-535 calculator

Press the log key, enter a poistive number and press the = key.
To calculate the inverse of the decimal log use SHIFT LOG to access the function 10^x (the inverse of the log function.)

Dec 15, 2010 | Sharp ELW535 Calculator

1 Answer

I need an inverse log button on the casio calculator 9750GII.... does it have one??? I know how to do log, but can't find the inverse.

The log base 10 function has an inverse: It is the 10 ^x function. It shares the same physical key with the decimal log. Use [SHIFT][LOG].
The natural log (LN) has an inverse alos and that it the exponentila function e^x. It shares the same physical key with it.

Jul 20, 2010 | Casio FX-9750GPlus Calculator

1 Answer

Using the correct key combination to determine inverse log

Hi,
Sorry to contradict you but there are many types of logarithms, the most important ones are
1. the common logarithms (log in base 10),
2. the natural logarithms (logarithms in base e)
3. the binary logarithms (logarithms in base 2)
On calculators, the common logarithms are labeled [LOG], and the natural logarithms are labeled [LN].

The inverse function of the natural log function is the exponential (e^(x)), and the inverse of the log in base ten function is the function ten to the power of. It is called (sometimes) the antilog

Ex:
Question What is the antilog of 3.5678?
Answer The antilog of 3.5678 is 10^(3.5678) = 3696.579068
Verification: log(3696.57908) =3.5678

Hope it helps.

Nov 29, 2009 | Texas Instruments TI-30XA Calculator

1 Answer

How do I enter an inverse log function into my claculator? for instance log-1(-.4/10)

Hello,
If you want to do correct mathematics you should strive to use the right words to express the concepts, and the right symbols too. While the logarithm function has an inverse function, it is never called an inverse log and it is never represented as log^-1. (I know you are going to protest and claim that the inverse of a sine function is represented on calculators by sin^-1. This a manufacturer shortcut, and we have no power to change that.) HP uses ASIN, ACOS, ATAN. These are still manufacturer shortcuts but they induce fewer errors.
Anyway, the logarithm functions do have inverse functions.

1. Natural loogarithm (ln)

The inverse of the natural log is the exponential.
ln(e^(x))=e^(ln(x)) =x

2. Common logarithm (logarithm in base 10)
The common logarithm has an inverse function, often called the antilogarithm or antilog.

There is an equivalence.
y=log(x) <--> x=10^(y)

From what I undesrtand of your exemple, you are looking for the antilog of the number -0.4/10 (or -0.04.)

-0.04= log(x), what is x?
You use the equivalence above to look for x as follows.
x=10^(-0.04) =0.9120108394.
Use the change sign (-) not the regular MINUS sign.

Take the log of the last result (still stored in Ans memory) and you get the original number.

Hope it helps.

Oct 26, 2009 | Texas Instruments TI-83 Plus Silver...

1 Answer

How do you compute Log base 5 to the exponent 5.9? i cant figure it out on this computer

Hello,
There is something missing in the formulation.

Any way you cannot calculate it directly on this calculator.You need to use the formula

log_5 (a)= ln(a) x log_5 (e) a is a positive integer

where log_5 means log in base 5 (my notation for the function)
e is the base of the natural logarithms (e=2.71928 )
ln is the natural log function

To obtain a more accurate value of e, calculate e^(1)
Here are some values of log(e) in different bases (for you to play with)

log_2(e)= 1.442695041
log_3(e)=0.9102392266
log_4(e)=0.7213475204
log_5(e)=0.6213349346
log_6(e)=0.5581106266
log_7(e)=0.5138983424
log_8(e)=0.4808983470
log_9(e)=0.4551196133
log_10(e)=log(e)=0.4342944819

If you have to use log in bases other than 10 or e, you will need a claculator that does that at the touch of a button. Some calculators that handle these calculations are the Casio FX-300ES, FX-115ES,FX-991ES, those called Natural Display, or WriteView(Sharp) or Textbook display.

Hope it helps.

Sep 03, 2009 | Texas Instruments TI-30XA Calculator

2 Answers

Help I dont know mutch of excel

If I am doing price analysis and have List Prices but want to formulate the whole sheet that it will calculate 30% of prices to give me trade prices

How can I do this

Sep 02, 2008 | Microsoft Excel for PC

Related Topics:

821 people viewed this question

Ask a Question

Usually answered in minutes!

Level 3 Expert

2983 Answers

Level 3 Expert

528 Answers

Level 3 Expert

18424 Answers

Loading...