excel slope formula in JMP

Question

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

xyslop 11-22?33?44?55?66?

altug_bayram · Answer

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

stan_koprowski · Answer

Hello,

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