+ Reply to Thread
Results 1 to 2 of 2

Doing a "best fit" bell-curve analysis

  1. #1
    Registered User
    Join Date
    05-25-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    1

    Doing a "best fit" bell-curve analysis

    Hi everyone, I'm sure there's probably a clever solution to this, but it's beyond me.

    I have a dataset that represents the varying sales prices of a particular product.

    My goal is to come up with what would be a "substantive" price for the product, and want to use a bell-curve approach. My methodology is that any price that is within 20% of the "substantive" price would be deemed acceptable, but prices that deviate by more than 20% are not acceptable.

    If my values were evenly distributed, I could use the median or an average price to define my "substantive" price, but my population of prices isn't evenly distributed. So, the most "substantive" price may not necessarily be the median or the average.

    I can figure this out myself by using goal seek (ex., if substantive price = $2,000, then 15 out of 20 sales are within range, if substantive price = $2,100, then 14 out of 20 sales are within range, etc.). However, I don't want to hunt and peck. I want a function that will automatically calculate the best fit to the bell-curve.

    I've uploaded an example of what I'm talking about.

    Any suggestions?

    Thanks!
    Attached Files Attached Files

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Doing a "best fit" bell-curve analysis

    So the mean price is $1625, and the standard deviation is $415. Now what?
    Entia non sunt multiplicanda sine necessitate

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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