Chat with us, powered by LiveChat You will work on US Border Crossing Data in the at - Writemia

You will work on US Border Crossing Data in the at

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 borderSTEP 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 overSTEP 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 crossingsSTEP 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 borderSTEP 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

Do you need an answer to this or any other questions?

About Writemia

We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.

How It Works

To make an Order you only need to click on “Place Order” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.

Are there Discounts?

All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.

Hire a tutor today CLICK HERE to make your first order