This is an individual assignment, which focuses on materials presented from Week 1 to (and including) Week 6 (Hypothesis Testing). The scenarios presented in this assessment task simulates a data- driven fact-based solution to a scenario faced by the Deakin Melbourne Boomers. For confidentiality reasons, actual data has not been used in the assessment tasks.
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.
1. An Excel file, which will include: (a) all your analysis, and (b) an interactive dashboard,
2. A Word file, which will include your report to Christy.
The following introduction to this scenario is followed by detailed guidelines.
The Deakin Melbourne Boomers have been a part of the Women’s National Basketball League (WNBL) since 1984, making the club both the oldest WNBL club and
the longest-running elite-level women’s sports team in Australia (in any sport). The iconic brand of the Boomers is both nationally and internationally recognised, most notably for being home to more Olympians and Opals than any other basketball club across Australia.
For 30 years the team was known as the Bulleen Boomers, before transforming into the Melbourne Boomers in 2013. In 2015 Deakin University joined as the club’s Naming Rights partner.
The Boomers’ Melbourne rivals are the Southside Flyers, which were formed in 2019. The Flyers are based in Dandenong. The Boomers are also based in Melbourne’s eastern suburbs. There are no other Melbourne-based WNBL teams.
Currently, the Boomers have almost 7,000 members. There are also more than 3,000 non-members on the Boomers’ database, making a distribution list of over 10,000 contacts.
The Boomers use a variety of “Campaigns” to engage with all contacts on their database. All campaigns invite members to renew their membership and non-members to join.
Assume that you are recruited by the Boomers as a business analyst. You have been asked by Ms Christy Collier, the General Manager, to analyse a sample of 250 randomly selected campaigns from the past 10 years alongside new memberships from January 2011 to December 2020.
Christy requires answers to the following questions. Your responses will be used as part of a report to the Managing Board. Christy’s questions together with guidelines (shown in blue) are presented below. For all questions use a 5% Level of Significance (α = 5%).
1. Campaign Revenue is an important measure for the Deakin Melbourne Boomers. Please provide details of the average “Campaign Revenue” in different “Campaign Types”.
• Create suitable tables of summary statistics and at least one graph,
• calculate 95% confidence interval estimates for the average “Revenue” for each “Campaign Type”,
• in the Conclusion section write a (one sentence) conclusion for each “Campaign Type” (e.g., “I am 95% confident…”).
• in the Conclusion section, in one sentence, answer the question “Which “Campaign Type” generates the highest Revenue?”
• Note: a brief interpretation of your analysis for this question must be included in your report to Christy.
• In Assignment 1, you created comparative summary measures and relevant graphs regarding Campaign Revenue in different Campaign Types. Compare your analysis with the provided Assignment 1 solution to ensure your analysis is correct.
2. The Melbourne Boomers aim to have an equal number of Campaign Types. Is there any “Campaign Type” that, proportionally, is represented more (or less) than others?
• Calculate 95% confidence interval estimates for the proportion of campaigns in each “Campaign Type”,
• in the Conclusion section write a (one sentence) conclusion for each “Campaign Type” (e.g., “I am 95% confident…”),
• in the Conclusion section, in one sentence, answer the question “Is there any “Campaign Type” that, proportionally, is represented more (or less) than the others?
• Note: a brief interpretation of your analysis for this question must be included in your report to Christy.
• In Assignment 1, you created tables and graphs regarding different campaign types. Compare your analysis with the provided Assignment 1 solution to ensure your analysis is correct.
3. Assuming that “Campaign Success” is approximately normally distributed, answer the following questions for each individual “Campaign Type”. What is the probability that “Campaign Success” is above 75 for each “Campaign Type”?
• You will need to create suitable comparative summary measures and histograms (with bins = 10, 20, etc) for “Campaign Success” in different “Campaign Types”,
• for each “Campaign Type” calculate the probability of “Campaign Success” being more than 75,
• in the Conclusion section write a (one sentence) conclusion for each “Campaign Type” (e.g., “The probability that Campaign Success …”).
• Note: a brief interpretation of your analysis for this question must be included in your report to Christy.
4. The Melbourne Boomers are considering whether there have been any changes in new memberships per month. They suspect that the average “New Membership” per month may
have changed since 2000 when it was 85 new memberships per month. Does the data support this view?
• Conduct an appropriate hypothesis test for “New Membership”,
• in the Conclusion section write a (one sentence) conclusion (e.g., “At a 5% level of Significance…”).
• Note: a brief interpretation of your analysis for this question must be included in your report to Christy.
The assignment consists of three parts.
Your data analysis must be performed on the Assignment 2 Excel file. The file includes tabs for:
• Data Description
• Campaign Sheet
• Membership Sheet
• Analysis for questions 1, 2, 3, and 4
• Interactive dashboard (see below)
• Any additional analysis you want to include in your report or dashboard.
When conducting the analysis, you will apply techniques from descriptive analytics, visualisations, probabilities, hypothesis testing, and confidence interval calculations. Hence, you will use the appropriate 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. This will be valuable when drafting your written report.
The analysis section you submit should be on the Q1 to Q4 worksheets 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.
One of the key performance measures of Ms Christy Collier is raising revenue for the Deakin Melbourne Boomers. Having analysed the sample data, including answers to the Data Analysis questions from Part 1 and any further analysis which is appropriate, you are required to provide a report which:
a) Answers all 4 questions described in the Scenario,
b) Makes one recommendation about the “Campaign Type” and “Campaign Media” the Deakin Melbourne Boomers should focus on to achieve the goal of maximising revenue generation. You must explain why you have selected this campaign type. Your recommendation must be supported by an explanation that is based on your analysis of the data.
Highest marks will be awarded to students which consider both “Campaign Type” and “Campaign Media” when drafting their recommendation.
You are allowed no more than 2 pages (approximately 1,000 words) for your report. Remember you should use font size 11 and leave margins of 2.54 cm. A template is provided for your convenience. Carefully consider the following points:
• Your report is to be written as a stand-alone document. Assume that Christy will pass your report directly to her team. Keep the English simple and the explanations succinct. Avoid the use of technical statistical jargon. Your task is to convert your analysis into plain, simple, easy to understand language.
• When composing your reply, make sure that you directly answer the questions asked. Cite (state) the summary statistics of importance without referring to your analysis section.
• Do not copy the Assignment Instructions when drafting your report.
• Include a succinct introduction at the start of your report.
• Marks will be deducted for the inclusion of irrelevant material, poor presentation, poor organisation, poor formatting, and reports that exceed two pages.
Include an interactive “dashboard” for Christy which will help her understand and visualise key data and allow her to drill down into the data.
Your interactive dashboard must be completed on the “Dashboard” tab of the Excel file.
The minimum requirement is a neat, functional, interactive dashboard. It is expected that the dashboard includes at least four (4) and up to six (6) interactive components.
The following questions will help guide you in designing an interactive dashboard.
1. What are the highest priority areas that should be included in the Dashboard?
2. What are the most appropriate visualisations for the dashboard?
3. What about colour choices?
4. How can I make the dashboard interactive?
This task allows you to demonstrate achievement towards the unit learning outcomes (ULOs). The ULOs are aligned with specific graduate learning outcomes – that is, the skills and knowledge graduates are expected to have upon completion of their studies – and this assessment task is an important tool in determining the achievement of those outcomes. If you do not demonstrate the achievement of the unit learning outcomes, you will not be successful in this unit.
It is good practice to familiarise yourself with the ULOs and GLOs as they provide guidance on the knowledge, understanding and skills you are expected to demonstrate upon completion of the unit. In this way, they can be used to guide your study.
Your submission will comprise of two files:
1. A Microsoft Word document containing Part 2: your report to Christy, and
2. A Microsoft Excel workbook file containing:
a. Your Analysis, on the relevant tabs, and
b. Your Dashboard.
Word file: MIS171_T1_YOURStudentID.doc (or .docx), and Excel file: MIS171_T1_YOURStudentID.xls (or .xlsx).
Enter YOUR student ID in the appropriate place when naming your submission files. This assessment is to be submitted ONLINE ONLY into the Assessment 2 Dropbox available on the MIS171 Cloud Deakin site. All work you submit is checked electronically or by other means for the purposes of detecting collusion and/or plagiarism.
When you are required to submit an assignment through your CloudDeakin unit site, you will receive an email to your Deakin email address confirming that it has been submitted. You should check that you can see your assignment in the Submissions view of the Assignment Dropbox folder after upload, and check for, and keep, the email receipt for the submission.
The marking rubric for this task is available in the MIS171 CloudDeakin unit site - in the Assessment folder (under Assessment Resources).
It is always a useful exercise to familiarise yourself with the criteria before completing any assessment task. Criteria act as a boundary around the task and help identify what assessors are looking for specifically in your submission. The criteria are drawn from the unit’s learning outcomes ensuring they align with appropriate graduate attribute/s. Identifying the standard, you aim to achieve is also a useful strategy for success and to that end, familiarizing yourself with the descriptor for that standard is highly recommended.
Extensions will only be granted for exceptional and/or unavoidable circumstances outside the student’s control.
Students seeking an extension for an assignment before the due date should apply directly to the Unit Chair (Dr Reza Kachouie: MIS171@deakin.edu.au) by completing the Assignment and Online Test Extension Application Form. Requests for extensions will not be considered after 12 pm (noon), Friday 30 April 2021. When requesting an extension, you need to provide evidence to support your request and a draft of the work that you have completed on the assessment to date. You must be able to demonstrate exceptional circumstances. Applications for special consideration after this time must be submitted via StudentConnect.
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 will receive 0% for the task. 'Day' means working day for paper submissions and calendar day for electronic submissions. The Unit Chair may refuse to accept a late submission where it is unreasonable or impracticable to assess the task after the due date.
CS 340 Milestone One Guidelines and Rubric Overview: For this assignment, you will implement the fundamental operations of create, read, update,
Retail Transaction Programming Project Project Requirements: Develop a program to emulate a purchase transaction at a retail store. This
7COM1028 Secure Systems Programming Referral Coursework: Secure
Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip
CS 340 Final Project Guidelines and Rubric Overview The final project will encompass developing a web service using a software stack and impleme
