BSAN160 Final Test Questions with Correct Answers
How are the whiskers for maximum and minimum in a box plot determined? - Answer-Whiskers for maximum and minimum are derived from the Inter-Quartile Range and is 1.5 times the IQR
Schema for Data Preparation - Answer-Data consolidation, Data cl...
How are the whiskers for maximum and minimum in a box plot determined? - Answer-
Whiskers for maximum and minimum are derived from the Inter-Quartile Range and is
1.5 times the IQR
Schema for Data Preparation - Answer-Data consolidation, Data cleaning, Data
transformation, Data reduction
Data Consolidation - Answer-Data preprocessing method that accesses and collects the
data, selects and filters the data, integrate and unify the data (through domain expertise,
software agents, web services, SQL queries in a database, spreadsheets)
Structure Query Language (SQL) - Answer-A language used in relational databases
that allows for different logical approaches for data integration
Data Cleaning - Answer-A data preprocessing method that handles missing values in
the data (through filling in missing values with most appropriate values called data
imputation), identifies and reduces noise in the data (through identifying outliers and
then either removing the outliers or smoothing them), and finding and eliminating
erroneous data
Missing Values - Carry Forward Method - Answer-Option when observations are
missing in a data set is to carry forward the last observation before the missing
observation
Missing Values - Observed Mean Method - Answer-Option when observations are
missing in a dataset is to use the mean value of the available observed values
Data Transformation - Answer-A data preprocessing method that normalizes the data
(through reducing the range of values to a standard range), discretizes or aggregates
the data, and constructs new attributes
Data Reduction - Answer-A data preprocessing method that reduces the number of
attributes, reduces the number of records and balances skewed data
Dashboards - Answer-A display of important information arranged on an interactive
screen so that the key insights can be digested at a single glance and easily drilled in
for further exploration
, Three layers of information that dashboards offer - Answer-Monitoring (operational
management), analysis (tactical management), management (strategic)
Regression - Answer-Most widely known and used analytical technique in statistics that
is used for forecasting values of a dependent variable and to test hypothesis expressed
in a mathematical form to examine the relationship between one or more variables
Linear Regression - Answer-The most common type of regression that is expressed in
the first degree, so it is portrayed as a straight line that gives the best fit to points in a
dataset
Simple Linear Regression - Answer-One numerical dependent variable, one
independent variable, which can be numerical or categorical
Multiple Linear Regression - Answer-One numerical dependent variable, more than one
independent variable, which can be numerical or categorical
Simple Linear Regression Model - Answer-The straight line defined by two parameters
that gives the smallest sum of squared errors (a.k.a. residuals) between data points and
line
Business Intelligence - Answer-Management of complex, multidimensional data to
support business decisions and improve performance
Business Analytics - Answer-A component of BI that defines the process of developing
actionable decisions or recommendations for actions based on insights generated from
historical data
Data visualization - Answer-A tool in use with business analytics that facilitates the
generation and presentation of insights to support business decisions
Traditional reporting - Answer-Manual collection and processing/analysis of data to
obtain information and decisions, which is time consuming and adapts slowly
Decision Support System (DSS) - Answer-Combination of human expertise with
computer capabilities to solve problems using data and models
BI systems - Answer-Data-driven DSSs in the 2000s that started to combine databases,
analytical tools, and advanced software applications to produce interactive reports and
analyses
Four Components of BI - Answer-Data warehouse, business analytics, business
performance management, user interface
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller Perfectscorer. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for £10.32. You're not tied to anything after your purchase.
