Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

\\The U.S. Census Bureau publishes data on factory orders for all manufacturing,

ID: 3060428 • Letter: #

Question

The U.S. Census Bureau publishes data on factory orders for all manufacturing, durable goods, and nondurable goods industries. Shown here are factory orders in the United States over a 13-year period ($ billion).

4,137.0

Use these data to develop forecasts for the years 6 through 13 using a 5-year moving average.

F13= ? e13= ?

Use these data to develop forecasts for the years 6 through 13 using a 5-year weighted moving average.Weight the most recent year by 6, the previous year by 4, the year before that by 2, and the other years by 1. Compute the error of the forecast.

F13(weighted)=?    e13(weighted)=?

Year Factory Orders ($ billion) 1 2,512.7 2 2,739.2 3 2,874.9 4 2,934.1 5 2,865.7 6 2,978.5 7 3,092.4 8 3,356.8 9 3,607.6 10 3,749.3 11 3,952.0 12 3,949.0 13

4,137.0

Use these data to develop forecasts for the years 6 through 13 using a 5-year moving average.

F13= ? e13= ?

Use these data to develop forecasts for the years 6 through 13 using a 5-year weighted moving average.Weight the most recent year by 6, the previous year by 4, the year before that by 2, and the other years by 1. Compute the error of the forecast.

F13(weighted)=?    e13(weighted)=?

Explanation / Answer

Forecasts from year 6 to year 13 using 5 year weighted moving average.

Here F(13) = (3356.8 +3607.6 + 3749.30 + 3952.0 + 3949.0 )/5 = 3722.94

E(13) = 4137.0 - 3722.94 = 414.06

Year Factory Orders ($ billion) Weighted average Error 1 2,512.70 2 2,739.20 3 2,874.90 4 2,934.10 5 2,865.70 6 2,978.50 2,785.32 193.18 7 3,092.40 2,878.48 213.92 8 3,356.80 2,949.12 407.68 9 3,607.60 3,045.50 562.10 10 3,749.30 3,180.20 569.10 11 3952 3,356.92 595.08 12 3949 3,551.62 397.38 13 4137 3,722.94 414.06