Creating a formula to model my data

[herrma29]

Hello,

I am having some difficulty modeling data with two independent variables and a dependent variable.


The data is included below:

	20000	40000	60000	80000	100000
2017	12375	11000	9475	9250	9250
2016	12100	10800	9450	8150	7900
2015	11000	9975	8775	7600	6475
2014	9850	9125	8250	7000	6075
2013	8850	8225	7450	6525	5600
2012	7950	7575	7125	6375	5775
2011	6825	6525	6175	5575	5125
2010	5925	5775	5500	4975	4575
2009	5175	5175	4950	4550	4250
2008	4875	4875	4675	4450	4175
2007	4125	4125	3925	3700	3475
2006	3650	3650	3475	3275	3150
2005	3575	3575	3425	3350	3175
2004	3050	3050	2975	2875	2725
2003	2825	2825	2775	2700	2625

<colgroup><col><col span="2"><col span="3"></colgroup><tbody>
</tbody>

Below is another configuration of the same data:

2017	20000	12375
2017	40000	11000
2017	60000	9475
2017	80000	9250
2017	100000	9250
2016	20000	12100
2016	40000	10800
2016	60000	9450
2016	80000	8150
2016	100000	7900
2015	20000	11000
2015	40000	9975
2015	60000	8775
2015	80000	7600
2015	100000	6475
2014	20000	9850
2014	40000	9125
2014	60000	8250
2014	80000	7000
2014	100000	6075
2013	20000	8850
2013	40000	8225
2013	60000	7450
2013	80000	6525
2013	100000	5600
2012	20000	7950
2012	40000	7575
2012	60000	7125
2012	80000	6375
2012	100000	5775
2011	20000	6825
2011	40000	6525
2011	60000	6175
2011	80000	5575
2011	100000	5125
2010	20000	5925
2010	40000	5775
2010	60000	5500
2010	80000	4975
2010	100000	4575
2009	20000	5175
2009	40000	5175
2009	60000	4950
2009	80000	4550
2009	100000	4250
2008	20000	4875
2008	40000	4875
2008	60000	4675
2008	80000	4450
2008	100000	4175
2007	20000	4125
2007	40000	4125
2007	60000	3925
2007	80000	3700
2007	100000	3475
2006	20000	3650
2006	40000	3650
2006	60000	3475
2006	80000	3275
2006	100000	3150
2005	20000	3575
2005	40000	3575
2005	60000	3425
2005	80000	3350
2005	100000	3175
2004	20000	3050
2004	40000	3050
2004	60000	2975
2004	80000	2875
2004	100000	2725
2003	20000	2825
2003	40000	2825
2003	60000	2775
2003	80000	2700
2003	100000	2625

<colgroup><col><col><col></colgroup><tbody>
</tbody>

I am looking for the best way to model this data. The data points are non-linear.

Thanks!
Chris

 

[shg]

Can you describe the data? What's the independent variable?

 

[herrma29]

Sure!

Basically, the first column is a column of years a particular car make and model was built. The second column is a series of mileage intervals per year. The last column is the dependent variable, which is the price of that make and model based on the data in the first two columns.

My goal is to predict the value of this car based on year and mileage.

Thanks!

 

[shg]

No idea, but people have studied this. See, for example, http://people.virginia.edu/~sns5r/resint/empiostf/nptsfiles/nptsestimatebw.pdf