Question

We consider data in the following table, summarizing sales of a product (in thousands). For each...

We consider data in the following table, summarizing sales of a product (in thousands). For each of the questions, justify your answer.

Year

Quarter

Sales

2015

1

2

3

4

4.95

4.25

6.15

6.65

2016

1

2

3

4

5.85

5.35

6.95

7.55

2017

1

2

3

4

6.15

5.75

7.65

7.95

(3.3) Ignoring seasonality and assuming the the time-series as given follows an AR(1) process, what is the expected sales value for the first quarter of 2018? (5)

Homework Answers

Answer #1

Here I attach the R code

x=c(4.95,4.25,6.15,6.65,5.85,5.35,6.95,7.55,6.15,5.75,7.65,7.95)
m=arima(x,order=c(1,0,0))
m
forecast::forecast(m,1)

Here I attach the data and fit AR(1) model. The model summary is

Zt=6.2887+0.4865Zt-1+

The forecasted value for 2018 first quarter is :7.04

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
Would like to see it done in EXCEL Vehicle Sales: Consider the data below ( in...
Would like to see it done in EXCEL Vehicle Sales: Consider the data below ( in thousands of units):   year Quarter 1 Quarter 2 Quarter 3 Quarter 4 2016: 4072 4521 4452 4418 2017: 4010 4392 4399 4334 2018: 4092 4484 4277     4360 Obtain the seasonal factors and enter them into the appropriate yellow cells below: Quarter 1 Quarter 2 Quarter 3 Quarter 4 Seasonal Factor Using the columns Year and Total (Annual Sales) below, obtain the regression equation...
Elliot Co. manufactures a product with seasonal variations in demand. The following budget data for this...
Elliot Co. manufactures a product with seasonal variations in demand. The following budget data for this product has been collected for the upcoming year (2014).   In addition, predictions were also made for the first quarter of 2015. 2014 Quarter 1 Quarter 2 Quarter 3 Quarter 4 -Forecasted sales in units: 40,000 60,000 100,000 50,000 -Forecasted sales in units for the first quarter of 2015: 70,000 -Sales price per unit $8.00 -Desired ending inventory of finished units as a percentage of...
Elliot Co. manufactures a product with seasonal variations in demand. The following budget data for this...
Elliot Co. manufactures a product with seasonal variations in demand. The following budget data for this product has been collected for the upcoming year (2014).   In addition, predictions were also made for the first quarter of 2015. 2014 Quarter 1 Quarter 2 Quarter 3 Quarter 4 -Forecasted sales in units: 40,000 60,000 100,000 50,000 -Forecasted sales in units for the first quarter of 2015: 70,000 -Sales price per unit $8.00 -Desired ending inventory of finished units as a percentage of...
Consider the following monthly revenue data for an up-and-coming service company. Sales Data Month Revenue (Thousands...
Consider the following monthly revenue data for an up-and-coming service company. Sales Data Month Revenue (Thousands of Dollars) Month Revenue (Thousands of Dollars) 11 315315 1010 819819 22 535535 1111 827827 33 533533 1212 843843 44 574574 1313 855855 55 628628 1414 849849 66 659659 1515 858858 77 697697 1616 870870 88 709709 1717 889889 99 789789 The summary output from a regression analysis of the data is also provided. Regression Statistics Multiple R 0.9309852070.930985207 R Square 0.8667334560.866733456 Adjusted R...
Consider the following sample data for the relationship between advertising budget and sales for Product A:...
Consider the following sample data for the relationship between advertising budget and sales for Product A: Observation 1 2 3 4 5 6 7 8 9 10 Advertising ($) 70,000 80,000 80,000 90,000 100,000 100,000 110,000 110,000 120,000 130,000 Sales ($) 432,000 478,000 484,000 552,000 605,000 594,000 688,000 674,000 713,000 784,000 What is the R2 coefficient of determination value for the relationship between advertising and sales? Please round your answer to the nearest hundredth.
Consider the following sample data for the relationship between advertising budget and sales for Product A:...
Consider the following sample data for the relationship between advertising budget and sales for Product A: Observation 1 2 3 4 5 6 7 8 9 10 Advertising ($) 40,000 50,000 50,000 60,000 70,000 70,000 80,000 80,000 90,000 100,000 Sales ($) 240,000 308,000 315,000 358,000 425,000 440,000 499,000 494,000 536,000 604,000 What is the predicted sales quantity for an advertising budget of $68,000? Please round your answer to the nearest integer.
Consider the following sample data for the relationship between advertising budget and sales for Product A:...
Consider the following sample data for the relationship between advertising budget and sales for Product A: Observation 1 2 3 4 5 6 7 8 9 10 Advertising ($) 50,000 60,000 60,000 70,000 70,000 80,000 90,000 90,000 100,000 110,000 Sales ($) 299,001 371,000 364,000 430,000 440,000 485,000 535,000 546,000 595,000 675,000 What is the predicted sales quantity for an advertising budget of $76,000? Please round your answer to the nearest integer.
Consider the following sample data for the relationship between advertising budget and sales for Product A:...
Consider the following sample data for the relationship between advertising budget and sales for Product A: Observation 1 2 3 4 5 6 7 8 9 10 Advertising ($) 30,000 30,000 40,000 50,000 50,000 50,000 60,000 70,000 80,000 80,000 Sales ($) 179,000 183,000 253,000 308,000 301,000 308,000 376,000 418,000 486,000 499,000 What is the predicted sales quantity for an advertising budget of $57,000? Please round your answer to the nearest integer.
Consider the following time series data. Quarter Year 1 Year 2 Year 3 1 2 5...
Consider the following time series data. Quarter Year 1 Year 2 Year 3 1 2 5 7 2 0 2 6 3 5 8 10 4 5 8 10 (a) Choose the correct time series plot. (i) (ii) (iii) (iv) Plot (iii)- Select your answer -Plot (i)Plot (ii)Plot (iii)Plot (iv)Item 1 What type of pattern exists in the data? Positive trend pattern, no seasonality- Select your answer -Positive trend pattern, no seasonalityHorizontal pattern, no seasonalityNegative trend pattern, no seasonalityPositive trend...
Consider the following sample data for the relationship between advertising budget and sales for Product A:...
Consider the following sample data for the relationship between advertising budget and sales for Product A: Observation 1 2 3 4 5 6 7 8 9 10 Advertising ($) 70,000 80,000 80,000 90,000 100,000 100,000 110,000 110,000 120,000 130,000 Sales ($) 432,000 478,000 484,000 552,000 605,000 594,000 688,000 674,000 713,000 784,000 What is the slope of the "least-squares" best-fit regression line? Please round your answer to the nearest hundredth.