Weekly Challenges

olacey · ‎07-10-2023

A solution to last week's challenge can be found here.

This week's challenge is the second in a trilogy of challenges inspired by the 2023 Inspire Grand Prix. These challenges delve into real-life scenarios that numerous companies encounter on a regular basis. Last week’s challenge focused on the preparation and integration of data, and this week the challenge presents a spatial problem. Anticipation continues to build for the third and final challenge, which will delve into a predictive case.

If you are eager to experience the same exhilaration our racers feel in Las Vegas, take a quick, 2-minute glance at the instructions, start your timer, and record how long it takes you to determine the correct answers! Remember to share your time when you submit your workflow.

Let’s start now: 3, 2, 1, Go!

A company called ACE is evaluating whether they should set up regional distribution centers to handle their food deliveries outside of the Sydney, Australia area, namely those routes that contain stops outside a 30-mile radius from the ACE headquarters in Sydney.

Create a spatial route for each trip based on the sequence of stops (0-61) for each trip (Trip ID) provided in the data.

Then, for further analysis, only include trips where at least one stop on that route is outside the 30-mile radius of ACE’s headquarters in Sydney.

Of the trips with at least one long-distance stop, determine the following values:

How many trips included stops outside the 30-mile radius from the headquarters location?
What is the average total route length in miles for those trips?

Omaira Lacey
Instructional Designer