Reference no: EM131164096
Question 1
Determine the error for each of the following forecasts. Then, calculate MAD and MSE.
|
Period
|
Value
|
Forecast Error
|
|
1
|
202
|
-
|
|
2
|
191
|
202
|
|
3
|
173
|
192
|
|
4
|
169
|
181
|
|
5
|
171
|
174
|
|
6
|
175
|
172
|
|
7
|
182
|
174
|
|
8
|
196
|
179
|
|
9
|
204
|
189
|
|
10
|
219
|
198
|
|
11
|
227
|
211
|
Question 2
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).
First, use the data to develop forecasts for years 6 through 13 using a 5-year moving average. Unit 5 [GB513: Business Analytics]
|
Year
|
Factory orders
|
|
1
|
2,512.70
|
|
2
|
2,739.20
|
|
3
|
2,874.90
|
|
4
|
2,934.10
|
|
5
|
2,865.70
|
|
6
|
2,978.50
|
|
7
|
3,092.40
|
|
8
|
3,052.60
|
|
9
|
3,145.20
|
|
10
|
3,114.10
|
|
11
|
3,257.40
|
|
12
|
3,654.00
|
|
13
|
|
Then, use the data to develop forecasts for 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.
Answer the following questions:
a) What is the forecast for year 13 based on the 5-year moving average?
b) What is the forecast for year 13 based on the 5-year weighted moving average?
c) What is the MAD for the moving average forecast?
d) What is the MAD for the weighted moving average forecast?
e) Which forecasting model is better?
|
Year
|
Total Number of New Orders
|
|
1
|
55,022
|
|
2
|
55,921
|
|
3
|
64,182
|
|
4
|
76,003
|
|
5
|
87,327
|
|
6
|
85,139
|
|
7
|
99,513
|
|
8
|
115,109
|
|
9
|
116,251
|
|
10
|
121,547
|
|
11
|
123,321
|
|
12
|
141,200
|
|
13
|
162,140
|
|
14
|
168,420
|
|
15
|
171,250
|
|
16
|
176,355
|
|
17
|
195,204
|
|
18
|
209,389
|
|
19
|
237,025
|
|
20
|
272,544
|
|
21
|
293,475
|
|
Markets often produce result that are economically efficient
: Markets often produce results that are economically efficient which allows society to get the most use from scarce resources. What is the relationship between benefits and cost when this occurs? Why is price the critical factor insuring this result?
|
|
Multivitamin in the past months
: If you cannot, explain why. A survey of adults found that 54% have used a multivitamin in the past 12 months. You randonly select 60 adults and ask them if they have used a multivitamin in the past 12 months.
|
|
Average production and marginal production
: Discuss the concepts of total production, average production and marginal production. Relate production to cost and discuss how the ideas of total cost, average cost and marginal cost are used in decision making.
|
|
Calculate values of software science metrics
: Write a program in C to add two numbers and then calculate the values of the following software science metrics:
|
|
What is the mad for the moving average forecast
: What is the MAD for the moving average forecast? What is the MAD for the weighted moving average forecast? Which forecasting model is better? What is the forecast for year 13 based on the 5-year moving average?
|
|
How these theories can impact the adult children raised
: How these theories can impact the adult children raised in a polygamist families. A brief reference will just be fine.
|
|
Define the given performance appraisal errors
: Define the following types of performance appraisal errors: - Leniency. - Central tendency. - Recency. - Halo effect.
|
|
Find the probability that the fruit cup you select
: The dietary fiber content and other essential nutrients in the fruit cup can be approximately by the normal distribution with population mean= 200 and standard deviation = 5. Find the probability that the fruit cup you select will contain more tha..
|
|
Investment in a continuously-compounding account
: 1.You want to make an investment in a continuously-compounding account over a period of three years. What interest rate is required for your investment to double in that time period? Round the logarithm value and the answer to the nearest tenth.
|