Question

(c) Does it seem that Wal-Mart’s revenue is closely related to the general state of the economy?

Identify and remove the six cases corresponding to December revenue.

(f) Does it seem that Wal-Mart’s revenue is closely related to the general state of the economy? Use all plots and statistical criteria on the Excel Regression output to explain it. (g) Compare the results of parts (a) and (d), which of these two models is better? Use R-square values, adjusted R-square values, Significance F values, p-values, scatter plots, residual plots and normal probability plots to explain your answer.

Date	Wal Mart Revenue	CPI	Personal Consumption	Retail Sales Index	December
11/28/2003	14.764	552.7	7868495	301337	0
12/30/2003	23.106	552.1	7885264	357704	1
1/30/2004	12.131	554.9	7977730	281463	0
2/27/2004	13.628	557.9	8005878	282445	0
3/31/2004	16.722	561.5	8070480	319107	0
4/29/2004	13.98	563.2	8086579	315278	0
5/28/2004	14.388	566.4	8196516	328499	0
6/30/2004	18.111	568.2	8161271	321151	0
7/27/2004	13.764	567.5	8235349	328025	0
8/27/2004	14.296	567.6	8246121	326280	0
9/30/2004	17.169	568.7	8313670	313444	0
10/29/2004	13.915	571.9	8371605	319639	0
11/29/2004	15.739	572.2	8410820	324067	0
12/31/2004	26.177	570.1	8462026	386918	1
1/21/2005	13.17	571.2	8469443	293027	0
2/24/2005	15.139	574.5	8520687	294892	0
3/30/2005	18.683	579	8568959	338969	0
4/29/2005	14.829	582.9	8654352	335626	0
5/25/2005	15.697	582.4	8644646	345400	0
6/28/2005	19.23	582.6	8724753	351068	0
7/28/2005	17.26	580.2	8833907	351887	0
8/26/2005	15.709	588.2	8825450	355897	0
9/30/2005	18.618	595.4	8882536	333652	0
10/31/2005	15.397	596.7	8911627	336662	0
11/28/2005	17.384	592	8916377	344441	0
12/30/2005	27.92	589.4	8955472	406510	1
1/27/2006	14.555	593.9	9034368	322222	0
2/23/2006	18.684	595.2	9079246	318184	0
3/31/2006	16.639	598.6	9123848	366989	0
4/28/2006	20.17	603.5	9175181	357334	0
10/26/2007	18.983	621.6	9836807	364265	0
11/30/2007	21.161	620.6	9870758	372970	0
12/28/2007	31.245	622.5	9946331	434488	1
1/25/2008	22.923	623.35	10008141	342422	0
2/29/2008	21.512	622.28	10032148	344464	0
3/28/2008	22.023	626.9	10030959	339463	0
4/25/2008	20.178	631.2	10075561	388158	0
5/30/2008	23.509	636.1	10126994	378653	0
6/27/2008	21.24	638.7	10190289	401354	0
7/25/2008	24.809	640.2	10223995	394488	0
8/29/2008	20.981	641.9	10291369	389780	0
9/26/2008	20.419	643.2	10305343	403812	0
10/31/2008	23.53	641.2	10301087	373978	0
11/28/2008	21.022	637.9	10328520	375932	0
12/26/2008	23.2	636.9	10362495	384677	0
1/30/2009	32.784	637.8	10438041	446195	1
2/27/2009	23.962	639.65	10499948	353997	0
3/27/2009	22.951	638.948	10523764	356183	0
4/24/2009	24.062	643.7	10522721	351032	0

Answer 1