100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
logo-home
BSAN160 Final Test Questions with Correct Answers £10.32   Add to cart

Exam (elaborations)

BSAN160 Final Test Questions with Correct Answers

 8 views  0 purchase
  • Module
  • BSAN160
  • Institution
  • BSAN160

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...

[Show more]

Preview 2 out of 9  pages

  • August 16, 2024
  • 9
  • 2024/2025
  • Exam (elaborations)
  • Questions & answers
  • BSAN160
  • BSAN160
avatar-seller
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 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

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

Quick and easy check-out

You can quickly pay through credit card for the summaries. There is no membership needed.

Focus on what matters

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.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

84669 documents were sold in the last 30 days

Founded in 2010, the go-to place to buy revision notes and other study material for 14 years now

Start selling
£10.32
  • (0)
  Add to cart