DSCI 4520 MIDTERM QUESTIONS WITH VERIFIED
ANSWERS
Which of the following statements is FALSE about data-driven decision-making method:
(a) It is based on the collected facts
(b) It is loaded with assumptions and theories
(c) It requires computational work
(d) It is an iterative and algorithmic process - Answers - (b) It is loaded with assumptions
and theories
Which of the following statements about business intelligence workflow is CORRECT?
(a) Data in the operational database is transformed to analytical data in the data
warehouse
(b) External data sources are never used in the BI analytics
(c) Business users and BI analysts are usually the same group of people
(d) Operational software is directly connected to data warehouse - Answers - (a) Data in
the operational database is transformed to analytical data in the data warehouse
Which of the following statements about data mining process is INCORRECT?
(a) Cleaning and pre-processing data usually takes the majority of the time spent on the
task
(b) The overall objective of any data mining process is to optimize the prediction
algorithms
(c) No value presents in raw, unprocessed, and unactionable data
(d) Data mining is a multidisciplinary field that makes a significant use of statistics -
Answers - (b) The overall objective of any data mining process is to optimize the
prediction algorithms
It is a supervised learning task to classify credit card purchases into fraudulent and
legitimate ones.
True/False - Answers - True
Training data set serves to detect and prevent overfitting of the predictive model.
True/False - Answers - False
What is the measurement level of the variable that measures customer intention as
strongly agree, agree, neutral, disagree and strongly disagree?
(a) Ordinal
(b) Binary
(c) Numeric
(d) Nominal - Answers - (a) Ordinal
,Consider two models A and B. If the prediction accuracy of Model A is higher than that
of Model B for the training dataset, we can safely say that Model A is better than Model
B.
True/False - Answers - False
In R, what kind of variables represents Numerical Discrete Variables?
(a) Complex
(b) Character
(c) Numeric
(d) Integer - Answers - (d) Integer
Which of the following statements is TRUE about classification and linear regression?
(a) Both methods are unsupervised learning algorithms
(b) Linear regression is a generalized form of all classification algorithms
(c) Linear regression is used for prediction, but classification is not useful for prediction
(d) Target variable in classification and liner regression is categorical and numerical,
respectively. - Answers - (d) Target variable in classification and liner regression is
categorical and numerical, respectively.
Which of the following steps comes before other steps in the data mining process?
(a) Model training
(b) Data pre-processing
(c) Define the problem
(d) Specify the modeling approach - Answers - (c) Define the problem
Which of the following tasks is unsupervised learning task?
(a) Identify a network data packet as dangerous vs. non-dangerous
(b) Separate loyal customers from not-loyal customers
(c) Forecasting sales with a predictive model
(d) Segment customers into unknown groups based on their demographics and
purchase history - Answers - (d) Segment customers into unknown groups based on
their demographics and purchase history
We have developed a model to predict student grades based on the number of books
they read and the number of classes they attend.
The model is estimated as follows:𝐺𝑟𝑎𝑑𝑒 = 𝑏0 + 𝑏1 ∗ 𝐵𝑜𝑜𝑘𝑠 + 𝑏2 ∗ 𝐴𝑡𝑡𝑒𝑛𝑑𝑎𝑛𝑐𝑒
Where 𝑏0 = 37.59 𝑏1 = 3.14 𝑏2 = 1.19
What is the predicted grade of a student who reads 3 book and attend 10 classes this
semester (rounded to 1 decimal point)?
(a) 73.8
(b) 58.9
(c) 41.9
(d) 48.2 - Answers - (b) 58.9
To create a plot to demonstrate the interactions of three variables, we may
(a) All of the other three
, (b) Create subplots based on the categories of the third variable
(c) Map the third variable to different sizes for the geometric objects
(d) Map the third variable to different colors for the geometric objects - Answers - (a) All
of the other three
Which of the following plot types is suitable for showing correlation between two
numeric variables?
(a) Stacked bar chart
(b) Side-by-Side bar chart
(c) Scatter plot
(d) Histogram - Answers - (c) Scatter Plot
The target variable in a multiple linear regression model must be a:
(a) Numeric variable
(b) Categorical variable
(c) Binary variable
(d) Ordinal variable - Answers - (a) Numeric variable
We import the dataset WestRoxbury, which contains records of more than 5000 houses
in WestRoxbury. The data dictionary is shown below:
TABLE 2.1 DESCRIPTION OF VARIABLES IN WEST ROXBURY (BOSTON) HOME
VALUE DATASET
TOTAL VALUE Total assessed value for property, in thousands of USD TAX Tax bill
amount based on total assessed value multiplied by the tax rate, in USD
LOT SQ FT Total lot size of parcel in square feet
YR BUILT Year the property was built
GROSS AREA Gross floor area
LIVING AREA Total living area for residential properties (ft2)
FLOORS Number of floors
ROOMS Total number of rooms
BEDROOMS Total number of bedrooms
FULL BATH Total number of full baths
HALF BATH Total number of half baths
KITCHEN Total number of kitchens
FIREPLACE Total number of fireplaces
REMODEL When the house was remodeled (Recent/Old/None)
To explore the relationship between Total Value and Remodel, what graphs may we
use?
( - Answers - (d) Boxplots across remodel categories
In the logistic regression model the target variable is:
(a) A numeric variable
(b) A binary variable
(c) Either a numeric or a binary variable
ANSWERS
Which of the following statements is FALSE about data-driven decision-making method:
(a) It is based on the collected facts
(b) It is loaded with assumptions and theories
(c) It requires computational work
(d) It is an iterative and algorithmic process - Answers - (b) It is loaded with assumptions
and theories
Which of the following statements about business intelligence workflow is CORRECT?
(a) Data in the operational database is transformed to analytical data in the data
warehouse
(b) External data sources are never used in the BI analytics
(c) Business users and BI analysts are usually the same group of people
(d) Operational software is directly connected to data warehouse - Answers - (a) Data in
the operational database is transformed to analytical data in the data warehouse
Which of the following statements about data mining process is INCORRECT?
(a) Cleaning and pre-processing data usually takes the majority of the time spent on the
task
(b) The overall objective of any data mining process is to optimize the prediction
algorithms
(c) No value presents in raw, unprocessed, and unactionable data
(d) Data mining is a multidisciplinary field that makes a significant use of statistics -
Answers - (b) The overall objective of any data mining process is to optimize the
prediction algorithms
It is a supervised learning task to classify credit card purchases into fraudulent and
legitimate ones.
True/False - Answers - True
Training data set serves to detect and prevent overfitting of the predictive model.
True/False - Answers - False
What is the measurement level of the variable that measures customer intention as
strongly agree, agree, neutral, disagree and strongly disagree?
(a) Ordinal
(b) Binary
(c) Numeric
(d) Nominal - Answers - (a) Ordinal
,Consider two models A and B. If the prediction accuracy of Model A is higher than that
of Model B for the training dataset, we can safely say that Model A is better than Model
B.
True/False - Answers - False
In R, what kind of variables represents Numerical Discrete Variables?
(a) Complex
(b) Character
(c) Numeric
(d) Integer - Answers - (d) Integer
Which of the following statements is TRUE about classification and linear regression?
(a) Both methods are unsupervised learning algorithms
(b) Linear regression is a generalized form of all classification algorithms
(c) Linear regression is used for prediction, but classification is not useful for prediction
(d) Target variable in classification and liner regression is categorical and numerical,
respectively. - Answers - (d) Target variable in classification and liner regression is
categorical and numerical, respectively.
Which of the following steps comes before other steps in the data mining process?
(a) Model training
(b) Data pre-processing
(c) Define the problem
(d) Specify the modeling approach - Answers - (c) Define the problem
Which of the following tasks is unsupervised learning task?
(a) Identify a network data packet as dangerous vs. non-dangerous
(b) Separate loyal customers from not-loyal customers
(c) Forecasting sales with a predictive model
(d) Segment customers into unknown groups based on their demographics and
purchase history - Answers - (d) Segment customers into unknown groups based on
their demographics and purchase history
We have developed a model to predict student grades based on the number of books
they read and the number of classes they attend.
The model is estimated as follows:𝐺𝑟𝑎𝑑𝑒 = 𝑏0 + 𝑏1 ∗ 𝐵𝑜𝑜𝑘𝑠 + 𝑏2 ∗ 𝐴𝑡𝑡𝑒𝑛𝑑𝑎𝑛𝑐𝑒
Where 𝑏0 = 37.59 𝑏1 = 3.14 𝑏2 = 1.19
What is the predicted grade of a student who reads 3 book and attend 10 classes this
semester (rounded to 1 decimal point)?
(a) 73.8
(b) 58.9
(c) 41.9
(d) 48.2 - Answers - (b) 58.9
To create a plot to demonstrate the interactions of three variables, we may
(a) All of the other three
, (b) Create subplots based on the categories of the third variable
(c) Map the third variable to different sizes for the geometric objects
(d) Map the third variable to different colors for the geometric objects - Answers - (a) All
of the other three
Which of the following plot types is suitable for showing correlation between two
numeric variables?
(a) Stacked bar chart
(b) Side-by-Side bar chart
(c) Scatter plot
(d) Histogram - Answers - (c) Scatter Plot
The target variable in a multiple linear regression model must be a:
(a) Numeric variable
(b) Categorical variable
(c) Binary variable
(d) Ordinal variable - Answers - (a) Numeric variable
We import the dataset WestRoxbury, which contains records of more than 5000 houses
in WestRoxbury. The data dictionary is shown below:
TABLE 2.1 DESCRIPTION OF VARIABLES IN WEST ROXBURY (BOSTON) HOME
VALUE DATASET
TOTAL VALUE Total assessed value for property, in thousands of USD TAX Tax bill
amount based on total assessed value multiplied by the tax rate, in USD
LOT SQ FT Total lot size of parcel in square feet
YR BUILT Year the property was built
GROSS AREA Gross floor area
LIVING AREA Total living area for residential properties (ft2)
FLOORS Number of floors
ROOMS Total number of rooms
BEDROOMS Total number of bedrooms
FULL BATH Total number of full baths
HALF BATH Total number of half baths
KITCHEN Total number of kitchens
FIREPLACE Total number of fireplaces
REMODEL When the house was remodeled (Recent/Old/None)
To explore the relationship between Total Value and Remodel, what graphs may we
use?
( - Answers - (d) Boxplots across remodel categories
In the logistic regression model the target variable is:
(a) A numeric variable
(b) A binary variable
(c) Either a numeric or a binary variable
