cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Steve_Kim
Level III

excel slope formula in JMP

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?

Slope7493_1.png

xyslop
11-
22?
33?
44?
55?
66?
2 REPLIES 2
stan_koprowski
Community Manager Community Manager

Re: excel slope formula in JMP

Hello,

You can create a column formula for calculating the slope as follows:

  1. Create a new numeric column entitled Slope.
  2. Enter the formula for the slope as shown below.
  3. The Col Sum and Col Mean functions are found under the Statistical functions.

7492_Screen Shot 2014-10-27 at 11.28.03 AM.png

Col Sum( (:X - Col Mean( :X )) * (:Y - Col Mean( :Y )) ) /

Col Sum( (:X - Col Mean( :X )) ^ 2 )

Best,

Stan

altug_bayram
Level IV

Re: excel slope formula in JMP

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