Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Month UK USA Germany Other Total Apr- 78 1324 3640 248 6604 11816 May- 78 964 2676 124 5040 8804 Jun- 78 924 2180 132
Month UK USA Germany Other Total Apr-78 1324 3640 248 6604 11816 May-78 964 2676 124 5040 8804 Jun-78 924 2180 132 3656 6892 Jul-78 1176 3232 136 5380 9924 Aug-78 1096 3008 308 5772 10184 Sep-78 1096 3184 272 4648 9200 Oct-78 1892 6836 716 7624 17068 Nov-78 4552 8140 664 9248 22604 Dec-78 4908 5964 640 15652 27164 Jan-79 4372 5684 576 11368 22000 Feb-79 3840 8496 616 10048 23000 Mar-79 2520 5868 592 8848 17828 Apr-79 1452 3304 608 6248 11612 May-79 1092 2704 236 5308 9340 Jun-79 964 2184 184 4436 7768 Jul-79 1340 2780 196 5956 10272 Aug-79 1340 3060 412 5840 10652 Sep-79 1380 3200 340 5416 10336 Oct-79 1872 7544 432 7068 16916 Nov-79 5956 9488 932 10276 26652 Dec-79 6236 5904 796 16732 29668 Jan-80 4964 7424 876 11260 24524 Feb-80 4972 10992 948 12477 29389 Mar-80 3104 11584 820 9660 25168 Apr-80 1560 5340 524 6837 14261 May-80 1236 2748 240 5933 10157 Jun-80 932 3237 208 5300 9677 Jul-80 1440 3796 404 6832 12472 Aug-80 1520 3808 544 6956 12828 Sep-80 1605 3652 340 5275 10872 Oct-80 2524 8289 680 7716 19209 Nov-80 3664 10600 1008 11488 26760 Dec-80 6580 6330 1212 17631 31753 Jan-81 3640 8345 1124 12284 25393 Feb-81 6961 10933 1172 11008 30074 Mar-81 3644 8180 764 10012 22600 Apr-81 1885 5268 568 7197 14918 May-81 1420 3770 340 6570 12100 Jun-81 1096 3528 200 5228 10052 Jul-81 1708 4747 437 7454 14346 Aug-81 1637 4885 544 7950 15016 Sep-81 1549 4262 352 6252 12415 Oct-81 2709 8720 980 9052 21461 Nov-81 4772 8364 1152 11603 25891 Dec-81 7051 5796 1092 17823 31762 Jan-82 6121 7124 1092 11863 26200 Feb-82 4140 8876 1288 10341 24645 Mar-82 3056 8456 996 9770 22278 Apr-82 2184 6636 560 8522 17902 May-82 1484 4488 352 6880 13204 Jun-82 1112 3609 324 5562 10607 Jul-82 1872 4928 488 7096 14384 Aug-82 1608 5632 348 6917 14505 Sep-82 1668 5064 380 6235 13347 Oct-82 2500 8552 940 8892 20884 Nov-82 5383 7252 1180 12064 25879 Dec-82 6803 5697 1020 19026 32546 Jan-83 6248 6792 868 14069 27977 Feb-83 4124 9316 1440 12160 27040 Mar-83 2868 7524 1144 10292 21828 Apr-83 2136 7832 524 7580 18072 May-83 1428 4808 352 6110 12698 Jun-83 1500 4364 412 5192 11468 Jul-83 2304 5580 560 6984 15428 Aug-83 1641 7960 388 6864 16853 Sep-83 1556 6316 428 6272 14572 Oct-83 2560 10400 948 9185 23093 Nov-83 5257 8660 1340 11518 26775 Dec-83 7474 7168 1124 18466 34232 Jan-84 6836 7844 904 13361 28945 Feb-84 4304 10844 1196 12382 28726 Mar-84 3500 12216 1024 10488 27228 Apr-84 2056 10184 724 9012 21976 May-84 1796 5360 376 6488 14020 Jun-84 1276 5476 318 5676 12746 Jul-84 2008 5940 372 7360 15680 Aug-84 1716 6880 440 7229 16265 Sep-84 2112 5860 356 6736 15064 Oct-84 3048 11124 944 10076 25192 Nov-84 4614 11438 1449 13504 31005 Dec-84 6943 7866 1408 20056 36273 Jan-85 6081 8836 924 15869 31710 Feb-85 5392 12180 1564 14473 33609 Mar-85 4212 11528 1260 11832 28832 Apr-85 2216 13237 628 10408 26489 May-85 1952 5976 372 7308 15608 Jun-85 1348 5096 328 7265 14037 Jul-85 2268 6428 420 8172 17288 Aug-85 1904 7896 568 9211 19579 Sep-85 2136 7192 444 7645 17417 Oct-85 3508 15265 1032 10845 30650 Nov-85 5080 17978 1660 18384 43102 Dec-85 7515 11348 1456 24612 44931 Jan-86 6086 12856 1240 17060 37242 Feb-86 6459 15616 1412 17636 41123 Mar-86 5058 15020 1396 14481 35955 Apr-86 2666 16232 480 12060 31438 May-86 1965 6950 460 8050 17425 Jun-86 1450 6300 340 8646 16736 Jul-86 2425 8080 465 10036 21006 Aug-86 2460 8886 675 10450 22471 Sep-86 2340 9440 610 11271 23661 Oct-86 3978 17832 1140 15126 38076 Nov-86 5580 21612 1746 22044 50982 Dec-86 9204 15150 2076 32112 58542 Jan-87 6942 17376 1632 22242 48192 Feb-87 7956 21522 2214 23484 55176 Mar-87 6180 14010 1344 15882 37416 Apr-87 3294 15798 1146 14250 34488 May-87 3246 8688 528 12852 25314 Jun-87 2786 8533 378 11179 22876 Jul-87 2728 10600 576 11640 25544 Aug-87 3208 10632 704 11736 26280 Sep-87 2480 11912 520 11960 26872 Oct-87 4480 20696 1792 19216 46184 Nov-87 6880 23240 2810 24390 57320 Dec-87 10868 17347 2794 32681 63690 Jan-88 9823 17611 2255 22187 51876 Feb-88 9351 18306 3024 24363 55044 Mar-88 7605 12258 2178 20187 42228 Apr-88 3872 12600 1144 16864 34480 May-88 3222 8829 639 15588 28278 Jun-88 2704 10704 528 12544 26480 Jul-88 3429 12546 909 15669 32553 Aug-88 3760 11210 920 16050 31940 Sep-88 3220 11970 1320 15440 31950 Oct-88 5852 20911 1936 20592 49291 Nov-88 7150 17292 2717 24530 51689 Dec-88 12716 13288 2541 34980 63525 Jan-89 8921 11924 3091 23892 47828 Feb-89 10386 16992 3303 26307 56988 Mar-89 6984 12087 2151 20682 41904 Apr-89 4365 12609 1350 17631 35955 May-89 3015 7056 873 13779 24723 Jun-89 2565 8109 531 14040 25245 Jul-89 4170 9250 1210 16310 30940 Aug-89 3916 9548 935 16874 31273 Sep-89 3058 10175 1320 15972 30525 Oct-89 5830 14234 2508 21516 44088 Nov-89 7740 13920 3350 27000 52010 Dec-89 13387 11605 3146 36564 64702 Jan-90 10452 11940 3132 31296 56820 Feb-90 12090 14500 4030 26340 56960 Mar-90 7940 14000 2480 22130 46550 Apr-90 6831 10863 2259 21645 41598 May-90 4644 8325 981 14652 28602 Jun-90 4374 8028 864 14121 27387 Jul-90 4664 9933 1034 17127 32758 Aug-90 4059 10087 1100 17402 32648 Sep-90 3390 9190 1620 14840 29040 Oct-90 6435 14773 3454 21087 45749 Nov-90 8756 15653 4675 25443 54527 Dec-90 13620 12372 4344 36216 66552 Jan-91 10020 11736 3720 24372 49848 Feb-91 12870 14220 4340 24670 56100 Mar-91 8300 13850 3780 20490 46420 Apr-91 5500 8261 1661 16489 31911 May-91 4190 7340 1440 14230 27200 Jun-91 4352 9288 640 14208 28488 Jul-91 4750 9830 1310 16290 32180 Aug-91 3883 9537 1122 15961 30503 Sep-91 3333 10582 1793 14729 30437 Oct-91 7073 13640 3333 20097 44143 Nov-91 9405 14674 5555 27346 56980 Dec-91 14268 9732 5604 37464 67068 Jan-92 11687 9893 4771 24388 50739 Feb-92 15230 15620 6710 31880 69440 Mar-92 9229 16313 4125 23155 52822 Apr-92 7710 9960 2980 20130 40780 May-92 4680 7420 2370 14900 29370 Jun-92 4080 7250 1390 13140 25860 Jul-92 4686 9504 1782 17479 33451 Aug-92 4444 7194 1639 16962 30239 Sep-92 3732 6840 1944 15396 27912 Oct-92 6721 13211 4290 22253 46475 Nov-92 9816 15696 6912 29532 61956 Dec-92 14508 12456 6792 43908 77664 Jan-93 12672 11376 6024 35928 66000 Feb-93 13740 17640 8760 31656 71796 Mar-93 10020 15456 6396 30084 61956 Apr-93 5621 10329 3245 26466 45661 May-93 4235 9460 2145 20185 36025 Jun-93 5445 7767 1287 15642 30141 Jul-93 4840 9944 2310 20306 37400 Aug-93 4675 7909 1815 18678 33077 Sep-93 3948 8484 2016 17736 32184 Oct-93 7800 16164 6300 28980 59244 Nov-93 13325 16887 8710 34736 73658 Dec-93 17066 12180 7154 46886 83286 Jan-94 13846 13832 8064 33572 69314 Feb-94 17244 18444 9660 41340 86688 Mar-94 12675 19266 6734 35659 74334 Apr-94 7152 12552 3780 31068 54552 May-94 5184 7272 2268 22968 37692 Jun-94 4370 9490 1430 19120 34410 Jul-94 5401 12067 2035 26587 46090 Aug-94 5642 9061 1716 22789 39208 Sep-94 5057 8775 2340 22269 38441 Oct-94 9044 15862 6216 36750 67872 Nov-94 13622 17472 8246 40936 80276 Dec-94 16830 14400 6765 53400 91395 Jan-95 16368 14160 7344 39376 77248 Feb-95 18750 17580 8460 41895 86685 Mar-95 11070 17040 6090 37590 71790 Apr-95 7969 11596 3796 35009 58370 May-95 5379 7403 2343 25751 40876 Jun-95 4378 10241 1243 18700 34562 Jul-95 5811 13013 1872 28691 49387 Aug-95 5992 7602 1694 24150 39438 Sep-95 5670 7200 2475 22830 38175 Oct-95 9585 15120 5475 36585 66765 Nov-95 13875 15360 7665 40500 77400 Dec-95 17552 15888 6480 60672 100592 Jan-96 17017 13872 6494 40834 78217 Feb-96 19376 19600 8320 50496 97792 Mar-96 13472 14928 5184 38672 72256 Apr-96 9270 11115 3315 37125 60825 May-96 6286 7280 2072 25788 41426 Jun-96 5512 9334 1157 24102 40105 Jul-96 6144 10848 1344 30624 48960 Aug-96 6128 7632 1296 27984 43040 Sep-96 5888 7552 2080 26240 41760 Oct-96 10132 14314 4369 37128 65943 Nov-96 16218 15776 7072 46104 85170 Dec-96 21042 15138 7218 67950 111348 Jan-97 20634 14326 6308 43187 84455 Feb-97 24072 17748 7004 52666 101490 Mar-97 15385 15215 4743 42551 77894 Apr-97 9197 10183 3417 34680 57477 May-97 6286 7014 2100 26334 41734 Jun-97 5460 8890 896 23422 38668 Jul-97 6970 11594 1394 28543 48501 Aug-97 6656 7856 1648 24832 40992 Sep-97 6058 7514 2509 23881 39962 Oct-97 10116 12732 4308 33084 60240 Nov-97 15612 15240 6144 42600 79596 Dec-97 21736 15262 6227 63076 106301 Jan-98 20430 16635 6555 48075 91695 Feb-98 25056 20580 7968 41316 94920 Mar-98 14417 18265 5278 34593 72553 Apr-98 10092 12372 2892 32076 57432 May-98 6340 8920 1370 23800 40430 Jun-98 5984 9610 913 22469 38976 Jul-98 7494 11307 1346 30005 50152 Aug-98 7103 7515 1368 24804 40790 Sep-98 6667 7907 2031 26755 43360 Oct-98 10227 14873 4379 38212 67691 Nov-98 18163 17377 6877 44444 86861 Dec-98 23353 16987 5512 65019 110871 Jan-99 21816 18551 6725 47490 94582 Feb-99 25607 21894 6967 51426 105894 Mar-99 17704 18692 4475 40511 81382 Apr-99 9737 12759 2208 38870 63574 May-99 6957 9054 1343 28186 45540 Jun-99 6760 10685 945 26276 44666 Jul-99 8478 11785 1297 32239 53799 Aug-99 7983 8930 1402 27912 46227 Sep-99 8587 10070 1867 30346 50870 Oct-99 13769 16777 4650 39685 74881 Nov-99 21025 18655 7780 50879 98339 Dec-99 20035 23113 6614 60468 110230 Jan-00 22388 21020 7293 46889 97590 Feb-00 31015 25313 7969 54561 118858 Mar-00 18602 19048 4972 39713 82335 Apr-00 15290 14657 2927 41698 74572 May-00 7892 10330 1693 31233 51148 Jun-00 7433 13208 1105 28338 50084 Jul-00 9940 16448 1715 35981 64084 Aug-00 9937 10695 1492 29760 51884 Sep-00 8089 8387 1976 30490 48942 Oct-00 15049 17466 5311 44877 82703 Nov-00 21699 18986 8323 55047 104055 Dec-00 33319 20451 6783 76308 136861 Jan-01 29331 18201 7706 57195 112433 Feb-01 32076 25707 9272 51798 118853 Mar-01 19875 20975 5536 46641 93027 Apr-01 13965 13513 2649 45278 75405 May-01 8209 10116 1698 33419 53442 Jun-01 7832 13717 1026 30219 52794 Jul-01 11491 14897 1811 38724 66923 Aug-01 10116 11667 1682 32343 55808 Sep-01 9265 8245 2248 34051
- Draw a time series graph of your data.Comment on any obvious features
- Calculate the proportion your country represents of the Total arrivals.[Hint: use a formula such as =C2/J2, where your data would be in column C, and the Total in column J.]Draw a time series graph of this proportion, and comment on any obvious features.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started