Results 1 to 2 of 2

Market basket analysis formula

Threaded View

  1. #1
    Registered User
    Join Date
    05-10-2016
    Location
    Ohio
    MS-Off Ver
    2010
    Posts
    1

    Market basket analysis formula

    hi,

    I have a large data set that is ~ 800k records in which I would like to perform a market basket analysis. I have attached a smaller data set that is a portion of the total data. I want to be able to understand the relationships between columns H through N and how they are bought together in all the transactions which are identified by a transaction number in column D.

    The key relationships that i want to establish first are:

    1. When the customer buys a certain style in column J what other styles is she buying?
    2. When the customer buys a certain size in column H what else is in the transaction. This could be any of the columns between H-N?
    3. When the customer buys a FASHION item in column L AND that item is in Combo 378 what other styles in column J is she buying?
    4. When the customer buys a certain style in column J what is the total $'s associated with the entire transaction in column F?


    I appreciate any thoughts or ideas!!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Stock market data analysis in excel?
    By alexfarris in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-16-2014, 09:10 PM
  2. [SOLVED] Time Series Forecast based on market share (market penetration)
    By mils in forum Excel General
    Replies: 5
    Last Post: 02-17-2014, 09:40 AM
  3. Replies: 0
    Last Post: 07-26-2013, 10:32 AM
  4. How to calculate market growth and market share?
    By keesberbee in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-12-2013, 02:42 AM
  5. Stock market formula...
    By yorkman in forum Excel General
    Replies: 3
    Last Post: 05-20-2009, 09:46 AM
  6. How can i get money market quotes on excel to build my analysis?
    By mikecfm in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-09-2005, 05:05 AM
  7. 'add-to-basket' function
    By A little Help in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-06-2005, 12:06 PM
  8. [SOLVED] [SOLVED] basket with fruits : numbers and formula
    By rbus in forum Excel General
    Replies: 4
    Last Post: 01-25-2005, 05:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1