The Most Important 25 Retailers In The United State
This project was developed as a practice to improve my skills as a Data Analyst
I proceed uploading the data
The mean sales for all retailer is U$D 71,063.08. All values are expressed in Millions Dollar.
Discovering that the main company (Walmart US) has sales far from the others, the mean does not tell me a realistic value. Therefore, I will analyze the data excluding the best selling company.
The mean sales for all retailers excluding Walmart is U$D 46,602.42. All values are expressed in Millions Dollar.
The new average looks more realistic
Most companies made at least U$D 34,980 This value is expressed in Millions Dollar.
Most companies have at least 1,828 stores and the mean of all is 3,466.57.
As we can see in the scatter diagram, we do not see any trend. Also in the chart, the value for Sales/Stores is very close to zero, which means no correlations.
The range of sales is U$D 641,527 millons dolars
In conclusion, among the Retailers with more number of stores only Walgreen Boots and Walmart US belong to the Retailers with higher sales This support the finding that there is not correlation between sales and number of stores.
The category with higher sales is Supercenters with USD 745,919 Million Dollars
Costco is the company which has more sales per every store
/shared-libs/python3.7/py-core/lib/python3.7/site-packages/ipykernel_launcher.py:10: UserWarning: FixedFormatter should only be used together with FixedLocator # Remove the CWD from sys.path while we load stuff.
The categry with more stores is "Dollar Stores" with: USD 79,731