Quantitative business analysis - case study

profilecharles23
WalMart_revenue.xls

Data

Date Wal Mart Revenue CPI Personal Consumption Retail Sales Index December
11/28/03 14.764 552.7 7868495 301337 0
12/30/03 23.106 552.1 7885264 357704 1
1/30/04 12.131 554.9 7977730 281463 0
2/27/04 13.628 557.9 8005878 282445 0
3/31/04 16.722 561.5 8070480 319107 0
4/29/04 13.98 563.2 8086579 315278 0
5/28/04 14.388 566.4 8196516 328499 0
6/30/04 18.111 568.2 8161271 321151 0
7/27/04 13.764 567.5 8235349 328025 0
8/27/04 14.296 567.6 8246121 326280 0
9/30/04 17.169 568.7 8313670 313444 0
10/29/04 13.915 571.9 8371605 319639 0
11/29/04 15.739 572.2 8410820 324067 0
12/31/04 26.177 570.1 8462026 386918 1
1/21/05 13.17 571.2 8469443 293027 0
2/24/05 15.139 574.5 8520687 294892 0
3/30/05 18.683 579 8568959 338969 0
4/29/05 14.829 582.9 8654352 335626 0
5/25/05 15.697 582.4 8644646 345400 0
6/28/05 20.23 582.6 8724753 351068 0
7/28/05 15.26 585.2 8833907 351887 0
8/26/05 15.709 588.2 8825450 355897 0
9/30/05 18.618 595.4 8882536 333652 0
10/31/05 15.397 596.7 8911627 336662 0
11/28/05 17.384 592 8916377 344441 0
12/30/05 27.92 589.4 8955472 406510 1
1/27/06 14.555 593.9 9034368 322222 0
2/23/06 18.684 595.2 9079246 318184 0
3/31/06 16.639 598.6 9123848 366989 0
4/28/06 20.17 603.5 9175181 357334 0
5/25/06 16.901 606.5 9238576 380085 0
6/30/06 21.47 607.8 9270505 373279 0
7/28/06 16.542 609.6 9338876 368611 0
8/29/06 16.98 610.9 9352650 382600 0
9/28/06 20.091 607.9 9348494 352686 0
10/20/06 16.583 604.6 9376027 354740 0
11/24/06 18.761 603.6 9410758 363468 0
12/29/06 28.795 604.5 9478531 424946 1
1/26/07 20.473 606.348 9540335 332797 0