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

Showing results for

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

News

On June 1, we’re asking you to select a content label when starting a new topic in the Discussions area. Read more to find out why.

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

Highlighted
##

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

excel slope formula in JMP

Oct 27, 2014 5:52 AM
(4791 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 2

Highlighted
##

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

Re: excel slope formula in JMP

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

Highlighted
##

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

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