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.