Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Year Time Period quarter sales 2017 1 1 43.7 2 2 53.6 3 3 52.4 4 4 57.2 2018 5 1 45.3 6 2 55.2
Year | Time Period | quarter | sales | |||||
2017 | 1 | 1 | 43.7 | |||||
2 | 2 | 53.6 | ||||||
3 | 3 | 52.4 | ||||||
4 | 4 | 57.2 | ||||||
2018 | 5 | 1 | 45.3 | |||||
6 | 2 | 55.2 | ||||||
7 | 3 | 54.2 | ||||||
8 | 4 | 56.9 | ||||||
2019 | 9 | 1 | 46.5 | |||||
10 | 2 | 56 | ||||||
11 | 3 | 54.7 | ||||||
12 | 4 | 59.7 | ||||||
2020 | 13 | 1 | 48.7 | |||||
14 | 2 | 60.7 | ||||||
15 | 3 | 59.4 | ||||||
16 | 4 | 64.1 | ||||||
the Regression Output | ||||||||
How much of the variation in sales revenue is explained by Time? | ||||||||
Used the regression output to predict sales revenue for the next four quarters | ||||||||
Calculate the two period, three period and four period moving averages | ||||||||
Create a regression model using a Lag to predict revenue |
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