NYC Bus Companies: Breakdown & Delay Patterns

Objective:

This project aims to analyze data related to bus companies operating in New York City, focusing on breakdown occurrences, delay durations, and the reasons behind these delays. By examining this data using Microsoft Excel and advanced functions like VLOOKUP, the project seeks to identify patterns and provide actionable insights that can help improve operational efficiency, reduce delays, and enhance commuter experiences.

Methodology

1. Breakdown Frequency per Company:

•    Identification of bus companies with the highest and lowest breakdown rates.

•    Trend analysis to determine if breakdowns are increasing or decreasing over time.

2. Delay Duration:

•    Comparison of delay times between different companies.

•    Determination of average delay times and analysis of which companies consistently experience longer or shorter delays.

3. Delay Causes:

•    Breakdown of the most common reasons for delays across all companies.

•    Analysis of whether specific companies are more prone to delays due to certain causes (e.g., mechanical failures versus external factors like traffic).

The analysis will include:

• Descriptive Statistics: To summarize the number of breakdowns, delay times, and the distribution of reasons for delays.

• Comparative Analysis: To compare the performance of different companies regarding breakdowns and delays.

• Trend Analysis: Observe how breakdown and delay metrics have changed.

• Correlation Analysis: To explore any relationships between breakdown frequency and delay times and the impact of specific delay reasons.

Expected Outcomes:

• Identification of companies with the most reliable and efficient bus services.

• Insight into the most common causes of delays and potential areas for improvement.

• Recommendations for minimizing breakdowns and delays, focusing on operational improvements and targeted maintenance efforts.

Conclusion:

The analysis provided a comprehensive overview of breakdowns and delays affecting New York City’s bus companies, offering valuable insights for transportation authorities to optimize service reliability and enhance the daily commute experience for passengers.