Consider the following data on y and x that also appear on the text website, lab

Question

Consider the following data on y and x that also appear on the text website, labeled Exercise 18.36 1 56.96 9,171.61 2 57 28 9,286.56 3 57.79 9,320.19 4 56.50 9,280.97 5 5480 9,256.26 6 54.92 9,370.07 53.15 9,337.95 8 53.35 9,241.45 9 53.91 9,361.61 10 52.74 9,398.19 11 52.09 9,135.34 12 51.99 9,217.94 Click here for the Excel Data File a. Estimate y-Po+ or-1 + Negative values should be indicated by a minus sign. Round your answers to 4 decimal places.) recast = b. Estimate y,-A + 'y-1 + (Round your answers to 4 decimal places.) y-forecast y-t c. Estimate y,-A + 1Xy1 + Ay-1 + (Negative values should be indicated by a minus sign. Round your answers to 4 decimal places.) y-forecast 1-00056 xmt O 9124 y-, d. Use the most suitable model to make a one-step-ahead forecast ( 13) for y (Round intermediate calculations to 4 decimal places and final answer to 2 decimal places.) y-forecast 52 62 References eBook &Resources; Worksheet

Explanation / Answer

Solution -

A. After running the data regression in excel, we find the following forcasting equation-

yt = 113.6 - 0.0064 xt-1

B.  After running the data regression in excel, we find the following forcasting equation-

yt = 3.9326 + 0.9201 yt-1

C. After running the data regression in excel, we find the following forcasting equation-

yt = 56.801 + 0.9124 yt-1 - 0.00565 xt-1

D. Value of cooficient of determination R2 for the above three models are -

1. 0.0666

2. 0.8137

3. 0.866

So the best model is in part C

when t=13

then -

y13 = 56.801 + 0.9124 yt2 - 0.00565 x12

= 56.801 + 0.9124 * 51.99 - 0.00565 * 9217.94

= 52.16

Answer

TY!

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.