Correlation Analysis

Correlation Analysis#

Sales

  • Moderate positive correlations:

    • Total delivery time vs carrier handover (0.4)

    • Total delivery time vs carrier delivery (0.6—stronger influence)

    • Total vs unique products per order (0.5)

    • Sellers per order vs unique products (0.6)

    • Sellers per order vs categories (0.6)

    • Shipping cost vs order value (0.5)

    • Shipping cost vs weight/volume (0.6)

    • Volume vs weight (0.8—strong)

  • Key insights:

    • Carrier delivery impacts total time most

    • More unique products → more sellers

    • Heavier/larger orders cost more to ship

    • Distance increases delivery time/cost

Customers

  • There is a high positive correlation (0.9) between the number of orders and the number of reviews. This means that customers who make more orders tend to leave more reviews.

  • The more months a customer makes purchases, the more orders they place. This is logical.

  • The higher the average number of unique products per order, the higher the average number of sellers. This indicates that customers with a greater variety of products in their orders tend to purchase from different sellers.