代写 MIS171 Business Analytics FACULTY OF BUSINESS & LA
100%原创包过,高质代写&免费提供Turnitin报告--24小时客服QQ&微信：120591129
代写 MIS171 Business Analytics FACULTY OF BUSINESS & LAWMIS171 Business Analytics Assignment Two – Trimester 2, 2016 Page 1 of 5
‐
DEAKIN UNIVERSITY
FACULTY OF BUSINESS & LAW
SCHOOL OF INFORMATION AND BUSINESS ANALYTICS
MIS171 Business Analytics
Assignment Two
Marks: 20% (Twenty Multiple Choice Questions)
The Quiz opens Saturday 24st Sep 2016, 10am
The Quiz closes Monday 26th Sep 2016, 11.59pm
The Quiz Window 2 hours (i.e. once you start the quiz, you will have 2 hours to complete it)
Background
This is an individual assignment and it focuses on materials presented in Topics 5‐9.
To complete the assignment you should first analyse the dataset to answer the specific questions asked in the
email from the Ballarat City Council (see page 3). Secondly, you should interpret the results, and be able to
draw conclusions. Once you have done this, you will have the necessary output (i.e. Data Analysis) to complete
the online quiz. The quiz contains twenty (20) randomly allocated questions that relate to the data analysis,
interpretation, and drawing conclusions.
The assignment again uses the file BusinessConfidenceDATA_T2_2016.xlsx which can be downloaded from
CloudDeakin.
Note:
1. You do NOT need to submit any data analysis or any written work. However, you will need to refer to
your data analysis and written work in order to answer the multiple‐choice questions successfully.
2. The online quiz will be open for just over 2 ½ days.
3 Once you start the quiz, you have a 2‐hour window to complete it.
4 No time extension is possible. That is, as this assignment is due one week before the end of trimester,
and as students require timely feedback, the solutions will be released very soon after the quiz closes.
If there are extenuating circumstances beyond your control, you can apply for a special consideration.
See http://www.deakin.edu.au/students/assessments/special‐consideration
MIS171 Business Analytics Assignment Two – Trimester 2, 2016 Page 2 of 5
Assurance of Learning
This assignment assesses following Graduate Learning Outcomes and related Unit Learning Outcomes:
Graduate Learning Outcome (GLO) Unit Learning Outcome (ULO)
GLO1: Discipline‐specific knowledge and capabilities:
appropriate to the level of study related to a
discipline or profession.
ULO4: Use contemporary data analysis tools to
analyse business performance.
This assignment assesses proficiency in the use of
data analysis tools within Microsoft Excel (one of the
most widely used data analysis tools).
GLO4: Critical Thinking: evaluating information using
critical and analytical thinking and judgement.
ULO2: Apply quantitative reasoning skills to analyse
business performance.
This assignment assesses the ability to think and
assess information more comprehensively. That is to
evaluate information and our thoughts in a
disciplined way.代写 MIS171 Business Analytics FACULTY OF BUSINESS & LAW
GLO5: Problem Solving: creating solutions to
authentic (real world and ill defined) problems.
ULO3: Create data driven/fact based solutions to
complex business problems.
This assignment assesses the ability to use the
appropriate technique to analyse the data, correctly
interpret the analysis output and draw appropriate
conclusions.
Feedback prior to submission
Students are able to seek assistance from the teaching staff to ascertain whether the assignment conforms to
submission guidelines.
Feedback after submission
In order to understand areas where improvement is required, students are expected to refer, and compare,
their answers to the suggested solutions.
Scenario
You continue to play the role of Vic Rankin, an analyst for Business Intelligence (BI). BI are data analytics
research service consultants that provide data modelling solutions to large organisations and governments, as
well as supporting various niche research projects across a variety of industry sectors.
Australian rural communities make a considerable contribution to the Australian economy yet very little
research has been done on the specific business communities that support the rural sector. For example, little
is known about the market place confidence and expectation of businesses that exist in the townships and small
rural cities that exist in these urban communities.
BI has been contracted because some rural municipal authorities have identified a need to focus expenditure
and related activities to assist in business growth. One such municipal authority is the Ballarat City Council. In an
effort to understand the marketplace confidence of the Ballarat businesses that support their local community,
BI has taken a random sample of 150 businesses. As well as asking them for useful demographic characteristics,
BI have asked questions about trading patterns, business confidence and business expectations. You have received
another email from the Ballarat City Council that contains specific questions that you must answer.
MIS171 Business Analytics Assignment Two – Trimester 2, 2016 Page 3 of 5
To: Vic Rankin
From: Ballarat City Council
Subject: Further analysis of Business confidence and expectation
Dear Vic,
Whilst I understand your previous reply was for 150 local Ballarat regional businesses, for this analysis, please provide
conclusions for all of our regional businesses. That is, I have been led to believe that because your data was collected
randomly, you can use your dataset to make inferences about all of our regional businesses. With that in mind, I hope you
are able to provide me with answers to the following questions.
1. Can you estimate the average number of people that local businesses employ in our region?
2. Can you estimate the proportion of all businesses in our region that do have a growth strategy?
3. The Creswick/Clunes Chamber of Commerce recently indicated that the proportion of businesses registered in their
region that do have a growth strategy was 76%. They then went on to suggest in a confidential report that any
proportion less than this value contributed to a significant reduction in the revenue generated in the region.
a. Is there any evidence to suggest that the proportion of our local businesses that do have a growth strategy
could be less than this suggested figure and thus impacting on revenue in our region?
b. Can you estimate the average number of staff for businesses with and without a growth strategy and can we
therefore conclude that businesses with a growth strategy have a higher number of employees on average,
and might therefore be more successful?
4. From your recent analysis of 150 businesses, I was very interested to learn that our local business managers seemed
rather young, with an average age of about 48 years. This seems at odds with a recent report that stated the average
age of managers in Australian businesses was 50 years. Can you please
a. Determine if the average age of our local business managers is indeed less than 50 years?
5. Over the years we have observed that an average of 10 businesses open each year. What is the likelihood that next
year:代写 MIS171 Business Analytics FACULTY OF BUSINESS & LAW
a. More than 15 businesses will open?
b. The number of businesses that open will be 5 or less?
6. Finally, when we conduct this survey again next year, we would like to be able to:
a. Estimate the average number of people that local business employ to within 4 employees, and,
b. Estimate the percentage of business with a growth strategy to within 2%.
Are you able to advise us on the sample size required that satisfies both these criteria? I look forward to your response.
Sincerely,
Ballarat City Council
MIS171 Business Analytics Assignment Two – Trimester 2, 2016 Page 4 of 5
Guidelines for Data Analysis
The analysis required for this assignment involves materials covered in Topics 5‐9. The corresponding seminars
will also provide useful materials.
For all questions in the email, you can assume that:
• a 95% confidence level is appropriate for confidence intervals and
• a 5% level of significance (that is, alpha (α) = 0.05) is appropriate for hypothesis tests.
Although questions can be completed using Excel (for example using the worksheets contained in the file
Htests CIs Sample Size and PDFs.xls), we strongly recommend that you do the analysis using a pen and paper
approach too, as this will help you confirm your results and give you greater insight for the examination. For
instructions on how to use the spread sheet Htests CIs Sample Size and PDFs.xls, please read the comments in
cell G1 (hover the mouse cursor over G1 in the first worksheet and the comments will appear).
• Before doing any analysis, classify your data as numerical or categorical.
• Most questions will require you to complete either a confidence interval or a hypothesis test. Go
through each of the questions asked by the Ballarat City Council and decide which technique is the
most appropriate.
Below are some hints regarding the most appropriate technique:
Do we have to make an estimate, and therefore need a confidence interval?
Are we testing a theory/claim/or comparing values… and therefore need a hypothesis test?
• To answer some questions you may need to make certain assumptions about the dataset we are using.
• For Question 5, you will need to calculate the probability using an appropriate probability distribution
table (binomial, Poisson or normal). You could then use Excel to confirm your answer. You do not need
the BusinessConfidenceDATA_T2_2016.xlsx dataset to answer this question.
Guidelines for your Online Quiz
Once you have completed your data analysis you should summarise the key findings for each question and
write a response to the Ballarat City Council’s questions. Before you attempt the on‐line quiz, make sure you
have a print out of your data analysis, your summaries and your ‘sample’ responses so that you can refer to
them when completing the quiz. You need to be familiar with all aspects of your assignment.
The quiz contains 20 multiple‐choice questions. Some questions focus on the appropriateness of the technique,
steps in the analysis, intermediary calculations, and the theoretical assumptions you had to make. The rest of
the questions relate to interpreting and drawing conclusions from your analysis.
The following two sample questions are indicative of the type of multiple‐choice questions you will receive in
the quiz.
Q1. From the following statements, which is the most appropriate when estimating the
average number of people employed by regional businesses?
a) The standard error is 5.214
b) We use the t distribution with 148 degrees of freedom
c) We use the normal distribution with z set at 1.645
MIS171 Business Analytics Assignment Two – Trimester 2, 2016 Page 5 of 5
d) We are dealing with a numerical variable measured on the ratio scale
Q2. When testing a suggestion that the average age of managers is in the region is
greater than 60 years, which of the following statements is correct?
a) H0:
代写 MIS171 Business Analytics FACULTY OF BUSINESS & LAW
