excel slope formula in JMP<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />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 | ? |
Re: excel slope formula in JMPHighly 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
Re: excel slope formula in JMPHello,
You can create a column formula for calculating the slope as follows:
- Create a new numeric column entitled Slope.
- Enter the formula for the slope as shown below.
- The Col Sum and Col Mean functions are found under the Statistical functions.
Col Sum( (:X - Col Mean( :X )) * (:Y - Col Mean( :Y )) ) /
Col Sum( (:X - Col Mean( :X )) ^ 2 )
Best,
Stan
