Apple numbers User Manual
Chapter 12
Dictionary of Functions
273
SLOPE
The SLOPE function calculates the slope of the best-fit line for the data set based on
linear regression analysis.
linear regression analysis.
SLOPE(y-range, x-range)
 y-range: A range of cells containing the dependent variable y. Must be the same size
as x-range.
 x-range: A range of cells containing the independent variable x. Must be the same
size as y-range.
Notes
To find the y-intercept of the best-fit line, use the INTERCEPT function.
To find the y-intercept of the best-fit line, use the INTERCEPT function.
SMALL
The SMALL function retrieves the nth-smallest value in a range. The smallest value is
ranked number 1.
ranked number 1.
SMALL(range, rank)
 range: The array of cells containing the values.
 rank: A number representing the rank of the value you want to return (smallest is
 rank: A number representing the rank of the value you want to return (smallest is
ranked 1, second-smallest is ranked 2, and so on).
Notes
If rank is omitted, is less than or equal to 0, or is greater than the number of values in
the array, an error is returned.
If rank is omitted, is less than or equal to 0, or is greater than the number of values in
the array, an error is returned.
Examples
Given the following table:
SLOPE(A2:F2, A1:F1) returns 2.
INTERCEPT(A2:F2, A1:F1) returns 1.
SLOPE(A5:F5, A4:F4) returns 0.402.