Forum Discussion

Copper Contributor

Oct 21, 2022

Solved

Figuring out slope without Slope function

I am having to use a program for work that cannot use the slope function like in excel. I am trying to figure out the slope by calculating it out. Below is the x,y values to calculate slope. ...

Formulas and Functions

dscheikey

Oct 21, 2022

DNow5577

Hi Daniel, Sum und AVERAGE Spills, so you have 3 calculations.

This formula results in0.925:

=(((14-16.0667)*(15.34-17.11))+((16.7-16.0667)*(17.07-17.11))+((17.5-16.0667)*(18.92-17.11)))/(((14-16.0667)^2)+((16.7-16.0667)^2)+((17.5-16.0667)^2))

dscheikey

Bronze Contributor

Oct 21, 2022

DNow5577

Hi Daniel, Sum und AVERAGE Spills, so you have 3 calculations.

This formula results in0.925:

=(((14-16.0667)*(15.34-17.11))+((16.7-16.0667)*(17.07-17.11))+((17.5-16.0667)*(18.92-17.11)))/(((14-16.0667)^2)+((16.7-16.0667)^2)+((17.5-16.0667)^2))