Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

Choose the data technology (Q,H,U, or S) that is most appropriate for each of th

ID: 455522 • Letter: C

Question

Choose the data technology (Q,H,U, or S) that is most appropriate for each of the following business questions/scenarios. Q – SQL Querying H – Statistical Hypothesis Testing U – Unsupervised Data Mining/Pattern Finding S – Supervised Data Mining a) ___ For my on-line advertising the decision tree model yields a response rate of 0.5% and the old, manual targeting model yields 0.3%. Is the decision tree model really better? b) ___ I want to know which of my customers are the most profitable. c) ___ I need to get data on all my on-line customers who were exposed to the special offer, including their registration data, their past purchases, and whether or not they purchased in the 15 days following the exposure. d)___ I would like to segment my customers into groups based on their demographics and prior purchase activity. I am not focusing on improving a particular task, but would like to generate ideas. e) ___ I have a budget to target 10,000 existing customers with a special offer. I would like to identify those customers most likely to respond to the special offer. f) ___ I want to know what characteristics differentiate my most profitable customers.

Explanation / Answer

Answer :

Q – SQL Querying H – Statistical Hypothesis Testing U – Unsupervised Data Mining/Pattern Finding S – Supervised Data Mining

a) ___ For my on-line advertising the decision tree model yields a response rate of 0.5% and the old, manual targeting model yields 0.3%. Is the decision tree model really better?

Answer : S – Supervised Data Mining

This requires supervised data coordination.

b) ___ I want to know which of my customers are the most profitable.

Answer : H – Statistical Hypothesis Testing

Answer will get only after testing Hypothesis

c) ___ I need to get data on all my on-line customers who were exposed to the special offer, including their registration data, their past purchases, and whether or not they purchased in the 15 days following the exposure.

Answer: Q – SQL Querying

For this Structure Query Language helps to get the systematic data.

d)___ I would like to segment my customers into groups based on their demographics and prior purchase activity. I am not focusing on improving a particular task, but would like to generate ideas.

Answer: U – Unsupervised Data Mining/Pattern Finding

What data that we are looking is completely Unsupervised

e) ___ I have a budget to target 10,000 existing customers with a special offer. I would like to identify those customers most likely to respond to the special offer.

Answer: Q – SQL Querying

For this Structure Query Language helps to get the systematic data.

f) ___ I want to know what characteristics differentiate my most profitable customers.

Answer: H – Statistical Hypothesis Testing

Answer will get only after testing Hypothesis