数据源及答案
提取码: p5mv
1.
Answer the question using the Coca Cola stock price data Coca Cola stock price. What was the % change in adjusted closing stock price (Adj Close) for Coca Cola between June 1998 and June 2017?
- -203.3%
- -11.26%
- 40.5%
- 72.14%
2.
Answer using this data: TopBabyNamesbyState
Which boys’ names were only on the Top Names list only during the 1980s (1980 – 1989)
- Jason and Mark
- Andrew and Justin
- Matthew and Jason
- Mark and John
3.
Answer this using the SuperStore data.Find the total sales value from customers who made their first purchase in 2011.
- $2,104,125
- $1,994,507
- $2,230,731
- $1,924,333
4.Answer this question with the Superstore Data.What is the most common first name for SuperStore customers?
- Enda
- Ricky
- James
- Marvin
- None of the above
5.
The term “addressing” refers to the direction of a calculation.
- True
- False
6.
Using the Players sheet on the Little League data, what percent of players on the Lions scored between 5 and 10 runs?
- 16.67%
- 68.18%
- 31.82%
- 81.50%
- 18.50%
7.
SUM is a table calculation.
- True
- False
8.
Use the Coffee Chain data to answer the following question.
Which area code was 25th place in sales for Espresso?
- 214
- 318
- 941
- 830
- None of the above
9.
Use this data to answer the following question. A group of people were surveyed regarding their smoking habits for each decade between 1960 and 2010. The survey data states “true” if the person was a smoker in the survey year, and “false” if they were not a smoker. Which decade saw the biggest decrease in the number of smokers?
- 1970
- 1980
- 1990
- 2000
- 2010
10.
Answer this question using the Smoker data. In addition to the survey data, there is also a “College Smokers” which estimates the percent of smokers in the college student population by year. Combine the “Smoking Survey” data with the “Percent Smokers” data to determine the decade with the biggest difference between the college student % smokers and the % smokers in the survey data.
- 1960
- 1970
- 1980
- 1990
- 2000
- 2010
11.
Answer this question by joining the Smoking Survey data with the Demographics data. Join using the ID field. In the 1960 survey, which birth year had the highest percent of respondents who said that they were smokers?
- 1930
- 1931
- 1932
- 1933
- None of the above
12.
Using the Coca Cola data, combine the “Price Archive” and “Price” worksheets, which date had the greatest increase between the Adjusted Open price (Adj Open) and the Adjusted Close Price (Adj Open)
- May 2009
- August 1998
- June 1970
- June 1971
13.
The benefits of creating a Tableau data extract include improving performance and allowing offline access to the data.
- True
- False
14.
The metadata grid displays the fields in your data source in columns.
- True
- False
15.
Answer this question using the Order sheet from the SuperStore data. Create a scatterplot showing the sum of Profit on the Y-axis and sum of Sales on the x-axis for each Customer. Add a linear trendline. What is the function?
- 1.37166*Profit + 2645.84
- 0.966844*Profit + 815.086
- 0.097578*Sales + 162.386
- 0.142809*Sales + 3.60978
16.
Answer this question using the Games sheet from the Little League data. Create a box plot by Home Team to analyze the distribution of Home Team Runs by game. Which Home Team has the lowest ‘lower hinge’ of runs?
- Falcons
- Knights
- Tigers
- Lighting
17.
_______ is a technique in Tableau which will identify marks with similar characteristics.
- Trendline
- Clustering
- Box Plots
- Distribution Bands
18.
A trendline using an exponential model type will be fit using exponential regression
- True
- False
19.
Which of the following is used to assess trendline significance:
- SSE
- R-Squared
- p-value
- slope
- none of the above
20.
Answer this using the SuperStore data. Find the top 10 customers with the highest total sales. How many of these customers live in the Central region?
- 0
- 3
- 5
- 6
- none of the above
21.Answer this using the SuperStore data. What were the total sales for items ordered in 2013 with product name containing the word vacuum?
- $91,506
- $24,839
- $91,839
- $3,125
- none of the above
22.
If you would like your Top N or Bottom N set to change depending on what filter choices are changed, what type of filter should use use?
- Context Filters
- Dimension Filters
- Measure Filters
- None of the above
23.
Sorts can break the dimension hierarchy. In other words, Tableau will rearrange any the headers of the fields that appear to the left of the sorted field.
- True
- False
24.Answer this question using the “Coke Price” worksheet from the Coca Cola End of Day Stock Price workbook. Create a histogram for the Adj High price using a bin size of 5. Which of these bins has the highest average adjusted volume (Adj Volume)?
- 0 - 5
- 5 - 10
- 20 - 25
- 30 - 35
- 35 - 40
25.
Answer the following question using the SuperStore Subset data. Create a calculated field called “Profit Goal” equal to 25% of Sales. Create a bullet graph comparing Profit to Profit Goal by product sub-category. For which of the following sub-categories did the Profit meet or exceed Profit Goal?
- Bookcases
- Office Furnishings
- Paper
- Appliances
- Rubber Bands
26.
Which of the following are generated fields in Tableau? (select all that apply)
- City
- Number of Records
- State
- Measure Names
- Distinct Values
27.
Answer this question using the San Francisco Police Department Incidents burglary data. Create a scatter plot showing the number of unique incidents and number of arrests by PD District. Which two districts are the closest on these two measures?
- Southern & Northern
- Taraval & Bayview
- Richmond & Park
- Central & Mission
- None of the Above
28.
Pareto charts combine the following elements:
- Tree maps & heat maps
- Bar & trend lines
- Pie charts & packed bubbles
- Left and right axis line graphs
- None of the Above
29.
Bullet graphs combine bar charts and reference lines
- True
- False
30.
Download the Contributors to Obesity dashboard: https://public.tableau.com/workbooks/contributorstoobesity.twb and open with Tableau. Looking at counties within the state of Indiana, which of the following is associated with higher rates of obesity?
- Consuming few fruits and vegetables
- Smokers
- Persons who excersisize
- None of the above
- All of the above
31.
Answer the following question using the Contributors to Obesity dashboard. For counties in North Dakota, an increase of 1% of proportion of the population who smokes is associated with a _____ increase in the proportion of the population that is obese.
- .44%
- .15%
- 44%
- 15%
- 1.5%
32.
Which of the following is an alternative to a Tile dashboard layout?
- Grid
- Floating
- Flowing
- Custom
- Default
33.
You want to email a packaged workbook containing a Tableau Dashboard to a coworker who does not have a license for Tableau Desktop. Which application will allow her to view the dashboard you send via email?
- Tableau Public
- Tableau Server
- Tableau Viewer
- Tableau Reader
34.
A visual best practice is that if you are using a color gradient to represent a continuous variable which can be negative or positive, you should use a single color range
- True
- False
35.
Answer the following question using the Contributors to Obesity dashboard. Which of the following counties in Rhode Island has the lowest rate of obesity?
- Providence County
- Bristol County
- Kent County
- Newport County
- Washington County
36.
Answer this question using the Superstore data. For the states that border New York, which state has the lowest average sales per customer?
- Vermont
- Massachusetts
- New Jersey
- Connecticut
- Pennsylvania
