I would like to ask about an EXCEL curve fitting formula. I cannot get the value of Y by substituting the values of X (0, 150, 300). The value of Y is not correct.

QWE4562009

I would like to ask about an EXCEL curve fitting formula. I cannot get the value of Y by substituting the values of X (0, 150, 300). The value of Y is not correct. [Copy link]

I have a question about an EXCEL curve fitting formula. I can't get the value of Y by substituting the values of X as 0, 150, and 300. The value of Y is incorrect. What is wrong? If any forum friends know, please enlighten me.

吾妻思萌

How can a quadratic function be a straight line?

Jacktang

The formula may be incorrect.

秦天qintian0303

Why not get a Matlab, it is so convenient, with various fitting algorithms

littleshrimp

How do you write an EXCEL formula?

QWE4562009

Qintianqintian0303 posted on 2022-7-16 22:05 Why not get a matlab, it's so convenient, with various fitting algorithms

The key is not to do that kind of stuff.

QWE4562009

littleshrimp posted on 2022-7-17 07:05 How do you write an EXCEL formula

EXCEL function self-generated

QWE4562009

Jacktang posted on 2022-7-16 22:05 The formula input may be incorrect

Already done

秦天qintian0303

QWE4562009 posted on 2022-7-22 18:11 The key is not to do that thing

The simple function is quite simple. Enter two rows of parameters and the cftool command will go directly to the fitting interface.

Jacktang

QWE4562009 posted on 2022-7-22 18:12 It's done

I'd like to know how you did it, please share.

QWE4562009

Jacktang posted on 2022-7-24 10:02 I really want to know how you did it. Welcome to share your experience

To select XY Scatter Chart