CCRM Data Analytics 2 — Questions and Answers
Question 1: A client relationship manager notices that customer churn rate increased by 15% after a product update. Which analytical approach best identifies the root cause?
- Descriptive analytics summarizing historical churn data
- Diagnostic analytics drilling into behavioral patterns before and after the update (Correct answer)
- Predictive analytics forecasting future churn rates
- Prescriptive analytics recommending retention offers
Correct answer: Diagnostic analytics drilling into behavioral patterns before and after the update
Diagnostic analytics is designed to identify why a metric changed by examining underlying patterns and correlations.
Question 2: When segmenting clients by lifetime value, which metric is MOST critical to include in the calculation?
- Number of support tickets submitted
- Average purchase frequency multiplied by average order value and customer lifespan (Correct answer)
- Number of referrals made by the client
- Social media engagement score
Correct answer: Average purchase frequency multiplied by average order value and customer lifespan
Customer Lifetime Value (CLV) is calculated using purchase frequency, average order value, and expected customer lifespan.
Question 3: A CRM analyst wants to predict which clients are most likely to upgrade their service tier. Which machine learning approach is most appropriate?
- Clustering to group clients by demographics
- Classification model trained on historical upgrade behavior (Correct answer)
- Time-series analysis of support ticket volume
- Association rule mining for product bundling
Correct answer: Classification model trained on historical upgrade behavior
Classification models predict categorical outcomes (upgrade vs. no upgrade) based on historical labeled data.
Question 4: Which visualization type is best suited for showing the distribution of client satisfaction scores across 500 responses?
- Pie chart
- Line graph
- Histogram (Correct answer)
- Scatter plot
Correct answer: Histogram
Histograms display the frequency distribution of continuous or ordinal data, making them ideal for survey score distributions.
Question 5: A data analyst is comparing client retention rates across five regional offices. Which statistical test is appropriate to determine if differences are statistically significant?
- Paired t-test
- One-way ANOVA (Correct answer)
- Pearson correlation
- Linear regression
Correct answer: One-way ANOVA
One-way ANOVA tests whether means differ significantly across three or more independent groups.
Question 6: In CRM data analytics, what does 'data normalization' primarily achieve?
- Removes all duplicate client records from the database
- Scales numeric variables to a common range to prevent bias in models (Correct answer)
- Translates client feedback into standardized sentiment scores
- Aggregates transaction data into monthly summaries
Correct answer: Scales numeric variables to a common range to prevent bias in models
Normalization rescales features to a consistent range so that no single variable dominates analytical models due to its magnitude.
Question 7: A relationship manager reviews a report showing a Pearson correlation of -0.82 between response time and client satisfaction. What does this indicate?
- Response time has no meaningful impact on satisfaction
- Faster response times are strongly associated with higher satisfaction scores (Correct answer)
- Slower response times are strongly associated with higher satisfaction scores
- The relationship between the two variables is weak
Correct answer: Faster response times are strongly associated with higher satisfaction scores
A correlation of -0.82 indicates a strong negative relationship: as response time increases (slower), satisfaction decreases.
CCRM Data Analytics 2
A client relationship manager notices that customer churn rate increased by 15% after a product update.
Which analytical approach best identifies the root cause?