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.