BSAN 160
T or F:Decision support system are computer-based support systems that integrate
individuals' expertise and computer capabilities, and they have precise definitions
agreed to by practitioners. - Answer- False
Business Intelligence (BI) - Answer- is an umbrella term that combines architectures,
databases, analytical tools, applications, and methodologies
T or F: Data is a collection of observations, experiments, and experiences that do not
necessarily represent absolute facts that are universally true. - Answer- True
Descriptive Analytics - Answer- help managers understand current events in the
organization including causes, trends, and patterns.
What type of analytics seeks to recognize what is going on as well as the likely
forecast and make decisions to achieve the best performance possible? - Answer-
Prescriptive
Which of the following is/are predictive analytics method(s)?
A)Boxplot B)Text analysis C)Simulation D)Regression analysis, E)Clustering B, D
and EB, C and ED and E - Answer- B, D, E
Using characteristics of first year undergraduate students, such as age, gender,
major, location, workout/sports activities, if we developed a model to forecast which
students are at risk of dropping out after the first year of college, decided which
students to reach out to and offered them support services to reduce their risk of
dropping out, what kind of analytics application would this work represent? - Answer-
prescriptive analytics
Which chart type below would be most helpful to show the comparison between
worldwide turnover rate compared with tech sector turnover rate?
Line chart
Histogram
Bar chart
Scatterplot - Answer- Bar chart
Which chart type below would be most helpful to show the relative proportions of
turnover rate of different categories (e.g., computer games, Internet, computer
software and other) within the tech sector that drive tech turnover the most?
Histogram
Pie chart
Bar chart
Scatterplot - Answer- Pie Chart
T or F: Original (raw) data is usually collected from multiple data sources including
various formats, and it is readily usable by analytics tools and algorithms - Answer-
False
, T or F: During data transformation, depending on the context and purpose of
preprocessing the data can be rescaled to a fixed range, and numeric variables can
be converted to categorical variables - Answer- True
T or F: Data reduction can be applied to rows (observations) and/or columns
(variables) in a given dataset - Answer- True
T or F: In data preprocessing step to reduce the dimension of data prior to analysis,
sampling the rows is more complex than selecting the columns (variables - Answer-
False
T or F: Choice of visualization method that meets the presentation requirements for a
given data depends on the data types available, purpose of the visual and context -
Answer- True
Which of the below is not a data preprocessing step?
data consolidation
data transformation
data separation
data reduction - Answer- data seperation
Which of the below is a method to deal with filling out the missing values in data?
data cleaning
data reduction
data smoothing
data imputation - Answer- data imputations
Which of the below statement(s) is/are correct?
A: An important data transformation subtask is to select the relevant data using
domain expert input, i.e., decide which sources and data to collect.
B: When merging two data source tables A and B, using the full outer join method
eliminates all rows from the resulting table that do not have corresponding rows in
both source tables A and B.
C: For numerical variables, normalizing the observed values between two values,
such as 0 and 1, allows to rescale the values and compare variables with different
means and/or standard deviations on a single scale.
D: Identifying and reducing noise in the data is a subtask of data reduction. -
Answer- C
When analyzing the original data of household income of a selected population,
analysts notice that 5% of observations are missing and entered in the dataset as
N/A (not available). Further, they notice that there are a few extremely low household
income values. Which of the following method(s) would be well-suited to prepare the
data before conducting descriptive analysis, such as calculating descriptive statistics
and creating histogram of household income?
A: Use the original dataset to avoid introducing additional noise to data prior to
analysis
B: Identify the outliers in data with statistical techniques and remove the extremely
low income values
T or F:Decision support system are computer-based support systems that integrate
individuals' expertise and computer capabilities, and they have precise definitions
agreed to by practitioners. - Answer- False
Business Intelligence (BI) - Answer- is an umbrella term that combines architectures,
databases, analytical tools, applications, and methodologies
T or F: Data is a collection of observations, experiments, and experiences that do not
necessarily represent absolute facts that are universally true. - Answer- True
Descriptive Analytics - Answer- help managers understand current events in the
organization including causes, trends, and patterns.
What type of analytics seeks to recognize what is going on as well as the likely
forecast and make decisions to achieve the best performance possible? - Answer-
Prescriptive
Which of the following is/are predictive analytics method(s)?
A)Boxplot B)Text analysis C)Simulation D)Regression analysis, E)Clustering B, D
and EB, C and ED and E - Answer- B, D, E
Using characteristics of first year undergraduate students, such as age, gender,
major, location, workout/sports activities, if we developed a model to forecast which
students are at risk of dropping out after the first year of college, decided which
students to reach out to and offered them support services to reduce their risk of
dropping out, what kind of analytics application would this work represent? - Answer-
prescriptive analytics
Which chart type below would be most helpful to show the comparison between
worldwide turnover rate compared with tech sector turnover rate?
Line chart
Histogram
Bar chart
Scatterplot - Answer- Bar chart
Which chart type below would be most helpful to show the relative proportions of
turnover rate of different categories (e.g., computer games, Internet, computer
software and other) within the tech sector that drive tech turnover the most?
Histogram
Pie chart
Bar chart
Scatterplot - Answer- Pie Chart
T or F: Original (raw) data is usually collected from multiple data sources including
various formats, and it is readily usable by analytics tools and algorithms - Answer-
False
, T or F: During data transformation, depending on the context and purpose of
preprocessing the data can be rescaled to a fixed range, and numeric variables can
be converted to categorical variables - Answer- True
T or F: Data reduction can be applied to rows (observations) and/or columns
(variables) in a given dataset - Answer- True
T or F: In data preprocessing step to reduce the dimension of data prior to analysis,
sampling the rows is more complex than selecting the columns (variables - Answer-
False
T or F: Choice of visualization method that meets the presentation requirements for a
given data depends on the data types available, purpose of the visual and context -
Answer- True
Which of the below is not a data preprocessing step?
data consolidation
data transformation
data separation
data reduction - Answer- data seperation
Which of the below is a method to deal with filling out the missing values in data?
data cleaning
data reduction
data smoothing
data imputation - Answer- data imputations
Which of the below statement(s) is/are correct?
A: An important data transformation subtask is to select the relevant data using
domain expert input, i.e., decide which sources and data to collect.
B: When merging two data source tables A and B, using the full outer join method
eliminates all rows from the resulting table that do not have corresponding rows in
both source tables A and B.
C: For numerical variables, normalizing the observed values between two values,
such as 0 and 1, allows to rescale the values and compare variables with different
means and/or standard deviations on a single scale.
D: Identifying and reducing noise in the data is a subtask of data reduction. -
Answer- C
When analyzing the original data of household income of a selected population,
analysts notice that 5% of observations are missing and entered in the dataset as
N/A (not available). Further, they notice that there are a few extremely low household
income values. Which of the following method(s) would be well-suited to prepare the
data before conducting descriptive analysis, such as calculating descriptive statistics
and creating histogram of household income?
A: Use the original dataset to avoid introducing additional noise to data prior to
analysis
B: Identify the outliers in data with statistical techniques and remove the extremely
low income values
