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.
-
After watching the lectures I am still having a hard time
understanding these equations.
1. The...
asked 55 minutes ago -
Testing:
H0:μ=56.9
H1:μ<56.9
Your sample consists of 23 subjects, with a mean of 56.3 and
standard...
asked 58 minutes ago -
straight wire, labeled as Wire A, lies horizontally on a
tabletop and is oriented to run...
asked 59 minutes ago -
For a Chi-Squared Goodness of Fit Test about a uniform
distribution, complete the table.
Round to...
asked 1 hour ago -
Milk of magnesia is only slightly soluble in water. Kc for the
reaction Mg(OHs)(s)>Mg2+(a) + 2OH-1(aq)...
asked 1 hour ago -
Excel's HYPGEOM.DIST function can be used to compute _____.
a. both hypergeometric probabilities and cumulative
hypergeometric...
asked 1 hour ago -
The rocket used for the human lunar missions was the Saturn V
rocket. At liftoff the...
asked 1 hour ago -
1. The East Street Bagel Shop has a weekly demand for 3,500
bagels, which they make...
asked 1 hour ago -
paraphrasing each paragraph
“Where two or more persons knowingly act together unlawfully,
the act of each...
asked 1 hour ago -
The lateral line system in fish is contained which of the
following?
chemoreceptors
photoreceptors
mechanoreceptors
odor...
asked 1 hour ago -
Find the y-intercept of y =-5 x. The y-intercept of y equals
negative 5 x is______...
asked 1 hour ago -
Customers arrive randomly at a gas station at the average rate
of 30 per hour, while...
asked 1 hour ago