Monthly gold prices. The fluctuation of gold prices is a reflection of the stren

Question

Monthly gold prices. The fluctuation of gold prices is a reflection of the strength or weakness of the U.S. dollar. The table below shows monthly gold prices from January 1998 to December 2005. The data is shared with “goldmon” data sheet.

A. Use exponential smoothing with w=.5 to calculate monthly smoothed values from 1998 to 2004. Then forecast the monthly gold prices for 2005.

B. Repeat part a using the Holt-Winters technique with w = .5 and v = .5.

Kindly use minitab in answering this question .Please answer ASAP.

Month Y1998 Y1999 Y2000 Y2001 Y2002 Y2003 Y2004 Y2005 Jan 304.9 285.4 284.3 265.5 281.7 356.9 414 424.2 Feb 297.4 287.1 299.9 261.9 295.5 359 405.3 423.4 Mar 301 279.5 286.4 263 294 340.6 406.7 434.2 Apr 310.7 286.6 279.9 260.5 302.7 328.2 403 428.9 May 293.6 269 275.3 272.4 314.5 355.7 383.4 421.9 Jun 296.3 262.6 285.7 270.2 321.2 356.5 392 430.7 Jul 288.9 255.6 281.6 267.5 313.3 351 398.1 424.5 Aug 273.4 254.8 274.5 272.4 310.3 359.8 400.5 437.9 Sep 293.9 307.5 273.7 283.4 319.2 378.9 405.3 456 Oct 294 299.1 270 283.1 316.6 378.9 420.5 469.9 Nov 294.7 291.4 266 276.2 319.2 389.9 439.4 476.7 Dec 287.8 290.3 271.5 275.9 333.4 407.6 441.7 509.8

Explanation / Answer

A)

b)

Month Y1998 Y1999 Y2000 Y2001 Y2002 Y2003 Y2004 Y2005 Exp Smooth 1998 Exp Smooth 1999 Exp Smooth 2000 Exp Smooth 2001 Exp Smooth 2002 Exp Smooth 2003 Exp Smooth 2004 Forecast 2005 Jan 304.9 285.4 284.3 265.5 281.7 356.9 414 424.2 300.65 278.3667 285.25 265.5833 301.6 349.4833 400.7333 426.9431 Feb 297.4 287.1 299.9 261.9 295.5 359 405.3 423.4 302.775 281.8833 284.775 265.5417 291.65 353.1917 407.3667 426.9175 Mar 301 279.5 286.4 263 294 340.6 406.7 434.2 300.0875 284.4917 292.3375 263.7208 293.575 356.0958 406.3333 430.3595 Apr 310.7 286.6 279.9 260.5 302.7 328.2 403 428.9 300.5438 281.9958 289.3688 263.3604 293.7875 348.3479 406.5167 429.0687 May 293.6 269 275.3 272.4 314.5 355.7 383.4 421.9 305.6219 284.2979 284.6344 261.9302 298.2438 338.274 404.7583 422.7219 Jun 296.3 262.6 285.7 270.2 321.2 356.5 392 430.7 299.6109 276.649 279.9672 267.1651 306.3719 346.987 394.0792 423.3521 Jul 288.9 255.6 281.6 267.5 313.3 351 398.1 424.5 297.9555 269.6245 282.8336 268.6826 313.7859 351.7435 393.0396 428.091 Aug 273.4 254.8 274.5 272.4 310.3 359.8 400.5 437.9 293.4277 262.6122 282.2168 268.0913 313.543 351.3717 395.5698 436.982 Sep 293.9 307.5 273.7 283.4 319.2 378.9 405.3 456 283.4139 258.7061 278.3584 270.2456 311.9215 355.5859 398.0349 456.6557 Oct 294 299.1 270 283.1 316.6 378.9 420.5 469.9 288.6569 283.1031 276.0292 276.8228 315.5607 367.2429 401.6674 467.9371 Nov 294.7 291.4 266 276.2 319.2 389.9 439.4 476.7 291.3285 291.1015 273.0146 279.9614 316.0804 373.0715 411.0837 483.1649 Dec 287.8 290.3 271.5 275.9 333.4 407.6 441.7 509.8 293.0142 291.2508 269.5073 278.0807 317.6402 381.4857 425.2419 505.9064

Related Questions

Navigate

• Browse (All)
• Browse M
• Subjects

---

---

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