Hi all,
I'd like to know what is the excel 'slope' formula in JMP. (not 'Bivariate' analysis menu)
If JMP does not have a formula format for 'slope', would you help me to make a JMP formula as below?
Slope
x | y | slop |
---|---|---|
1 | 1 | - |
2 | 2 | ? |
3 | 3 | ? |
4 | 4 | ? |
5 | 5 | ? |
6 | 6 | ? |
Hello,
You can create a column formula for calculating the slope as follows:
Col Sum( (:X - Col Mean( :X )) * (:Y - Col Mean( :Y )) ) /
Col Sum( (:X - Col Mean( :X )) ^ 2 )
Best,
Stan
Highly recommend to standardize least squares slopes and intercept as a built-in JMP function that can be used directly for formulaes ....
thanks for the post