In: Statistics and Probability
Open Air_Traffic data. SETUP: It is believed that in July, as years go by we see higher and higher traffic. Given the data your job is to confirm or disprove this assertion.
4. What test/procedure did you perform? (4 points)
5. What is the statistical interpretation? (4 points)
6. What is the conclusion? (4 points)
month | year | Air Traffic |
Sep | 2001 | 527,483 |
Feb | 1998 | 545,512 |
Feb | 1997 | 560,142 |
Nov | 2001 | 562,761 |
Feb | 1999 | 568,516 |
Nov | 1997 | 571,222 |
Feb | 2002 | 571,898 |
Jan | 1998 | 573,195 |
Sep | 1998 | 574,779 |
Apr | 1998 | 577,213 |
Feb | 1996 | 578,736 |
Dec | 2001 | 580,757 |
Nov | 1996 | 584,295 |
Oct | 2001 | 588,116 |
Sep | 1997 | 588,745 |
Dec | 1997 | 591,915 |
Jan | 1996 | 593,346 |
Jan | 1999 | 595,134 |
Sep | 1996 | 595,394 |
Nov | 1998 | 601,849 |
Jun | 1998 | 602,622 |
Jan | 1997 | 604,399 |
Jun | 1996 | 605,753 |
Apr | 1997 | 605,797 |
Feb | 2000 | 605,799 |
Dec | 1996 | 606,229 |
Apr | 1996 | 606,312 |
Oct | 1997 | 606,522 |
Feb | 2013 | 607,481 |
Mar | 1998 | 608,740 |
May | 1998 | 610,593 |
Jul | 1997 | 611,722 |
Jan | 2002 | 614,110 |
Feb | 2001 | 614,242 |
Jun | 1997 | 614,943 |
Aug | 1997 | 619,541 |
May | 1996 | 619,734 |
Dec | 1998 | 619,871 |
Oct | 1996 | 620,810 |
Sep | 1999 | 621,236 |
Apr | 1999 | 622,759 |
Feb | 2010 | 623,022 |
May | 1997 | 623,488 |
Jul | 1996 | 623,594 |
Jan | 2000 | 623,646 |
Mar | 1997 | 624,222 |
Feb | 2011 | 625,559 |
Apr | 2002 | 626,683 |
Mar | 1996 | 626,722 |
Sep | 2002 | 626,950 |
Nov | 1999 | 627,298 |
Aug | 1996 | 628,524 |
Oct | 1998 | 629,926 |
Aug | 1998 | 632,272 |
Jun | 1999 | 633,058 |
May | 1999 | 634,994 |
Apr | 2000 | 635,683 |
Jul | 1998 | 636,816 |
Mar | 2002 | 639,968 |
May | 2002 | 640,659 |
Mar | 1999 | 641,159 |
Jun | 2002 | 642,274 |
Dec | 1999 | 646,562 |
Dec | 2000 | 646,562 |
Feb | 2012 | 647,034 |
Nov | 2013 | 652,027 |
Apr | 2001 | 652,922 |
Jul | 1999 | 654,104 |
Oct | 1999 | 655,244 |
Jun | 2001 | 655,886 |
Nov | 2000 | 657,575 |
Sep | 2000 | 658,274 |
Feb | 2009 | 659,905 |
Jun | 2000 | 660,467 |
Jan | 2013 | 661,969 |
Aug | 1999 | 663,927 |
Mar | 2000 | 666,940 |
Nov | 2012 | 669,426 |
Dec | 2012 | 670,923 |
May | 2000 | 672,620 |
Jul | 2002 | 673,615 |
May | 2001 | 674,360 |
Jan | 2012 | 677,716 |
Jan | 2001 | 677,941 |
Sep | 2012 | 678,037 |
Aug | 2002 | 679,840 |
Sep | 2013 | 680,200 |
Jan | 2011 | 681,174 |
Jul | 2000 | 682,558 |
Nov | 2011 | 682,682 |
Mar | 2001 | 683,033 |
Feb | 2003 | 690,351 |
Apr | 2013 | 692,634 |
Oct | 2000 | 692,862 |
Aug | 2000 | 692,874 |
Jul | 2001 | 693,672 |
Oct | 2012 | 694,760 |
Nov | 2009 | 694,780 |
Jan | 2010 | 694,866 |
Dec | 2011 | 701,368 |
Dec | 2010 | 702,620 |
Oct | 2013 | 702,901 |
Nov | 2010 | 704,414 |
Dec | 2009 | 704,870 |
Sep | 2011 | 706,423 |
Apr | 2012 | 707,046 |
Aug | 2001 | 707,077 |
Nov | 2008 | 707,252 |
Sep | 2009 | 709,839 |
Jan | 2009 | 709,936 |
Mar | 2013 | 710,186 |
Feb | 2006 | 715,843 |
Sep | 2010 | 718,697 |
Jun | 2013 | 719,059 |
Dec | 2008 | 720,064 |
Apr | 2011 | 720,117 |
May | 2013 | 721,141 |
Apr | 2010 | 722,593 |
Oct | 2011 | 723,246 |
Feb | 2007 | 724,657 |
May | 2012 | 725,746 |
Oct | 2009 | 726,611 |
Sep | 2008 | 728,389 |
Mar | 2012 | 728,653 |
Apr | 2009 | 728,892 |
Jun | 2012 | 735,119 |
Oct | 2010 | 737,265 |
Mar | 2010 | 739,935 |
May | 2010 | 741,616 |
May | 2011 | 743,824 |
Feb | 2008 | 746,679 |
Aug | 2013 | 747,008 |
Mar | 2009 | 747,367 |
May | 2009 | 749,038 |
Jul | 2013 | 750,776 |
Jun | 2010 | 751,359 |
Aug | 2012 | 753,513 |
Mar | 2011 | 754,694 |
Jun | 2011 | 756,735 |
Jul | 2012 | 757,513 |
Oct | 2008 | 758,540 |
Jun | 2009 | 760,198 |
Feb | 2005 | 760,955 |
Feb | 2004 | 761,618 |
Nov | 2003 | 765,842 |
Apr | 2003 | 766,260 |
Nov | 2002 | 766,327 |
Aug | 2011 | 767,983 |
Aug | 2009 | 781,361 |
Aug | 2010 | 781,460 |
Dec | 2002 | 781,653 |
Sep | 2003 | 781,804 |
Jul | 2010 | 782,506 |
Jul | 2011 | 783,853 |
Jan | 2003 | 785,160 |
Jan | 2006 | 785,364 |
Jan | 2004 | 787,237 |
May | 2003 | 789,397 |
Nov | 2006 | 792,523 |
Jan | 2008 | 793,275 |
Jul | 2009 | 794,077 |
Apr | 2006 | 794,390 |
Mar | 2003 | 797,194 |
Nov | 2005 | 797,460 |
Jun | 2003 | 798,351 |
Dec | 2003 | 798,392 |
Apr | 2008 | 799,666 |
Sep | 2006 | 799,777 |
Dec | 2005 | 802,067 |
Jan | 2007 | 803,924 |
Dec | 2007 | 803,981 |
Nov | 2007 | 804,635 |
Dec | 2006 | 805,058 |
Sep | 2007 | 805,076 |
Jan | 2005 | 807,338 |
Apr | 2007 | 809,663 |
Sep | 2005 | 814,935 |
Oct | 2002 | 815,032 |
Jun | 2008 | 815,936 |
Mar | 2008 | 817,511 |
Apr | 2004 | 817,899 |
Oct | 2003 | 818,308 |
Sep | 2004 | 819,294 |
Nov | 2004 | 820,048 |
May | 2008 | 820,130 |
Jun | 2006 | 820,310 |
Aug | 2008 | 823,531 |
Mar | 2006 | 823,793 |
May | 2006 | 824,051 |
Oct | 2006 | 828,218 |
Mar | 2007 | 830,373 |
Aug | 2003 | 830,737 |
Oct | 2005 | 831,265 |
Jul | 2003 | 831,619 |
Jun | 2007 | 832,163 |
May | 2004 | 833,350 |
Mar | 2004 | 834,476 |
Dec | 2004 | 836,232 |
Jun | 2004 | 836,916 |
Apr | 2005 | 838,122 |
Oct | 2007 | 841,179 |
May | 2007 | 844,074 |
Jul | 2008 | 844,755 |
Jul | 2006 | 852,114 |
Oct | 2004 | 861,291 |
Jun | 2005 | 863,422 |
Jul | 2007 | 863,659 |
Aug | 2006 | 866,551 |
Mar | 2005 | 866,593 |
Jul | 2004 | 871,049 |
Aug | 2007 | 872,349 |
May | 2005 | 872,961 |
Aug | 2004 | 882,979 |
Jul | 2005 | 887,084 |
Aug | 2005 | 890,938 |
July Data
Month | Year | Air traffic |
Jul | 1996 | 623,594 |
Jul | 1997 | 611,722 |
Jul | 1998 | 636,816 |
Jul | 1999 | 654,104 |
Jul | 2000 | 682,558 |
Jul | 2001 | 693,672 |
Jul | 2002 | 673,615 |
Jul | 2003 | 831,619 |
Jul | 2004 | 871,049 |
Jul | 2005 | 887,084 |
Jul | 2006 | 852,114 |
Jul | 2007 | 863,659 |
Jul | 2008 | 844,755 |
Jul | 2009 | 794,077 |
Jul | 2010 | 782,506 |
Jul | 2011 | 783,853 |
Jul | 2012 | 757,513 |
Jul | 2013 | 750,776 |
4. What test/procedure did you perform?
Regression, the statement states increase in july airtraffic with year.
Considering the base year as 1996 (0) , we do regression analysis.
Air traffic | time preiod |
623,594 | 1 |
611,722 | 2 |
636,816 | 3 |
654,104 | 4 |
682,558 | 5 |
693,672 | 6 |
673,615 | 7 |
831,619 | 8 |
871,049 | 9 |
887,084 | 10 |
852,114 | 11 |
863,659 | 12 |
844,755 | 13 |
794,077 | 14 |
782,506 | 15 |
783,853 | 16 |
757,513 | 17 |
750,776 | 18 |
SUMMARY OUTPUT
Regression Statistics | |
Multiple R | 0.638055 |
R Square | 0.407114 |
Adjusted R Square | 0.370058 |
Standard Error | 73752.72 |
Observations | 18 |
ANOVA | |||||
df | SS | MS | F | Significance F | |
Regression | 1 | 59761352692 | 5.98E+10 | 10.98663 | 0.004382 |
Residual | 16 | 87031415034 | 5.44E+09 | ||
Total | 17 | 146792767726.44 |
Coefficients | Standard Error | t Stat | P-value | |
Intercept | 660880.3 | 33366.75696 | 19.80655 | 1.11E-12 |
time preiod | 11106.14 | 3350.666012 | 3.314608 | 0.004382 |
5) P-value is smaller than 5% thus we are confident to say that the slope is not zero.
6. What is the conclusion? (4 points)
We can claim that in July, as years go by we see higher and higher traffic.