give my a mail id
Marital status Gender Type of customer Region Payment Source Product Married=1 Male=1 Light user=1 East=1 Paypal=1 Web=1 DVD=1 Single=2 Female=2 medium userl=2 West=2 Credit=2 Email=2 CD=2 Divorced=3 Heavy user=3 North=3 cash=3 Shop=3 Novel=3 Widow=4 South=4 Classical=4 Politics=5 Best seller=6 Page 5 of 5 Assessment Details and Submission Guidelines School School of Business Course Name Master of Professional Accounting Unit Code MA508 Unit Title Business Statistics Assessment Author Dr Ken Mardaneh Assessment Type Assignment [Individual] Assessment Title Assignment [Individual] Unit Learning Outcomes covered in this assessment a. Demonstrate advanced and integrated understanding of situations in which statistical analysis may be useful. b. Critically analyse, reflect on and solve statistical problems using analytical methods. Weight 10% Total Marks 100 Marks (this will be scaled down to 10%) Word limit NA Release Date Week 2 Due Date Week 7 Submission Guidelines · All work must be submitted on Moodle by the due date along with a completed Assignment Cover Page. · The assignment must be in MS Word format, 1.5 spacing, 11-pt Calibri (Body) font and 2 cm margins on all four sides of your page with appropriate section headings. · Reference sources must be cited in the text of the report, and listed appropriately at the end in a reference list using APA or IEEE referencing style for School of Business and School of Information Technology and Engineering respectively. Extension · If an extension of time to submit work is required, a Special Consideration Application must be submitted directly to the School's Administration Officer, in Melbourne on Level 6 or in Sydney on Level 7. You must submit this application three working days prior to the due date of the assignment. Further information is available at: http://www.mit.edu.au/about-mit/institute-publications/policies-procedures-and-guidelines/specialconsiderationdeferment Academic Misconduct · Academic Misconduct is a serious offence. Depending on the seriousness of the case, penalties can vary from a written warning or zero marks to exclusion from the course or rescinding the degree. Students should make themselves familiar with the full policy and procedure available at: http://www.mit.edu.au/about-mit/institute-publications/policies-procedures-and-guidelines/Plagiarism-Academic-Misconduct-Policy-Procedure. For further information, please refer to the Academic Integrity Section in your Unit Description. Assessment Cover Sheet Student ID Number/s: Student Surname/s: Given name/s: Course: School: Unit code: Unit title: Due date: Date submitted: Campus: Lecturer: Tutor: Student Declaration I/We declare that: 1. the work contained in this assignment is my/our own work/group work, except where acknowledgement of sources is made; 1. certify that this assessment has not been submitted previously for academic credit in this or any other course; 1. I/we have read the MIT’s Plagiarism and Academic Misconduct Policy Procedure, and I/we understand the consequences of engaging in plagiarism; 1. a copy of the original assignment is retained by me/us and that I/we may be required to submit the original assignment to the Lecturer and/or Unit Co-ordinator upon request; I/we have not plagiarised the work of others or participated in unauthorised collaboration when preparing this assignment. MIT ID Signature Date For Assessor Use Only (if not marked on Moodle) Name: Position Date: Signature: Marks/Grades: 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 5 to analyse 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 which include the data for 400 days of 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 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. Assignment structure: · Introduction– Introduce the business problem. (10 marks) · Describe how you want to achieve this objective in this assignment · Identifying the data types and measurement scales of all variables in the dataset (10marks) · Create a table containing all names of variables and the associated data type as well as the scale of measurement · Calculate descriptive statistics for all numerical variables (20 marks) · This includes mean, median, mode, minimum, maximum, range · measures of variation: variance, standard deviation · Discuss whether you can calculate numerical variables (10 marks) · For nominal categorical variables and why? · For ordinal categorical variables and why? · Methods of data summarising (30 marks) · 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 (10 marks) · Create Pivot table of region, type of customer, and amount paid and interpret the table. · Discussion of the results and recommendations (10 marks) · This section includes findings of the analysis and discussion as well as recommendations Submission: You need to submit assignment in word document, data analysis is submitted as Excel file. MA508 Business Statistics Assignment [Individual] Marking Guide (10 Marks) Criteria Possible Marks% Marks Allocated · Introduction– Introduce the business problems Describe how you want to achieve this objective in this assignment 10 · 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 10 · Calculate descriptive statistics for all numerical variables This includes mean, median, mode, minimum, maximum, range measures of variation: variance, standard deviation 20 · Discuss whether you can calculate numerical measures For nominal categorical variables and why? For ordinal categorical variables and why? 10 · 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 30 · Pivot table Create Pivot table of region, type of customer, and amount paid and interpret the table. 10 · Discussion of the results and recommendations This section includes findings of the analysis and discussion as well as recommendations 10 Total 100% Overall Comments: Assessor Name: Assessor Signature: = _____/10__ Marks Date: Last updated: Trimester 3, 2019