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
Voordelen van het kopen van samenvattingen bij Stuvia op een rij:
Verzekerd van kwaliteit door reviews
Stuvia-klanten hebben meer dan 700.000 samenvattingen beoordeeld. Zo weet je zeker dat je de beste documenten koopt!
Snel en makkelijk kopen
Je betaalt supersnel en eenmalig met iDeal, creditcard of Stuvia-tegoed voor de samenvatting. Zonder lidmaatschap.
Focus op de essentie
Samenvattingen worden geschreven voor en door anderen. Daarom zijn de samenvattingen altijd betrouwbaar en actueel. Zo kom je snel tot de kern!
Veelgestelde vragen
Wat krijg ik als ik dit document koop?
Je krijgt een PDF, die direct beschikbaar is na je aankoop. Het gekochte document is altijd, overal en oneindig toegankelijk via je profiel.
Tevredenheidsgarantie: hoe werkt dat?
Onze tevredenheidsgarantie zorgt ervoor dat je altijd een studiedocument vindt dat goed bij je past. Je vult een formulier in en onze klantenservice regelt de rest.
Van wie koop ik deze samenvatting?
Stuvia is een marktplaats, je koop dit document dus niet van ons, maar van verkoper Perfectscorer. Stuvia faciliteert de betaling aan de verkoper.
Zit ik meteen vast aan een abonnement?
Nee, je koopt alleen deze samenvatting voor €12,41. Je zit daarna nergens aan vast.
