Re: 'trend value' formula needed


matt271829-news@xxxxxxxxxxx wrote:
khany wrote:

Hi all,

hope this isn't too off-topic but i could really do with some help

i have, say, at least 5 records with 3 columns of data based on
industry activity (so
not pre-determined by me)

the values of the first 2 columns roughly reflect the value of the
third.

i want to be able to pass in 2 arbitrary values for the first 2 columns
and get a trend/predicted value for the third back.

eg. some records I already have:

A:22000, B:24, C: 5000
A:36000, B:35, C: 3200
A:56000, B:43, C: 1800

so as A and B increase (not directly related) C decreases.

So if I pass in A:39000 and B:37 what would C be? more importantly,
whats the formula?

thanks in advance

khany

So, you have two variables A and B, and you think that C is
approximately determined by A and B. Based on the data you have, you
want to find an equation "C = some calculation involving A and B" that
gives the best prediction of C. There is no "formula" that will
magically do this for you in all cases; instead there are techniques,
which generally come under the name of "regression analysis" (Googling
this should throw up plenty of info).

However, if you know, or can reasonably assume, that the "calculation
involving A and B" approximately follows some particular form - for
example C = p*A + q*B + r for some numbers p, q and r to be determined
- then life is potentially easier. Do you have an idea about what the
nature of relationship between A, B and C ought to be, or are you in
the dark? (Knowing that C decreases as A and B increase is not really
specific enough; it could decrease with A and B in any of innumerable
ways.)

OK, I can see I need to pass more information to you all. I really
appreciate this.

The records represent cars that have sold and column A is the mileage
of the car and B is the number of months old the car is at the point of
sale. So based on existing records, I want to pass mileage and age and
receive in return an approximate value or even value range (high|low).

hope this helps

.

Relevant Pages

  • Re: trend value formula needed
    ... The records represent cars that have sold and column A is the mileage ... of the car and B is the number of months old the car is at the point of ... calculate value from age and mileage alone will result in completely ... You would need to figure out the depreciation rate, ...
    (sci.math)
  • Re: Wow, where are these crazy MPG figures coming from ?
    ... mpg is best i get ... The gas mileage was killing us: ... you don't go anywhere without a car and gas is the most ...
    (rec.autos.makers.chrysler)
  • Re: Saturn is doomed?
    ... But the biggest reason mileage has changed is that in response to pressure ... The sticker from my son's car said 40 highway and that is exactly what he ... emissions from a given car. ... that this set up would fail the federal test cycle omissions test. ...
    (rec.outdoors.rv-travel)
  • Re: 2005 Malibu LS V6 Fuel Filters
    ... pressure, and I replaced the air filter 1,000 miles ago. ... Frankly this car never got more than 20 city and 24 highway when I ... My octane rating and mileage should actually be better! ... effect on fuel economy unless it was so plugged it turned on the check ...
    (rec.autos.tech)
  • Re: Religion and sin, and anti-religion and saints...
    ... your ordinary gas guzzler. ... the average mileage is down to 21MPG and change. ... including your car in that equation therefore your car is a gas ... average of 26 mpg with both CITY and HIGHWAY driving. ...
    (soc.men)