AN 300 - Exam 1

What role does each of the following key features play in preliminary analysis? 1. A primary key 2. SQL 3. Summary 4. Highlights

1. Combines data from multiple tables in data query 2. Retrieves and combine data in a data query 3. Facilitates sense making in data reporting 4. Draws attention to issues in data reporting

What is the order of Data Hierarchy?

1. Date field 2. Date record 3. File 4. Database 5. Database management systems

What is the sequence of the decision making process?

1. Define a decision making situation 2. Determine the criteria used to evaluate alternative solutions 3. Identify alternative solutions 4. Evaluate each alternative using the chosen criteria 5. Choose one alternative

What are 4 characteristics of a business analytics approach to decision making?

1. fact-based 2. data-driven 3. scientific 4. computer-assisted

You are given 100 years of Annual Enrollment, Average GPA, Average Debt, Average Age, and Average Credit Hours Taken for Business major at UK. What is the data-ink ratio for last 31 years' Annual Enrollment?

6 (Relevant # of Rows x Relevant # of Columns) / (Total # of Rows x Total # of Columns)

The Tableau workspace includes _____. Check all that apply. A) Analytics pane B) Sheet tabs C) Menus D) Toolbar E) Files pane F) Side bar

A) Analytics pane B) Sheet tabs C) Menus D) Toolbar

What are the basic data visualization methods that you learned in this class? A) Bubble chart B) Biplot C) Table D) Dashboard E) Constellation plot F) Dendrogram G) Scatter plot matrix H) Heat map

A) Bubble chart C) Table G) Scatter plot matrix H) Heat map

The purpose of data cleansing is to ensure data in the data set is _____. A) Complete B) Biased C) Available D) Valid E) Accurate F) Legitimate

A) Complete E) Accurate F) Legitimate

A cross tab is also known as a _____. A) Contingency table B) Cross-over table C) Pivot table D) Two-way table E) 3D table

A) Contingency table C) Pivot table D) Two-Way table

Which 3 of the following Business Analytics functionalities will be covered in this class? A) Data analysis B) Data warehousing C) Data reporting D) Data pre-processing E) Data management F) Data outsourcing

A) Data analysis C) Data reporting D) Data pre-processing

Which 2 of the following tasks is included in preliminary analysis? A) Data reporting B) Data pre-processing C) Data query D) Data analysis E) Data acquisition

A) Data reporting C) Data query

Which of the following is a means to evaluate the effectiveness of a visual design? A) Data-ink ratio B) Suitability C) Accessibility D) General design principles E) Usability

A) Data-ink ratio D) General design principles

Which of the following is TRUE about primary data? A) First-hand data B) Open-source data C) Properitary data D) Collected indirectly by someone else E) Collected directly from the data's source F) Managed by a database management systems G) Second-hand data

A) First-hand data C) Properitary data E) Collected directly from the data's source F) Managed by a database management systems

Which of the following file types is compatible with JMP? A) HTML B) R code C) SPSS D) wp4 E) Excel F) Tableau G) Zip

A) HTML B) R code C) SPSS E) Excel

Which 1 of the following is a predictive analytics software tool? A) IBM SPSS Modeler B) Oracle C) Regression tree D) Simulation E) Time-Series forecasting

A) IBM SPSS Modeler

Which 3 of the following is TRUE about JMP? A) It is developed at SAS. B) Its goal is to transform a world of data into intelligence. C) It is developed in 2003. D) Its goal is to make data understandable to ordinary people. E) It is developed in Stanford University. F) It is developed in 1989.

A) It is developed at SAS. B) Its goal is to transform a world of data into intelligence. C) It is developed in 1989.

Which of the following is FALSE about a dashboard? A) Only one key performance indicator is shown. B) It is interactive. C) All visuals should be viewed without scrolling. D) It is dynamic. E) It involves multiple screens.

A) Only one key performance indicator is shown E) It involves multiple screens

Which of the following statements about data visualization method is FALSE? A) Parallel coordinate plots work with numerical variables only. B) A tree map uses nested rectangles of varying sizes and/or color to visualize data along mulitiple dimensions. C) A scatter plot matrix works with numerical variables only. D) A dashboard uses colors, symbols, and bubbles to draw attention to KPIs in a static view. E) A geographical map cannot show categorical data. F) A heat map uses different shades of color to represent magnitude of data values.

A) Parallel coordinate plots work with numerical variables only. D) A dashboard uses colors, symbols, and bubbles to draw attention to KPIs in a static view. E) A geographical map cannot show categorical data.

