Question

I want to get this sum's answer manually solved, if possible. The regression for the deseasonalized...

I want to get this sum's answer manually solved, if possible.

The regression for the deseasonalized line in Problem 6 is y=10.5-0.31x.

  1. Use the regression line to determine the deseasonalized UR for each quarter of 2018, 2019 and 2020.
  2. Use the following seasonal factors, determined from a longer-term forecast, to calculate the seasonalized estimate for each quarter of 2018 and 2019, and the forecast for each quarter of 2020:

Q1       1.20

Q2       0.75    

Q3       0.90

Q4       1.10

  1. Graph the three years, including the forecast period.

Homework Answers

Answer #1

The trend graph is

Excel formula are

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
*******NOTE: I must be able to attach an **EXCEL** document with cell data to the assignment...
*******NOTE: I must be able to attach an **EXCEL** document with cell data to the assignment submission. More important than the answer is the step by step process on how to get these functions to work properly in **EXCEL**. Thank you!****** Using the given data set, please forecast future sales data using each method. Then, determine which method you prefer and why. GAP Data set: $M Year Quarter Period GAP 2012 Q1 1 $ 3,487 2012 Q2 2 $ 3,575...
1) When operating a business, a manager should only use one forecasting technique at a time....
1) When operating a business, a manager should only use one forecasting technique at a time. Yes or No? 2) Quarterly demand for a product includes both a trend and seasonality. The trend portion of deseasonalized demand is forecast based on a linear trend, yt = 50 + 4t, while the quarterly seasonal relatives are Q1 = 1.2, Q2 = 1.1, Q3 = 0.95 and Q4 = 0.75. What is the forecast demand for t = 11 and t =...
Year Quarter Sales ($000) 2015 1 $400 2015 2 2,000 2015 3 3,500 2015 4 260...
Year Quarter Sales ($000) 2015 1 $400 2015 2 2,000 2015 3 3,500 2015 4 260 2016 1 740 2016 2 2,720 2016 3 4,900 2016 4 520 2017 1 1,500 2017 2 3,100 2017 3 6,520 2017 4 960 2018 1 1,840 2018 2 4,040 2018 3 7,680 2018 4 1,640 2019 1 3,520 2019 2 5,640 2019 3 8,900 2019 4 3,620 Problem 2 House Depot’s quarterly sales of a lawn, landscaping, and gardening items – like lawnmowers,...
The Municipal Government has asked you to forecast the sales tax revenue it will collect in...
The Municipal Government has asked you to forecast the sales tax revenue it will collect in 2017, 2018 and 2019. Data on revenue in recent years is presented below. Year Q1 Q2 Q3 Q4 TOTAL 2012          695          788          809       1,302 $3,594 2013          896          941       1,018       1,677 $4,532 2014       1,037          929       1,353       2,090 $5,409 2015       1,067       1,081       1,574       2,143 $5,865 2016       1,147       1,161...
Please, i need Unique answer, Use your own words (don't copy and paste). Please, don't use...
Please, i need Unique answer, Use your own words (don't copy and paste). Please, don't use handwriting, Use your keyboard. Q1: Suppose you survey that a random sample of 150 people from one hospital has been given cholesterol tests, and 60 of these people had levels over the “safe” count of 200. Construct a 95% confidence interval for the population proportion of people in test with cholesterol levels over 200. Q2: A research conducted by the University of Michigan claimed...