Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

How To Prepare Perform And Pass An ISO 9001 2015 Audit

Authors: Rhys J Mitchell

2020 Edition

B085KBSW66, 979-8618615969

More Books

Students also viewed these Accounting questions

Question

The amount of work I am asked to do is reasonable.

Answered: 1 week ago

Question

The company encourages a balance between work and personal life.

Answered: 1 week ago