Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- JMP User Community
- :
- Discussions
- :
- Discussions
- :
- excel slope formula in JMP

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Oct 27, 2014 5:52 AM
(3032 views)

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 REPLIES

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Jun 14, 2016 5:59 AM
(2505 views)
| Posted in reply to message from stan_koprowski 10/27/2014 11:34 AM

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