Logarithmic regression Calculator

Analyzes the data table by logarithmic regression and draws the chart.

Logarithmic regression: y=A+Bln(x)
    1. (input by clicking each cell in the table below)

Guidelines for interpreting correlation coefficient r :
  0.7<|r|≦1        strong correlation
  0.4<|r|<0.7     moderate correlation
  0.2<|r|<0.4     weak correlation
  0≦|r|<0.2         no correlation

    Logarithmic regression
    [1-6] /6Disp-Num
    [1]  2019/04/26 02:54   Male / 30 years old level / High-school/ University/ Grad student / Useful /
    Purpose of use
    Org. Beh. Analysis of factors causing attrition.
    I have 1470 data points...would like a way to link to an excel input file or copy and past from excel.
    [2]  2019/02/28 00:28   Male / 20 years old level / An engineer / Very /
    Purpose of use
    Scale the work of a preweigh operators to better represent effort so we can better monitor performance
    [3]  2018/11/05 13:33   Male / 20 years old level / High-school/ University/ Grad student / Useful /
    Purpose of use
    Obtaining a more exact correlation between pitot tube position in a square air duct and the flow speed for the purpose of finding the volumetric flow rate of air in said duct. I'm a University senior pursuing a B.S. in Mechanical Engineering in a Thermo-Fluid Systems Lab.
    [4]  2018/09/21 23:14   Male / 40 years old level / A teacher / A researcher / Very /
    Purpose of use
    Allocate awards.
    [5]  2017/08/22 02:43   Male / 60 years old level or over / An engineer / Very /
    Purpose of use
    Frequency drift of a quartz crystal oscillator over extended time.
    The Log Regression showed much better correlation to my data than the "built-in" used in excel chart curve-fit utility.

    I am told there''s a better way to fit this particular data by using a "sum of log regressions", where 2 independent correlated variables that both follow log function can be modeled. I wold appreciate any feedback, but I''m afraid the details are unknown to me.
    [6]  2017/05/16 09:28   Male / Under 20 years old / High-school/ University/ Grad student / Very /
    Purpose of use


    Thank you for your questionnaire.
    Sending completion


    To improve this 'Logarithmic regression Calculator', please fill in questionnaire.
    Male or Female ?



    Purpose of use?
    Comment/Request (Click here to report a bug).Bug report (Click here to report questionnaire.)
    Calculation bug(Please enter information such as specific input values, calculation result, correct result, and reference materials (URL and documents).)
    Text bug(Please enter information such as wrong and correct texts)
    Your feedback and comments may be posted as customer voice.