Results 1 to 3 of 3
  1. #1
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Statistical (Ratio) Question (Excel 2000 >)

    Bugging you again...(I've hit a blank!)

    If a customer1 purchases 42 items over 180 days, and customer2 purchases 42 items over 36 days, what is the daily purchase ratio of each customer. I need to know how much more purchases did customer2 do over customer1.
    Hope I'm clear enough!
    Regards,
    Rudi

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Statistical (Ratio) Question (Excel 2000 >)

    In this case, since the number of purchases is the same, it's simple: the ratio is 180:36 = 5.

    More generally, the average number of purchases per day is 42/180 for customer1, and 42/36 for customer2, so the ratio customer2 : customer1 is (42/36) / (42/180) = (42/36) * (180/42).

  3. #3
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Thanx Hans

    <P ID="nt"><font size=-1>(No Text)</font>
    Regards,
    Rudi

Posting Permissions

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