Syntax LOG number base Arguments. Simply speaking taking the log value of a large number such as the number of cells killed in a disinfectant test transforms it into a smaller one that is easier to work with. A practical guide on how to calculate AUC from pharmacokinetic data.
The Excel LOG function returns the logarithm of a given number using a supplied base.
Suppose we have the Xs values located in the excel sheet range from A1 to A10 and Ys values located in the given excel sheet from range B1 to B10 then we can calculate the SLOPE here by using the below VBA functions. It is used to calculate the arithmetic mean of a given set of arguments. ROUNDLOGA620 The result could be in decimal so we have rounded the result of 0 places of digits. Log both OD and the concentration to plot out a linear standard equation yaxb next is to Log your sample OD y and calculate the x with the equation obtained next using the equation.