Can you provide some examples from the book \"exploring microsoft excel office 2

Question

Can you provide some examples from the book "exploring microsoft excel office 2016 by Mary Anne Poatsy" leading to data analysis usage. ?



Data mining is the process of analyzing large volumes of data, using advanced statistical techniques, and identifying trends and patterns in the data.



Managers use data-mining techniques to address a variety of questions, such as the following:



    • What snack foods do customers purchase most when purchasing Pepsi® products?

    • What age group from what geographic region downloads the most top 10 songs from iTunes?

    • What hotel chain and rental car combinations are most popular among Delta Air Lines passengers flying into Salt Lake City?



Questions similar to those above help organizations prepare their marketing plans to capitalize on consumer spending patterns. The more you know about your customer demographics, the better you can focus your strategic plans to increase market share.



    What other examples can you provide from the book ?

Explanation / Answer

Example 1) Apriori algorithm takes a transactional database, containing list of transactions and each transaction contains the list of items purchased together. Apriori Algorithms is used to find the sets of items which are commonly purchased together. So, if a customer purchases a particular item, we can predict “what he might be interested in purchasing?”. So, Apriori algorithm can improve advertising methods.

Example 2) On E-commerce websites if we search particular items and did not purchased that item, then we receive emails from the e-commerce website about that item or other items which are similar to our interests. This is achieved using data mining.

Example 3) These days data mining is being used in predicting traffic at various locations at particular time instance of the day.

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.