+ Reply to Thread
Results 1 to 4 of 4

Cohort Analysis help needed

  1. #1
    Registered User
    Join Date
    12-21-2016
    Location
    India
    MS-Off Ver
    2013
    Posts
    2

    Question Cohort Analysis help needed

    Hi, Is there anyone who can help me with Cohort Analysis for the attached data to get the-
    1. No. of unique shoppers every month with respect to total number of users acquired that month (for all months that data is given)
    2. Commission Earned from Users Acquired from each month with respect to total number of users acquired that month (for all months that data is given)
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    11-02-2016
    Location
    NY
    MS-Off Ver
    2010
    Posts
    459

    Re: Cohort Analysis help needed

    Please give a sample of how end results would look. Need more info. However, I would summarize using pivot tables

  3. #3
    Registered User
    Join Date
    12-21-2016
    Location
    India
    MS-Off Ver
    2013
    Posts
    2

    Re: Cohort Analysis help needed

    At the moment no output is given, we have to provide the output. 1st part is somewhat understood but not able to get the 2nd part.

  4. #4
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,826

    Re: Cohort Analysis help needed

    A quick internet search for "cohort analysis excel" found this video: https://www.youtube.com/watch?v=2QZQolcLo6M
    this page has a spreadsheet you can download: http://andrewchen.co/the-easiest-spr...is-guest-post/
    This page works through an example: http://www.cohortanalysis.com/
    and many other hits. It seems that this kind of analysis is complex enough that I would recommend that you narrow your question -- exactly what part of performing this kind of analysis do you need help with?
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 09-10-2015, 05:34 AM
  2. Counting if in certain cohort
    By sacha.dyer in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 03-13-2014, 08:42 AM
  3. Replies: 1
    Last Post: 03-06-2014, 11:00 AM
  4. [SOLVED] advanced help needed for data analysis
    By rob0387 in forum Excel General
    Replies: 4
    Last Post: 02-01-2014, 09:04 AM
  5. Help Needed: Data Table (What If Analysis)
    By BoomerSooner2014 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-02-2013, 05:58 PM
  6. Analysis TookPak Documentation Needed
    By burro in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-28-2011, 04:51 PM
  7. Help needed with date range based analysis
    By SG2 in forum Excel General
    Replies: 2
    Last Post: 07-28-2010, 04:00 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