Current location - Loan Platform Complete Network - Big data management - How to calculate scatter formula in excel
How to calculate scatter formula in excel
Select scatter plot-right click-add trend line-select formula type (linear, exponential, polynomial, etc. )-Select.

"Show Formula" and "Show R Square Value"-Formula and r2 appear.

Note that the closer r2 is to 1, the more accurate the formula is.

I hope my answer is helpful to you (I am aiming at 07

It is estimated that 03 is the same)

You can also send a request to our team, and there will be more professional people to answer your questions!

If my answer doesn't help you, please keep asking questions.