Apply descriptive statistics to “Baseball Salaries” dataset provided in the resources on LMS. ❑Determine the measures of central tendency. ❑Determine the variance and standard deviation. ❑Graph the distribution of the data and determine whether it is normal or skewed.
1 Unit MBIS4009 Business Analytics Assessment Type Practical Project Assessment Number 3 Assessment Weighting Individuals 30% Alignment with Unit and Course Unit Learning Outcomes Graduate Attributes Assessed ULO01: Interpret concepts of Business Analytics in data-driven business environments. ULO02: Analyse and reflect on the application of different Business Analytics techniques in business scenarios. ULO03: Use Business Analytics approaches to find trends and patterns in data from which to form a sustainable competitive advantage. ULO04: Examine the features of various Business Analytics software and draw insights from their application in business situations. 1. Communication: The ability to communicate persuasively, both orally and in writing, with a diverse range of audiences. 2. Collaboration: The ability to build and manage teams, and to liaise and co-operate with stakeholders successfully. 3. Research: The ability to conduct and evaluate project. 4. Critical thinking & problem solving: The ability to pro-actively identify and solve problems creatively and in a structured and methodical way. 6. Flexibility: The ability to critically assess, evaluate and synthesize alternatives. 8. Self-sustained learning: The ability to conduct future self-sustained learning through accurate and advanced research. Due Date/Time Week 6 and Week 10 Report due Week 6 and Week10 (Friday) via Moodle Turnitin 5:00pm (AEST) Assessment Description Students will work individually to submit an assessment with two parts: Part A (10%) and Part B (20%) based on the application of business analytic techniques on a given case study. This assessment aims at students performing advanced business analytics on a chosen data set and writing a report based on the topics covered in the previous week’s workshops. Business analytics is the process of performing autonomous or semi-autonomous insight extractions from real world data using sophisticated techniques and tools. Through this assessment, students are expected to utilise sophisticated techniques and tools to drive facts driven decision making based on complex, real world data that would create value for stakeholders. In addition, students are expected to work individually to address the questions pertaining to this two-part assessment. The assessments are aimed at testing students’ ability to apply concepts, tools and techniques covered during the lectures to ensure they meet the required learning outcomes. Part A Students will identify a given dataset they need to answer a set of questions pertaining to the dataset. 2 You have been hired as a consultant to assist the marketing manager of a large supermarket chain in Australia to determine the effect of shelf space (in metres) on the weekly sales of international food (in thousands of dollars). A random sample of 12 equal- sized stores was selected, with the following results: Store Shelf Space X Weekly Sales Y 1 10 2.0 2 10 2.6 3 10 1.8 4 15 2.3 5 15 2.8 6 15 3.0 7 20 2.7 8 20 3.1 9 20 3.2 10 25 3.0 11 25 3.3 12 25 3.5 You are required to provide a short report answering the following questions that were required of the department head for marketing to assist with their planning. Include the normal elements of a report such as cover page, table of content, introduction, body, and conclusion with emphasis on answering the questions pertaining to the marketing efforts. (A) Draw a scatterplot of the data and comment on the relationship between shelf space and weekly sales. (B) Run a regression on this data set and report the results. (C) What are the coefficients of the Y-intercept (a) and slope (b) of the least squares regression? (D) Interpret the meaning of the slope b. (E) Predict the average weekly sales (in hundreds of dollars) of international food for stores with 13metres of shelf space for international food. (F) Why would it not be appropriate to predict the average weekly sales (in hundreds of dollars) of international food for stores with 35 metres of shelf space for international food? (G) Identify the coefficient of determination, , and interpret its meaning. (H) Determine the standard error of the estimate. What does it represent? Each question should have its own section heading in the report and it should be formatted professionally as one can expect from a consultant report that would be submitted to senior management within the organisation. 3 Part B An online travel agency is performing market analysis to determine how their sales have impacted Koala’s travel agencies in key cities since its launch ten years ago. As the organisations Business Analyst, you were asked by the CEO to analyse and evaluate the monthly number of airline tickets sold in their Sydney branch during the first four years of their business journey. The forecast would be useful for future planning of the company. The table of the dataset is provided below: (A) Is this time series random? Perform a runs test and compute a few autocorrelations to support your answer. (B) Does a linear trend appear to fit these data well? If so, estimate the linear-trend model for this time series, and interpret the value. (C) Is there evidence of some seasonal pattern in these sales data? If so, characterize the seasonal pattern, and explain how to forecast future values. (D) Describe the best practices in business reporting and how can you make the business reports stand out? Students are expected to prepare a short business report where they are expected to present the key findings of their analysis and evaluation answering the questions provided in this section. The report should include a cover page, table of content, introduction, body, and conclusion section with an emphasis on answering the questions provided in this section. Each question should have its own section heading in the report and it should be formatted professionally as one can expect from a consultant report that would be submitted to senior management within the organisation. 4 You are encouraged to attend the workshop on Referencing and Research Practice organised with the Academic Success Team (AST). You may also schedule a one-on-one workshop with the AST by emailing academicsuccess@aih.nsw.edu.au. Students must adhere to the information provided in the marking rubric. Each report should not exceed 1,500 words. Research expectation: ● The submission needs to be supported with information by credible sources. ● Credible sources should be varied and include, but not limited to, the Textbook, Government reports, Industry reports, Newspaper articles, Books, and Journal articles. ● Use the EBSCO Databases accessed through the Library and Learning Support page on Moodle to find journal articles, case studies and more to help you prepare your assessment. Speak with the library assistants or email (academicsuccess@aih.nsw.edu.au) if you require further assistance. Detailed Submission Requirements ● Use Harvard referencing including the reference list ● All students must submit the peer evaluation via relevant Moodle link before the assessment due date ● You must submit the assessment through the Assessment 3 Part A and Part B Turnitin link on the Moodle page for this unit Individual Work Misconduct ● The assessment will be submitted through Turnitin via your unit page on Moodle. ● Turnitin is plagiarism software, which will identify if you have copied information and included it in your assessment. ● Copying information from others (i.e. websites, partner company information, or other students etc.) without acknowledging the author is classified as misconduct. ● Engaging someone else to write any part of your assessment is classified as misconduct. ● To avoid being charged with Misconduct, students need to submit their own work and apply Harvard Style Referencing (ask your lecturer or the learning support coordinator (academicsuccess@aih.nsw.edu.au) if you do not know what this means, or you need assistance applying it). ● The AIH misconduct policy and procedure can be read on the AIH website (https://aih.nsw.edu.au/about-us/policies-procedures/). ● Use the AIH referencing guide accessible via Library and Learning Support Page on Moodle. Late Submission ● Any assessment submitted past the specific due date and time will be classified as Late. ● Any Late submission will be subject to a reduction of the mark allocated for the assessment item by 5% per day (or part thereof) of the total marks available for the assessment item. A ‘day’ for this purpose is defined as any day of the week including weekends. Assignments submitted later than one (1) week after the due date will not be accepted, unless special consideration is approved as per the formal process. Special consideration ● Students whose ability to submit or attend an assessment item is affected by sickness, misadventure or other circumstances beyond their control, may be eligible for special consideration. No consideration is given when the condition or event is unrelated to the student's performance in a component of the assessment, or when it is considered not to be serious. mailto:academicsuccess@aih.nsw.edu.au mailto:academicsuccess@aih.nsw.edu.au mailto:academicsuccess@aih.nsw.edu.au https://aih.nsw.edu.au/about-us/policies-procedures/ 5 ● Students applying for special consideration must submit the form within 3 days of the due date of the assessment item or exam. ● The form can be obtained from the AIH website (https://aih.nsw.edu.au/current- students/student-forms/) or on-campus at Reception. ● The request form must be submitted to Student Services. Supporting evidence should be attached. For further information please refer to the Student Assessment Policy and associated Procedure available on ● (https://aih.nsw.edu.au/about-us/policies-procedures/). https://aih.nsw.edu.au/current-students/student-forms/ https://aih.nsw.edu.au/current-students/student-forms/ https://aih.nsw.edu.au/about-us/policies-procedures/ 6 MBIS4009 Business Analytics Assessment 3 –Individual Report - Marking Rubric Rubrics Criteria Marking Criteria HD D C