Homework Answers
Add Answer to:
This is a table to show how to calculate a three-month moving average. Please use this...
Use a three-period simple moving average and weighted-moving average and Naive methods to forecast the 8th...
Use a three-period simple moving average and weighted-moving average and Naive methods to forecast the 8th month. Calculate and compare the MAD for methods. Month Sales MA AD WMA AD Naive AD 1 20 --- --- --- --- --- --- 2 25 --- --- --- --- --- --- 3 22 --- --- --- --- --- --- 4 26 5 22 6 24 7 26 8 ---- ? ? AD: Absolute Deviation MA: Moving Average WMA: Weighted Moving Average
VORE Senty Editor Use a three period simple moving average and weighted-moving average and Naive methods...
VORE Senty Editor Use a three period simple moving average and weighted-moving average and Naive methods to forecast the 8th month Calculate and compare the MAD for methods AD WMA AD Naive AD Month Sales MA 1 20 2 25 3 22 4 26 5 22 6 24 7 26 8 ? AD: Absolute Deviation MA: Moving Average WMA: Weighted Moving Average
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...
Moving average (MA) Calculate the sales using 2, 3, 4, 5, and 6 month moving average...
Moving average (MA) Calculate the sales using 2, 3, 4, 5, and 6 month moving average values. Forecast and plot the upcoming period’s sales using the moving average series that fits best. Explain why you chose that particular MA. Why is it inadvisable to use the Moving Average approach to forecast far into the future? Month Sale Month Sale Month Sale Oct-12 13.30 Oct-13 24.01 Oct-14 50.56 Nov-12 1.70 Nov-13 32.67 Nov-14 60.06 Dec-12 11.44 Dec-13 23.19 Dec-14 61.73 Jan-13...
observation, and 1/6 for the third most recent observation, compute a three-week weighted moving average for...
observation, and 1/6 for the third most recent observation, compute a three-week weighted moving average for the time series. 2. a. Using a weight of 1/2 for the most recent observation, 1/3 for the second most recent Error Forecast Sales Week 17 21 19 23 18 16 20 18 10 20 15 12 b. Compute the MSE for the weighted moving average in part (a) MSE - c. Do you prefer this weighted moving average to the unweighted moving average...
How to compute the average speed for each location? for example the pair is the location. how can...
how to compute the average speed for each location?
for example the pair is the location. how can I get all the
locations of 1,2,3,4,5,6,7,8,9,10,11,12,13,14 and the speed for
each of them to find the mean.
I tried doing this
df4=df [df [ ['pair', 'speed']]==1].mean() #To get all the pairs
with 1's and it's speeds and getting the mean
df4=df [df [['pair','speed']]==2].mean() #To get all the pairs
with 2's and it's speeds and getting the mean
.
Unnamed: 0 speed...
A can opener manufacturer has had monthly sales for a seven-month period as follows: Month ...
A can opener manufacturer has had monthly sales for a seven-month period as follows: Month Sales (000 units) Feb. 19 Mar. 18 Apr. 15 May 20 Jun. 18 Jul. 22 Aug. 20 a) Plot the data b) Forecast September's sales volume and the previous months and calculate MAD for each method using each of the following: 1)The naïve approach. 2)A four-month moving average. 3)A weighted average using .50 for the recent month, .30 for 2 months ago, and .20...
You want to compare how two forecasting methods would perform on some historical sales data. You...
You want to compare how two forecasting methods would perform on
some historical sales data. You will forecast the sales for months
4 through 19, calculate the mean absolute deviation (MAD) for both
methods, and you can claim that the one that has lower MAD
performed better, at least for the historical data.
a) The first method is known as the moving average method. The
forecast for a month will be the average sales of three previous
months. So, forecast...
Question 3 part a & b. please show work! 3. The following time series shows the...
Question 3 part a & b. please show work!
3. The following time series shows the number of units of a particular product sold over the past six months. Units Sold Month (Thousands) 23 2 17 3 17 4 5 26 11 23 6 a. Use a = 0.2 to compute the exponential smoothing values for the time series, forecast the sales volume for month 7, and fill in the unknown spaces. Units Sold Forecast (F) error Squared error Month...
VORE Senty Editor Use a three period simple moving average and weighted-moving average and Naive methods to forecast the 8th month Calculate and compare the MAD for methods AD WMA AD Naive AD Month Sales MA 1 20 2 25 3 22 4 26 5 22 6 24 7 26 8 ? AD: Absolute Deviation MA: Moving Average WMA: Weighted Moving Average
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...
observation, and 1/6 for the third most recent observation, compute a three-week weighted moving average for the time series. 2. a. Using a weight of 1/2 for the most recent observation, 1/3 for the second most recent Error Forecast Sales Week 17 21 19 23 18 16 20 18 10 20 15 12 b. Compute the MSE for the weighted moving average in part (a) MSE - c. Do you prefer this weighted moving average to the unweighted moving average...
how to compute the average speed for each location?
for example the pair is the location. how can I get all the
locations of 1,2,3,4,5,6,7,8,9,10,11,12,13,14 and the speed for
each of them to find the mean.
I tried doing this
df4=df [df [ ['pair', 'speed']]==1].mean() #To get all the pairs
with 1's and it's speeds and getting the mean
df4=df [df [['pair','speed']]==2].mean() #To get all the pairs
with 2's and it's speeds and getting the mean
.
Unnamed: 0 speed...
You want to compare how two forecasting methods would perform on
some historical sales data. You will forecast the sales for months
4 through 19, calculate the mean absolute deviation (MAD) for both
methods, and you can claim that the one that has lower MAD
performed better, at least for the historical data.
a) The first method is known as the moving average method. The
forecast for a month will be the average sales of three previous
months. So, forecast...
Question 3 part a & b. please show work!
3. The following time series shows the number of units of a particular product sold over the past six months. Units Sold Month (Thousands) 23 2 17 3 17 4 5 26 11 23 6 a. Use a = 0.2 to compute the exponential smoothing values for the time series, forecast the sales volume for month 7, and fill in the unknown spaces. Units Sold Forecast (F) error Squared error Month...
Most questions answered within 3 hours.
-
1. When a nearsighted person looks at an object that is in the
distance with their...
asked 5 minutes ago -
QUESTION 8
Both of these statements will store the same value in the
variable $number
$number...
asked 29 minutes ago -
The price of 1 lb of potatoes is $1.75. If all the potatoes sold
today at...
asked 1 hour ago -
Garcia Company issues 20.00%, 15-year bonds with a par value of
$470,000 and semiannual interest payments....
asked 1 hour ago -
In C++ Programming, Try using loops only.
This lab demonstrates the use of the While Loop...
asked 2 hours ago -
Effect of DCMU and sodium azide on Chlamydomonas? We did an
experiment where we had Chlamydomonas...
asked 2 hours ago -
1a) According to the ideal gas law, _______________.
a. a gas has infinite volume at absolute...
asked 4 hours ago -
Oakdale Fashions, Inc. had $245,000 in 2018 taxable income.
Using the tax schedule in Table 2.3...
asked 4 hours ago -
The marketing class at CSUS had an average score of 150. An
educational analyst determined that...
asked 6 hours ago -
Justin Case has purchased a $250 000 home by putting 20 % down
and taking out...
asked 6 hours ago -
1. In a labor market, marginal cost for a firm is
____________.
a. recruiting cost
b....
asked 6 hours ago -
On January 1, 2019, ABC Company issued $60,000,000 of 20-year,
10.5% bonds when the market rate...
asked 7 hours ago