Consider the data set below low 2 Yes Medium Order ID Customer ID Customer Name Segment Product ID Sales Quantity Discount given? Order Priority MX-2014-143658 SC-20575 Sonia Cooley Consumer OFF-LA-10002782 13.08 3 yes Medium MX-2012-155047 KW-16570 Kelly Williams Home office FUR-FU-10004015 252.16 8 no MX-2013-134096 DP-13000 Darren Powers Consumer OFF-EN-10001375 56.12 MX-2014-100727 DM-13525 Don Miller Home office OFF-SU-10004480 300.72 MX-2014-116337 MG-18205 Mitch Gastineau Home office FUR-BO-10000624 875.22 MX-2011-137897M-15580 Jill Matthias Consumer TEC-PH-10000018 2124.5 High Medium High 14 no 3 no 5 yes Category Office Supplies Furniture Office Supplies Office Supplies Technology Technology The idea is to make a data-driven decision to decide which two orders are the most similar. Your task as a data analyst is to help the organiza dentify the similarity between the orders based on your findings from the above data set. Clearly specify the attributes used to determine imilarity. Why did you select/reject them? (Do not use any filter or wrapper method. Use your logic or common knowledge.) Find the two imilar orders. Show all calculations. The most effective method will fetch maximum credits. Ensure that bias in the data is not considered. larks]
Consider the data set below low 2 Yes Medium Order ID Customer ID Customer Name Segment Product ID Sales Quantity Discount given? Order Priority MX-2014-143658 SC-20575 Sonia Cooley Consumer OFF-LA-10002782 13.08 3 yes Medium MX-2012-155047 KW-16570 Kelly Williams Home office FUR-FU-10004015 252.16 8 no MX-2013-134096 DP-13000 Darren Powers Consumer OFF-EN-10001375 56.12 MX-2014-100727 DM-13525 Don Miller Home office OFF-SU-10004480 300.72 MX-2014-116337 MG-18205 Mitch Gastineau Home office FUR-BO-10000624 875.22 MX-2011-137897M-15580 Jill Matthias Consumer TEC-PH-10000018 2124.5 High Medium High 14 no 3 no 5 yes Category Office Supplies Furniture Office Supplies Office Supplies Technology Technology The idea is to make a data-driven decision to decide which two orders are the most similar. Your task as a data analyst is to help the organiza dentify the similarity between the orders based on your findings from the above data set. Clearly specify the attributes used to determine imilarity. Why did you select/reject them? (Do not use any filter or wrapper method. Use your logic or common knowledge.) Find the two imilar orders. Show all calculations. The most effective method will fetch maximum credits. Ensure that bias in the data is not considered. larks]
Chapter2: Formatting Workbook Text And Data
Section: Chapter Questions
Problem 3.7CP
Related questions
Question
![36801
60329
Consider the data set below
Order ID
Customer ID Customer Name Segment Product ID Sales Quantity Discount given? Order Priority Category
MX-2014-143658 SC-20575 Sonia Cooley
Consumer OFF-LA-10002782 13.08
3 yes
Medium Office Supplies
MX-2012-155047 KW-16570 Kelly Williams Home office FUR-FU-10004015 252.16
8 no
low
Furniture
MX-2013-134096 DP-13000 Darren Powers Consumer OFF-EN-10001375 56.12 2 Yes
Medium
MX-2014-100727 DM-13525 Don Miller Home office OFF-SU-10004480 300.72
14 no
High
MX-2014-116337 MG-18205 Mitch Gastineau Home office FUR-BO-10000624 875.22
Medium
MX-2011-137897 UM-15580 Jill Matthias Consumer TEC-PH-10000018 2124.5
Office Supplies
Office Supplies
3 no
5 yes
High
Technology
Technology
The idea is to make a data-driven decision to decide which two orders are the most similar. Your task as a data analyst is to help the organizati
identify the similarity between the orders based on your findings from the above data set. Clearly specify the attributes used to determine t
similarity. Why did you select/reject them? (Do not use any filter or wrapper method. Use your logic or common knowledge.) Find the two m
similar orders. Show all calculations. The most effective method will fetch maximum credits. Ensure that bias in the data is not considered.
Marks]
Options](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fb97a9e49-f5c1-4ea5-8736-c78f0d8c614a%2F69bf5cf2-f900-45fa-8834-1bd064be9533%2Fizrz9ef_processed.jpeg&w=3840&q=75)
Transcribed Image Text:36801
60329
Consider the data set below
Order ID
Customer ID Customer Name Segment Product ID Sales Quantity Discount given? Order Priority Category
MX-2014-143658 SC-20575 Sonia Cooley
Consumer OFF-LA-10002782 13.08
3 yes
Medium Office Supplies
MX-2012-155047 KW-16570 Kelly Williams Home office FUR-FU-10004015 252.16
8 no
low
Furniture
MX-2013-134096 DP-13000 Darren Powers Consumer OFF-EN-10001375 56.12 2 Yes
Medium
MX-2014-100727 DM-13525 Don Miller Home office OFF-SU-10004480 300.72
14 no
High
MX-2014-116337 MG-18205 Mitch Gastineau Home office FUR-BO-10000624 875.22
Medium
MX-2011-137897 UM-15580 Jill Matthias Consumer TEC-PH-10000018 2124.5
Office Supplies
Office Supplies
3 no
5 yes
High
Technology
Technology
The idea is to make a data-driven decision to decide which two orders are the most similar. Your task as a data analyst is to help the organizati
identify the similarity between the orders based on your findings from the above data set. Clearly specify the attributes used to determine t
similarity. Why did you select/reject them? (Do not use any filter or wrapper method. Use your logic or common knowledge.) Find the two m
similar orders. Show all calculations. The most effective method will fetch maximum credits. Ensure that bias in the data is not considered.
Marks]
Options
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning