AN300 1st Test

A _____ uses _____ to depict magnitude of data values. heat map, color shades biplot, color shades bubble chart, color shades biplot, size of bubbles heat map, size of bubbles

heat map, color shades

Select a number from 1 (earliest) to 5 (latest) to reflect the chronological sequence of each of the following stages in the decision making process: 1. Identify alternative solutions. 2. Choose one alternative 3. Define a decision making situation 4. Evaluate each alternative using the chosen criteria 5. Determine the criteria used to evaluate alternative solutions

1. -3 2.- 5 3- 1 4.- 4 5. - 2

Match the data type you want to present and the information you want to convey on the left with the appropriate method to visualize the data on the right. 1. Summarize data of two categorical variables in a pairwise fashion. [ Choose ] A. Bubble chart B. Cross tab C. Bar chart D. Constellation plot E. Line chart F. Tree plot G. Scatter plot matrix H. Biplot 2. Discover the relationship between two numeric variables. [ Choose ] A. Bubble chart B. Cross tab C. Bar chart D. Constellation plot E. Line chart F. Tree plot G. Scatter plot matrix H. Biplot 3. Count the number of observations in each category. [ Choose ] A. Bubble chart B. Cross tab C. Bar chart D. Constellation plot E. Line chart F. Tree plot G. Scatter plot matrix H. Biplot 4. Show the relationship among three variables in a two-dimensional space. [ Choose ] A. Bubble chart B. Cross tab C. Bar chart D. Constellation plot E. Line chart F. Tree plot G. Scatter plot matrix H. Biplot 5. Show how multiple numerical variables are related to each other in one comprehensive visual. [ Choose ] A. Bubble chart B. Cross tab C. Bar chart D. Constellation plot E. Line chart F. Tree plot G. Scatter plot matrix H. Biplot

1. Cross Tab 2. Line Chart 3. Bar Chart 4. Bubble Chart 5. Scatter plot matrix

Match the example on the left with the related data transformation process on the right. 1. Group of answer choicesA customer is 1,000 years old. [ Choose ] A. Data imputation B. Data query C. Data cleansing D. Data conversion E. Data dimension reduction 2. Who is our employee-of-the-month? 3. The missing income of a customer is replaced with the average income of all customers. 4. The age field of the customer table is removed because we can always compute a customer's age from his/her data of birth.

1. Data cleansing 2. Data query 3.Data imputation 4.Data dimension reduction

Match the technique on the left with its data-preprocessing function on the right. 1. Binning[ Choose ] Data query Data modification Data preparation Data reporting Data cleansing 2. Imputation [ Choose ] Data query Data modification Data preparation Data reporting Data cleansing 3. Dimension reduction [ Choose ] Data query Data modification Data preparation Data reporting Data cleansing 4. Recoding [ Choose ] Data query Data modification Data preparation Data reporting Data cleansing 5. Omission [ Choose ] Data query Data modification Data preparation Data reporting Data cleansing 6. Mathematical manipulation [ Choose ] Data query Data modification Data preparation Data reporting Data cleansing

1. Data modification 2. Data cleansing 3. Data modification 4. Data cleansing 5. Data cleansing 6. Data modification

Match the example on the left with the concept it illustrates on the right. 1. We rely solely on our CEO's feeling to promote the next year's assortment of products. [ Choose ] A. Prescriptive analytics application in human resource. B. Decision making based on experience. C. Predictive analytics application in human resource. D. Decision making based on intuition. E. Volume and variety of Big Data. F. Perform data query to answer what has happened questions. G. Volume and velocity of Big data. H. Use data mining to answer what has happened questions. 2. We use a sophisticated software tool to predict employee turnover and retention. 3. We use SQL to find our most profitable customers. 4. We have millions rows of customer data in numbers, text, audio, video, pictures. and other multi-media format.

1. Decision making based on intuition. 2. Predictive analytics application in human resource. 3. Perform data query to answer what has happened questions. 4. Volume and variety of Big Data

Match the category of Business Analytics on the left to the type of questions it addresses on the right. 1. Descriptive Analytics [ Choose ] Who is responsible for this to happen? What could happen? What has happened? What should happen? When did this happen? Why this is happening? How did this happen? 2. Predictive Analytics [ Choose ] Who is responsible for this to happen? What could happen? What has happened? What should happen? When did this happen? Why this is happening? How did this happen? 3. Prescriptive Analytics [ Choose ] Who is responsible for this to happen? What could happen? What has happened? What should happen? When did this happen? Why this is happening? How did this happen?

