jyothisable/walmart-eda

EDA on walmart black friday sales with bootstrapping and hypothesis testing

Intro to the Dataset and the Aim of the EDA

The Management team at Walmart Inc. wants to analyze the customer purchase behavior (specifically, purchase amount) against the customer’s gender and the various other factors to help the business make better decisions. They want to understand if the spending habits differ between male and female customers

Dataset

This dataset contains a sample of transactional data of customers who purchased products from the Walmart Stores during Black Friday sale

Aim: To analyze relationship of purchase amount against customer features, with added importance to gender

Methods and Techniques used: EDA and hypothesis testing

Features

• User_ID: User ID
• Product_ID: Product ID
• Gender: Sex of User
• Age: Age in bins
• Occupation: Occupation(Masked)
• City_Category: Category of the City (A,B,C)
• StayInCurrentCityYears: Number of years stay in current city
• Marital_Status: Marital Status
• ProductCategory: Product Category (Masked) *Purchase: Purchase Amount

Conclusion

With hypothesis testing, we proved below with a significance level of 0.01

• Men spend more than women on average (purchase value)
• Male customers tend to have higher average order value than female customers (AOV signifies purchasing power/disposable income)
• Marriage reduced the average order value for men while increased for women