Which of the following is TRUE about Business Analytics? A) RapidMiner is a predictive analytics software tool. B) Data mining is strictly a predictive analytics technique. C) Market basket analysis is an example of prescriptive analytics technique called decision rule. D) "What is the profit from Diet Coke sales if we increase the price of a can by 5 cents" is an example of What-If Analysis. E) Reports present information using visuals only.

A) RapidMiner is a predictive analytics software tool. D) "What is the profit from Diet Coke sales if we increase the price of a can by 5 cents" is an example of What-If Analysis.

Which of the following about the JMP Home Window is TRUE? A) The Help menu is where you will go to access sample data files. B) It has two panels: Recent Files and Window List. C) There is no way to stop the Tip of the Day window from popping up when JMP is launched. D) It has a menus of items such as File, Tables, Analyze, and Help across the top. E) To see an explanation of a specific part of the JMP Home window, you can point your cursor at that part of the window after you select Tools > Help.

A) The Help menu is where you will go to access sample data files. B) It has two panels: Recent Files and Window List. D) It has a menus of items such as File, Tables, Analyze, and Help across the top.

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

A) Unnecessary use of colors

The principles of good table design include _____. A) Use light shading to distinguish columns B) Align text values on the right C) Align numeric values on the left D) Avoid horizontal lines E) Use just enough precision

A) Use light shading to distinguish columns E) Use just enough precision

You should use a table when _____ . A) Values have very different magnitudes. B) Values are measured using different units. C) Focus is on specific categorical values. D) Focus is on specific numeric values. E) Focus is on relative numeric values.

A) Values have very different magnitudes B) Values are measured using different units D) Focus is on specific numeric values

Which of the following is TRUE about JMP? A) You installed the Pro version on your own device so you can use it offline. B) You need to install Citrix Receiver in order to use it offline. C) It is a Business Analytics technique. D) It cannot be accessed remotely. E) It is developed by researchers at Standford. F) Your license expired at the end of this course. G) It is a Business Analytics tool.

A) You installed the Pro version on your own device so you can use it offline. G) It is a Business Analytics tool.

Which 3 of the following is TRUE if you install a personal copy of JMP Pro on your own laptop? A) You will save your work locally. B) You will need to renew your license after this course. C) You will access JMP Pro locally. D) You will need to install Citrix Receiver. E) You will access JM Pro remotely. F) You will need to renew your license annually.

A) You will save your work locally. C) You will access JMP Pro locally. F) You will need to renew your license annually.

Which 2 of the following tasks is included in data preparation? A) Data analysis B) Data pre-processing C) Data acquistion D) Data reporting E) Data query

B) Data pre-processing C) Data acquistion

Which 1 of the following is a prescriptive analytics technique? A) Cluster analysis B) Decison rules C) Linear regression D) What-If analysis E) Simulation

B) Decison rules

Which of the following is an advanced data visualization method that you learned in this class? A) Box plot B) Geographical map C) Biplot D) Tree map E) Parallel coordinate plot F) Heat map

B) Geographical map D) Tree map E) Parallel coordinate plot

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

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

Which of the following is TRUE about data preparation? A) It consists of Data Query and Data Reporting. B) It is to ensure the right data is collected to meet quality and suitability requirements. C) It consists of Data Acquistion and Data Pre-Processing. D) Secondary data is the sole source of data acquistion. E) Its goal is to provide on-demand retrieval of data from multiple data tables.

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

Which of the following is TRUE about a tree map? A) It is useful for displaying trends and correlations. B) It is useful for visualzing hierarchical data along multiple dimensions. C) It conveys values of multiple numerical variables associated with each value of a categorical variable. D) It uses lines and color to convey information. E) It uses varying sizes and/or color of a rectangular area to convey information

B) It is useful for visualzing hierarchical data along multiple dimensions. E) It uses varying sizes and/or color of a rectangular area to convey information

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

B) It shows locations in the U.S. only D) It does not support color E) It cannot represent categorical data

Method used to count the number of observations in each category?

Bar Chart

Make comparisons of average exam performance among students of different majors in AN300.

Bar chart

Display the relationship among sleep time, screen time, and academic performance.

Bubble Chart

Method used to show the relationship among three variables in a two-dimensional space?

Bubble Chart

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

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

Data visualization is useful for _____. A) Detecting duplicates B) Detecting falsified data C) Detecting data errors D) Detecting missing values E) Detecting outliers

C) Detecting data errors E) Detecting outliers

We discussed many business analytics applications in various business domain in this class. Which 2 of the following is explicitly cited as an illustrative example? A) Artificial intelligence B) Accounting C) Health care D) Statistics E) Sports

