Data360 Analyze

Welcome to the Data360 Analyze community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Here are some useful links where you can find more information:

Product Announcements  Product Documentation  Ideas Portal

Discussions

Members

Resources

Events

 View Only

  • 1.  Exponential function and natural logarithm

    Employee
    Posted 01-31-2017 03:51

    Hi,

    What is the easiest way to calculate exponential function and natural logarithm in Dataverse? In a typical spreadsheet program you would typically use EXP() and LN() formulas. Is it as easy in Dataverse?



  • 2.  RE: Exponential function and natural logarithm

    Employee
    Posted 01-31-2017 07:26

    Dataverse has pow() and log()  you can compute the exp() and ln() with two simple formulas.

    e=2.718281828459045   #add more digits as necessary for acuracy

    ln(x) = log(x) / log(e)

    exp(x) = pow(e,x)

     

    You can also use

    n=1000000000 #add more digits as necessary for acuracy
    e = pow((1+1/n),n)

    to compute the value of e