statistics

Overview

This is a group assignment. It assesses your achievement of the following learning outcomes:

LO1: Present and describe information effectively

LO3: Draw conclusions about populations using sample information

LO4: Suggest ways to improve decision making processes

LO5: Obtain reliable forecasts of variables of interest

In this assignment, you are required to produce several statistical analyses for a given case study. The

analyses must be carried out using Microsoft Excel and Microsoft Power BI. For more details, refer to the

questions and tasks on the next page.

Submission items

You are required to submit the following:

a. One piece of written group report. Length: not more than 12 pages (A4-size, 11pt font size,

single space). The report should address all questions in this assignment.

b. One Excel workbook (.xlsx file), consisting of 7 worksheets. Each worksheet demonstrates the

working of questions 3 – 9.

c. One-page Power BI dashboard uploaded to Power BI service and shared with your Unit

Coordinator and the teaching support team. This addresses question 10.

d. One recording of PowerPoint presentation, saved as either .mp4 or .wmv format.

Items a, b and d must be compressed together into a single .zip file. Rename the .zip file with your group

number (e.g. Group1.zip).