Analyze a messy spreadsheet

Purpose

Learn how the model cleans data, uses tools, and supports a business conclusion.

What you need

• A CSV or spreadsheet with missing values, inconsistent labels, and extra columns.
• One business question.

Prompt

Analyze this file and answer the business question. Explain how you cleaned the data. Show the calculations that support the answer. State all important limits.

What to observe

• Does the model inspect the data before it calculates?
• Does it clean values without losing important records?
• Are the calculations correct and repeatable?
• Does the conclusion match the evidence?