Business > QUESTIONS & ANSWERS > BUSINESS ANALYTICS REPORT (All)
BUSINESS ANALYTICS REPORT
Document Content and Description Below
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 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). Exploratory Data Analysis: - 1. The Channel column has two unique values in which ‘Hotels’ have the most values (298), The Region column has three unique values in which ‘Other’ have the most values (316). 2. The various items mean and their standard deviation are as follows: - No. Items Mean Standard Deviation 1 Fresh 12000.2977 12647.3289 2 Milk 5796.2659 7380.3772 3 Grocery 7951.2773 9503.1628 4 Frozen 3071.9318 4854.6733 5 Detergents Paper 2881.4932 4767.8544 6 Delicatessen 1524.8704 2820.1059 Checking for Null-values: Question 1.1: - Which Region and which Channel seems to spend more? Which Region and which Channel seems to spend less? Question 1.2: - There are 6 different varieties of items are considered. Do all varieties show similar behavior across Region and Channel? Question 1.3: - On the basis of descriptive measure of variability, which item shows the most inconsistent behavior? Which items show the least inconsistent behaviour? Question 1.4: - Are there any outliers in the data? [Show More]
Last updated: 3 years ago
Preview 1 out of 32 pages
Buy this document to get the full access instantly
Instant Download Access after purchase
Buy NowInstant download
We Accept:
Reviews( 0 )
$13.00
Can't find what you want? Try our AI powered Search
Document information
Connected school, study & course
About the document
Uploaded On
Jun 01, 2021
Number of pages
32
Written in
All
Additional information
This document has been written for:
Uploaded
Jun 01, 2021
Downloads
0
Views
51
