excel slope formula in JMP

[#1]

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	?

[#2]

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.

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

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

Best,

Stan

[#3]

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