Assessment 3 Assessment Type: Computer assignment analysis and 1,500 + 10% word report individual assessment. Purpose: To allow students to demonstrate an understanding of statistical analysis and the ability to summarise and manipulate sample data, make basic statistical inferences and interpret the results in a business context. This assessment contributes to learning outcome a, b, c and d. Value: 25% (Preparation quizzes 5% and Word file, Excel file 20%) Submission: Preparatory Quizzes access and submit via Moodle links. An excel file with a unique dataset and summaries of the dataset. A word file with answers to questions about the summaries of the dataset and questions about some videos that discuss why statistics is useful.

Task details: Each individual student will be provided with their own unique dataset and they will have to summarize the dataset using PivotTable and Scatterplot commands using Microsoft Excel Students will have to use the summaries as the basis of a report that using descriptive and inferential statistics. Students will also have to use the dynamic array functions in Microsoft excel to create datasets with summaries that are like their own unique dataset and describe the relationship between the variables in simple terms that could be understood by someone that has not done a business statistics course. Preparatory Quizzes: Before you start summarizing your dataset, you need to do the Preparatory Quizzes to ensure you are familiar with the concepts and techniques involved. You may attempt the Quizzes as many times as you like each new attempt will overwrite the previous attempt. Only the last attempts will be marked. Marking Guide: Preparatory Quizzes: worth a total 5% of the final grade individual marks will be identified with each quiz in Moodle. Discussion of a sample repot worth 20% of the final grade. The marking rubric is given on the next page