+ Reply to Thread
Results 1 to 3 of 3

Conjoint Market Simulator - $10 Amazon gift card

  1. #1
    Valued Forum Contributor abduljaleel.mca's Avatar
    Join Date
    Chennai, India
    MS-Off Ver
    MS 365 Business

    Conjoint Market Simulator - $10 Amazon gift card


    I would be happy to email a $10 Amazon gift card to anyone who can help me out on the below.

    Please have a look at the attached file.

    I am expecting values in B22 = 17.98, C22=11.79, D22=27.42 and E22=42.81. Please refer 'Results' tab for your reference.

    I did all the calculation however I can't able to get the above values, I am doing something wrong in the price calculation.

    Please have a look at it and help me.

    Last edited by abduljaleel.mca; 10-04-2013 at 11:10 AM.

  2. #2
    Forum Guru
    Join Date
    MS-Off Ver
    Microsoft 365 aka Office 365

    Re: Conjoint Market Simulator - $10 Amazon gift card

    I only checked the B22 value and 29.9 seems to be correct.

    If you go into 'First Choice' and manually add up the values in column U, the sum is 418.
    Click on cell 'U3' and keep the left mouse button down. Keep the mouse down, while
    moving down the screen until you reach cell 'U1401'. The sum as displayed on the
    'Status Bar' which is the same sum the average calculation uses.

    418 / 1399 = 29.9%

  3. #3
    Forum Expert
    Join Date
    MS-Off Ver

    Re: Conjoint Market Simulator - $10 Amazon gift card

    I'm not entirely sure why but your sumproduct formulas seem to be returning incorrect results. If you look at B3 on the first choice worksheet, the calculation should be (I think):
    1*39.49+3*(-5.3)=23.59 and your sumproduct formula is returning 50 odd.

    I tried fixing it by changing your sumproduct formulas to =sum(Range1*range2) as an array formula (confirm with ctrl+shift+enter), it gave different end results but not the numbers you were wanting above.

    Are the ranges on the design sheet meant to be blank from column D onwards?

+ 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: 0
    Last Post: 07-26-2013, 10:32 AM
  2. 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
  3. Loan Simulator
    By Jaai001 in forum Excel General
    Replies: 5
    Last Post: 05-26-2011, 08:16 AM
  4. [SOLVED] flight simulator
    By ianalexh in forum Excel General
    Replies: 1
    Last Post: 02-16-2005, 03:35 PM


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