辅导案例-MIS171 /-Assignment 2
Business Analytics – MIS171 / MISP171
Assignment 2
Trimester 2 2020
DUE DATE AND TIME:
Due by 8:00 pm AEST Friday 28 August 2020
PERCENTAGE OF FINAL GRADE:
20% of the final grade
Learning Outcome Details
ULO1: Apply quantitative reasoning skills to analyse business problems.
ULO2: Create data-driven/fact-based solutions to complex business scenarios.
ULO3: Implement contemporary data analysis tools to analyse business performance.
ULO4: Interpret findings and effectively communicate solutions to business scenarios.

Assessment Feedback:
Students who submit their work by the due date will receive their marks and feedback on Moodle on or before Friday
11 September 2020. Your assignment feedback will be returned in a rubric via Moodle with an overall mark together
with comments. In order to understand the areas where improvement is required, students are expected to refer, and
compare, their answers to the suggested solutions and discuss further improvements with the teachers.
General Description / Requirements
The assignment requires that you analyse a data set, interpret, and draw conclusions from your analysis, and then
convey your conclusions in a written report. The assignment must be completed individually. The assignment must be
submitted by the due date electronically in Moodle using the assignment submission link (Turnitin).
When submitting electronically, you must check that you have submitted the work correctly by following the
instructions provided in Moodle. Please note that we will NOT accept any hard copies or assignments submitted via
email. The assignment uses the Microsoft Excel file ‘Assignment 2 T2 2020’ which can be downloaded from Moodle.
The assignment must be completed individually.
The assignment focuses on materials presented up to and including Week 6.

Scenario
ReadyToShop Limited
ReadyToShop Limited: Background
ReadyToShop Ltd is one of Australia's leading supermarket chains. Originating from a family-based chain of general
stores, ReadyToShop now has supermarkets all over Australia. Each state capital has a company office. The company
planning and direction take place in the company Head Office in Melbourne. A principal role of the Research and
Development department in the Melbourne office is to provide statistical advice on matters affecting the company.
You (Adam Brown) are one of the leading analysts in the department.
You have received an email from the Director of Analytics (Kayden Li), that contains specific questions that you must
answer.
Email from the Director of Analytics
To: Adam Brown
From: Director of Analytics, Kayden Li
Subject: Analysis of the provided data set
Dear Adam,
At the resent board meeting, the directors have decided to initiate certain business analysis on a survey conducted
three months ago. As one of the leading analysts, can you do the following analysis and provide a report?
1. Revenue is the most important measure that the ReadyToShop is interested in. Provide with an overall estimate
of the average revenue for all the stores in all the locations?

Hint: You will need to produce the relevant tabulated summary statistics and graph(s). Then, you will need to
calculate a 90% confidence interval for average Revenue

2. Are there any differences in the overall proportion of stores surveyed in ACT, NSW, NT, QLD? That is, is there any
one state sampled proportionally, that is represented more than the others?
Hint: You will need to calculate the proportion of the number of stores surveyed in ACT, NSW, NT, QLD produce
the relevant tabulated summary statistics and graph(s). Then, you will need to calculate, compare and contrast,
90% confidence interval estimates for the proportion of stores in ACT, NSW, NT, QLD. Make sure that you
interpret your findings.
3. Are there any relationships between the variables wages, number of staff, advertising, competitors and trading
hours with the sales of the business (Consider Sales as the dependent variable)?

Hint: You will need to calculate suitable association measures and create relevant graph(s). Then interpret
the highlights of key measures.


4. Assuming that the Sales is approximately normally distributed, answer the following questions:
a. What is the probability that Sales exceeds $17million?
b. What is the probability that Sales would be less than $8million?
c. What is the minimum value of Sales that only the top 10% of the stores will achieve annually?


Hint: You only consider the sales distribution for this question. To answer this question, you will need to
produce descriptive summary statistics and find relevant information to apply for the probability calculations.

5.a. It has been suggested at our most recent meeting that the average sales of the 4 states NSW, ACT, QLD and
VIC are now more than $14million. Does this data confirm this hypothesis?

5.b. Further, is there sufficient evidence to conclude that the proportion of sales in any state is below 35% of all
sales?
Hint: To answer this question, you will need to conduct appropriate hypothesis testing for each state
separately (using 5% significance level).

Finally, include an interactive Dashboard to explore the performance of Wages, Number of staff and Gross profit.

I look forward to your response and the Dashboard

Sincerely,

Kayden Li

Please note that this diagram is only
related to part c of this question
Assignment instructions
The assignment consists of three parts:

Part 1: Data Analysis

When conducting the analysis, you will apply techniques from descriptive analytics, visualisations, probabilities, and
confidence interval calculation. Hence, you will use various tables, graphs, and summary measures. When exploring
data, we often produce more results than we eventually use in the final report, but by investigating the data from
different angles, we can develop a much better ‘feel’ for the data: a deeper understanding of the data.

 Always ensure that you consider relevant modelling assumptions such as considerations of the level of
measurement of the variable, the method of sampling, the shape of the population distribution, and the sample
size.
 The analysis section you submit should be on Q1 to Q5 sheets of the Excel file.
 Where possible, it is always useful to produce both numerical and graphical statistical summaries as sometimes,
something is revealed in one that is not obvious in the other.
 Your analysis should be clearly labelled and grouped around each question.
 Poorly presented, unorganised analysis, or excessive output will be penalised.

Part 2: Email

You are required to reply by email, detailing all essential information and relevant conclusions from your data analysis.
You are allowed no more than 2 pages to cover your written conclusions. Please use the font size 11 (Arial), 1.5 line
spacing and leave a margin of 2.54 cm.

Please consider the following dot points very carefully.

 Keep the English simple and the explanations succinct. Avoid the use of technical statistical jargon.
 Your reader will not necessarily understand complicated statistical terms, thus your task is to convert your analysis
into plain, simple, easy to understand language.
 The email is to be written as a stand-alone document. Thus, you should not have any references in the email to
your analysis, nor should you include any charts and tables in your email.
 Use an email format for your reply. That means the email heading (e.g. To: From: Subject :) should be included,
the recipient should be addressed at the beginning and the signature or name of the sender should be included at
the end.
 When composing your reply, make sure that you actually answer the questions asked.
 Do not copy the questions in the email.
 Sequentially number your answers in both your email and your analysis (1, 2 ...5) to match the email.
 Include a simple introduction at the start of the email and a summary/conclusion at the end.
 Marks will be deducted for the use of technical terms, irrelevant material, poor presentation / organisation /
formatting and emails that are over two pages long or copy questions in the email.


When you have completed the email, it is a useful exercise to leave it for a day, return to it and re-read it as if you
knew nothing about the analysis.

 Does it flow easily?
 Does it make sense?
 Can someone without prior knowledge follow your written conclusions?
Often on re-reading, you become aware that you may have made some unclear points, and find that you can re-
phrase them much more clearly.


Part 3: Interactive Dashboard

The minimum requirement is a neat, functional, interactive dashboard. It is expected that the dashboard includes up
to 5 interactive components.

The Microsoft Excel file should contain a separate sheet for the interactive Dashboard.
The following questions will help guide you in designing an interactive dashboard.

 What are the most appropriate visualisations for the dashboard?
 What about the choice of colour?
 How can I make the dashboard interactive?

Submission Instructions
Your submission will comprise of two files:

1. Your report in Microsoft Word format.
2. A Microsoft Excel workbook file (Containing: Your Analysis including all the graphs, charts etc.).
3. Submission should have the following format: MIS171_T2_StudentID.doc (or .docx) and
MIS171_T2_StudentID.xls (or .xlsx).
4. This assessment is to be submitted ONLINE ONLY into the Assessment 2 Turnitin link available on the MIS171
Moodle site.
5. All work you submit is checked electronically or by other means to detect potential collusion and/or plagiarism.
6. When you are required to submit an assignment through Moodle (Turnitin link), you will receive an instant
notification on the screen confirming that it has been submitted.
Notes
Penalties for late submission:

The following marking penalties will apply if you submit an assessment task after the due date without an approved
extension:

 5% will be deducted from available marks for each day up to five days, and work that is submitted more than five
days after the due date will not be marked and you will receive 0% for the task.
 'Day' means working day for paper submissions and calendar day for electronic submissions.
 The Unit Coordinator may refuse to accept a late submission where it is unreasonable or impracticable to assess
the task after the due date.
 For more information about academic misconduct, special consideration, extensions, and assessment feedback,
please refer to the unit outline or Deakin College student portal.

Requests for Extensions:
Students who are unable to submit an assignment by the due date, due to exceptional circumstances, may contact the
Unit Coordinator ([email protected]) to discuss options. Please submit evidence of the progress on your
analysis and the extension request via email.
Before contacting the Unit Coordinator, you must obtain appropriate documentation to support your request. You
must be able to demonstrate exceptional circumstances.

All requests must be made prior to the due date.


Good luck!
51作业君 51作业君

Email:51zuoyejun

@gmail.com

添加客服微信: ITCSdaixie