Refer to the Exhibit.

You are working on creating an OLAP query that outputs several rows of with summary rows of
subtotals and grand totals in addition to regular rows that may contain NULL as shown in the
exhibit. Which function can you use in your query to distinguish the row from a regular row to a
subtotal row?

Refer to the exhibit.

After analyzing a dataset, you report findings to your team:
1. Variables A and C are significantly and positively impacting the dependent variable.
2. Variable B is significantly and negatively impacting the dependent variable.
3. Variable D is not significantly impacting the dependent variable.
After seeing your findings, the majority of your team agreed that variable B should be positively
impacting the dependent variable.
What is a possible reason the coefficient for variable B was negative and not positive?

Refer to the exhibit.

You have run a linear regression model against your data, and have plotted true outcome versus
predicted outcome. The R-squared of your model is 0.75. What is your assessment of the model?

Refer to the exhibit.

You are using K-means clustering to classify customer behavior for a large retailer. You need to
determine the optimum number of customer groups. You plot the within-sum-of-squares (wss)
data as shown in the exhibit. How many customer groups should you specify?