Question

1. (6 pts) A luxury boat manufacturer recorded the following sales quantities. a. Construct an appropriate...

1. (6 pts) A luxury boat manufacturer recorded the following sales quantities. a. Construct an appropriate centered moving average trend of boat sales. b. Plot the time series and your centered moving average trend on the same coordinate axes. ref: Chap13Practice Prob1, Prob2, Prob3 & YouTube video - Forecasting (intermediate check value: 2013Q2 Centered MA = 8.75)

Year Qtr Boat Sales Qty
2012 4 7
2013 1 6
2 10
3 11
4 9
2014 1 9
2 19
3 15
4 8
2015 1 12
2 27
3 23
4 15
2016 1 10
2 21
3 17
4 11
2017 1 15
2 16
Math   Statistics-And-Probability   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1
Year Qtr BoatSalesQty MA CMA
2012 4 7
2013 1 6
2013 2 10 8.5 8.75
2013 3 11 9 9.375
2013 4 9 9.75 10.875
2014 1 9 12 12.5
2014 2 19 13 12.875
2014 3 15 12.75 13.125
2014 4 8 13.5 14.5
2015 1 12 15.5 16.5
2015 2 27 17.5 18.375
2015 3 23 19.25 19
2015 4 15 18.75 18
2016 1 10 17.25 16.5
2016 2 21 15.75 15.25
2016 3 17 14.75 15.375
2016 4 11 16 15.375
2017 1 15 14.75
2017 2 16

we calulate MA as

MA(t)= (X(t-2) +X(t-1) X(t) +X(t+1))/4

CMA(t) = (MA(t+1) + MA(t))/2

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Consider the following gasoline sales time series data. Week Sales (1000s of gallons) 1     18   ...
Consider the following gasoline sales time series data. Week Sales (1000s of gallons) 1     18    2     22    3     20    4     24    5     17    6     15    7     19    8     17    9     23    10     19    11     14    12     23    a. Using a weight of 1/2 for the most recent observation, 1/3 for the second most recent observation, and 1/6 third the most recent observation, compute a three-week weighted moving average...
A small business has recorded sales over the last 20 years.  The data is provided in accompanying...
A small business has recorded sales over the last 20 years.  The data is provided in accompanying workbook, tab “Small Business”. The business would like to use this data to provide a sales forecast for the future, specifically, the next two years. Build a spreadsheet that shows all the forecasts on a side-by-side basis so they can be compared for effectiveness using an error measure. Create a chart showing the data in time.  Discuss any patterns in the dat Create moving average...
Refer to the gasoline sales time series data in the given table. Week Sales (1000s of...
Refer to the gasoline sales time series data in the given table. Week Sales (1000s of gallons) 1 18 2 21 3 18 4 22 5 17 6 15 7 20 8 18 9 21 10 20 11 14 12 22 Compute four-week and five-week moving averages for the time series. Round your answers to two decimal places. Week Sales 4-Week Moving Average 5-Week Moving Average 1 18 2 21 3 18 4 22 5 17 6 15 7 20...
Refer to the gasoline sales time series data in the given table. Week Sales (1,000s of...
Refer to the gasoline sales time series data in the given table. Week Sales (1,000s of gallons) 1 16 2 22 3 17 4 23 5 15 6 17 7 21 8 19 9 20 10 18 11 15 12 23 (a) Compute four-week and five-week moving averages for the time series. If required, round your answers to two decimal places. Week Sales 4 Period Moving Average 5 period Moving Average 1 16 2 22 3 17 4 23 5...
Consider the following gasoline sales time series data. Click on the datafile logo to reference the...
Consider the following gasoline sales time series data. Click on the datafile logo to reference the data. Week Sales (1000s of gallons) 1     16    2     20    3     19    4     23    5     19    6     15    7     19    8     17    9     23    10     20    11     15    12     21    a. Using a weight of (1/2) for the most recent observation, (1/3) for the second most recent observation, and (1/6) third the...
Refer again to the gasoline sales time series data in the following table. Week Sales (1000s...
Refer again to the gasoline sales time series data in the following table. Week Sales (1000s of gallons) 1 18 2 22 3 20 4 26 5 18 6 17 7 21 8 19 9 23 10 23 11 16 12 24 Using a weight of 1/2 for the most recent observation, 1/3 for the second most recent, and 1/6 for third most recent, compute a three-week weighted moving average for the time series. Use rounded for two decimal places...
1. Consider the following time series data. t 1 2 3 4 5 Yt 6 11...
1. Consider the following time series data. t 1 2 3 4 5 Yt 6 11 9 14 15 a. Develop the linear trend equation for this time series (to 1 decimal). Tt = (___) + (___) t b. What is the forecast for t=6 (to 1 decimal)? (___) 2. Consider the following time series data. t 1 2 3 4 5 Yt 7 11 9 14 16 a. Develop the linear trend equation for this time series (to 1...
For the data given below, forecast period 17 using following methods and suggest the best forecasting...
For the data given below, forecast period 17 using following methods and suggest the best forecasting model 1. Simple Moving Average (Three Period) 2. Weighted Average (50% on t-1, 30% on t-2, 20% on t-3) 3. Exponential Smoothing (α=.1), F1= y intercept from regression) 4. Exponential Smoothing (α=.3), F1= y intercept from regression) 5. Exponential Smoothing with trend (α=.3) and (δ=.3), F1= y intercept from regression)** 5. Exponential Smoothing with trend (α=.1) and (δ=.3), F1= y intercept from regression)** 6....
Problem 15-07 (Algorithmic) Refer to the gasoline sales time series data in the given table. Week...
Problem 15-07 (Algorithmic) Refer to the gasoline sales time series data in the given table. Week Sales (1000s of gallons) 1 17 2 21 3 19 4 24 5 18 6 15 7 21 8 19 9 22 10 21 11 16 12 22 Compute four-week and five-week moving averages for the time series. Round your answers to two decimal places. Week Sales 4-Week Moving Average 5-Week Moving Average 1 17 2 21 3 19 4 24 5 18 6...
Week Sales (1000s of gallons) 1     16    2     22    3     19    4    ...
Week Sales (1000s of gallons) 1     16    2     22    3     19    4     24    5     18    6     15    7     19    8     19    9     23    10     20    11     16    12     23    a. Using a weight of 1/2 for the most recent observation, 1/3 for the second most recent observation, and 1/6 third the most recent observation, compute a three-week weighted moving average for the time series (to 2 decimals). Enter...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT