Reference no: EM132611225

MA508 Business Statistics - Melbourne Institute of Technology

Learning Outcome 1: Demonstrate advanced and integrated understanding of situations in which statistical analysis may be useful.

Learning Outcome 2: Critically analyse, reflect on and solve statistical problems using analytical methods.

Assignment Description

Students are required to produce an individual assignment using data provided. Data is available on MA508 Moodle shell in the folder named [Global Corporation -Customer attributes&Sales data]. You need to use Business Statistics theory, concepts, tools and terminology that you have learnt from weeks 1 to 5to analyse the data and to write upthe assignment.

Data set [Global Corporation -Customer attributes&Sales data] isobtained froma 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 which include the data for400 daysof trading.
1. Datasheet labelled [customer attributes& sales] lists the results of an online survey given to customers. The [coding]sheet indicates how the nominal data have been coded.
a. variables include:
i. Customer ID
ii. "Gender" - male or female
iii. Marital status (Married, single, divorced, widow)
iv. Age
v. Type of customer (light user, medium user, heavy user)
vi. Region that they come from (east, west, south, north)
vii. Payment which defined customers' payment methods (Paypal, credit, cash)
viii. Source (web, email, shop)
ix. Amount of customer's pay
x. Product that they have purchased (Best select, CD, Classical, DVD, Novel, Politics).
xi. Salary
xii. Days of transaction
xiii. Opening Gross Sales
xiv. Total Gross sales for the days.
xv. Price over earnings ratio
xvi. Gross profit margin (%)
xvii. Revenue ($000)

Assignment instructions:

The main challenge in the business is to increasesales, 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.

Assignment structure:
• Introduction- Introduce the business problem.
» Describe how you want to achieve this objective in this assignment
• Identifying the data types and measurement scales of all variables in the dataset
» Create a table containing all names of variables and the associated data type as well as the scale of measurement
• Calculate descriptive statisticsfor all numerical variables
» This includes mean,median, mode, minimum, maximum, range
» measures of variation: variance, standard deviation
• Discuss whether you can calculate numerical variables
» For nominal categorical variables and why?
» For ordinal categorical variables and why?
• Methods of data summarising
» Create one frequency table for region
» Create corresponding bar chart and/or pie chart
» Create one frequency table for salary
» Create corresponding histogram
• Pivot table
» Create Pivot table of region, type of customer, and amount paid and interpret the table.
• Discussion of the results and recommendations
» This section includes findings of the analysis and discussion as well as recommendations

Attachment:- Business Statistics.rar