Question

In: Statistics and Probability

Open Air_Traffic data. SETUP: It is believed that in July, as years go by we see...

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)

  • a. Regression
  • b. Two sided t-test
  • c. One sided t-test
  • d. Confidence Interval

5. What is the statistical interpretation? (4 points)

  • a. Average of data is inconsistent with the claim
  • b. P-value is too large to have a conclusive answer
  • c. P-value is smaller than 5% thus we are confident to say that the slope is not zero.
  • d. P-value is smaller than 5% thus we are confident that the averages are different.
  • e. None of these

6. What is the conclusion? (4 points)

  • a. We cannot claim that in July, as years go by we see higher and higher traffic.
  • b. We can claim that in July, as years go by we see higher and higher traffic.
  • c. None of these
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

Solutions

Expert Solution

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.


Related Solutions

Erikson believed that during middle childhood we go through the crisis of Industry vs. Inferiority (make...
Erikson believed that during middle childhood we go through the crisis of Industry vs. Inferiority (make sure you understand what industry means in this context). Do you think this still is relative with elementary school-aged children today? Why or why not? What is different about today's elementary school-aged child's experiences compared to your experiences when you with this age?
as big data increases we see a parallel growth in the need for small data to...
as big data increases we see a parallel growth in the need for small data to answer the questions it raises . in your own words and with specific examples discuss the qoute above . 6 lines answer
Setup The game that we will use for this simulation is "darts." We will randomly throw...
Setup The game that we will use for this simulation is "darts." We will randomly throw a number of darts at a specially configured dartboard. The set up for our board is shown below. In the figure, you can see that we have a round ‘dart board’ mounted on a square piece of ‘wood’. The dartboard has a radius of one unit. The piece of wood is exactly two units square so that the round board fits perfectly inside the...
We see data displayed in graphs and charts on a regular basis. Because we live in...
We see data displayed in graphs and charts on a regular basis. Because we live in a world dominated by visual information, it is not surprising that writers, advertisers, and journalists use data visualisations such as charts, graphs, and other graphics to help readers understand complex information more easily. However, it is not uncommon for published graphs to be designed to be eye-catching, shocking, or fun to look at, rather than informative and understandable. You can find a plethora of...
1. Open Kellogg's Annual Reports See Supplemental Financial Data and find the balance in Allowance for...
1. Open Kellogg's Annual Reports See Supplemental Financial Data and find the balance in Allowance for Doubtful Accounts for the most recent year. 2.  Sigmund Company completed the following transactions in 2012: Jan. 9     Sold merchandise on account to Roger’s Supply, $1,200. Jan. 15     Wrote off the account of Pete Ramirez as uncollectible because of his death, $500. Mar. 17     Received $450 from Roland Co., whose account had been written off in 2011. The account was reinstated and the collection recorded....
Open the Corn Yield dataset. There you see data recorded from an experiment to test 4...
Open the Corn Yield dataset. There you see data recorded from an experiment to test 4 organic pesticide methods (wasps, nematodes, pepper spray, and bacteria) to see if they eradicate corn weevils better than a standard chemical pesticide (control). For each method, effectiveness is determined by the average weight in grams of corn that is yielded from a randomly selected ear of corn. Use Minitab to do an Anderson-Darling test on the Yields to determine if the normality assumption for...
It is believed that 1/4 of adults over 50 years old graduated from high school. We...
It is believed that 1/4 of adults over 50 years old graduated from high school. We want to see if the percentage is the same for 30 year olds. How many should we survey in order to estimate the proportion of non-grads within 0.06 with 90 % confidence? Suppose we have no idea of the % of non-grads, what would be the "n" value?
We see that data structures, collections, and abstract data types are closely related concepts. Objects that...
We see that data structures, collections, and abstract data types are closely related concepts. Objects that are contained within these entities are typically called items or elements. From the object-oriented perspective, data structures have both private data and public behaviors. The behaviors define data structures in an abstract, implementation independent manner. Other equivalent terms used for behaviors are operations, methods, public interface, and usage interface. In this discussion, we explore the primary behaviors needed to use data structures. - Remove...
Will we see an increase in healthcare system consolidation over the next 4 years? If yes...
Will we see an increase in healthcare system consolidation over the next 4 years? If yes what type of systems will be the acquirers and why? If not, why not, and what will the successful independent system look like? Discuss rational for consolidation with both offensive and defensive logic. Discuss the perspective of at least one external constituency. In other words for example will a Biden Administration be a supporter or opponent of consolidation.
To see internal controls in action, look around you. When you go to the store, see...
To see internal controls in action, look around you. When you go to the store, see what types of internal controls you can identify. At your place of work see if you can identify internal controls that might be in place. After checking out some different places, come up with two internal controls you have observed. It can be at your place of business or when you are a customer (and they don't have to be from the same place)....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT