topic Re: excel slope formula in JMP in Discussions https://community.jmp.com/t5/Discussions/excel-slope-formula-in-JMP/m-p/9968#M9739 <HTML><HEAD></HEAD><BODY><P>Highly recommend to standardize least squares slopes and intercept as a built-in JMP function that can be used directly for formulaes ....</P><P>thanks for the post</P></BODY></HTML> Tue, 14 Jun 2016 12:59:09 GMT altug_bayram 2016-06-14T12:59:09Z excel slope formula in JMP https://community.jmp.com/t5/Discussions/excel-slope-formula-in-JMP/m-p/9966#M9737 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I'd like to know what is the excel 'slope' formula in JMP.&nbsp;&nbsp;&nbsp; (not 'Bivariate' analysis menu)</P><P>If JMP does not have a formula format for 'slope',&nbsp; would you help me to make a JMP formula as below?</P><P></P><P>Slope<span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="7493_1.png" style="width: 125px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/937i612F50AC2D090FCF/image-size/medium?v=v2&amp;px=400" role="button" title="7493_1.png" alt="7493_1.png" /></span></P><P></P><P></P><TABLE border="1" class="jiveBorder" height="246" style="border: 1px solid rgb(0, 0, 0); width: 253px; height: 246px;"><TBODY><TR><TH style="padding: 2px; text-align: center; color: rgb(255, 255, 255); background-color: rgb(102, 144, 188);" valign="middle"><STRONG>x</STRONG></TH><TH style="padding: 2px; text-align: center; color: rgb(255, 255, 255); background-color: rgb(102, 144, 188);" valign="middle"><STRONG>y</STRONG></TH><TH style="padding: 2px; text-align: center; color: rgb(255, 255, 255); background-color: rgb(102, 144, 188);" valign="middle"><STRONG>slop </STRONG></TH></TR><TR><TD style="padding: 2px; text-align: center;">1</TD><TD style="padding: 2px; text-align: center;">1</TD><TD style="padding: 2px; text-align: center;">-</TD></TR><TR><TD style="padding: 2px; text-align: center;">2</TD><TD style="padding: 2px; text-align: center;">2</TD><TD style="padding: 2px; text-align: center;"><SPAN style="color: #ff0000;">?</SPAN></TD></TR><TR><TD style="padding: 2px; text-align: center;">3</TD><TD style="padding: 2px; text-align: center;">3</TD><TD style="padding: 2px; text-align: center;"><SPAN style="color: #ff0000;">?</SPAN></TD></TR><TR><TD style="padding: 2px; text-align: center;">4</TD><TD style="padding: 2px; text-align: center;">4</TD><TD style="padding: 2px; text-align: center;"><SPAN style="color: #ff0000;">?</SPAN></TD></TR><TR><TD style="padding: 2px; text-align: center;">5</TD><TD style="padding: 2px; text-align: center;">5</TD><TD style="padding: 2px; text-align: center;"><SPAN style="color: #ff0000;">?</SPAN></TD></TR><TR><TD style="padding: 2px; text-align: center;">6</TD><TD style="padding: 2px; text-align: center;">6</TD><TD style="padding: 2px; text-align: center;"><SPAN style="color: #ff0000;">?</SPAN></TD></TR></TBODY></TABLE></BODY></HTML> Tue, 18 Oct 2016 21:57:11 GMT https://community.jmp.com/t5/Discussions/excel-slope-formula-in-JMP/m-p/9966#M9737 Steve_Kim 2016-10-18T21:57:11Z Re: excel slope formula in JMP https://community.jmp.com/t5/Discussions/excel-slope-formula-in-JMP/m-p/9967#M9738 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>You can create a column formula for calculating the slope as follows:</P><OL><LI>Create a new numeric column entitled Slope.</LI><LI>Enter the formula for the slope as shown below.</LI><LI>The Col Sum and Col Mean functions are found under the Statistical functions.</LI></OL><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="7492_Screen Shot 2014-10-27 at 11.28.03 AM.png" style="width: 2030px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/938i38C0FB982801F880/image-size/medium?v=v2&amp;px=400" role="button" title="7492_Screen Shot 2014-10-27 at 11.28.03 AM.png" alt="7492_Screen Shot 2014-10-27 at 11.28.03 AM.png" /></span> </P><P>Col Sum( (:X - Col Mean( :X )) * (:Y - Col Mean( :Y )) ) /</P><P>Col Sum( (:X - Col Mean( :X )) ^ 2 )</P><P></P><P>Best,</P><P>Stan</P></BODY></HTML> Tue, 18 Oct 2016 21:57:20 GMT https://community.jmp.com/t5/Discussions/excel-slope-formula-in-JMP/m-p/9967#M9738 stan_koprowski 2016-10-18T21:57:20Z Re: excel slope formula in JMP https://community.jmp.com/t5/Discussions/excel-slope-formula-in-JMP/m-p/9968#M9739 <HTML><HEAD></HEAD><BODY><P>Highly recommend to standardize least squares slopes and intercept as a built-in JMP function that can be used directly for formulaes ....</P><P>thanks for the post</P></BODY></HTML> Tue, 14 Jun 2016 12:59:09 GMT https://community.jmp.com/t5/Discussions/excel-slope-formula-in-JMP/m-p/9968#M9739 altug_bayram 2016-06-14T12:59:09Z