BCOR 2205 Midterm Exam
Questions with All Correct
Answers
Why is Cross Validation Important? - Answer-If the original validation partition is not
representative of the overall population, then the resulting model may appear to have a
high accuracy when in reality it just happens to fit the unusual validation set well
Define project Objectives - Answer-Define Project Objectives
Specify business problem
Acquire subject matter expertise
Define unit of analysis and prediction target Prioritize modeling criteria
Consider risks and success criteria
Decide whether to continue
What is a Business Problem? - Answer-Anything a company would want to know in
order to increase sales and/or decrease costs
4 Criteria for stating a business problem - Answer-Is the project statement in the
language of the business
Does the project statement specify actions that should result from the project
Are there specifics included
impact to the bottom line
SME - Answer-subject matter experience
Define unit of analysis - Answer-the 'who' or 'what' we are studying
what is the prediction target
Success - Answer-Who uses the model
how much can the model drive
what is the modeling criteria
Internal data - Answer-Data that is procured and consolidated from different branches
within your organization
, External data - Answer-Data that is not collected by your organization (can be public or
bought)
Data Base - Answer-A collection of records.
Data Base Management Systems - Answer-(DBMS) Are designed as means of
managing all the records. DBMS is a software system designed to allow the definition,
update, retrieval and administration of databases.
Coma Separated Values - Answer-CSVs
Year,make,model
Cloud Computing - Answer-the practice of using a network of remote servers hosted on
the Internet to store, manage, and process data, rather than a local server or a personal
computer.
Entity Relationship Data Base - Answer-(ERBD)
A graphical approach to database design. Graphically represents the logical relationship
of entities (objects)
Attributes - Answer-are data items that describe an entity.
'Name' and 'hire date' are examples of attributes of the entity employee
primary Key - Answer-an attribute that uniquely identify a specific instance of an entity.
Every entity in the data model must have a primary key whose values uniquely identify
instances of the entity.
Foreign Key - Answer-attribute borrowed from another related table in order to make the
relationship between the two tables.
CRM - Answer-customer relationship management
keeping all records in same place
Flat file database - Answer-Contains one table, with no relationships.
relational database - Answer-A database that represents data as a collection of tables in
which all data relationships are represented by common values in related tables
Quantitative data - Answer-Nominal and Ordinal
measured by numbers or counting
Qualitative data - Answer-ratio and interval
categorical data
described by words and numbers
Discrete data - Answer-countable (ie people at a concert, cannot have 1/2 of a person)
Questions with All Correct
Answers
Why is Cross Validation Important? - Answer-If the original validation partition is not
representative of the overall population, then the resulting model may appear to have a
high accuracy when in reality it just happens to fit the unusual validation set well
Define project Objectives - Answer-Define Project Objectives
Specify business problem
Acquire subject matter expertise
Define unit of analysis and prediction target Prioritize modeling criteria
Consider risks and success criteria
Decide whether to continue
What is a Business Problem? - Answer-Anything a company would want to know in
order to increase sales and/or decrease costs
4 Criteria for stating a business problem - Answer-Is the project statement in the
language of the business
Does the project statement specify actions that should result from the project
Are there specifics included
impact to the bottom line
SME - Answer-subject matter experience
Define unit of analysis - Answer-the 'who' or 'what' we are studying
what is the prediction target
Success - Answer-Who uses the model
how much can the model drive
what is the modeling criteria
Internal data - Answer-Data that is procured and consolidated from different branches
within your organization
, External data - Answer-Data that is not collected by your organization (can be public or
bought)
Data Base - Answer-A collection of records.
Data Base Management Systems - Answer-(DBMS) Are designed as means of
managing all the records. DBMS is a software system designed to allow the definition,
update, retrieval and administration of databases.
Coma Separated Values - Answer-CSVs
Year,make,model
Cloud Computing - Answer-the practice of using a network of remote servers hosted on
the Internet to store, manage, and process data, rather than a local server or a personal
computer.
Entity Relationship Data Base - Answer-(ERBD)
A graphical approach to database design. Graphically represents the logical relationship
of entities (objects)
Attributes - Answer-are data items that describe an entity.
'Name' and 'hire date' are examples of attributes of the entity employee
primary Key - Answer-an attribute that uniquely identify a specific instance of an entity.
Every entity in the data model must have a primary key whose values uniquely identify
instances of the entity.
Foreign Key - Answer-attribute borrowed from another related table in order to make the
relationship between the two tables.
CRM - Answer-customer relationship management
keeping all records in same place
Flat file database - Answer-Contains one table, with no relationships.
relational database - Answer-A database that represents data as a collection of tables in
which all data relationships are represented by common values in related tables
Quantitative data - Answer-Nominal and Ordinal
measured by numbers or counting
Qualitative data - Answer-ratio and interval
categorical data
described by words and numbers
Discrete data - Answer-countable (ie people at a concert, cannot have 1/2 of a person)