1. What has happened? 2. What Could happen? 3. What Should happen?

Match the information you want to convey on the left with the most appropriate data visualization method on the right. 1. Display height, weight, body temperature, and blood pressure of all patients. [ Choose ] A Line Chart A Pie Chart A Stacked or Clustered Column Chart A Heat Map A Parallel Coordinates Plot A Bubble Chart A Table Biplot 2. Compare demand for cupcakes over time. 3. Compare the number of students in each Major as a percentage of a whole. 4. Compare the number of employees by job title for the last five years. 5. Display the relationship among sleep time, screen time, and academic performance on a two-dimensional space. 6. Distinguish high performers from laggards using color gradations in presenting weekly performance data. 7. Displays lines connecting the values of Sales, Profit, Number-of-Employees, and Years-in-Business associated with each value of Company-Size.

1.A Table 2. A Line Chart 3. A Pie Chart 4. A Stacked or Clustered Column Chart 5. A Bubble Chart 6. A Heat Map 7.A Parallel Coordinates Plot

Match a key feature on the left with the role it plays in preliminary analysis on the right. 1. A primary key: [ Choose ] A. Retrieve and combine data in data query B. Link tables together in data outsourcing. C. Ask questions about the data in data outsourcing. D. Combine data from multiple tables in data query E. Draw attention to issues in data reporting F. Facilitate sense making in data reporting 2. SQL: [ Choose ] A. Retrieve and combine data in data query B. Link tables together in data outsourcing. C. Ask questions about the data in data outsourcing. D. Combine data from multiple tables in data query E. Draw attention to issues in data reporting F. Facilitate sense making in data reporting 3. Summary: [ Choose ] A. Retrieve and combine data in data query B. Link tables together in data outsourcing. C. Ask questions about the data in data outsourcing. D. Combine data from multiple tables in data query E. Draw attention to issues in data reporting F. Facilitate sense making in data reporting 4. Highlights: [ Choose ] A. Retrieve and combine data in data query B. Link tables together in data outsourcing. C. Ask questions about the data in data outsourcing. D. Combine data from multiple tables in data query E. Draw attention to issues in data reporting F. Facilitate sense making in data reporting

1.Combine data from multiple tables in data query 2.Retrieve and combine data in data query 3.Facilitate sense making in data reporting 4. Draw attention to issues in data reporting

Order the data hierarchy from 1 (the lowest level) to 4 (the highest level): 1.Database 2.Data field 3.Data record 4.File

1.Data field 2.Data record 3.File 4.Database

Match the statement on the left with the concept it defines on the right. 1. It is at the lowest level of the data hierarchy. A. Query B. Secondary data C. Oracle D. Primary data E. Imputation F. Recoding G. JMP H. Variable 2. It is a software called database management systems. 3. It is data collected directly from business transactions. [ Choose ] Query Secondary data Oracle Primary data Imputation Variable Recoding Data JMP 4. It replaces data values with legitimate and correct ones. [ Choose ] Query Secondary data Oracle Primary data Imputation Variable Recoding Data JMP 5. It combines relevant data from multiple tables into a single one for data analysis. [ Choose ] Query Secondary data Oracle Primary data Imputation Variable Recoding Data JMP

1.Variable 2. Oracle 3.Primary data 4.Recoding 5.Query

Which of the following statements about data visualization method is FALSE? Check all that apply. A Dashboard uses colors, symbols, and bubbles to draw attention to KPIs in a static view. A Scatter Plot Matrix works with numerical variables only. A Heat Map uses different shades of color to represent magnitudes of data values. A Tree Map uses nested rectangles of varying sizes and color to visualize data along multiple dimensions. A Parallel Coordinate Plot displays values of multiple Categorical Variables using the lengths/heights of each bar relative to the others. A Geographical Map cannot show Categorical data.

A Parallel Coordinate Plot displays values of multiple Categorical Variables using the lengths/heights of each bar relative to the others. A Dashboard uses colors, symbols, and bubbles to draw attention to KPIs in a static view. A Parallel Coordinate Plot displays values of multiple Categorical Variables using the lengths/heights of each bar relative to the others.

Which of the following is TRUE about Business Analytics techniques? Data mining is strictly a predictive analytics technique. An answer to "what could happen" type of questions can be found by using forecasting techniques such as time-series analysis. Reports present information using visuals only. An answer to "what has happened" type of questions can be found by random guesses. Predictive analytics techniques answer "what should happen" type of questions.

An answer to "what could happen" type of questions can be found by using forecasting techniques such as time-series analysis.

