Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The attached data set contains vacation packages sold by a travel agent by quarter over a 12 year period. Add a sequential observation number and

The attached data set contains vacation packages sold by a travel agent by quarter over a 12 year period.

Add a sequential observation number and convert the quarter number to a set of dummy variables. Run a linear regeression model that uses the observation number and the quarterly dummies for Q2-Q4 (Q1 is the base case) to predict Vacation. Based on this model, make a forecast for 2020. What is the forecast for Q2? (Report your answer as a whole number)

Year Quarter Vacation
2008 1 500
2008 2 147
2008 3 1314
2008 4 673
2009 1 984
2009 2 584
2009 3 1449
2009 4 1125
2010 1 209
2010 2 458
2010 3 1357
2010 4 544
2011 1 483
2011 2 280
2011 3 1392
2011 4 780
2012 1 340
2012 2 1003
2012 3 1692
2012 4 783
2013 1 781
2013 2 409
2013 3 1657
2013 4 792
2014 1 671
2014 2 769
2014 3 1068
2014 4 520
2015 1 616
2015 2 775
2015 3 1215
2015 4 514
2016 1 232
2016 2 492
2016 3 1581
2016 4 1028
2017 1 551
2017 2 869
2017 3 1114
2017 4 476
2018 1 405
2018 2 412
2018 3 1121
2018 4 554
2019 1 666
2019 2 729
2019 3 1283
2019 4 923

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Algebra And Trigonometry Enhanced With Graphing Utilities (Subscription)

Authors: Michael Sullivan, Michael Sullivan III

8th Edition

0135813158, 9780135813157

More Books

Students also viewed these Mathematics questions

Question

Express the following ratios in its lowest terms. 11,11 7. 3

Answered: 1 week ago