Week Sales
26 15200
27 15600
28 16400
29 15600
30 14200
31 14400
32 16400
33 15200
34 14400
35 13800
36 15000
37 14100
38 14400
39 14000
40 15600
41 15000
42 14400
43 17800
44 15000
45 15200
46 15800
47 18600
48 15400
49 15500
50 16800
51 18700
52 21400
53 20900
54 18800
55 22400
56 19400
57 20000
58 18100
59 18000
60 19600
61 19000
62 19200
63 18000
64 17600
65 17200
66 19800
67 19600
68 19600
69 20000
70 20800
71 22800
72 23000
73 20800
74 25000
75 30600
76 24000
77 21200
Modeling the data quadratically
a. Generate a quadratic model for this data. Also output and discuss the R2 value.
b. What are the marginal sales for this department using this model?
c. Calculate the model generated relative max/min value. Show backup analytical work.
d. Compare actual and model generated relative max/min value.
e. Remove outliers and rerun the quadratic least squares model. What is the marginal sales and discuss improvements.
Week Sales 26 15200 27 15600 28 16400 29 15600 30 14200 31 14400 32 16400 33 15200 34 14400 35 13...
The WalMart’s fiscal year starts the first week of February. This means that when analyzing the data, week 26 is actually week 30 (26+4 weeks for January) in 2002 or the end of July 2002. Also, week 52 is actually week 4 (52+4 weeks for January 2002 minus 52 weeks for 2002) in 2003 or the end of January 2003. As an example, the spike in sales (revenue) at week 75 occurs in week 27 (75+4 weeks for January 2002...
The WalMart’s fiscal year starts the first week of February. This means that when analyzing the data, week 26 is actually week 30 (26+4 weeks for January) in 2002 or the end of July 2002. Also, week 52 is actually week 4 (52+4 weeks for January 2002 minus 52 weeks for 2002) in 2003 or the end of January 2003. As an example, the spike in sales (revenue) at week 75 occurs in week 27 (75+4 weeks for January 2002...
WalMart’s fiscal year starts the first week of February. This means that when analyzing the data, week 26 is actually week 30 (26+4 weeks for January) in 2002 or the end of July 2002. Also, week 52 is actually week 4 (52+4 weeks for January 2002 minus 52 weeks for 2002) in 2003 or the end of January 2003. As an example, the spike in sales (revenue) at week 75 occurs in week 27 (75+4 weeks for January 2002 minus...
Project #2Wal*Mart Dry Goods Sales 2003-2004The following items are a guide for responses to be addressed in project two. Note that WalMart’s fiscal year starts the first week of February. This means that when analyzing the data, week 41 is actually week 45 (41+4 weeks for January) in 2003 or the beginning of November 2003. Also, week 52 is actually week 4 (52+4 weeks for January 2003 minus 52 weeks for 2003) in 2004 or the end of January 2004. ...