C) Health care E) Sports

An example of a database management systems is: A) SPSS B) Rapidminer C) Oracle D) Tableau E) JMP

C) Oracle

Descriptive analytics techniques include the following EXCEPT: A) What-If analysis B) Data-mining C) Simulations D) Data queries E) Reports

C) Simulations

When identifying the source of your data, the 3 factors to be considered include? A) Variety B) Volume C) Time D) Cost E) Veracity F) Availabilty

C) Time D) Cost F) Availabilty

Which 3 of the following are characteristics of big data? A) Validity B) Valence C) Volume D) Variety E) Vitality F) Veracity

C) Volume D) Variety F) Veracity

Show number of students by gender and classification.

Cross tab table

Method used to summarize two or more categorical variables in a pairwise fashion?

Cross-Tab

Which of the following is TRUE about Tableau? A) It is developed at SAS. B) It is developed in 1989. C) Its goal is to transform a world of data into intelligence. D) It is developed at Stanford University. E) It is developed in 2003. F) Its goal is to make data understandable to ordinary people.

D) It is developed at Stanford University. E) It is developed in 2003. F) Its goal is to make data understandable to ordinary people.

What is the Business Analytics approach for managerial decision making? A) It is to automate decision making. B) It is to make plans. C) It is to completely do away subjective approach to decision making. D) It is to yield actionable insights from analyzing data. E) It is to improve business performance. F) It is to make evidence-based decisions.

D) It is to yield actionable insights from analyzing data. E) It is to improve business performance. F) It is to make evidence-based decisions.

Which of the following is TRUE about a parallel coordinate plot? A) It is useful for displaying values of multiple numerical variables associated with each value of a numerical varaiable.. B) It is useful for displaying summary statistics. C) It uses bubbles to capture the magnitude of the variables. D) It is useful for displaying values of three or more numerical variables associated with each value of a categorical varaiable. E) It uses lines to convey information. F) It captures spatial information

D) It is useful for displaying values of three or more numerical variables associated with each value of a categorical varaiable. E) It uses lines to convey information.

The following techniques go with which data pre-processing function? 1. Imputation 2. Recoding 3. Omission

Data Cleansing

A customer is 1,000 years old.

Data cleansing

The age field of the customer table is removed because we can always compute a custmer's age from his/her data of birth.

Data dimension reduction

The missing income of a customer is replaced with the average income of all customers.

Data imputation

The following techniques go with which data pre-processing function? 1. Binning 2. Dimension reduction 3. Mathematical manipulation

Data modification

It involves two steps: data cleansing and data modification.

Data pre-processing

Who is our employee-of-the-month?

Data query

The misspelling of a customer's name is corrected.

Data recoding

We need to draw attention to the increased sales in last 5 years.

Data reporting

We rely on our CEO's vision to promote the next year's assortment of products.

Decision making based on intuition

What type of analytics asks "What has happened?"

Descriptive Analytics

Distinguish high performers from laggards using color gradations in presenting weekly performance data.

Heat map

Method used to discover the relationship between two numeric variables?

Line Chart

Display demand for cupcakes over time.

Line chart

It is a software called database management systems.

Oracle

We use SQL to find our most profitable customers.

Perform data query to answer what has happened questions

What type of analytics asks "What could happen?"

Predictive Analytics

We use a sophisticated software tool to predict emplyee turnover and retention.

Predictive analytics application in human resources

What type of analytics asks "What should happen?"

Prescriptive Analytics

It is data collected directly from business transactions.

Primary data

It combines relevant data from multiple tables into a single one for data analysis.

Query

It replaces data values with legitimate and correct ones.

Recoding

Show the relationship between hours of sleep and exam 1 performance of each student in AN300.

Scatter plot

Method used to show how multiple numerical variables are related to each other in one comprehensive visual?

Scatter plot matrix

Compare the number of employees by job title for the last five years.

Stacked column chart

SAS stands for _____.

Statistical Analysis Systems

What does SQL stand for?

Structured Query Language

Display height, weight, body temperature, and blood pressure of all patients.

Table

It is at the lowest level of the data hierarchy.

Variable

We have millions rows of customer data in numbers, text, audio, video, pictures. and other multi-media format.

Volume and variety of Big Data

A data table organizes data into _____ and _____ .

columns; rows

A data column is also known as a _____.

data variable

A _____ uses colors to depict magnitude of data values.

heat map

Data visualization is the process of _____ data and _____ information in a visually appealing manner using tables, charts, maps, and dashboards.

presenting; conveying

Business Analytics tools are essentially _____.

software

"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 _____.

tradition