Question

1. [20 marks] Managers worldwide, but especially these days in North America, must closely follow historical trends and ongoing debates on potential future workers, clients, customers or other stakeholders crossing international borders. In fact, specifically for the Canadian-U.S. and U.S.-Mexican borders, relevant entry data is also publicly available from the U.S. Department of Transportation at the following website.

https://data.transportation.gov/Research-and-Statistics/Border-Crossing-Entry-Data/keg4-3bc2/data

1. [3 marks] Briefly describe this data set (e.g., give number and meaning of its elements and variables).

2. [4 marks] Download this full data set using the “Export” option as “CSV for Excel” onto your computer.

State its size in megabytes and its numbers of columns, rows and cells

3. [6 marks] Obviously, there is a nearly endless number of interesting questions that could be asked and answered, so here, let’s keep it (somewhat) simple. Complete the following crosstabulation and percent crosstabulation for the number of border crossings in 2018 between Canada and the U.S. versus the

U.S. and Mexico, as “Pedestrians” versus “Personal Vehicles” (and/or “Personal Vehicle Passengers”) versus “Buses” (and/or “Bus Passengers”) versus “Trains” (and/or “Train Passengers”). To simplify this task, consider to download the much smaller data set that you actually need using the “Filter” option.

Number of border crossings in 2018	by foot	by car	by bus	by train	in total
between Canada and the U.S. between the U.S. and Mexico
in total

Number of border crossings in 2018	by foot	by car	by bus	by train	in total
between Canada and the U.S. between the U.S. and Mexico
in total					100%

4. [7 marks] Finally, use the “Visualization” option to create at least seven interesting plots including a bar chart, column chart, pie chart, timeline chart, histogram, combo chart and a map. Print and clearly label all charts and maps and insert them as final pages at the very end of your assignment submission.

Answer 1

a) The total data count is 341989. The variables are the port name, State abbreviation, Port Code, Border, Date, Measure, Value, and Location. So that means our total data of 341989 entries have all these information.

b) The total size of the file is 34.6MB. The total number of rows is 341990 and the total number of column is 8.

c)

Number of border crossings in 2018	by foot	by car	by bus	by train	in total
between Canada and the U.S.	21466	112887	43676	84573	262602
between the U.S. and Mexico	6872	33842	13263	25410	79387
Total	28338	146729	56939	109983	341989
Number of border crossings in 2018	by foot	by car	by bus	by train	in total
between Canada and the U.S.	6.276810073	33.00895643	12.771171	24.72974277	76.78668027
between the U.S. and Mexico	2.009421356	9.895639918	3.878194913	7.43006354	23.21331973
Total	8.286231428	42.90459635	16.64936592	32.15980631	100

d) For these question, the steps are simple go to visualization then click on the chart then select any variable for rows and columns then select different types of the chart like pie, bar, etc. and then you can print it