Produce an individual assignment using the data provided. Data is available on the MA508 Moodle shell in the folder named [Data set]. You need to use Business Statistics theory, concepts, tools, and terminology that you have learned from weeks 1 to 5 to analyze the data and to write up the assignment.

Data set [Global Corporation –Customer attributes &Sales data] is obtained from a global corporation. The business sells categories of products including DVD, CD, and books which include classical, novel, politics, and bestsellers.

You have been given a data set that includes the data for 400 days of trading.

The datasheet is labeled [customer attributes& sales] lists the results of an online survey given to customers.
The customer variables include:
Customer ID
“Gender” – male or female
Marital status (married, single, divorced, widow)
Age
Type of customer (light user, medium user, heavy user)
A region that they come from (east, west, south, north)
Payment which defined customers’ payment methods (Paypal, credit, cash)
Source (web, email, shop)
Amount of customer’s pay
The product that they have purchased (Best select, CD, Classical, DVD, Novel, Politics).
Salary
Opening Gross Sales
Total Gross sales for the days.
Price over earning ratio
Gross profit margin (%)
Revenue ($000)
The sales variables include.
Assignment instructions:

The main challenge in the business is to increase sales, revenue and profit. For this reason the company has decided to conduct a survey and identify the reasons for this. They have collected the data for customers’ demographics and sales.

Using statistical theory and application answer the main research questions below. Also by using the dataset create and answer any other research questions that are meaningful to you.

Assignment structure:

Introduction– Introduce the business problem. (10 marks)
Identifying the data types and measurement scales of all variables in the dataset (10marks)
Calculate descriptive statistics for all numerical variables (20 marks)
Discuss whether you can calculate numerical variables (10 marks)
Methods of data summarising (30 marks)
Pivot table and covariance (10 marks)
Discussion of the results and recommendations (10 marks)
Describe the main objective of the researchers who collected this dataset
Describe how you want to achieve this objective in this assignment
Create a table containing all names of variables and the associated data type as well as the scale of measurement
measures of location,
measures of variation such as
For nominal categorical variables and why?
For ordinal categorical variables and why?
Create two frequency tables for two different categorical variables
Create a corresponding bar chart and/or pie chart
Create two frequency tables for two different numerical variables
Create two corresponding histograms
Create a Pivot table of region, payment and source and interpret the table.
Create covariance of amount paid and salary and interpret the table.
Consider the business issues you listed in the introduction for which the above analytic methods can help
What is your conclusion
such as median, sample average, selected percentiles

variance, standard deviation, range, interquartile range

Submission: You need to submit assignment in word document, and in Excel file for data analysis.

MA508 Business Statistics Assignment [Individual] Marking Guide (10 Marks)

Criteria

Possible Marks%

Marks Allocated

Introduction– Introduce the business problems
Identifying the data types and measurement scales of all variables in the dataset
Calculate descriptive statistics For all numerical variables
Discuss whether you can calculate numerical measures
Methods of data summarising
Pivot table and covariance
Discussion of the results and recommendations
10

10

such as median, sample average, selected percentiles

variance, standard deviation, range, interquartile range

20

10

30

10

10

Total

100%

Overall Comments:

= _____/10