Question: PPlease find if there is a trend, forecast value on now month and forecast when in date and month when control limit of 1 will
PPlease find if there is a trend, forecast value on now month and forecast when in date and month when control limit of 1 will come.
| Xi-Xavg | Time | value | Yi-Yavg | (Yi-Yavg)*(Xi-Xavg) | (Y-mx-c)/(n-2) | ||
| -223.3333333 | 1-Jan-18 | 0.55 | -0.1 | 22.33333333 | 0.001261655 | ||
| -133.3333333 | 1-Apr-18 | 0.64 | -0.01 | 1.333333333 | 0.000812002 | ||
| -44.33333333 | 29-Jun-18 | 0.68 | 0.03 | -1.33 | 0.001831823 | ||
| 44.66666667 | 26-Sep-18 | 0.65 | 0 | 0 | 0.000166308 | ||
| 133.6666667 | 24-Dec-18 | 0.65 | 0 | 0 | 0.001489334 | ||
| 222.6666667 | 23-Mar-19 | 0.73 | 0.08 | 17.81333333 | 0.000246875 | ||
| 0 | 0 | 0 | 0 | ||||
| 0 | 0 | 0 | 0 | ||||
| 0 | 0 | 0 | 0 | ||||
| SUMSQ | AVERAGE | ||||||
| 139063.3333 | 12-Aug-18 | 0.65 | value forecast | SUM | 40.15 | SUM | 0.005807998 |
| NOW() | 26-09-2020 12:24 | 0.87 | value forecast | ||||
| 6 | s2 | 0.001451999 | |||||
| _ | 4 | s | 0.03810511 | ||||
| 0.000289 | |||||||
| -11.85848762 | s(b1) | 0.000102183 | |||||
| statistical | |||||||
| Ans I | Test | TREND | t0.95 | 2.776445105 | |||
| VALUE | DATE/TIME | ||||||
| 1 | FORECAST DATE/TIME | 6-Dec-21 | t0.95*s(b1) | 0.000283704 |
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
