Data Analysis & Reporting Flashcards
7 cards from real CSS practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 7 Data Analysis & Reporting flashcards as text
A report shows agency complaint counts for 12 months. Which measure of central tendency is least affected by one unusually large month?
Answer: Median
The median depends on the middle value's position, so a single extreme month barely changes it.
Which chart type is best for showing how a total budget is divided among five departments at one point in time?
Answer: Pie or stacked bar chart
Pie or stacked bar charts display parts of a whole at a single point in time.
A data set has values 4, 7, 7, 9, 13. What is the mode?
Answer: 7
The mode is the most frequently occurring value, and 7 appears twice.
Before analyzing a case-processing data set, an analyst finds duplicate records. What should be done first?
Answer: Verify and remove true duplicates, documenting the change
Data cleaning should verify duplicates, remove true ones, and document the change for transparency.
Which statement best describes a percentage change from 50 to 60?
Answer: 20 percent increase
The change is 10, and 10 divided by the original 50 equals 20 percent.
In a spreadsheet, which function would most directly add only the values in a column that meet a single condition?
Answer: SUMIF
SUMIF adds the cells in a range that meet a specified criterion.
A report's audience is senior leaders with limited time. Which element should come first?
Answer: An executive summary with key findings
Executive summaries put the main findings and recommendations up front for busy decision makers.
Written and edited by Nathan Beja, founder of Practice Test Geeks, with AI assistance. Exam facts are checked against the official sources linked below. Editorial policy
Sources & references
Exam facts on this page (fees, format, dates, passing scores) are checked against these official sources; the date is our last check. Editorial policy
- cp.fpsc.gov.pk — Test delivery, fees, retake policy, time limit · verified Nov 2026
- fpsc.gov.pk — Test delivery, eligibility, fees · verified Nov 2026