Calculates the slope of the line resulting from linear regression of a dataset.
data_y- The range representing the array or matrix of dependent data.
data_x- The range representing the array or matrix of independent data.
- Any text encountered in the
valuearguments will be ignored.
In order to use the SLOPE formula, start with your edited Excellentable
Then type in the SLOPE Formula in area you would like to display the outcome:
Type in the complete SLOPE formula for a cell as shown below:
Excellentable will generate the outcome when hitting enter.