Write down the regression equation obtained

Reference no: EM133547431

Assignment: Business Analytics and Modeling

This is an open book exam but but you are not allowed to consult with anyone. Violation of academic integrity will lead to severe penalty.
You have 3 hrs. to complete and upload the excel file.

Consider the following data which indicates quarter-wise sales for Years 1, 2 & 3.

Quarter	Year 1	Year 2	Year 3
1	4	6	7
2	2	3	6
3	3	5	6
4	5	7	8

Use dummy variables as follows to account for the seasonal effects in the data as follows

Qtr 1=1 if Qtr 1, 0 otherwise
Qtr 2=1 if Qtr 2, 0 otherwise
Qtr 4=1 if Qtr 4, 0 otherwise
Qtr 3=1 if Qtr 3, 0 otherwise

Create a variable t such that t=1 for Qtr 1 in year 1 and t=2 for Qtr 2 in year 1,...t=12 for Qtr 4 in year 3.

Use a multiple regression model to develop an equation to account for trend and seasonal effects.

Question A. Write down the regression equation obtained.
Question B. Compute the quarterly forecasts for the next year based on the model you developed above.

Reference no: EM133547431

Questions Cloud

Write self care plan : Write a self care plan that can be utilized to help you avoid feeling stressed, overworked or burned out when it comes to your schooling and work as a nurse.

Perform a quick evaluation of your security breach : Briefly review the attached material on the Common Criteria and use it to perform a quick evaluation of your security breach that you have chosen for research.

What does it mean to be socially responsible in advertising : What does it mean to be socially responsible in advertising? Citing some references, if possible, Could you share your thoughts on advertising on the internet

What are the mechanical properties of cold sprayed : What are the Mechanical properties of cold sprayed deposits and the factor limiting them (i.e. porosity) What is meant by Sintering (what is sintering

Write down the regression equation obtained : Write down the regression equation obtained. Compute the quarterly forecasts for the next year based on the model you developed above.

Discuss the enrgy flow through an ecosystem : The energy flow in ecosystems is based on the primary productivity of autographs. Discuss the enrgy flow through an ecosystem and the relative efficiency with

How were emotions perceived by teacher and student : How were the emotions perceived by the teacher and the student, how did the student expressed the emotions,

How are they the same contrast their structure and function : Compare their structure and function - How are they the same? Contrast their structure and function - How are they different? Describe at least two examples

Identify the community role of community rehabilitation : Identify the community role of community rehabilitation. What population does a community rehabilitation worker work with?

User Account

All Pages