Subscribe Bookmark RSS Feed

excel slope formula in JMP

jameskim

Community Trekker

Joined:

May 17, 2012

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
stan_koprowski

Community Manager

Joined:

Aug 8, 2012

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

Community Trekker

Joined:

Apr 11, 2016

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