Question
A wholesale distributor operating in different regions of Portugal has information on annual spending of several items in their stores across different regions and channels.
A wholesale distributor operating in different regions of Portugal has information on annual spending of several items in their stores across different regions and channels. The data (Wholesale Customer.csv) consists of 440 large retailers' annual spending on 6 different varieties of products in 3 different regions (Lisbon, Oporto, Other) and across different sales channel (Hotel, Retail).
file link: https://drive.google.com/file/d/1KmVITrLpSBC8piQ8394H6tcslbK3wKV7/view?usp=sharing
1.1. Use methods of descriptive statistics to summarize data.
Which Region and which Channel seems to spend more?
Which Region and which Channel seems to spend less?
1.2. There are 6 different varieties of items are considered, do all varieties show similar behaviour across Region and Channel?
1.3. On the basis of the descriptive measure of variability, which item shows the most inconsistent behaviour?
Which items shows the leastinconsistent behaviour?
1.4. Are there any outliers in the data?
1.5. On the basis of this report, what are the recommendations?
Note: please provide the details answer for last question also (Question: 1.5)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started