Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started