SLOPE Excel Formula

Author Zaheer    Category Formulas     Tags ,

Microsoft Excel is indeed very helpful software program these days. It is equipped with lots of formulas and functions that can enable the users to perform simple and even complex tasks like mathematical calculations. One functions in MS Excel that has variety of usage is SLOPE function. This article will provide you relevant information about this function and some examples on how to apply it so you can easily learn and understand.

Overview of SLOPE Function with the MS Excel

SLOPE in the Excel is utilized to compute for slope in the linear regressions line all through the given set of an x- and a y- values. Formula of this function includes:

=SLOPE (known_y’s, known_x’s)

In this formula, arguments are the following:

  • Known_y’s – This is a required argument and it refers to the variety of known y-value.
  • Known_x’s – This is also a required argument and it refers to the variety of the known x-value.
  • You have to take note that known_x’s as well as known_y’s array must have similar length. In addition, variance of known_x’s should not be equivalent to zero.
  • Remarks in using SLOPE function with MS Excel
  • Slope is vertical distance which is divided by horizontal distance flanked by two given points along linear regressions line. This indicates the rates of change on regression line.
  • The arguments can be supplied as either cell reference which contains numbers, arrays, names, or actual numeric values.
  • If a reference or array argument includes blank cells, logical value or even text, those values will be ignored. But cells containingvalue of 0 are included.
  • The #NA! error value is displayed if known_x’s as well as known_y’s have dissimilar length or are empty.
  • Some Examples on the Application of SLOPE Function with MS Excel
  • For a better understanding about SLOPE function, this article will provide you some examples that will help you to easily learn and understand the usage of function.
  • For instance, you want to find slope of linear regressions line with these x- as well as y- values. Values for known_y’s are: 1, ,2, 3, 4; and values for known_x’s are: 5, 6, 7, 8. Then type in this formula in any cell where you want the result to appear, =SLOPE({1,2,3,4}, {5,6,7,8}). The function will instantly return the result which is 1.
  • Here’s another one, let’s say that you have these x or y values. For x, you have: 6, 5, 11, 7, 5, 4, 4; and for y, you have: 2, 3, 9, 1, 8, 7, 5. You can use this formula to calculate for slope ofregressions line, =SLOPE({2,3,9,1,8,7,5}, {6,5,11,7,5,4,4}). The function will return the result which is 0.306
  • Finally, let’s have this example. For instance, the following x-values are contained in cells F1 to F6: 1, 2, 3, 4, 5, 6; and the following y-values are contained in cells G1 to G6: 3, 7, 17, 20, 20, 27. You can enter this formula in any cell where you want the result where you want the result to be displayed, =SLOPE(G1:G6, F1:F6). The function will give a result of 4.6285714.

You can try working with the examples given above so that you could learn and understand more about the usage of SLOPE function with Microsoft Excel.

Post comment