Reference no: EM13859635
For 2008-2014, a company has collected the following data on quarterly sales of its product.
|
Year
|
Quarter
|
t
|
Sales (000)
|
|
2008
|
q1
|
1
|
1135
|
|
|
q2
|
2
|
900
|
|
|
q3
|
3
|
1005
|
|
|
q4
|
4
|
1025
|
|
2009
|
q1
|
5
|
1220
|
|
|
q2
|
6
|
950
|
|
|
q3
|
7
|
870
|
|
|
q4
|
8
|
1098
|
|
2010
|
q1
|
9
|
1205
|
|
|
q2
|
10
|
1025
|
|
|
q3
|
11
|
1050
|
|
|
q4
|
12
|
1300
|
|
2011
|
q1
|
13
|
1315
|
|
|
q2
|
14
|
1050
|
|
|
q3
|
15
|
1152
|
|
|
q4
|
16
|
1150
|
|
2012
|
q1
|
17
|
1155
|
|
|
q2
|
18
|
1075
|
|
|
q3
|
19
|
1190
|
|
|
q4
|
20
|
1316
|
|
2013
|
q1
|
21
|
1350
|
|
|
q2
|
22
|
1205
|
|
|
q3
|
23
|
1280
|
|
|
q4
|
24
|
1300
|
|
2014
|
q1
|
25
|
1450
|
|
|
q2
|
26
|
1250
|
|
|
q3
|
27
|
1225
|
|
|
q4
|
28
|
1340
|
a. The manager would like to know if there is an upward trend in sales of the product. Use the data above to estimate the quarterly trend in sales using a linear trend model of the form:
Qt = a + bt.
Where Qt = quarterly sales
(paste your computer printout here)
b. Does your statistical analysis indicate a trend? If so, is it an upward or downward trend and how great is it? Is it a statistically significant trend (use the 5 percent level of significance )?
c. Now adjust your statistical model to account for seasonal variation in sales. Estimate the following model of sales:
Qt= a + bt+ c1D1+ c2 D2+ c3 D3
WhereD1, D2andD3 are respectively dummy variables for quarters I, II, and III (e.g., D1 is equal to 1 in the first quarter of each year and 0 in other quarters).
(paste your computer printout here)
d. Does the data indicate a statistically significantseasonal pattern (use the 5 percent level of significance)? If so, what is theseasonal pattern of sales of the product?
e. Comparing your estimates of the trend in sales in parts a and c, which estimate is likely to be more accurate? Why?
f. Using the estimated forecast equation from part c, forecast sales for quarter 1, 2, 3 and 4 of 2015; quarter 1, 2, 3, and 4 of quarter 16, and quarter 1 of 2017. What possible concerns do you have about these forecasts?
|
How has the cycle of violence manifested in the king family
: Identify/define the 4 stages of the cycle of violence. How has the cycle of violence manifested in the King family? Identify when the family has entered a particular phase in the cycle, and give your rationale
|
|
What data collection techniques would you use
: What data collection techniques would you use to study this hypothesis and why? Assuming that you get a correlation of r = -.70, what does this tell you about the strength and direction of the correlation between satisfaction and absenteeism
|
|
Offshoring-monopolistic competition
: Problem 1: (Offshoring) A good is produced using three production activities (a, b, and c) that each use skilled and unskilled labor. The table below shows the number of skilled and unskilled workers needed to produce one unit in each production s..
|
|
Explain what are the new contents of registers a4 and a7
: Draw a memory map showing the state of the relevant range of memory after this instruction executes. What are the new contents of registers A4 and A7
|
|
Quarterly sales of its product
: For 2008-2014, a company has collected the following data on quarterly sales of its product.
|
|
Federal reserve say about the strength of the economy?
: What does the Federal Reserve say about the strength of the economy?
|
|
Is this a good strategy
: Two consumers Justin and Cindy of the same product have the following demand curves: Q1 = 500 – 10 P and Q2 = 500 – 20 P. The marginal cost (MC) for the firm is $10. Calculate the prices when the firm discriminates between the two consumers. Is this ..
|
|
Estimate the demand equation
: As the manager of a restaurant, you decided to estimate the demand equation for your specialty food. After careful statistical analysis,your estimation resulted in the following demand equation. All parameters are statistically significant at the ..
|
|
Funds developed in the government and nonprofit sectors?
: funds developed in the government and nonprofit sectors?
|