https://community.jmp.com/t5/Discussions/95-confidence-interval-calculation-from-profile-for-Excel/m-p/448602#M69542 <P>Hello&nbsp;<a href="https://community.jmp.com/t5/user/viewprofilepage/user-id/7952">@nac</a>&nbsp;,</P> <P>&nbsp;</P> <P>If I understand you correctly your goal is to take the model you created in JMP and score it in Excel.&nbsp; If so you should be able to save the formula for the confidence limits directly from the nonlinear platform and then recreate the column formulas just like you did for the prediction.</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="ih_0-1641221972731.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/38697i64FE2951C8CE832B/image-size/medium?v=v2&amp;px=400" role="button" title="ih_0-1641221972731.png" alt="ih_0-1641221972731.png" /></span></P> <P>&nbsp;</P> Mon, 03 Jan 2022 15:00:38 GMT ih 2022-01-03T15:00:38Z https://community.jmp.com/t5/Discussions/95-confidence-interval-calculation-from-profile-for-Excel/m-p/448084#M69497 <P>Dear all,</P><P>One of my friend doesnt have jmp. I prepared an excel for it. But I just calculate prediction value from equation. I do not calculate 95% upper lower prediction of model in excel. Could you please inform how can i calculate 95%range of prediction model in excel. I used nonlinear part of jmp.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="nac_0-1640613040817.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/38660i873D01A0B8F7C4A2/image-size/medium?v=v2&amp;px=400" role="button" title="nac_0-1640613040817.png" alt="nac_0-1640613040817.png" /></span></P><P>Thanks anyone help to solve this issue.</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Sat, 10 Jun 2023 23:42:04 GMT https://community.jmp.com/t5/Discussions/95-confidence-interval-calculation-from-profile-for-Excel/m-p/448084#M69497 nac 2023-06-10T23:42:04Z https://community.jmp.com/t5/Discussions/95-confidence-interval-calculation-from-profile-for-Excel/m-p/448602#M69542 <P>Hello&nbsp;<a href="https://community.jmp.com/t5/user/viewprofilepage/user-id/7952">@nac</a>&nbsp;,</P> <P>&nbsp;</P> <P>If I understand you correctly your goal is to take the model you created in JMP and score it in Excel.&nbsp; If so you should be able to save the formula for the confidence limits directly from the nonlinear platform and then recreate the column formulas just like you did for the prediction.</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="ih_0-1641221972731.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/38697i64FE2951C8CE832B/image-size/medium?v=v2&amp;px=400" role="button" title="ih_0-1641221972731.png" alt="ih_0-1641221972731.png" /></span></P> <P>&nbsp;</P> Mon, 03 Jan 2022 15:00:38 GMT https://community.jmp.com/t5/Discussions/95-confidence-interval-calculation-from-profile-for-Excel/m-p/448602#M69542 ih 2022-01-03T15:00:38Z