INTRO TO DATA ANALYTICS D491
EXAM QUESTIONS WITH COMPLETE
ANSWERS
Maintaining DB2® and Oracle databases involves updating statistics, monitoring
database, server, and space utilization, and planning backup and recovery
strategies. - an example of ? - ANSWER-Maintaining databases
Project initiation falls under what role? - ANSWER-Project Sponsor
How to find p-value? - ANSWER--look at alternative
-if less than, find area to the left of z value
-if greater than, find area to the right of z value
-if not equal to, if positive, find area to the right and double it. if negative, find area to
the left and double it.
creating tables and establishing relationships between those tables according to
rules designed both to protect the data and to make the database more flexible by
eliminating redundancy and inconsistent dependency. - ANSWER-normalization
MATLAB - ANSWER-The Matrix Laboratory language is used for a variety of
mathematical calculations and tasks
Centroid Clustering - ANSWER-clusters are represented by their centroids.
hierarchical clustering with cluster distance defined by a centroid/assigned center
___ has many applications in diverse fields such as face recognition, computer
vision, image compression, bioinformatics, and fraud detection. - ANSWER-PCA
Density Clustering - ANSWER-detecting areas where points are concentrated and
where they are separated by areas that are empty or sparse.
Data Wrangling is - ANSWER-the process of removing errors and combining
complex data sets to make them more accessible and easier to analyze.
Data Wrangling Examples - ANSWER-Merging several data sources into one data-
set for analysis.
Identifying gaps or empty cells in data and either filling or removing them.
Deleting irrelevant or unnecessary data.
Identifying severe outliers in data and either explaining the inconsistencies or
deleting them to facilitate analysis.
Merging several data sources into one data-set for analysis.
Identifying gaps or empty cells in data and either filling or removing them.
Deleting irrelevant or unnecessary data.
,Identifying severe outliers in data and either explaining the inconsistencies or
deleting them to facilitate analysis. - ANSWER-Data Wrangling Examples
Maintaining Databases examples/purpose - ANSWER-Routines meant to help
performance, free up disk space, check for data errors, check for hardware faults,
update internal statistics, and many other obscure (but important) things.
Support Vector Machines - ANSWER-A discriminating classifier that is defined by a
separating hyperplane (lower level plot) that works first to find the widest margin (or
biggest pipe).
________ _________ reduces overfitting by averaging multiple decision trees and is
less sensitive to noise and outliers in the data. - ANSWER-Random Forest
Machine Learning (ML) - ANSWER-A branch of artificial intelligence focused on
developing algorithms and models that allow computers to learn and make
predictions or decisions based on data; in the context of a data analytics course,
machine learning is a set of techniques and tools used to analyze and derive insights
from large and complex datasets
Examples of ML objects products - ANSWER-driverless cars (Tesla, Volvo),
medicine (find cancer), detect fraud (PayPal, Amazon, Home Depot), MT Everest
Weather, Missing Children based on Facial Recognition, Alexa/Cortana/Siri,
Facebook ads, Zillow home prices
There are two main types of ML models: machine learning ____________(where the
response belongs to a set of classes) and machine learning __________(where the
response is continuous). - ANSWER-classification, regression
optimization - ANSWER-the process of finding the best solution to a problem or
maximizing or minimizing an objective function, subject to constraints
conversion rate - ANSWER-a metric that measures the percentage of website
visitors who complete a desired action, such as purchasing or filling out a form
If an ecommerce site receives 200 visitors in a month and has 50 sales, the
__________ _____ would be 50 divided by 200, or 25%. A _________can refer to
any desired action that you want the user to take. - ANSWER-Conversion rate,
conversion
Signing up for emails. Filling out a contact form. Visiting certain pages on your
website. - All examples of a _______________ _____ - ANSWER-Conversion Rate
If 1000 people visit the website and 50 people make a purchase, the conversion rate
would be ?/? = (?: decimal value) or ?%. - ANSWER-50/1000, .05, 5%, conversion
rates are really just finding the desired outcome by part/whole = percentage of what
you're looking for (the part being subject to change and the whole being the total
amount)
, If an email was sent to 200 people and 40 people clicked on the link, the conversion
rate would be? - ANSWER-40/200, 0.2, 20%
If an ad is viewed 500 times and it gets 75 clicks, the conversion rate would be? -
ANSWER-75/500 = 0.15 or 15%.
click-through rate (CTR) - ANSWER-a metric that measures the percentage of
people who click on a link or advertisement
customer lifetime value (CLV) - ANSWER-a metric that measures the total value of a
customer to a business throughout their relationship
Subscription Services: A customer subscribes to a streaming service like Netflix for
$10/month. If the average customer stays subscribed for 3 years. How much is the
CLV? - ANSWER-the CLV would be $10 * 12 months/year * 3 years = $360.
Telecommunications: A customer signs up for a 2-year contract with a mobile phone
company. The monthly bill is $50, and the customer also purchases a $200 phone.
What would the CLV be? - ANSWER-The CLV would be ($50 * 24 months) + $200 =
$1400.
Find the CLV: A customer shops at an online store and makes an average purchase
of $30, five times a year, for ten years. - ANSWER-The CLV would be $30 * 5
times/year * 10 years = $1500.
E-Commerce: Customer Lifetime Value is a ___________ of the net profit attributed
to the entire future relationship with a customer. It helps businesses make decisions
about how much money to invest in acquiring new customers and retaining existing
ones. - ANSWER-prediction
Find the CLV: Telecommunications with Churn Rate: A customer signs up for a 2-
year contract with a mobile phone company. The monthly bill is $70, and the
customer also purchases a $300 phone. However, the company has a yearly churn
rate of 20%. - ANSWER-This means that each year, they lose 20% of their
customers. The CLV would be [($70 * 12 months + $300) * (1 - 0.20)] = $1,056 for
the first year. If the customer stays for the second year, the CLV would be $1,056 +
[($70 * 12 months) * (1 - 0.20)] = $1,812.
A ________churn rate is typically better for a business; it means they are retaining
more of their customers. However, some amount of churn is normal and expected in
most businesses. - ANSWER-lower
Streaming Services: A streaming service like Netflix might have a monthly churn rate
of 2%. - What does this mean? - ANSWER-Out of their total subscribers, 2% cancel
their subscription each month.
churn rate: - ANSWER-a metric that measures the percentage of customers who
stop doing business with a company over a certain period
EXAM QUESTIONS WITH COMPLETE
ANSWERS
Maintaining DB2® and Oracle databases involves updating statistics, monitoring
database, server, and space utilization, and planning backup and recovery
strategies. - an example of ? - ANSWER-Maintaining databases
Project initiation falls under what role? - ANSWER-Project Sponsor
How to find p-value? - ANSWER--look at alternative
-if less than, find area to the left of z value
-if greater than, find area to the right of z value
-if not equal to, if positive, find area to the right and double it. if negative, find area to
the left and double it.
creating tables and establishing relationships between those tables according to
rules designed both to protect the data and to make the database more flexible by
eliminating redundancy and inconsistent dependency. - ANSWER-normalization
MATLAB - ANSWER-The Matrix Laboratory language is used for a variety of
mathematical calculations and tasks
Centroid Clustering - ANSWER-clusters are represented by their centroids.
hierarchical clustering with cluster distance defined by a centroid/assigned center
___ has many applications in diverse fields such as face recognition, computer
vision, image compression, bioinformatics, and fraud detection. - ANSWER-PCA
Density Clustering - ANSWER-detecting areas where points are concentrated and
where they are separated by areas that are empty or sparse.
Data Wrangling is - ANSWER-the process of removing errors and combining
complex data sets to make them more accessible and easier to analyze.
Data Wrangling Examples - ANSWER-Merging several data sources into one data-
set for analysis.
Identifying gaps or empty cells in data and either filling or removing them.
Deleting irrelevant or unnecessary data.
Identifying severe outliers in data and either explaining the inconsistencies or
deleting them to facilitate analysis.
Merging several data sources into one data-set for analysis.
Identifying gaps or empty cells in data and either filling or removing them.
Deleting irrelevant or unnecessary data.
,Identifying severe outliers in data and either explaining the inconsistencies or
deleting them to facilitate analysis. - ANSWER-Data Wrangling Examples
Maintaining Databases examples/purpose - ANSWER-Routines meant to help
performance, free up disk space, check for data errors, check for hardware faults,
update internal statistics, and many other obscure (but important) things.
Support Vector Machines - ANSWER-A discriminating classifier that is defined by a
separating hyperplane (lower level plot) that works first to find the widest margin (or
biggest pipe).
________ _________ reduces overfitting by averaging multiple decision trees and is
less sensitive to noise and outliers in the data. - ANSWER-Random Forest
Machine Learning (ML) - ANSWER-A branch of artificial intelligence focused on
developing algorithms and models that allow computers to learn and make
predictions or decisions based on data; in the context of a data analytics course,
machine learning is a set of techniques and tools used to analyze and derive insights
from large and complex datasets
Examples of ML objects products - ANSWER-driverless cars (Tesla, Volvo),
medicine (find cancer), detect fraud (PayPal, Amazon, Home Depot), MT Everest
Weather, Missing Children based on Facial Recognition, Alexa/Cortana/Siri,
Facebook ads, Zillow home prices
There are two main types of ML models: machine learning ____________(where the
response belongs to a set of classes) and machine learning __________(where the
response is continuous). - ANSWER-classification, regression
optimization - ANSWER-the process of finding the best solution to a problem or
maximizing or minimizing an objective function, subject to constraints
conversion rate - ANSWER-a metric that measures the percentage of website
visitors who complete a desired action, such as purchasing or filling out a form
If an ecommerce site receives 200 visitors in a month and has 50 sales, the
__________ _____ would be 50 divided by 200, or 25%. A _________can refer to
any desired action that you want the user to take. - ANSWER-Conversion rate,
conversion
Signing up for emails. Filling out a contact form. Visiting certain pages on your
website. - All examples of a _______________ _____ - ANSWER-Conversion Rate
If 1000 people visit the website and 50 people make a purchase, the conversion rate
would be ?/? = (?: decimal value) or ?%. - ANSWER-50/1000, .05, 5%, conversion
rates are really just finding the desired outcome by part/whole = percentage of what
you're looking for (the part being subject to change and the whole being the total
amount)
, If an email was sent to 200 people and 40 people clicked on the link, the conversion
rate would be? - ANSWER-40/200, 0.2, 20%
If an ad is viewed 500 times and it gets 75 clicks, the conversion rate would be? -
ANSWER-75/500 = 0.15 or 15%.
click-through rate (CTR) - ANSWER-a metric that measures the percentage of
people who click on a link or advertisement
customer lifetime value (CLV) - ANSWER-a metric that measures the total value of a
customer to a business throughout their relationship
Subscription Services: A customer subscribes to a streaming service like Netflix for
$10/month. If the average customer stays subscribed for 3 years. How much is the
CLV? - ANSWER-the CLV would be $10 * 12 months/year * 3 years = $360.
Telecommunications: A customer signs up for a 2-year contract with a mobile phone
company. The monthly bill is $50, and the customer also purchases a $200 phone.
What would the CLV be? - ANSWER-The CLV would be ($50 * 24 months) + $200 =
$1400.
Find the CLV: A customer shops at an online store and makes an average purchase
of $30, five times a year, for ten years. - ANSWER-The CLV would be $30 * 5
times/year * 10 years = $1500.
E-Commerce: Customer Lifetime Value is a ___________ of the net profit attributed
to the entire future relationship with a customer. It helps businesses make decisions
about how much money to invest in acquiring new customers and retaining existing
ones. - ANSWER-prediction
Find the CLV: Telecommunications with Churn Rate: A customer signs up for a 2-
year contract with a mobile phone company. The monthly bill is $70, and the
customer also purchases a $300 phone. However, the company has a yearly churn
rate of 20%. - ANSWER-This means that each year, they lose 20% of their
customers. The CLV would be [($70 * 12 months + $300) * (1 - 0.20)] = $1,056 for
the first year. If the customer stays for the second year, the CLV would be $1,056 +
[($70 * 12 months) * (1 - 0.20)] = $1,812.
A ________churn rate is typically better for a business; it means they are retaining
more of their customers. However, some amount of churn is normal and expected in
most businesses. - ANSWER-lower
Streaming Services: A streaming service like Netflix might have a monthly churn rate
of 2%. - What does this mean? - ANSWER-Out of their total subscribers, 2% cancel
their subscription each month.
churn rate: - ANSWER-a metric that measures the percentage of customers who
stop doing business with a company over a certain period
