AN 300 EXAM 1

D.

SAS stands for _____. A. Standard Advanced Systems B. Student Advancement Software C. Structured Analysis Systems D. Statistical Analysis Systems E. Statistical Analysis Software

D.

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

contingency table pivot table two-way table

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

A.

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

columns rows

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

B.

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

A.

Business Analytics tools are essentially _____. A. Software B. Models C. Algorithms D. Techniques E. Methods

A.

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

detecting outliers detecting data errors

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

C.

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

combine data from multiple tables in data query retrieve and combine data in data query facilitate sense making in data reporting draw attention to issues in data reporting

Match a key feature on the left with the role it plays in preliminary analysis on the right. -A primary key -SQL -Summary -Highlights

what has happened? what could happen? what should happen?

Match the category of Business Analytics on the left to the type of questions it addresses on the right. Descriptive Analytics Predictive Analytics Prescriptive Analytics

cross tab line chart bar chart bubble chart scatter plot matrix

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. -Summarize two or more categorical variables in a pairwise fashion. -Discover the relationship between two numeric variables. -Count the number of observations in each category. -Show the relationship among three variables in a two-dimensional space. -Show how multiple numerical variables are related to each other in one comprehensive visual.

data modification data cleansing data modification data cleansing data cleansing data modification

Match the technique on the left with its data-preprocessing function on the right. -Binning -Imputation -Dimension reduction -Recoding -Omission -Mathematical manipulation

4 1 2 5 3

Order the data hierarchy from 1 (the lowest level) to 5 (the highest level): Database Data field Data record Database management systems File

3,5,1,4,2

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

scientific data driven computer-assisted data-driven

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

use just enough precision use light shading to distinguish columns

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

accurate legit complete

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

sports health care

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). Sports Artificial intelligence Statistics Accounting Health care

table bubble chart scatter plot matrix heat map

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

E.

What does SQL stand for? A. Super Quick Language B. Structured Quick Linguist C. Standard Question List D. Standard Query Language E. Structured Query Language

time availability cost

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

variety volume veracity

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

data reporting data pre-processing data analysis

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

B & D

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

B, D & E

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

it was developed at SAS it was developed in 1989 its goal to transform a world of data into intelligence

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

it was developed in 2003 its goal is to make data understandable to ordinary people it was developed at Stanford University

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

A & B

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

B & C

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

collected directly from the datas source managed by a database management systems proprietary data first-hand data

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

you will need to renew your license annually you will access JMP Pro locally you will save your work locally

Which of the following is TRUE if you install a personal copy of JMP Pro on your own laptop? Check all that apply. You will need to renew your license annually. You will need to install Citrix Receiver. You will need to renew your license after this course. You will access JM Pro remotely. You will access JMP Pro locally. You will save your work locally.

B.

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

data-ink ratio general design principles

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

D.

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

B.

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

tree map geographical map parallel coordinate plot

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

A

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

data pre processing data acquisition

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

data query data reporting

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

values have very different magnitudes focus is on specific numeric values values are measured using different units

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