Home : Slope
Q11272 - INFO: Slope

Slope returns the slope (the average value change per day) of the linear regression line for the variable (i.e. the m part of the equation y = mx + b).   

SYNTAX:

Slope(VarNum, Coefficient Minimum)

VarNum:   Variable Number

Coefficient Minimum: Optional. Sets the minimum acceptable Coefficient of Correlation.  If the Coefficient of Correlation is below this value, no forecast value will be calculated.  If left blank, the Slope value is always displayed.

 

EXAMPLES:

Slope(1,0.6) Calculates the slope for variable 1 for the date range of the report.   If the Coefficient of Correlation is below .6, no value will be calculated.

 

Related Articles
No Related Articles Available.

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
 
Approved Comments...
No user comments available for this article.
Created on 5/21/2008 9:22 PM.
Last Modified on 5/21/2008 9:22 PM.
Last Modified by Scott Dorner.
Article has been viewed 1366 times.
Rated 0 out of 10 based on 0 votes.
Print Article
Email Article