known_ys – an array or range of cells containing dependent numeric values (y).The parameters of the function are: =SLOPE(known_ys,known_xs) To get a slope value in Excel, you can use the SLOPE function. To give you a practical example, suppose we have the data from 100 households about the monthly income and expenses.Īssuming that the slope value of this dataset is 0.9, it tells us that when the income increases by 100 dollars, the expense increases by 90 dollars. This way you can get a better insight into a dependency between two coordinates. In the other words, a slope can tell you how much y value changes as value x increases.
In statistics, you can often get a task to calculate a slope of a line based on values generated by two coordinates (x and y). Some Error When Using the SLOPE function.
0 kommentar(er)
