4. (LO 7.4, 7.5, 7.6, 7.7) Match the analytics type (descriptive, diagnostic, predictive, or prescriptive) to the analytics technique used.

Analytics Technique Used Analytics Type (Descriptive, Diagnostic, Predictive, or Prescriptive)
Summarization of last year’s sales data Pivot table for drill down and drill up of sales by product Sentiment analysis to see what customers think of a new product Hypothesis test to see if conversion rates have significantly changed from last period Root cause analysis of why product sales have fallen Regression analysis with the conversion rate as the dependent variable and website traffic as the independent variable Pivot table to summarize sales by region