https://community.jmp.com/t5/Discussions/Why-JMP-stores-simple-moving-average-forecast-for-n-1-period-in/m-p/543161#M76230 <P>Why JMP stores simple moving average forecast for n+1 period in nth period? For e.g I calculated SMA for 7 periods. I want forecast to appear in 8th row but it is appearing in 7th row.<span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="Screenshot 2022-09-11 at 14.21.33.png" style="width: 999px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/45355i985FCAD691A90A75/image-size/large?v=v2&amp;px=999" role="button" title="Screenshot 2022-09-11 at 14.21.33.png" alt="Screenshot 2022-09-11 at 14.21.33.png" /></span></P><P>&nbsp;</P> Fri, 09 Jun 2023 00:54:28 GMT abhinavsharma91 2023-06-09T00:54:28Z https://community.jmp.com/t5/Discussions/Why-JMP-stores-simple-moving-average-forecast-for-n-1-period-in/m-p/543161#M76230 <P>Why JMP stores simple moving average forecast for n+1 period in nth period? For e.g I calculated SMA for 7 periods. I want forecast to appear in 8th row but it is appearing in 7th row.<span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="Screenshot 2022-09-11 at 14.21.33.png" style="width: 999px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/45355i985FCAD691A90A75/image-size/large?v=v2&amp;px=999" role="button" title="Screenshot 2022-09-11 at 14.21.33.png" alt="Screenshot 2022-09-11 at 14.21.33.png" /></span></P><P>&nbsp;</P> Fri, 09 Jun 2023 00:54:28 GMT https://community.jmp.com/t5/Discussions/Why-JMP-stores-simple-moving-average-forecast-for-n-1-period-in/m-p/543161#M76230 abhinavsharma91 2023-06-09T00:54:28Z https://community.jmp.com/t5/Discussions/Why-JMP-stores-simple-moving-average-forecast-for-n-1-period-in/m-p/543813#M76269 <P>SMA is not a statistical forecasting method per se. But you can shift the column using the Lag function. Right click on the SMA(7) column and following the menu trail in this screenshot to get the desired result:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="peng_liu_0-1663026671465.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/45404i612F2370BE9A85E8/image-size/medium?v=v2&amp;px=400" role="button" title="peng_liu_0-1663026671465.png" alt="peng_liu_0-1663026671465.png" /></span></P> <P>And here is the result:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="peng_liu_1-1663026695470.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/45405iB163C5B88302E7C3/image-size/medium?v=v2&amp;px=400" role="button" title="peng_liu_1-1663026695470.png" alt="peng_liu_1-1663026695470.png" /></span></P> <P>&nbsp;</P> Mon, 12 Sep 2022 23:51:56 GMT https://community.jmp.com/t5/Discussions/Why-JMP-stores-simple-moving-average-forecast-for-n-1-period-in/m-p/543813#M76269 peng_liu 2022-09-12T23:51:56Z