The motor vehicle collision data set $($Q$2\_$Manhattan.jmp$)$ includes the date and time, location $($street names, zip code, latitude and longitude coordinates$),$ injuries and fatalities, and vehicle type for the collisions in Manhattan from $2015$ to $2017.$ Use JMP to analyze the data and answer the following questions.

Question at position $8$

$8$

$6$ points

Question at position $8$

Use the map service method to show the collisions overlaid on Manhattan street map. Include the JMP screenshot $($jpeg$,$ jpg$,$ png$,$ pdf$)$ of your graph in the submission.

Problem $2$

The motor vehicle collision data set $($Q$2\_$Manhattan.jmp$)$ includes the date and time, location $($street names, zip code, latitude and Iongitude coordinates$),$ injuries and fatalities, and vehicle type for the collisions in Manhattan from $2015$ to $2017.$ Use JMP to analyze the data and answer the following questions.

Drag n$\text{'}$ Drop here or Browse

$9$

$9$

File Upload

$6$ points

Using the graph built in previous step, focus on the collisions that involved taxi $($Vehicle Type$)$ and also led to pedestrian fatalities $($Pedestrians Killed$)$ by filtering out other records. Include in your submission the JMP screenshot $($jpeg$,$ jpg$,$ png$,$ pdf$)$ of the updated map. The screenshot should show only the collisions involving taxi and pedestrian fatalities, properly zoom in on those data points, and show the data labels of these data points $($including On Street Name and Cross Street Name$).$

Drag n$\text{'}$ Drop here or Browse

$10$ File Upload

$6$ points

Create a separate data table based on the original data set $($Q$2\_$Manhattan.jmp$)$ in JMP to summarize the total number of collisions by vehicle type for each day of the week $($i$.$e$.,$ Sunday through Saturday$).$ Build a treemap to present the summary. Include in your submission the JMP screenshots of the first five rows of your summary data table and the treemap.

Drag n$\text{'}$ Drop here or Browse

$11$

Multiple Choice

$2$ points

Using the graph created in Part C$,$ did collisions on different days of the week tend to involve different vehicle types?

Yes

No