Quiz #1-5
A bubble chart is a type of scatter chart that provides a way to plot three variables in two dimensions. a) True b) False
a) True
A correlation of 0 indicates that the two variables have no linear relationship with each other. a) True b) False
a) True
A data set is simply a collection of data. a) True b) False
a) True
A database is a collection of related files (tables) containing records on people, places, or things. a) True b) False
a) True
A population consists of all items of interest for a particular decision or investigation. a) True b) False
a) True
A sample is a subset of a population. a) True b) False
a) True
AND(condition 1, condition 2...) is a logical function that returns TRUE if all conditions are true and FALSE if not. a) True b) False
a) True
Dashboards may include tabular as well as visual data to help a manager to quickly locate key information. a) True b) False
a) True
Data visualization is the process of displaying data in a meaningful fashion to provide insights that will support better decisions. a) True b) False
a) True
Excel distinguishes between vertical and horizontal bar charts, calling the former column charts and the latter bar charts. a) True b) False
a) True
Form controls are buttons, boxes, and other mechanisms for inputting or changing data on spreadsheets easily and used to design user-friendly spreadsheets. a) True b) False
a) True
Having a user-friendly approach is the greatest strength of Tableau. a) True b) False
a) True
Line charts provide a useful means for displaying data over time. a) True b) False
a) True
PivotTables may be used to facilitate data visualization and statistical analysis of data sets. a) True b) False
a) True
Skewness describes the lack of symmetry of data. a) True b) False
a) True
Tableau has an edge over other Business Intelligence and Analytics tools as it lets you work by connecting to various data sources, data warehouses, and files which exist in the cloud, big data that exists in spreadsheets, and non-relational data, among other types of data. a) True b) False
a) True
Tableau is a powerful and quickly growing data visualization tool used in the Business Intelligence Industry. a) True b) False
a) True
The Pareto principle is often called the "80--20 rule." a) True b) False
a) True
The average is formally called the arithmetic mean (or simply the mean) which is the sum of the observations divided by the number of observations. a) True b) False
a) True
The larger the variance, the more the data are spread out from the mean. a) True b) False
a) True
The range is the difference between the maximum value and the minimum value in the data set. a) True b) False
a) True
Three useful logical functions in business analytics applications are IF, AND, and OR followed by conditions in parentheses. a) True b) False
a) True
With Tableau, one has the option of switching between different visualizations to bring about a greater context, ways of drilling down data, and exploring the data at a minute level. a) True b) False
a) True
What is a database? a) a structured collection of related files and data b) simply a collection of data c) a data file holding a single filed) flat files used to store data
a) a structured collection of related files and data
Excel has a tool called 'dicers' for drilling down data in a PivotTable to display as subset of that data. a) True b) False
b) False
For an odd number of observations, the median is the mean of the two middle numbers. a) True b) False
b) False
In stock trading, the higher the coefficient of variation for the stock, the smaller the relative risk is for the return provided. a) True b) False
b) False
Tableau is optimal when you use it as a data creation tool. a) True b) False
b) False
The filter tool extracts records meeting the specified criteria, deleting any records that don't match the criteria. a) True b) False
b) False
The measure of location that specifies the middle value when the data are arranged from least to greatest is called the mode. a) True b) False
b) False
To select a chart type in Excel from the Charts group, which tab has to be accessed? a) Design tab b) Layout tab c) Insert tab d) Format tab
c) Insert tab
Using a $ sign before a column label ________. a) keeps the reference to both the row and column fixed b) keeps the reference to the row fixed, but allows the column reference to change c) keeps the reference to column fixed, but allows the row reference to changed) allows both the row and column references to change
c) keeps the reference to column fixed, but allows the row reference to change
Tableau can help enterprises futuristically to: a) Analyze data without any specific goals in mind. b) Explore visualizations and have a look at the same data from different angles. c) Frame 'what if' queries and work with data by hypothetically visualizing it in a different manner and dynamically adding components for comparison and analysis. d) All of these.
d) All of these.
Which of the following is not a lookup function in Excel? a) VLOOKUP b) INDEX c) CHOOSE d) COUNTIF
d) COUNTIF
Predictive analytics: a) summarizes data into meaningful charts and reports that can be standardized or customized. b) identifies the best alternatives to minimize or maximize an objective. c) uses data to determine a course of action to be executed in a given situation. d) detects patterns in historical data and extrapolates them forward in time.
d) detects patterns in historical data and extrapolates them forward in time.