When identifying the source of your data, the factor(s) to be considered include _____. Check all that apply. Time Variety Volume Availability Veracity Cost

Availability Time Cost

Which of the following is a descriptive data mining technique? Linear Programming. What-If Analysis. Cluster Analysis. SQL. Decision Analysis-Utility Theory.

Cluster Analysis.

Which of the following is TRUE about primary data? Check all that apply. Collected directly from the data's source Open-source data Collected indirectly by someone else Proprietary data First-hand data Second-hand data Managed by a database management systems

Collected directly from the data's source Proprietary data First-hand data Managed by a database management systems

The purpose of data cleansing is to ensure data in the data set is _____. Check all that apply. Complete Vulnerable Legitimate Accurate Biased Available

Complete Legitimate Accurate

The characteristics of a business analytics approach to decision making include _____. (Check all that apply). Fact-based Scientific Computer-assisted Data-driven Intuition-based Experience-based Subjective Conventional

Fact-based Scientific Computer-assisted Data-driven

Which of the following Business Analytics functionalities will be covered in this class? Check all that apply. Data management Data analysis Data reporting Data pre-processing Data outsourcing Data warehousing

Data analysis Data reporting Data pre-processing

Which of the following tasks is included in data preparation? Check all that apply. Data pre-processing Data analysis Data acquisition Data reporting Data query

Data pre-processing Data acquisition

Which of the following tasks is included in preliminary analysis? Check all that apply. Data acquisition Data analysis Data pre-processing Data reporting Data query

Data reporting Data query

A data column is also known as a _____. Data file Data set Data record Data variable Data observation

Data variable

Which of the following statements about data visualization is TRUE? Check all that apply. Data visualization can be used to display data relationships and patterns. A low data-ink ratio is indicative of a good design. "Never use a 3D chart if a 2D chart is sufficient" is an example of the "Keep it Simple" design principle. General design principles are about knowing when to use tables instead of charts. Data visualization can be used to identify data errors and outliers. Use tables instead of charts when making relative and approximate comparisons on peformance of sales representatives.

Data visualization can be used to identify data errors and outliers. "Never use a 3D chart if a 2D chart is sufficient" is an example of the "Keep it Simple" design principle. Data visualization can be used to display data relationships and patterns.

Which of the following is a prescriptive analytics technique? Linear regression Cluster analysis Decision rules SimulationWhat-If analysis

Decision rules

Data visualization is useful for _____. Check all that apply. Detecting outliers Detecting missing values Detecting duplicates Detecting data errors Detecting falsified data

Detecting data errors Detecting outliers

Which of the following is a means to evaluate the effectiveness of a visual design? Check all that apply. General design principles Usability Data-ink ratio Accessibility Suitability

General design principles Data-ink ratio

Which of the following is an advanced data visualization method that you learned in this class? Check all that apply. Heat map Geographical map Biplot Tree map Box plot Parallel coordinate plot

Geographical map Tree map Parallel coordinate plot

We discussed many business analytics applications in various business domains in this class. Which of the following is/are explicitly cited as an illustrative example? (Check all that apply). Artificial intelligence Health care Sports Statistics Accounting

Health care Sports

What are the basic data visualization methods that you learned in this class? Check all that apply, Dashboard Heat map Bubble chart Constellation plot Dendrogram Table Scatter plot matrix Biplot

Heat map Bubble chart Table Scatter plot matrix

Which of the following is TRUE about data preparation? Check all that apply. It consists of Data Query and Data Reporting. It is to ensure the right data is collected to meet quality and suitability requirements. It consists of Data Acquisition and Data Pre-Processing. Secondary data is the sole source of data acquisition.

It consists of Data Acquisition and Data Pre-Processing. It is to ensure the right data is collected to meet quality and suitability requirements.

Which of the following is FALSE about a dashboard? Check all that apply. It is interactive. It involves multiple screens. Only one key performance indicator is shown. All visuals should be viewed without scrolling. It is dynamic.

It involves multiple screens. Only one key performance indicator is shown.

Which of the following is the definition of decision making you learned from this class? It is to make successful business plans. It is to choose among alternative courses of action to improve organization performance. It is to provide leadership for an organization. It is to minimize costs.It is to maximize profit.

It is to choose among alternative courses of action to improve organization performance.

What is the Business Analytics approach for managerial decision making? Check all that apply. It is to improve business performance by transforming data into actionable insights. It is to fully automate decision making. It is to make evidence-based decisions. It is to make experience-based decisions. It is to completely do away with a subjective approach to decision making. It is to follow traditions in making decisions.

