Quiz #1-5

Ace your homework & exams now with Quizwiz!

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.


Related study sets

Texas Real Estate Finance (Edited by me)

View Set

Final Real Estate Exam Study Set

View Set

Fluid Electrolyte Balance Physiology

View Set

Anatomy & Physiology 101 Chapter 13 The Brain, Cranial Nerves and Sensory and Motor Pathways

View Set

Q9 Ebusiness Customization and Pricing

View Set

Law Test 3 - SU 15: Non-Corporate Bus. Entities; Rhodes Ole Miss

View Set

Chapter 40: tThe Child with a Musculoskeletal Disorder

View Set