Results 1 to 1 of 1

Math Help - Looking for a Keyword ranking formula on a Data set in excel

  1. #1
    Newbie
    Joined
    Apr 2009
    Posts
    1

    Smile Looking for a Keyword ranking formula on a Data set in excel

    Hi,

    I am trying to do keyword comparison based on position ranking in a search pattern over time and create a predictor of a profitability index of which keyword and ad grouping will perform best over time,

    Here is the data that I am given:

    Last position ranked
    top position ranked
    avg position ranked
    and avg number of competitors in this ranking
    total days in the count (TDC)
    total number of times this keyword was found (TDF)
    and a ratio of TDF/TDC
    first day seen
    last day seen

    Here is what I am trying to achieve:
    A Profitability Index number between 0 and 1 that would indicate how well this keyword performed over a time period. with 1 being the best.

    I am including a 500 keyword xls spreadsheet in a zip file for your help. You can see my attempt at ranking. I am not a math whiz, that's why I am asking for your help. Any suggestions would be appreciated and acknowledged on future site designs.

    Thanks
    Damon
    Attached Files Attached Files
    Last edited by dunrented; April 7th 2009 at 09:36 AM. Reason: forgot to attach file
    Follow Math Help Forum on Facebook and Google+

Similar Math Help Forum Discussions

  1. Working out a formula from a set of data
    Posted in the Algebra Forum
    Replies: 1
    Last Post: June 9th 2010, 03:18 AM
  2. Formula needed, all data available
    Posted in the Advanced Statistics Forum
    Replies: 0
    Last Post: November 26th 2009, 08:10 AM
  3. Finding a formula for this data
    Posted in the Algebra Forum
    Replies: 2
    Last Post: October 17th 2009, 07:58 AM
  4. need help with excel formula
    Posted in the Business Math Forum
    Replies: 5
    Last Post: August 31st 2009, 05:50 AM
  5. Replies: 4
    Last Post: May 18th 2009, 11:16 PM

Search Tags


/mathhelpforum @mathhelpforum