Analyzing Average Transport Costs by Zone in February 2023

Apr 6, 2024, 12:16 PM

Compare average transport costs by zone

We've loaded and inspected the data from the TRANSPORT COST Watch FEBRUARY 2024.xlsx file. Here's what we found:
  • The file contains multiple sheets, with Transport Feb. 2024 being the relevant one for our analysis.
  • The Transport Feb. 2024 sheet includes data on average transport costs by zone.
  • The data structure shows zones listed alongside their average transport costs for February 2023.
Next, we will calculate the average transport costs by zone to answer the query.
We successfully calculated the average transport costs by zone from the Transport Feb. 2024 sheet. Here are the key points:
  • Zones are diverse, including geographical regions and specific transport services.
  • The calculated average costs show significant variation across zones.
  • Both regional zones (e.g., NORTH CENTRAL, SOUTH EAST) and specific transport services (e.g., Air fare charges for specified routes) are included in the analysis.
This analysis provides a clear view of the average transport costs by zone for February 2023, as recorded in the provided dataset.

There is no significant difference in the average cost of transportation between the North and the South. Test this hypothesis.

We performed a t-test to compare the average transportation costs between the North and South zones. The results show:
  • The p-value is approximately 0.97.
This high p-value suggests that there is no statistically significant difference in the average transportation costs between the North and South zones, supporting the hypothesis.

Continue the analysis

To continue the analysis, we could explore additional aspects such as:
  • Monthly trends: Analyze how the transportation costs have changed monthly and identify any patterns.
  • Year-over-Year (YoY) changes: Examine the Year-over-Year changes in transportation costs for different zones.
  • Mode of transport comparison: Compare the costs across different modes of transportation (e.g., air, water, road) within the North and South zones.
Let me know which aspect you'd like to dive into next, or if there's another angle you're interested in.

Visualize the hypothesis result

Get started with Vizly