It is to improve business performance by transforming data into actionable insights. It is to make evidence-based decisions.

Which of the following is TRUE about a parallel coordinate plot? Check all that apply. It captures spatial information It is useful for displaying summary statistics. It uses bubbles to capture the magnitude of the variables. It is useful for displaying values of three of more numerical variables associated with each value of a categorical variable. It is useful for displaying values of multiple numerical variables associated with each value of a numerical variable. It uses lines to convey information.

It is useful for displaying values of multiple numerical variables associated with each value of a numerical variable. It uses lines to convey information.

Which of the following is TRUE about a tree map? Check all that apply. It uses lines and color to convey information. It is useful for displaying trends and correlations.It is useful for visualizing hierarchical data along multiple dimensions. It uses varying sizes and/or color of a rectangular area to convey information. It conveys values of multiple numerical variables associated with each value of a categorical variable.

It uses varying sizes and/or color of a rectangular area to convey information. It is useful for displaying trends and correlations.It is useful for visualizing hierarchical data along multiple dimensions.

Which of the following is TRUE about Tableau? Check all that apply. Its activation requires a product key. It was developed in 2003. It was developed at Stanford University. It was developed at SAS. Its goal is to transform a world of data into intelligence. Its goal is to make data understandable to ordinary people. It was developed in 1989.

Its activation requires a product key. It was developed in 2003. Its goal is to make data understandable to ordinary people.

Which of the following is TRUE about JMP? Check all that apply. Its goal is to transform a world of data into intelligence. It requires a product key to activate. It was developed at SAS. It was developed in 2003. Its goal is to make data understandable to ordinary people. It was developed in 1989. It was developed in Stanford University.

Its goal is to transform a world of data into intelligence. It was developed at SAS. It was developed in 1989.

An example of a database management systems is: JMP Tableau Oracle SPSS Rapidminer

Oracle

A cross tab is also known as a _____. Check all that apply, Cross-over table Two-way table 3D table Pivot table Contingency table

Pivot table Two-way table Contingency table

Which of the following is a predictive analytics software tool? EndNote Simulation SAS Enterprise Miner Time-Series forecasting Regression tree

SAS Enterprise Miner

Descriptive analytics techniques include the following EXCEPT: Reports Data-mining Data queries Data dashboards Simulations

Simulations

Business Analytics tools are essentially _____. Methods Techniques Models Algorithms Software

Software

SAS stands for _____. Student Advancement Software Structured Analysis Systems Standard Advanced Systems Statistical Analysis Software Statistical Analysis Systems

Statistical Analysis Systems

"We will not offer online shopping because our customers always prefer shopping at our brick-and-mortar stores" is an example of making decisions based on _____. Feeling Rule of thumb Tradition Fact Evidence

Tradition

Which of the following is a distractor that should be avoided in visual design? Large font size Grammatical mistakes Pictures Misspellings Unnecessary use of colors

Unnecessary use of colors

The principles of good table design include _____. Check all that apply. Avoid horizontal lines Align text values on the right Use light shading to distinguish columns Use just enough precision Align numeric values on the left

Use light shading to distinguish columns Use just enough precision

You should use a table when _____. Check all that apply. Focus is on specific numeric values. Focus is on relative numeric values. Values have very different magnitudes. Focus is on specific categorical values. Values are measured using different units.

Values have very different magnitudes. Focus is on specific numeric values. Values are measured using different units.

Which of the following is/are characteristic of big data? (Check all that apply). Vitality Validity Valence Veracity Variety Volume

Variety Volume Veracity

Which of the following is FALSE about JMP? Check all that apply. You need to install Citrix Receiver in order to use it offline. It cannot be accessed remotely. You need to install the Pro version on your own device so you can use it offline. You must have Internet access to use it. It is a Business Analytics technique. Its strength is in data visualization. It is a Business Analytics tool. It was developed at SAS.

You must have Internet access to use it. It is a Business Analytics technique. You need to install Citrix Receiver in order to use it offline. Its strength is in data visualization. It cannot be accessed remotely.

A data table organizes data into _____. Check all that apply. columns panels trees platforms rows

columns rows

Which of the following is FALSE about a geographical map? It requires mapping data. It shows locations in the U.S. only. It does not support color. It cannot represent categorical data. It captures spatial information.

it shows locations in the U.S. only. It does not support color. It cannot represent categorical data.

Data visualization is the process of _____ data and _____ information in a visually appealing manner using tables, charts, maps, and dashboards. querying, conveying processing, presenting cleansing, presenting acquiring, processing presenting, conveying

presenting, conveying