Homework Answers
Add Answer to:
Question 3 Calculate a set of moving averages of period: (a) 3 (b) 5 for the following time serie...
1.- Using time series shown in the table a) Determine if moving averages is an adequate...
1.- Using time series shown in the table a) Determine if moving averages is an adequate method to use for the time series shown in the table. b) If the answer to a) is YES, then apply the weighted moving averages method using alpha1 = 0.5 alpha2 = 0.4 alpha3 = 0.1 Week Demand 1 200 2 250 3 175 4 186 5 225 6 240 7 250 8 190 9 185 10 210 11 205 12 207 13
Problem 08-06 Algo (Moving Averages and Exponential Smoothing) Consider the following time series data: Month 1...
Problem 08-06 Algo (Moving Averages and Exponential
Smoothing)
Consider the following time series data:
Month
1
2
3
4
5
6
7
Value
23
13
21
13
19
21
17
(a) Choose the correct time series plot Month (iv) Month Select your answer What type of pattern exists in the data? Select your answer- (b) Develop a three-month moving average for this time series. Compute MSE and a forecast for month 8. If required, round your answers to two decimal...
Moving Averages. Use the below actual sales to calculate a three-year average which will be used as...
Moving Averages. Use the below actual sales to calculate a three-year average which will be used as the forecast for next periods (chapter 14, text). Exponential Smoothing. Use the same data to forecast sales for the next periods with α=.40 (chapter 14, text) Month Actual Sales 1 3050 2 2980 3 3670 4 2910 5 3340 6 4060 7 4750 8 5510 9 5280 10 5504 11 5810 12 6100
1. Compute Three- week and five-week moving averages for the time series. 2. Compute the MSE for Three- week and five-week moving average forecasts. 3. What appears to be the best number of weeks...
1. Compute Three- week and five-week moving averages for the time series. 2. Compute the MSE for Three- week and five-week moving average forecasts. 3. What appears to be the best number of weeks of past data (three or five) to use in the moving average computation? Week Sale (1000s of Gallons) three-week five-week 17 21 19 23 18 16 20 18 10 20 15 12 31 34 31 14 15 16 17 18 19 20 28 32 29 34...
1. Compute Three- week and five-week moving averages for the time series. 2. Compute the MSE...
1. Compute Three- week and five-week moving averages for the time series. 2. Compute the MSE for Three- week and five-week moving average forecasts. 3. What appears to be the best number of weeks of past data (three or five) to use in the moving average computation? Week Sale (1000s of Gallons) three-week five-week 17 21 19 23 18 16 20 18 10 20 15 12 31 34 31 14 15 16 17 18 19 20 28 32 29 34...
In Excel, create a forecast for periods 6-13 using the following method: 5 period simple moving...
In Excel, create a forecast for periods 6-13 using the following method: 5 period simple moving average. Using a 5 period simple moving average, the forecast for period 13 will be: Period Data 1 45 2 52 3 48 4 59 5 55 6 55 7 64 8 58 9 73 10 66 11 69 12 74
Question 2 Calculate a set of trend values using the method of semi-averages, for the following...
Question 2 Calculate a set of trend values using the method of semi-averages, for the following data: 16, 12, 15, 14, 18, 12, 14, 13, 18, 13
Please use Excel Solver. Consider the following set of time series sales data for a growing...
Please use Excel Solver.
Consider the following set of time series sales data for a growing company over the past 8 months: Month Sales 1 15 2 13 18 4 22 20 6 23 7 22 8 21 1. Construct a time series plot. What type of pattern exists? 2. Develop a forecast for the next month using the averaging method. 3. Develop a forecast for the next month using the naïve last-value method. 4. Develop a forecast for the...
Consider the following time series data. t 1 ය 6 11 2 4 5 Y 9...
Consider the following time series data. t 1 ය 6 11 2 4 5 Y 9 13 15 a. Which of the following is a correct time series plot for this data? 1. TimeSeries Value 14 -12 10 te 16 -4 F2 3 Time Period/t) 2. TimeSeries Value +14 +12 10 18 6 -4 1 3 Time Period (t) 3. TimeSeries Value F14 +12 10 18 6 -4 2 2 Time Period (t) - Select your answer. What type of...
(CO 2) Using the table Gasoline Sales Time Series, calculate the mean absolute deviation for a 3-day moving average. Gasoline Sales Time Series Sales (000's of gallons) Week 17 21 2 19 3 23 4 18...
(CO 2) Using the table Gasoline Sales Time Series, calculate the mean absolute deviation for a 3-day moving average. Gasoline Sales Time Series Sales (000's of gallons) Week 17 21 2 19 3 23 4 18 16 6 20 18 8 9 20 10 15 12 ○ 2.50 ○ 2.62 О 3.00 О 2.67
(CO 2) Using the table Gasoline Sales Time Series, calculate the mean absolute deviation for a 3-day moving average.
Gasoline Sales Time Series Sales (000's of...
Problem 08-06 Algo (Moving Averages and Exponential
Smoothing)
Consider the following time series data:
Month
1
2
3
4
5
6
7
Value
23
13
21
13
19
21
17
(a) Choose the correct time series plot Month (iv) Month Select your answer What type of pattern exists in the data? Select your answer- (b) Develop a three-month moving average for this time series. Compute MSE and a forecast for month 8. If required, round your answers to two decimal...
1. Compute Three- week and five-week moving averages for the time series. 2. Compute the MSE for Three- week and five-week moving average forecasts. 3. What appears to be the best number of weeks of past data (three or five) to use in the moving average computation? Week Sale (1000s of Gallons) three-week five-week 17 21 19 23 18 16 20 18 10 20 15 12 31 34 31 14 15 16 17 18 19 20 28 32 29 34...
1. Compute Three- week and five-week moving averages for the time series. 2. Compute the MSE for Three- week and five-week moving average forecasts. 3. What appears to be the best number of weeks of past data (three or five) to use in the moving average computation? Week Sale (1000s of Gallons) three-week five-week 17 21 19 23 18 16 20 18 10 20 15 12 31 34 31 14 15 16 17 18 19 20 28 32 29 34...
Question 2 Calculate a set of trend values using the method of semi-averages, for the following data: 16, 12, 15, 14, 18, 12, 14, 13, 18, 13
Please use Excel Solver.
Consider the following set of time series sales data for a growing company over the past 8 months: Month Sales 1 15 2 13 18 4 22 20 6 23 7 22 8 21 1. Construct a time series plot. What type of pattern exists? 2. Develop a forecast for the next month using the averaging method. 3. Develop a forecast for the next month using the naïve last-value method. 4. Develop a forecast for the...
Consider the following time series data. t 1 ය 6 11 2 4 5 Y 9 13 15 a. Which of the following is a correct time series plot for this data? 1. TimeSeries Value 14 -12 10 te 16 -4 F2 3 Time Period/t) 2. TimeSeries Value +14 +12 10 18 6 -4 1 3 Time Period (t) 3. TimeSeries Value F14 +12 10 18 6 -4 2 2 Time Period (t) - Select your answer. What type of...
(CO 2) Using the table Gasoline Sales Time Series, calculate the mean absolute deviation for a 3-day moving average. Gasoline Sales Time Series Sales (000's of gallons) Week 17 21 2 19 3 23 4 18 16 6 20 18 8 9 20 10 15 12 ○ 2.50 ○ 2.62 О 3.00 О 2.67
(CO 2) Using the table Gasoline Sales Time Series, calculate the mean absolute deviation for a 3-day moving average.
Gasoline Sales Time Series Sales (000's of...
Most questions answered within 3 hours.
-
2) You are given the task of finding a representation for a
circle in a drawing...
asked 24 seconds ago -
1. An object weighing 40 N rests on a surface. The coefficient
of friction is 0.35....
asked 1 hour ago -
Investor company owns 35% of investee company voting stock and
accounts for the investment under the...
asked 2 hours ago -
The number of major faults on a randomly chosen 1 km stretch of
highway has a...
asked 2 hours ago -
Consider the competitive environment of Starbuck's, Progressive
Insurance, a manufacturing firm with low turnover, or a...
asked 3 hours ago -
3. Gains from trade
Consider two neighbouring island countries called Euphoria and
Contente. They each have...
asked 5 hours ago -
A business executive has the option to invest money in two
plans: Plan A guarantees that...
asked 7 hours ago -
Hello, can someone please help me answer this question?
How much heat is absorbed by a...
asked 7 hours ago -
. A marketing researcher conducted a survey of 25 shoppers
randomly selected at the local mall...
asked 7 hours ago -
Create an comprehensive response to the
following:
Antimicrobial agents work on a multitude of microbes (bacteria,...
asked 7 hours ago -
6.13 LAB: Step counter. Section 6.3.
A pedometer treats walking 2,000 steps as walking 1 mile....
asked 7 hours ago -
(14.2) A block of mass m = 10 kg riding on a frictionless
horizontal plane is...
asked 7 hours ago