Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Data set ( Global Corporation Customer &Sales data ) is obtained from a business. The business sells categories of products including DVD , CD ,

Data set (Global Corporation Customer &Sales data) is obtained from a business. The business sells categories of products including DVD, CD, and books which include classical, novel, politics, and bestsellers.
1. You have been given a data set which include the data for 400 days of trading. Data set is in 2 sheets. One is about customers and another one is about sales of the business. The data set lists the results of an online survey given to customers.
2. The datasheet the results of an online survey given to customers.
a. The customer variables include:
1. Customer ID
2.Gender male or female
3. Marital status (Married, single, divorced, widow)
4. Age
5. Promotion (3 levels)
6. Type of use (light user, medium user, heavy user)
7. Region that they come from (east, west, south, north)
8. Payment which defined customers payment methods (Paypal, credit, cash)
9. Source (web, email, shop)
10. Amount of customers pay
11. Product that they have purchased (Best select, CD, Classical, DVD, Novel, Politics).
12. Salary
b. The sales variables include.
1.Opening gross sales
2.Total gross sales for the days.
3.Price over earning ratio
4.Gross profit margin (%)
5.Revenue ($000)
Assignment instructions:
The main challenge in the business is to increase sales, revenue and profit. For this reason, the business has decided to conduct a survey and identify the ways the business can improve. They have collected the data about customers demographics, as well as sales data. Using statistical concepts and application answer the main research questions below. Also by using the dataset you can create and answer any other research questions that are meaningful to you.
Assignment structure:
(1) Introduction: objectives of the research and analysis. [10 marks]
Describe the main objective of the researchers who collected this dataset
Describe how you want to analyse the collected data in order to suggest a solution for increasing sales/profit. What are the statistical methods that you will use and why will you be using them.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Systems Introduction To Databases And Data Warehouses

Authors: Nenad Jukic, Susan Vrbsky, Svetlozar Nestorov

1st Edition

1943153191, 978-1943153190

More Books

Students also viewed these Databases questions

Question

What are the important facts related to this situation?

Answered: 1 week ago