i have a x - y array of data. i want to like to fit as following:

I would like to fit it as :
y = a x + b tanh(c x) + d sinh(e x)
where a,b, c, d and e are the variables that I change to do the fittings.

=B$3*A11+B$4*TANH(B$5*A11)+B$6*SINH(B$7*A11)

image description

See sample file.

Tested with LibreOffice 6.4.7.2 (x86); OS: Windows 6.1.


Add Answer is reserved for solutions. If you think the answer is not satisfactory, add a comment below, or click edit (below your question) to add more information. Thanks.

If the answer helped you, you can mark the up arrow (Upvote mark) that is on the left (to vote, you need to have karma of at least 5).