In recent years, Australians have been waiting longer before getting married for the first time

and the number of long-term de facto couples is also on the increase. These trends may have

some effect on Australian society and government policies. The table below presents the agespecific marriage rate (in percentage) of Australian males and females by age group for the

years 1993 and 2013.

Attachments:HOLMES INSTITUTE FACULTY OF HIGHER EDUCATION HA1011 APPLIED QUANTITATIVE METHODS GROUP ASSIGNMENT Assessment Details and Submission Guidelines Trimester T1 2020 Unit Code HA1011 Unit Title Applied Quantitative Methods Assessment Type Group Report Assessment Title Group Assignment (Report Format) Purpose of the assessment (with ULO Mapping) Students are required to demonstrate their understanding of the key concepts, principles and techniques of business research and statistical analysis, as delivered in the unit from weeks 1 – 10. The following unit learning outcomes are relevant to this assessment: 1. Summarise numerical data and present it both by means of tables and charts. 2. Be able to calculate and interpret descriptive summary measures. 3. Develop simple regression models and interpret the regression coefficients. 4. Understand basic probability concepts. Weight 40 % of the total assessments Total Marks 40 Marks Word limit Maximum 4,000 words Due Date Week 10 – Sunday 7 th of June 2020 Midnight(23.59PM) Late submission incurs penalties of 5 (five) % of the assessment value per calendar day unless an extension and/or special consideration has been granted by the lecturer prior to the assessment deadline. Submission Guidelines • All work must be submitted on Blackboard by the due date along with a completed assignment cover page. Please make sure that your name and surname, student ID, subject name, and code and lecture’s name are written on the cover sheet of the submitted assignment. • The assignment must be in MS Word format, no spacing, 12-pt Arial font, justify and 2 cm margins on all four sides of your page with appropriate section headings and page numbers. • Reference sources must be cited in the text of the report, and listed appropriately at the end in a reference list using Harvard referencing style. Submitted work should be your original work showing your creativity. Students need to read and understand the Holmes Academic Integrity Policy before they start any assessment. (Please refer section 4.3 Guide to Academic Integrity p 27 of the Holmes Student Handbook) Page 2 of 8 HA1011 APPLIED QUANTITATIVE METHODS GROUP ASSIGNMENT • Always keep an electronic copy until you have received the final grade for the Unit. Please make sure that you submit the correct file. Any appeal relating to submitting wrong files after the deadline will not be considered. Assignment Specifications Purpose: This group assignment aims to develop students’ understanding of various qualitative and quantitative research methodologies and techniques, which are commonly used in practice. This assignment consists of four (4) statistical questions which requires the application of different statistical techniques. The main focus of the assignment is on the topics studied from Lecture 1 to Lecture 10. This assignment is to be completed as a group assignment, but there are specific individual components. Assignment Structure: This is an applied assignment. Students have to show that they understand the principles and techniques taught in this course. Therefore, students are expected to show all the workings, and all problems must be completed in the format taught in class, the lecture notes or prescribed text book. Any problems not done in the prescribed format will not be marked, regardless of the ultimate correctness of the answer. (Note: The questions and the necessary data are provided under “Assignment and Due date” in the Blackboard.) Instructions: • Maximum members of a group is 5 and minimum is 3 members. • Your assignment must be submitted in WORD format only! • When answering questions, wherever required, you should copy/cut and paste the Excel output (e.g., plots, regression output etc.) to show your working/output. • You are required to keep an electronic copy of your submitted assignment to re-submit, in case the original submission is failed and/or you are asked to resubmit. • Please check your email prior to reporting your assignment mark regularly for possible communications due to failure in your submission. Important Notice: All submitted assignments must undergo plagiarism checking through safe-assign prior to being graded. Academic misconduct is a serious issue which will be dealt with in accordance with Holmes policies and procedures. Please refer to the Holmes Student Handbook for more information on Academic Misconduct or consult with your local campus lecturer if you require more clarification. Page 3 of 8 HA1011 APPLIED QUANTITATIVE METHODS GROUP ASSIGNMENT Students MUST Attempt ALL Questions Question 1 (8 marks) In recent years, Australians have been waiting longer before getting married for the first time and the number of long-term de facto couples is also on the increase. These trends may have some effect on Australian society and government policies. The table below presents the agespecific marriage rate (in percentage) of Australian males and females by age group for the years 1993 and 2013. Age group (years) Male Female 1993 2013 1993 2013 16–19 1.4 0.6 7.3 3.1 20-24 36.3 15.2 57.8 25.4 25-29 53.2 41.2 46.4 48.3 30-34 28.9 33.9 21.5 30.3 35-39 15.0 18.8 11.3 14.2 40-44 9.7 10.8 7.4 8.4 45-49 7.4 7.6 5.7 6.2 50 and over 3.5 3.4 1.9 1.9 a. Use a graphical technique to compare the marriage rates in 1993 and 2013, broken down by age, for Australian males. (2 Marks) b. Use a graphical technique to compare the marriage rates in 1993 and 2013, broken down by age, for Australian females. (2 Marks) c. Compare your observations in part (a) and (b). (2 Marks) d. Explain why you selected the particular graphical technique in part a and b . (2 Marks) Question 2 (10 marks) A sample of 400 visitors to an exhibition was timed to determine how long each took to view the exhibit. Three samples were taken: one in the morning (134), the second in the afternoon (133) and the third in the evening (133). These data are stored in columns 1,2 and 3 respectively of the data file. (See the data file named as data set for question No 2) a. Determine the mean, median and mode of each sample. (3 Marks) b. Determine the range, the variance and the standard deviation of each sample. (3 Marks) c. Discuss the similarities and differences among the three samples. (2 Marks) d. What are the implications of your findings? (2 Marks) Page 4 of 8 HA1011 APPLIED QUANTITATIVE METHODS GROUP ASSIGNMENT Question 3 (10 marks) The production manager of a company that manufactures car seas has been concerned about the number and cost of machine breakdowns. The problem is that the machines are old and becoming quite unreliable. However, the cost of replacing them is quite high, and the manager is not certain that the cost can be recouped given the slow economy. To help make a decision about replacement, he gathered data about last month’s costs for repairs and the ages (in months) of the plant’s 20 welding machines Repairs Age 327.67 110 376.68 113 392.52 114 443.14 134 342.62 93 476.16 141 324.74 115 338.98 115 433.45 115 526.37 142 362.42 96 448.76 139 335.27 89 350.94 93 291.81 91 467.80 109 474.48 138 354.15 83 420.11 100 416.04 137 Tasks: a. Derive the simple linear regression equation. (2 Marks) b. Interpret the slope coefficient and the intercept coefficient (2 Marks) c. Calculate and interpret the Coefficient of Determination. (2 Marks) d. Calculate and interpret the correlation coefficient. (2 marks) e. Predict the monthly repair cost of a welding machine that is 120 months old. (2 Marks) Page 5 of 8 HA1011 APPLIED QUANTITATIVE METHODS GROUP ASSIGNMENT Question 4 (10 marks) Casino Windsor conducts surveys to determine the opinions of its customers. Among other questions, respondents are asked the question ‘what is your overall impression of Casino Windsor?’. The possible responses are: Excellent, Good, Average and Poor. Additionally, the gender of the respondent is also noted. After analysing the results, the following table of joint probabilities was produced. Rating Women Men Excellent 0.27 0.22 Good 0.14 0.10 Average 0.06 0.12 Poor 0.03 0.06 a. What proportion customers rate Casino Windsor as excellent? (2 Marks) b. Determine the probability that a male customer rates Casino Windsor as excellent. (3 Marks) c. Find the probability that a customer who rates Casino Windsor as excellent as excellent is a man. (3 Marks) d. Are gender and rating independents? Explain your answer. (2 Marks) Page 6 of 8 HA1011 APPLIED QUANTITATIVE METHODS GROUP ASSIGNMENT Assignment Marks and Weighting Marking Criteria Marks Weighting 1. Selection of an appropriate chart and comparisons made a) Correct graphical representation of the marriage rate of males b) Correct graphical representation of the marriage rate of males c) Comparison of information across groups d) Clear idea on selecting suitable chart types 8 marks 8% 2 marks 2 marks 2 marks 2 marks 2. Understanding of Numerical Descriptive Measures a) Calculating mean, median and mode b) Calculating range, variance and standard deviation c) Understanding differences between samples d) Understanding the implications of analysed data 10 marks 10% 3 marks 3 marks 2 marks 2 marks 3. Application of Linear Regression and Correlation Concepts a) Estimating the regression equation b) Interpreting slope and intercept c) Calculating and interpreting R square d) Calculating and interpreting R e) Use regression for prediction 10 marks 10% 2 marks 2 marks 2 marks 2 marks 2 marks 4. Application of Probability Concepts a) Understanding joint probability b) Understanding joint probability (Question b and c) c) Understanding whether events are independent or not 10 marks 10% 2 marks 6 marks 2 marks 5. Quality of the Report Compliance with the given assignment guidelines including font type and the font size. Used the assignment cover sheet and filled the required information. Students’ details in the assignment clearly matches with the group registration details. 2 marks 2% 2 marks TOTAL MARKS 40 Marks 40% Assessment Feedback to the Student: Detailed group assignment feedback will be provided to students when grades are released. Students should seek consultation with their local campus lecturer if clarification is needed prior to final submission. Page 7 of 8 HA1011 APPLIED QUANTITATIVE METHODS GROUP ASSIGNMENT Marking Rubric Criteria Excellent Very Good Good Satisfactory Unsatisfactory Selection of an appropriate chart and comparisons made (Max 8 marks) Demonstration of an outstanding knowledge on different chart types, selection of correct chart type and making comparison. 8 -7 Marks Demonstration of very good knowledge on different chart types, selection of correct chart type and making comparison. 7 – 6 Marks Demonstration of good knowledge on different chart types, selection of correct chart type and making comparison. 6 -5 Marks Demonstration of basic knowledge on different chart types, selection of correct chart type and making comparison. 5 -4 Marks Demonstration of poor knowledge on different chart types, selection of correct chart type and making comparison. (Unsatisfactory = 0 mark if not attempted) 4 – 0 Marks Understanding of numerical descriptive measures (Max 10 marks) Demonstration of outstanding knowledge on numerical descriptive measures. 10 – 8 Marks Demonstration of very good knowledge on numerical descriptive measures. 8 – 7 Marks Demonstration of good knowledge on numerical descriptive measures. 7 – 6 Marks Demonstration of basic knowledge on numerical descriptive measures. 6 – 5 Marks Demonstration of poor knowledge on numerical descriptive measures. (Unsatisfactory = 0 mark if not attempted) 4 – 0 Marks Linear Regression and correlation concepts (Max 10 marks) Demonstration of outstanding knowledge on linear regression. 10 – 8 Marks Demonstration of very good knowledge on linear regression 8 – 7 Marks Demonstration of good knowledge on linear regression. 7 – 6 Marks Demonstration of basic knowledge on linear regression 6 – 5 Marks Demonstration of poor knowledge on linear regression. (Unsatisfactory = 0 mark if not attempted) 4 – 0 Marks Probability concepts (Max 10 marks) Demonstration of outstanding knowledge on simple probability. 10 – 8 Marks Demonstration of very good knowledge on simple probability 8 – 7 Marks Demonstration of good knowledge on simple probability. 7 – 6 Marks Demonstration of basic knowledge on Simple probability. 6 – 5 Marks Demonstration of poor knowledge on simple probability. (Unsatisfactory = 0 mark if not attempted) 4 – 0 Marks Page 8 of 8 HA1011 APPLIED QUANTITATIVE METHODS GROUP ASSIGNMENT Quality of the report (Max 2 marks) Assignment structure shows an excellent application of the template provided and is excellently formatted. 2 Marks Assignment structure is very well presented with the provided template and format. 1.8 Marks Assignment structure is coherently presented with the provided template and format. 1.5 Marks Assignment structure is partially coherently presented with the provided template and format. 1 Mark Assignment structure is not coherent with the provided template and format. (Unsatisfactory = 0 mark if not attempted) 1 – 0 Marks Unsatisfactory* : 0 mark if not attempted