Does anyone know if there is an inverse log function in Excel? I found a LOGINV function but it asked for parameters I'm not familiar with. I'm using a dB loss equation "dB = Log(Pout/Pin)*10" rearranged to calculate expected output power given the nominal dB loss and input power so I need to...
The only standard inverse log function that I know of in Excel is LOGINV the log normal sum of the distribution of x. LOGINV (probability [log normal distribution where P>0 or P<1], mean [of In (x)], standard_dev [SD of In (x) where SD>0]) The regular LOG function will allow for user defined powers and bases.
NORMINV - Returns the inverse of the normal cumulative distribution (Statistical) NORMSDIST - Returns the standard normal cumulative distributionIn Excel 2007, this is a Statistical function.
in excel you have the function for normal standard inverse distribution. i need to pragram that function in visual basic. does anybody have the code???. thanks!!!
But in VBA code LN (num) gives compile error: "Sub or Function not defined". LOG (num,base) gives compile error: "Wrong number of arguments or invalid property assignment".
Does anyone know how to have a formula in cell AH71 that will reference a number in a cell AH70 and just return the inverse of the number. For example if AH70 is a negative -550,000 to just return the value 550,000. There are a number of ways to do this but is there just a simple Inverse formula?
PERCENTRANK.INC also gives .9670. PERCENTILE.INC gives back 931.64. (a slightly different answer). So, it is a bit closer to the original value of 936.25...but it is still not behaving as an inverse, that one undoes the other. Anybody out there with any further knowledge of this sort of numerical matter? Thanks!
I am doing work with confidence intervals for normally distributed data and I want to be able to calculate specific intervals (such as .92, etc). If x is the mean and y is the std dev I know that CI=(x-ny,x+ny), where n=sqrt(2)*inverseERF(CI). I tried to make a vba function to calculate the...
