AN 300 EXAM QUESTIONS AND
ANSWERS
First hand data collected directly from where the data originates (business
transactions, customer feedback, surveys) - ANSWER-primary data
Second-hand data collected by someone else and made available to others (public
or external outlets) - ANSWER-Secondary data
Data Cleaning Process - ANSWER-Make it accurate, complete, and unbiased
Recoding - ANSWER-Replace incorrect/missing/extreme data values with legitimate
and correct one
Omission - ANSWER-Exclude incorrect/missing/extreme data from the data set
Imputation - ANSWER-Replace missing values with some reasonable imputed
values
relational database - ANSWER-A database that is logically organized set of data
tables consisting rows and columns
Data variable - ANSWER-A data column is also known as a _________
-Time
-Cost
-Availability
-Accessibility
-Complexity - ANSWER-Factors of consideration when considering data sources
oracle - ANSWER-Database management systems example
Binning - ANSWER-Data modification
imputation - ANSWER-Data cleansing
Dimension reduction - ANSWER-Data modification
Recoding - ANSWER-Data cleansing
Omission - ANSWER-Data Cleansing
Mathematical manipulation - ANSWER-Data modification
The JMP _______ window is where you will go to access sample data files. -
ANSWER-Help
SAS Enterprise Miner - ANSWER-A predictive analytics software tool is
, Decision rules - ANSWER-Prescriptive analytics technique includes
-finance
-HR
-marketing
-healthcare
-supply chain
-sports - ANSWER-Examples of illustrative business analytics applications
Reproducible - ANSWER-A Scientific approach of business analytics is ______
Software - ANSWER-Business Analytics tools are essentially_______
-Data pre-processing
-Data acquisition
- Data query
-Data reporting
-Data visualization
-Data anylyses - ANSWER-Software that offers business analytics functionalities
1989 and developed at SAS John Sall - ANSWER-When and who was JMP
developed by
It's goal is to transform a world of data into intelligence - ANSWER-JMP Goal
Stanford 2003 - ANSWER-When and where was tableau developed
It's goal is to made data understandable to ordinary people - ANSWER-Tableau's
goal
Shape raw data to meet quality & structural requirements (acquisition and pre-
processing) - ANSWER-Data Preparation:
Ask the right question & highlight important issues (data query and reporting) -
ANSWER-Preliminary analysis:
Field, record, table, database - ANSWER-Data Hierarchy
The JMP home window has two panels: - ANSWER-Recent Files and Window List.
JMP has a menus of items such as - ANSWER-File, Tables, Analyze, and Help
across the top.
Compatible file types with JMP? - ANSWER-- R Code
- SPSS
- Excel
- HTML
Demographic risk factors for COVID-19 deaths include: - ANSWER-Age
ANSWERS
First hand data collected directly from where the data originates (business
transactions, customer feedback, surveys) - ANSWER-primary data
Second-hand data collected by someone else and made available to others (public
or external outlets) - ANSWER-Secondary data
Data Cleaning Process - ANSWER-Make it accurate, complete, and unbiased
Recoding - ANSWER-Replace incorrect/missing/extreme data values with legitimate
and correct one
Omission - ANSWER-Exclude incorrect/missing/extreme data from the data set
Imputation - ANSWER-Replace missing values with some reasonable imputed
values
relational database - ANSWER-A database that is logically organized set of data
tables consisting rows and columns
Data variable - ANSWER-A data column is also known as a _________
-Time
-Cost
-Availability
-Accessibility
-Complexity - ANSWER-Factors of consideration when considering data sources
oracle - ANSWER-Database management systems example
Binning - ANSWER-Data modification
imputation - ANSWER-Data cleansing
Dimension reduction - ANSWER-Data modification
Recoding - ANSWER-Data cleansing
Omission - ANSWER-Data Cleansing
Mathematical manipulation - ANSWER-Data modification
The JMP _______ window is where you will go to access sample data files. -
ANSWER-Help
SAS Enterprise Miner - ANSWER-A predictive analytics software tool is
, Decision rules - ANSWER-Prescriptive analytics technique includes
-finance
-HR
-marketing
-healthcare
-supply chain
-sports - ANSWER-Examples of illustrative business analytics applications
Reproducible - ANSWER-A Scientific approach of business analytics is ______
Software - ANSWER-Business Analytics tools are essentially_______
-Data pre-processing
-Data acquisition
- Data query
-Data reporting
-Data visualization
-Data anylyses - ANSWER-Software that offers business analytics functionalities
1989 and developed at SAS John Sall - ANSWER-When and who was JMP
developed by
It's goal is to transform a world of data into intelligence - ANSWER-JMP Goal
Stanford 2003 - ANSWER-When and where was tableau developed
It's goal is to made data understandable to ordinary people - ANSWER-Tableau's
goal
Shape raw data to meet quality & structural requirements (acquisition and pre-
processing) - ANSWER-Data Preparation:
Ask the right question & highlight important issues (data query and reporting) -
ANSWER-Preliminary analysis:
Field, record, table, database - ANSWER-Data Hierarchy
The JMP home window has two panels: - ANSWER-Recent Files and Window List.
JMP has a menus of items such as - ANSWER-File, Tables, Analyze, and Help
across the top.
Compatible file types with JMP? - ANSWER-- R Code
- SPSS
- Excel
- HTML
Demographic risk factors for COVID-19 deaths include: - ANSWER-Age
