ANL203 Analytics for Decision-Making Tutor-Marked Assignment 2025-26| SUSS

ANL203 TUTOR-MARKED ASSIGNMENT (TMA)

This assignment is worth 20% of the final mark for ANL203 Analytics for Decision-Making.  The cut-off date for this assignment is 13 September 2025, 2355hrs

Note to Students:

Compose your report using Microsoft Office Word, and save either as .doc or .docx (preferred).

You are to include the following particulars in your submission: Course Code, Title of the TMA, SUSS PI No., Your Name, and Submission Date.

ANL203 Question 1

You are provided with a dataset that captures information for the obesity levels in individuals. The dataset incorporates a wide range of variables that reflect individuals’ demographics, eating habits, physical activity, and other daily routines that may influence body weight. For a detailed explanation of the variables and their definitions, please refer to the second sheet of the attached Excel file, titled “Data Dictionary.” Note that the obesity level is based on the Body Mass Index (끫롪끫롪끫롪 =끫뢔끫뢔끫뢔끫뢔ℎ끫룂(끫뢰끫뢔)/끫롶끫뢔끫뢔끫뢔ℎ끫룂(끫뢴)2 ).

(a) Identify a business problem that can be addressed through an analysis of the dataset. List the relevant data fields and explain how these fields can be utilized to address the business problem. (Maximum of 150 words for part (a))(10 marks)

(b) Identify and correct the data issues and errors in the dataset with explanations and justifications. Illustrate the data preparation with relevant example screenshot(s). (Up to 250 words for part (b))(20 marks)

(c) Generate a summary of the updated dataset in tabular format. You should include the classification of each data field as nominal, ordinal, interval, or ratio. Examine individual variables within the dataset and compute relevant summary measures when applicable. (Up to 200 words for part (c)) (20 marks)

(d) Employ two graphical charts and one pivot table to present the key features of the data variables or to analyse the relationship among the variables. Please provide a screenshot of each produced chart and pivot table. In your explanation, describe the process of creating the charts and the pivot table and discuss why these visualizations are recommended. (Up to 250 words for part (d))(30 marks)

The word limit does not apply to visuals or screenshots of data preparation example(s), charts and pivot tables. 20 marks will be allocated to the professional presentation and writing of your TMA report, e.g., covering the following aspects,

• Organisation 
• Communication of ideas 
• Citation and reference 
• Grammar