Craig F.

asked • 12/28/17

Calculate price based on score using distribution

Hopefully I can make sense of this. I'm writing a program that requires pricing of items. For an example let's say houses. Items are evaluated and given a score. Given that these scores are normally distributed, but prices have a right-skewed distribution I would like to be able to calculate the asking price of each item. It's been a long time since I've done this kind of math, and I'm trying to remember how to do it. I have some current statistics including total number of items, mean, mode, range and median of current item prices.
 
For example, let's say there is a mean of about 300,000, a median of about 240,000, a mode of 250,000, and a range between 67,000 - 800,000, and 320 houses total. If I have  the item's score, can I calculate it's likely price? Any help you can give is appreciated.

1 Expert Answer

By:

Andy C. answered • 12/28/17

Tutor
4.9 (27)

Math/Physics Tutor

Craig F.

Yes, I suppose they are.
Report

12/28/17

Andy C.

Then you may be better of doing a least squares regression trend line between the scores and the price.
You can use the data to find the slope and intercept of the best fit trend line.
Nothing easier than a linear function.
 
If you can come up with some data in the form of ordered pairs,  (score, price)
then we can get a best fit trend line for you.
 
Let suppose the scores are 0-100.
The slope CAN be (800000 - 67000)/(100 - 0)   <---- range of prices divided by range of scores
                                = 7330
 
So a possible trend line is Price = 7330*score + 67000
 
For example a house with a score of zer0 price at 67000.
A house with a score of 100 prices at 800000.
 
A house with a score of 50 prices at 7330*50+67000 = 433500
                        
Report

12/28/17

Still looking for help? Get the right answer, fast.

Ask a question for free

Get a free answer to a quick problem.
Most questions answered within 4 hours.

OR

Find an Online Tutor Now

Choose an expert and meet online. No packages or subscriptions, pay only for the time you need.