代写 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