Graded Quiz: Data Analysis and Visualization :Capstone Project: Applying Business Analysis Skills (IBM Business Analyst Professional Certificate) Answers 2025

Question 1

What is the primary goal of data cleaning in this assignment?

❌ To create advanced visualizations
❌ To automate appointment scheduling processes
✅ To ensure data accuracy and consistency for meaningful analysis
❌ To identify the root cause of all operational inefficiencies

Explanation:
Data cleaning ensures the dataset is accurate, consistent, and reliable, which is essential before performing any meaningful analysis.

Question 2

Which Excel tool is best for summarizing and categorizing large datasets?

❌ Conditional formatting
❌ Data validation
✅ Pivot tables
❌ INDEX-MATCH

Explanation:
Pivot Tables are specifically designed to summarize, group, and categorize large volumes of data efficiently.

Question 3

Why is it important to analyze trends in patient visits and resource usage?

❌ To implement new IT systems immediately
❌ To generate invoices for hospital services
✅ To identify peak times, resource shortages, and inefficiencies
❌ To determine the hospital’s overall budget

Explanation:
Trend analysis helps organizations optimize staffing and resources by identifying usage patterns and inefficiencies.

Question 4

What Excel function would you use to merge data from two datasets using a common identifier?

✅ VLOOKUP
❌ COUNTIF
❌ SUM
❌ CONCATENATE

Explanation:
VLOOKUP retrieves matching data from another table using a common key or identifier.

Question 5

Which chart type is most suitable for identifying patterns in patient visits over time?

❌ Bar chart
❌ Scatter plot
❌ Pie chart
✅ Line chart

Explanation:
Line charts are ideal for showing trends and changes over time.

🧾 Summary Table