AN 300 PRACTICE EXAM 1 QUESTIONS & ANSWERS
What is the Business Analytics approach for managerial decision making? - Answers :-
improve business performance
- it is to yield actionable insights from analyzing data
-to make evidence-based decisions
we rely on our CEO's vision to promote the next year's assortment of products -
Answers :decision making
The use of sophisticated software tool to predict employee turnover and retention -
Answers :predictive analytics application in human resources
use SQL to find our most profitable customers - Answers :perform data query to answer
to what has happen to the question
We have millions rows of customer data in numbers, text, audio, video, pictures. and
other multi-media format. - Answers :volume and variety of big data
Which of the following is TRUE about Business Analytics? - Answers :- "What is the
profit from Diet Coke sales if we increase the price of a can by 5 cents" (example of
what-if-analysis)
- RapidMiner is a predictive analytics software tool
Which of the following is FALSE about JMP? - Answers :- your license expired at the
end of this course
- it cannot be access remotely
- it is a business analytics technique
- needs to install Citrix Receiver in order to use it offline
- developed by researchers at Standford
It is at the lowest level of the data hierarchy. - Answers :variable
It is a software called database management systems. - Answers :oracle
It is data collected directly from business transactions. - Answers :primary data
It involves two steps: data cleansing and data modification. - Answers :data pre-
preprocessing
, It replaces data values with legitimate and correct ones. - Answers :recording
it combines relevant data from multiple tables into a single one for data analysis. -
Answers :query
Which of the following is TRUE about data preparation? - Answers :- consists of Data
Acquisition and Data Pre-processing
- it is to ensure the right data is collected to meet quality and suitability requirement
A customer is 1,000 years old. - Answers :data cleansing
Who is our employee-of-the-month? - Answers :data query
We need to draw attention to the increased sales in last 5 years. - Answers :data
reporting
The misspelling of a customer's name is corrected. - Answers :data recording
The missing income of a customer is replaced with the average income of all
customers. - Answers :data imputation
The age field of the customer table is removed because we can always compute a
customer's age from his/her data of birth. - Answers :data dimension reduction
You are given 115 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 26 years' Annual Enrollment? Give your answer in % and rounded to a
whole number, i.e., no decimal places. - Answers :formula:
(Relevant # of Rows x Relevant # of Columns) / (Total # of Rows x Total # of Columns)
answer: 5
Which of the following statements about data visualization is TRUE? - Answers :- data
visualization can be used to display data relationships and patterns
- data visualization can be used to identify data errors and outliers
- "never use a 3D chart if a 2D chart is suffices" is an example of the 'keep it simple'
design principle
Show the relationship between hours of sleep and exam 1 performance of each student
in AN300. - Answers :scatter plot
What is the Business Analytics approach for managerial decision making? - Answers :-
improve business performance
- it is to yield actionable insights from analyzing data
-to make evidence-based decisions
we rely on our CEO's vision to promote the next year's assortment of products -
Answers :decision making
The use of sophisticated software tool to predict employee turnover and retention -
Answers :predictive analytics application in human resources
use SQL to find our most profitable customers - Answers :perform data query to answer
to what has happen to the question
We have millions rows of customer data in numbers, text, audio, video, pictures. and
other multi-media format. - Answers :volume and variety of big data
Which of the following is TRUE about Business Analytics? - Answers :- "What is the
profit from Diet Coke sales if we increase the price of a can by 5 cents" (example of
what-if-analysis)
- RapidMiner is a predictive analytics software tool
Which of the following is FALSE about JMP? - Answers :- your license expired at the
end of this course
- it cannot be access remotely
- it is a business analytics technique
- needs to install Citrix Receiver in order to use it offline
- developed by researchers at Standford
It is at the lowest level of the data hierarchy. - Answers :variable
It is a software called database management systems. - Answers :oracle
It is data collected directly from business transactions. - Answers :primary data
It involves two steps: data cleansing and data modification. - Answers :data pre-
preprocessing
, It replaces data values with legitimate and correct ones. - Answers :recording
it combines relevant data from multiple tables into a single one for data analysis. -
Answers :query
Which of the following is TRUE about data preparation? - Answers :- consists of Data
Acquisition and Data Pre-processing
- it is to ensure the right data is collected to meet quality and suitability requirement
A customer is 1,000 years old. - Answers :data cleansing
Who is our employee-of-the-month? - Answers :data query
We need to draw attention to the increased sales in last 5 years. - Answers :data
reporting
The misspelling of a customer's name is corrected. - Answers :data recording
The missing income of a customer is replaced with the average income of all
customers. - Answers :data imputation
The age field of the customer table is removed because we can always compute a
customer's age from his/her data of birth. - Answers :data dimension reduction
You are given 115 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 26 years' Annual Enrollment? Give your answer in % and rounded to a
whole number, i.e., no decimal places. - Answers :formula:
(Relevant # of Rows x Relevant # of Columns) / (Total # of Rows x Total # of Columns)
answer: 5
Which of the following statements about data visualization is TRUE? - Answers :- data
visualization can be used to display data relationships and patterns
- data visualization can be used to identify data errors and outliers
- "never use a 3D chart if a 2D chart is suffices" is an example of the 'keep it simple'
design principle
Show the relationship between hours of sleep and exam 1 performance of each student
in AN300. - Answers :scatter plot
