aly6000 data analytics and report- Savvy Essay Writers | savvyessaywriters.net

You will work on US Border Crossing Data in the attached ZIP file. This file contains data about border crossings on one day (March 1, 2019) at the US-Canada and the US-Mexico borders including passengers in private vehicles and buses, as well as freight in trains and trucks. You will perform the following steps in this assignment:

STEP 1: Split the data into two groups: crossings at the US-Canada border and crossings at the US-Mexico border

STEP 2: For each group, you will only work with passenger data points. You will need to look at two columns: a) ‘Measure’, which contains values such as Trucks, Private Vehicles, Pedestrians, etc. and b) ‘Value’, which contains the count of Trucks, Private Vehicles, Pedestrians, etc. at each border crossing.

STEP 3: For each border crossing, identify the number of i) Private Vehicles, ii) Pedestrians, and iii) Buses crossing over

STEP 4: Compute the following statistics from the isolated data.

* Total Number of Private Vehicles, Pedestrians, and Buses Crossing over across all the border stations on the US-Canada Border and the US-Mexico Border

* Avg Number of Private Vehicles, Pedestrians, and Buses Crossing over across all the border stations on the US-Canada Border and the US-Mexico Border

* Median Number of Private Vehicles, Pedestrians, and Buses Crossing over across all the border stations on the US-Canada Border and the US-Mexico Border

* Standard Deviation of Private Vehicles, Pedestrians, and Buses Crossing over across all the border stations on the US-Canada Border and the US-Mexico Border

* Does the median number in each category differ significantly from the average number? If so, can you explain the reason?

* Are there any border crossings where the number of crossings of Private Vehicles, Pedestrians, or Buses is different from the average by 2 standard deviations or more? Enumerate these.

* Identify the busiest border crossing on the US-Canada Border and the US-Mexico Border for each category: a) Private Vehicle crossings, b) Pedestrian crossings, and c) Bus crossings

* Identify the busiest border crossing overall for each category: a) Private Vehicle crossings, b) Pedestrian crossings, and c) Bus crossings

STEP 5: Plot a histogram of border crossings for buses, pedestrians, and private vehicles with specific border checkpoints (e.g. Blaine WA, Nogales AZ) on the X-axis. Do this for the US-Mexico border and for the US-Canada border

STEP 6: Submit your findings in a formatted report in MS Word or equivalent format. Submit your Excel spreadsheet (or R code) along with your report

Savvy Essay Writers

Place your order Now