Question

120 marksl Managers worldwide, but espeaally these days in North America, must closely follow historical trends and ongoing debates on potential future workers, clients, customers or other stakeholders crossing internatonal borders. In fact, specifically for the Canadian-U.S. and US.-Mexican borders, relevant entry data is also publicly available from the US. Department of Transportation at the following website Entry-Data/keg4-3bc2/data a. 3 marks] Briefly de scribe this data set (e.g., give number and meaning of its elements and variables). b. 4 marks] Download this full data set using the "Export option as "CSV for Exce onto your computer. State its size in megabytes and its numbers of columns, rows and cells c· (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 crosstabulafon 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" (andior Train Passengers). To simplity this task, consider to download the much smaller data set that you actually need using the "Filter option Number of border crossings in 2018by foot by car by bus by train in total between Canada and the U.S. between the US. and Mexico n tota Number of border crossings in 2018by foot by car by bus by train in total between Canada and the US. between the US. and Mexico n tota 100% d. 7 marks Finally, use the Visualization" option to create at least seven interesting plots including a bar chart, column chart, pie chart, tmeline chart, histogram, combo chart and a map. Print and cle arly label all charts and maps and insert them as final pages at the very end of your assignment submission.

Answer 1

(A) The otal db out vantle s Bovder, Dal, Meacue, ,Value, and Loer. S Sa means our tohel ds enshe vse total numbe p colunn is &

ike pie, bar, eve ard l you con