Which feature of Excel’s Data Analysis Toolpak is used to forecast sales based on variables...

The correct answer is D .

The CPCM course identifies regression models as one of the predictive analytics methods included in advanced category analytics. The official CPCM extract states that predictive analytics includes “collaborative filtering, clustering algorithms, regression models and time-to-event models.” Microsoft’s Excel Analysis ToolPak documentation confirms that the Regression tool performs linear regression and allows analysis of how one dependent variable is affected by one or more independent variables. It also states that regression results can be used to predict performance.

This fits the question exactly. Sales is the dependent variable. Price, promotion, and seasonality are independent variables. Regression is the correct ToolPak feature for modeling that relationship.

Option A is wrong because K-Means clustering groups similar observations. Option B and C are time-series smoothing methods, but they do not directly model sales against multiple explanatory variables like price and promotion.