MATRIZ OD

Summary

This video explains the process of analyzing a large dataset of over 3,000 trips in Jauja, focusing on transportation modes, origins, destinations, and other key factors. The data is transformed into a 68x68 matrix to track travel patterns between various zones, with the ability to filter and analyze by criteria such as mode of transport, trip purpose, and time of day. Using Excel formulas like `SUMPRODUCT`, users can filter the data to examine specific travel behaviors, making it an essential guide for transportation analysis and urban planning.

Takeaways

• 😀 The dataset contains over 3,300 travel records with details like origin, destination, mode of transport, time of travel, and reason for the trip.
• 😀 The data is organized into a matrix where rows represent origins and columns represent destinations, with each cell showing the number of trips between the corresponding zones.
• 😀 Excel's **SUMPRODUCT** function is used to filter and analyze the data based on multiple conditions like origin, destination, mode of transport, and time of travel.
• 😀 Filtering by transport mode (e.g., motorcycle taxi) allows users to isolate specific types of trips from the dataset.
• 😀 Filtering by reason for the trip (e.g., work, study) enables analysis of trips based on their purpose.
• 😀 Time-based filtering (e.g., morning rush hour, evening) helps analyze travel patterns across different times of the day.
• 😀 The dataset includes 68 zones of origin and 68 zones of destination, with the possibility of mapping travel patterns between any pair of these zones.
• 😀 Each travel record is associated with a 'survey point' where data was collected, providing additional context to the trips.
• 😀 The matrix provides insights into both 'generated' (trips originating in a zone) and 'attracted' (trips ending in a zone) travel volumes for each zone.
• 😀 Combining multiple filters (e.g., transport mode, reason, and time) allows for a more detailed and specific analysis of travel behavior.
• 😀 The flexibility of the dataset allows for in-depth exploration of transportation patterns, which can be adjusted to examine various factors like cost, duration, and control points.

Q & A

What is the main purpose of the dataset described in the transcript?

The dataset is used to track and analyze travel patterns in the city of Jauja, with detailed information about the origin, destination, mode of transport, reason for travel, time, and control points where surveys were conducted.

How is the data organized in the matrix format?

The data is organized into a 68x68 matrix, where rows represent the origin zones and columns represent the destination zones. Each cell contains the total number of trips between the corresponding origin and destination.

What types of data are stored in the original dataset before it is converted into a matrix?

The original dataset includes information on the origin and destination of trips, the mode of transport (e.g., mototaxi, car, bus), the time of the trip (e.g., peak hours), the reason for the trip (e.g., work, study), and the point where the survey was conducted.

How are the total trips between origin and destination calculated in the matrix?

The total trips are calculated by using the `SUMPRODUCT` formula in Excel, which sums the trips that match specific criteria such as the origin, destination, and potentially other factors like mode of transport or time.

What is the purpose of filtering the dataset by mode of transport, reason for travel, or time of day?

Filtering allows for more detailed analysis by isolating specific types of trips based on criteria such as the mode of transport (e.g., mototaxi), reason for travel (e.g., study), or time of day (e.g., peak hours). This helps to better understand travel behaviors and trends.

What does the 'SUMPRODUCT' function do in this analysis?

The `SUMPRODUCT` function is used to filter and aggregate the data based on multiple criteria. It multiplies corresponding elements in the given arrays (e.g., origin, destination, and mode of transport) and sums the results, providing a count of trips that meet all specified conditions.

How can you filter for trips made for a specific reason, such as study?

To filter for trips made for a specific reason, you can add an additional condition in the `SUMPRODUCT` formula that checks if the reason for the trip matches the specified code for study. This will sum only the trips that meet the origin, destination, and reason criteria.

What happens if you want to include multiple filters, such as mode of transport, reason for travel, and time of day?

You can apply multiple filters by adding more conditions to the `SUMPRODUCT` formula. Each condition represents a separate factor (e.g., mode, reason, time), and the formula will only sum the trips that meet all of these conditions.

What are the 68 zones mentioned in the transcript?

The 68 zones refer to different areas within the city of Jauja, where the travel data is collected. Both the origin and destination of trips are categorized into these zones, forming the basis for the travel matrix.

What is meant by 'generated' and 'attracted' trips in the matrix?

'Generated' trips refer to trips that originate from a particular zone, while 'attracted' trips are those that arrive at a particular zone. The matrix allows for analysis of both types of trips for each of the 68 zones.