(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 |
In: Statistics and Probability
Question 3 How can you identify the difference between quantitative and qualitative question? Conduct an internet search citing your references of respected authorities on this subject. Refer to Week 3 slides and recordings for further information (Must provide 2 references, there should be at least one academic reference and one non-academic). (At least 200 words).
In: Finance
Solve the heat equation (in one dimensional case) for c^2=9, the following boundary and initial conditions:
u(0,t)=u(2Pie,t)=0
u(x,0)=5sinx = 2sin5x
In: Advanced Math
Find the solution to the heat equation on 0 < x < l,
with u(0, t) = 0, ux(l, t) = 0, and u(x, 0) =
phi(x).
This is sometimes called a "mixed" boundary condition.
In: Advanced Math
a heat transfer experiment consist of a stream of air blowing over a heated horizontal plate. what causes the formation of both velocity and thermal boundary layers? what causes a difference in thickness between them?
In: Mechanical Engineering
When a wave passes through a boundary and into a new medium, which of the following characteristic of this wave don't change? And which do? a) wavelength b) Frequency c) speed d) both a and b e) none
In: Physics
11. Solve numerically the following Boundary Value Problem.
X2Y” – X(X+2)Y’ + (X+2)Y = 0
Y(1) = e and Y(2) = 2e2
The value of e = 2.71828
In: Advanced Math
In: Statistics and Probability
The Centurion, Inc had the following balance sheet as of 12/31/01
Cash $20,000
A/R $21,200
Investments $32,000
Plant assets (net) $81,000
Land $40,000
A/P - $30,000
Bonds Payable - $41,000
Common Stock $100,000
Retained Earnings $23,200
During the year 2002, the following occurred
In: Accounting