Slope formula as Excel

Options
rhernandez
rhernandez Member, ALL USERS Posts: 3 New Contributor
in Planning & Modeling

Include in the formulas & functions  the formula named "SLOPE" 

the slope function : Returns the slope of the linear regression line through data points in known_y's and known_x's. The slope is the vertical distance divided by the horizontal distance between any two points on the line, which is the rate of change along the regression line.

Example:

In some cases my customers sends to me and excel file that needs to be replicated in anaplan, but their files includes the formula slope; currently in anaplan is very dificult to replicate it, so it would be very usefull to have a function that do this.

Below there is a link where you can find all the logic behind thie slope function.

 

https://support.office.com/en-us/article/slope-function-11fb8f97-3117-4813-98aa-61d7e01276b9

 

Tagged:

Categories