Answered step by step
Verified Expert Solution
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started