Picking limited points to best represent a Curve or trendline

[stephanies0123]

Please excuse me this is my first post and I am not familiar with the lay out or formatting here.

I am wondering if there is an easy way to pick out 8 points along my curve or trendline that will best represent the curve.

Here's what I have:

[TABLE="width: 327"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD] Sweep[/TD]
[TD] Thermistor ADC[/TD]
[TD] Power (dBm)[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]39963[/TD]
[TD="align: right"]16.532[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: right"]39917[/TD]
[TD="align: right"]16.508[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD="align: right"]39850[/TD]
[TD="align: right"]16.475[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD="align: right"]39782[/TD]
[TD="align: right"]16.439[/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD="align: right"]39679[/TD]
[TD="align: right"]16.397[/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD="align: right"]39563[/TD]
[TD="align: right"]16.354[/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[TD="align: right"]39440[/TD]
[TD="align: right"]16.302[/TD]
[/TR]
[TR]
[TD="align: right"]8[/TD]
[TD="align: right"]39279[/TD]
[TD="align: right"]16.239[/TD]
[/TR]
[TR]
[TD="align: right"]9[/TD]
[TD="align: right"]39079[/TD]
[TD="align: right"]16.172[/TD]
[/TR]
[TR]
[TD="align: right"]10[/TD]
[TD="align: right"]38843[/TD]
[TD="align: right"]16.096[/TD]
[/TR]
[TR]
[TD="align: right"]11[/TD]
[TD="align: right"]38589[/TD]
[TD="align: right"]16.032[/TD]
[/TR]
[TR]
[TD="align: right"]12[/TD]
[TD="align: right"]38302[/TD]
[TD="align: right"]15.943[/TD]
[/TR]
[TR]
[TD="align: right"]13[/TD]
[TD="align: right"]37983[/TD]
[TD="align: right"]15.831[/TD]
[/TR]
[TR]
[TD="align: right"]14[/TD]
[TD="align: right"]37645[/TD]
[TD="align: right"]15.735[/TD]
[/TR]
[TR]
[TD="align: right"]15[/TD]
[TD="align: right"]37265[/TD]
[TD="align: right"]15.616[/TD]
[/TR]
[TR]
[TD="align: right"]16[/TD]
[TD="align: right"]36834[/TD]
[TD="align: right"]15.493[/TD]
[/TR]
[TR]
[TD="align: right"]17[/TD]
[TD="align: right"]36370[/TD]
[TD="align: right"]15.355[/TD]
[/TR]
[TR]
[TD="align: right"]18[/TD]
[TD="align: right"]35906[/TD]
[TD="align: right"]15.228[/TD]
[/TR]
[TR]
[TD="align: right"]19[/TD]
[TD="align: right"]35455[/TD]
[TD="align: right"]15.111[/TD]
[/TR]
[TR]
[TD="align: right"]20[/TD]
[TD="align: right"]34992[/TD]
[TD="align: right"]14.966[/TD]
[/TR]
[TR]
[TD="align: right"]21[/TD]
[TD="align: right"]34513[/TD]
[TD="align: right"]14.833[/TD]
[/TR]
[TR]
[TD="align: right"]22[/TD]
[TD="align: right"]34033[/TD]
[TD="align: right"]14.701[/TD]
[/TR]
[TR]
[TD="align: right"]23[/TD]
[TD="align: right"]33545[/TD]
[TD="align: right"]14.551[/TD]
[/TR]
[TR]
[TD="align: right"]24[/TD]
[TD="align: right"]33044[/TD]
[TD="align: right"]14.397[/TD]
[/TR]
[TR]
[TD="align: right"]25[/TD]
[TD="align: right"]32554[/TD]
[TD="align: right"]14.255[/TD]
[/TR]
[TR]
[TD="align: right"]26[/TD]
[TD="align: right"]32090[/TD]
[TD="align: right"]14.12[/TD]
[/TR]
[TR]
[TD="align: right"]27[/TD]
[TD="align: right"]31665[/TD]
[TD="align: right"]14.001[/TD]
[/TR]
[TR]
[TD="align: right"]28[/TD]
[TD="align: right"]31252[/TD]
[TD="align: right"]13.847[/TD]
[/TR]
[TR]
[TD="align: right"]29[/TD]
[TD="align: right"]30858[/TD]
[TD="align: right"]13.714[/TD]
[/TR]
[TR]
[TD="align: right"]30[/TD]
[TD="align: right"]30480[/TD]
[TD="align: right"]13.584[/TD]
[/TR]
[TR]
[TD="align: right"]31[/TD]
[TD="align: right"]30139[/TD]
[TD="align: right"]13.459[/TD]
[/TR]
[TR]
[TD="align: right"]32[/TD]
[TD="align: right"]29814[/TD]
[TD="align: right"]13.318[/TD]
[/TR]
[TR]
[TD="align: right"]33[/TD]
[TD="align: right"]29496[/TD]
[TD="align: right"]13.173[/TD]
[/TR]
[TR]
[TD="align: right"]34[/TD]
[TD="align: right"]29203[/TD]
[TD="align: right"]13.051[/TD]
[/TR]
[TR]
[TD="align: right"]35[/TD]
[TD="align: right"]28932[/TD]
[TD="align: right"]12.927[/TD]
[/TR]
[TR]
[TD="align: right"]36[/TD]
[TD="align: right"]28693[/TD]
[TD="align: right"]12.803[/TD]
[/TR]
[TR]
[TD="align: right"]37[/TD]
[TD="align: right"]28464[/TD]
[TD="align: right"]12.67[/TD]
[/TR]
[TR]
[TD="align: right"]38[/TD]
[TD="align: right"]28241[/TD]
[TD="align: right"]12.537[/TD]
[/TR]
[TR]
[TD="align: right"]39[/TD]
[TD="align: right"]28038[/TD]
[TD="align: right"]12.424[/TD]
[/TR]
[TR]
[TD="align: right"]40[/TD]
[TD="align: right"]27847[/TD]
[TD="align: right"]12.31[/TD]
[/TR]
[TR]
[TD="align: right"]41[/TD]
[TD="align: right"]27679[/TD]
[TD="align: right"]12.194[/TD]
[/TR]
[TR]
[TD="align: right"]42[/TD]
[TD="align: right"]27529[/TD]
[TD="align: right"]12.098[/TD]
[/TR]
[TR]
[TD="align: right"]43[/TD]
[TD="align: right"]27389[/TD]
[TD="align: right"]12.009[/TD]
[/TR]
[TR]
[TD="align: right"]44[/TD]
[TD="align: right"]27267[/TD]
[TD="align: right"]11.914[/TD]
[/TR]
[TR]
[TD="align: right"]45[/TD]
[TD="align: right"]27153[/TD]
[TD="align: right"]11.835[/TD]
[/TR]
[TR]
[TD="align: right"]46[/TD]
[TD="align: right"]27045[/TD]
[TD="align: right"]11.752[/TD]
[/TR]
</tbody>[/TABLE]


​

I plot these on a scatter chart curve and can get a trendline, but what I really need to do is narrow it down and pull out 8 Sweep points that best represent the curve.
Right now I am doing this by hand but it is quite monotonous and I'm hoping these an easier way.
For Example on this run I would pick out:
[TABLE="width: 327"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD] Sweep[/TD]
[TD] Thermistor ADC[/TD]
[TD] Power (dBm)[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]39963[/TD]
[TD="align: right"]16.532[/TD]
[/TR]
[TR]
[TD="align: right"]22[/TD]
[TD="align: right"]34033[/TD]
[TD="align: right"]14.701[/TD]
[/TR]
[TR]
[TD="align: right"]26[/TD]
[TD="align: right"]32090[/TD]
[TD="align: right"]14.12[/TD]
[/TR]
[TR]
[TD="align: right"]29[/TD]
[TD="align: right"]30858[/TD]
[TD="align: right"]13.714[/TD]
[/TR]
[TR]
[TD="align: right"]32[/TD]
[TD="align: right"]29814[/TD]
[TD="align: right"]13.318[/TD]
[/TR]
[TR]
[TD="align: right"]35[/TD]
[TD="align: right"]28932[/TD]
[TD="align: right"]12.927[/TD]
[/TR]
[TR]
[TD="align: right"]39[/TD]
[TD="align: right"]28038[/TD]
[TD="align: right"]12.424[/TD]
[/TR]
[TR]
[TD="align: right"]46[/TD]
[TD="align: right"]27045[/TD]
[TD="align: right"]11.752[/TD]
[/TR]
</tbody>[/TABLE]


Thanks in advance for your help!