Question
A researcher decided to create set of Y-intercept dummy variables to reflect the impact of seasonality on sales. If the researcher wishes to analyze the
- A researcher decided to create set of Y-intercept dummy variables to reflect the impact of seasonality on sales. If the researcher wishes to analyze the impact of the four quarters of the year (January to March, April to June, July to September, and October to December), how many dummy variables should be created and included in the multiple regression model?
- Continuing from problem 7, a researcher has decided to create quarterly (January to March, April to June, July to September, and October to December) dummy variables to reflect the impact of seasonality on sales.
- (3 pts) The researcher has asked you to complete the data table below. (Hint: See slide #51 from Slide Set 16 Multiple Linear Regression; the dummy variables you are creating are looking at differences in the intercept term of each.)
- (2 pts) To avoid the issue of perfect multicollinearity, how many of the above quarterly "dummy" variables will you include in your regression model? In addition, how would you report the results of your model regarding the included dummy variables? It might help if you select a quarter as a "base" and explain your answer from there.
- (4 pts) Continuing from question #7, a second researcher believes that each quarter (January to March, April to June, July to September, and October to December) has a different slope, therefore she decides to create quarterly slope dummy variables (rather than intercept dummy variables). She has asked you to complete the data table below. (Hint: See slide #68 audio box from Slide Set 16 Multiple Linear Regression; the dummy variables you are creating are looking at differences in the slope term of each.)
Year | Month | Units sold | Qtr 1 | Qtr 2 | Qtr 3 | Qtr 4 |
2018 | Jan | 15 |
|
|
|
|
2018 | Feb | 30 |
|
|
|
|
2018 | Mar | 25 |
|
|
|
|
2018 | Apr | 15 |
|
|
|
|
2018 | May | 13 |
|
|
|
|
2018 | Jun | 14 |
|
|
|
|
2018 | Jul | 12 |
|
|
|
|
2018 | Aug | 22 |
|
|
|
|
2018 | Sep | 20 |
|
|
|
|
2018 | Oct | 14 |
|
|
|
|
2018 | Nov | 35 |
|
|
|
|
2018 | Dec | 40 |
|
|
|
|
2019 | Jan | 18 |
|
|
|
|
2019 | Feb | 36 |
|
|
|
|
2019 | Mar | 28 |
|
|
|
|
2019 | Apr | 30 |
|
|
|
|
2019 | May | 16 |
|
|
|
|
2019 | Jun | 17 |
|
|
|
|
2019 | Jul | 14 |
|
|
|
|
2019 | Aug | 26 |
|
|
|
|
2019 | Sep | 24 |
|
|
|
|
2019 | Oct | 17 |
|
|
|
|
2019 | Nov | 42 |
|
|
|
|
2019 | Dec | 48 |
|
|
|
|
Year | Month | Units sold | Qtr 1 | Qtr 2 | Qtr 3 | Qtr 4 |
2018 | Jan | 15 |
|
|
|
|
2018 | Feb | 30 |
|
|
|
|
2018 | Mar | 25 |
|
|
|
|
2018 | Apr | 15 |
|
|
|
|
2018 | May | 13 |
|
|
|
|
2018 | Jun | 14 |
|
|
|
|
2018 | Jul | 12 |
|
|
|
|
2018 | Aug | 22 |
|
|
|
|
2018 | Sep | 20 |
|
|
|
|
2018 | Oct | 14 |
|
|
|
|
2018 | Nov | 35 |
|
|
|
|
2018 | Dec | 40 |
|
|
|
|
2019 | Jan | 18 |
|
|
|
|
2019 | Feb | 36 |
|
|
|
|
2019 | Mar | 28 |
|
|
|
|
2019 | Apr | 30 |
|
|
|
|
2019 | May | 16 |
|
|
|
|
2019 | Jun | 17 |
|
|
|
|
2019 | Jul | 14 |
|
|
|
|
2019 | Aug | 26 |
|
|
|
|
2019 | Sep | 24 |
|
|
|
|
2019 | Oct | 17 |
|
|
|
|
2019 | Nov | 42 |
|
|
|
|
2019 | Dec | 48 |
|
|
|
|
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