SLOPE

The SLOPE function returns the slope of the best-fit line for the set using linear regression analysis.

SLOPE(y-values, x-values)

y-values: The collection containing the y (dependent) values. y-values must contain number values, date/time values, or duration values. All values must be of the same value type.

x-values: The collection containing the x (independent) values. x-values must contain number values, date/time values, or duration values. All values must be of the same value type.

Notes

  • The two collections must be of the same size or the function returns an error.

  • If, for example, you had data on the driving speed of a vehicle and its fuel efficiency at each speed, fuel efficiency would be the dependent variable and driving speed would be the independent variable.

  • To find the y-intercept of the best-fit line, use the INTERCEPT function.

Example

Suppose you kept a record of the periodic changes in the price you paid for each delivery of heating oil and also the average temperature setting of your thermostat during the period covered by the specified price.

Given the following table:

A

B

1

Price

Setting

2

4.50

64

3

4.20

65

4

3.91

65

5

3.22

66

6

3.09

66

7

3.15

66

8

2.98

68

9

2.56

70

10

2.60

70

11

2.20

72

=SLOPE(B2:B11, A2:A11) returns approximately -3.23374495288702, indicating a best-fit line sloping downward (as prices rose, the setting on the thermostat was lowered).

See alsoINTERCEPT
Morty Proxy This is a proxified and sanitized view of the page, visit original site.
Kasulik?
Tähemärkide piirang: 250
Maksimaalne tähemärkide piirang on 250.
Täname tagasiside eest.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.