Question: 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

Q:

The attached data set contains vacation packages sold by a travel agent by quarter over a 1 2 year period. Vacation.xlsxDownload Vacation.xlsx Add a sequential observation number and convert the...

Q:

The attached Vacation data file contains vacation packages sold by a travel agent over the last 12 years. The file includes quarterly data on the number of vacation packages sold. In Excel, add a...

Q:

In this class you will be required to create a course map as we move through the semester. Your course mapping project will essentially be the most important accounting concepts covered in this...

Q:

In this class you will be required to create a course map as we move through the semester. Your course mapping project will essentially be the most important accounting concepts covered in this...

Q:

you will be given a Organization Profile in which you will then answer your questions according to the information in the Organization Profile. The questions should be formatted such that when I send...

Q:

you will be given a Organization Profile in which you will then answer your questions according to the information in the Organization Profile. The questions should be formatted such that when I send...

Q:

you will be given a Organization Profile in which you will then answer your questions according to the information in the Organization Profile. The questions should be formatted such that when I send...

Q:

you will be given a Organization Profile in which you will then answer your questions according to the information in the Organization Profile. The questions should be formatted such that when I send...

Q:

my question: The related case is put below with images. Can you describe trivago's organization design since 2010 by considering its structural dimensions such as formalization, specialization,...

Q:

Financial Statement Analysis Part 1 As described in the project overview, Appendix A of your textbook describes several ratios, as well as vertical analysis and horizontal analysis of financial...

Q:

Explain why systematic risk is the relevant risk of an investment and why investors should be rewarded only for this type of risk.

Q:

The operating cycle of a merchandiser with credit sales includes the following five activities. With merchandise acquisition as the starting point, arrange the events in the correct order. a Prepare...

Q:

Eleanor is a board member with Biotech Inc., a pharmaceutical company. At a recent meeting, the board votes to acquire a smaller competitor whose shares trade on the NASDAQ at $ 4 5 per share....

Q:

Question 2 Identify, and explain the significance of, the implicit assumptions being made by the armed protesters and their supporters (2-4 sentences). Armed protesters enter Michigan's state capitol...

Q:

1. To gain insight into communication situations regarding the fact that they should be understood by examining the relationship between the parts and the whole, and to provide an understanding that...

Q:

2. Using a communication conflict you have been involved in, or a problem or phenomenon that you are familiar with, provide answers for a)d). a) Find the critical elements that existed (exist) as you...

Q:

5. What is meant by the statement, when we attribute a different meaning to a situation, the situation will consequentially change for us?