How to calculate total least squares regression in excel

Поделиться
HTML-код
  • Опубликовано: 16 апр 2024
  • =LET(xvalues,A2:A18,yvalues,B2:B18,w,DEVSQ(yvalues)-DEVSQ(xvalues),r,2*COVARIANCE.P(xvalues,yvalues)*COUNT(xvalues),(w+SQRT(w^2+r^2))/r)
  • НаукаНаука

Комментарии • 1

  • @ianl1052
    @ianl1052 Месяц назад

    I can't believe nobody has took the time to post a short comment yet.
    Your style makes a complex subject understandable. Thank you.
    Sadly, Help isn't working for me. I get the message "[Help] Sorry, something went wrong. Please check your network connection and try again." I must set aside some time and look into that.