Which of the following is an appropriate use case for a line graph?

A. To show the change in a continuous variable over time

B. To plot discrete dimension members over time

C. To show trends in multiple variables over time

D. All of the Above

Which of the following is an appropriate use case for a line graph?

A. Median

B. Quartiles

C. Outliers

D. Mean

Why would someone use a histogram?

A. To the show distribution of the data

B. To compare totals across multiple groups

C. To see what group(s) make up the highest percentage of the grand total

True or False: The following is an example of a Pareto analysis: "I want to know when 80% of my products make up 20% of my profit."

A. True

B. False

How would you calculate the percent change using the values below?

Current Value: 10, Prior Value: 23

A. (23-10)/10

B. (10-23)/23

C. (23-10)/23

D. (10-23)/10

When performing anomaly detection and wanting 95% of results to fit within the expected range, how many standard deviations would you use?

A. 1 standard deviation

B. 2 standard deviations

C. 3 standard deviations

For the following group of numbers, calculate the median: 11, 10, 12, 14, 14, 15, 12

A. 10

B. 11

C. 12

D. 14

For the following group of numbers, calculate the mode: 10, 14, 10, 10, 12, 13, 10, 15, 12

A. 10

B. 11

C. 12

D. 13

If the distribution of your data primarily bunches on the right side of the bell curve with a long tail to the left side of the curve, how would you describe your data?

A. Right skewed distribution

B. Left skewed distribution

C. Symmetric distribution

D. Normally distributed

Which of these choices would decrease the margin of error?

A. Increase sample size

B. Decrease sample size

C. Increase standard error

D. Increase standard deviation

What would a correlation coefficient of 0 between two variables tell us?

A. There is a perfect negative correlation between the variables

B. There is no linear relationship between the variables

C. There is a perfect negative correlation between the variables

What is the range for Mean Squared Error (MSE)?

A. -1 to 1

B. 0 to 1

C. >=0

D. <=0

When would you NOT use a z-test?

A. After conducting an A/B test

B. When creating a weighted average

C. When looking for statistical significance

D. When comparing two different email subject lines

Which is NOT an assumption of linear regression?

A. There exists a linear relationship between the independent and dependent variable

B. There is a non-normal distribution

C. There is no exact relationship between any independent variables

D. There is no correlation between error terms

What is R^2?

A. A measure of probability that an observed difference could have occurred by chance

B. The percentage of variance in dependent variable that is explained by the independent variables

C. The frequency with which a variable occurs

D. The average distance between the mean and each data point

What is the range of R^2?

A. 0 to 1

B. -1 to 1

C. 0 to 10

D. There is no range

Which of the following is true when the output of a regression analysis that is calculating the acceleration of a vehicle based on weight (w) and horsepower (h) is:

F(h,w) = -0.093313h + 0.002302w + 18.435791

A. As horsepower increases, acceleration will increase

B. As the weight of a vehicle decreases, the acceleration will increase

C. As the weight of a vehicle increases, the acceleration will increase

D. As the horsepower decreases, the acceleration will decrease

If your data shows seasonality with clear highs and lows moving from left to right, which model would most likely fit your data best?

A. Linear

B. Polynomial

C. Exponential

D. Logarithmic

What type of forecast model is natively used in Tableau when using the forecast option from the Analytics pane?

A. Adaptive smoothing

B. Moving average

C. Exponential smoothing

D. K-means

What type of clustering model is natively used in Tableau when using the cluster option from the Analytics pane?

A. K-means

B. KNN

C. Moving average

D. Polynomial trend line

When describing a forecast model in Tableau, what is a given quality metric you can use to determine the quality of the forecast?

A. R-squared

B. P-value

C. AIC

D. None of the above

Which property of the Marks card is both the cluster and forecast model added to when dragged onto the view from the Analytics pane?

Using the provided dataset, create a continuous line chart with the sum of Sales on the y-axis and month of Order Date on the x-axis.

Okay - I have built the view and am ready to continue.

Add a linear trend line to the view. What is the R^2 value?

A. 0.38

B. 0.58

C. 0.68

D. 0.78

Add a polynomial trend line to the view. What is the R^2 value?

A. 0.34

B. 0.54

C. 0.64

D. 0.74

Based purely on the R^2 value, which model is preferred?

A. Linear

B. Polynomial

Let us know who is taking the test:

First Name(Required)

Last Name(Required)

Playfair+ Email(Required)

Phone

Company Name

Advanced Analytics Practitioner Exam

What to know:

Using the provided dataset, create a continuous line chart with the sum of Sales on the y-axis and month of Order Date on the x-axis.

Let us know who is taking the test: