software

Hi folks ...any help here would be much appreciated.

Simply in column a I have time and column b is the number of records
processed within this time period.

What I would like to do is to extrapolate time against the number of
records to get an idea of how long 30,000 records is likely to take.The data I have is as follows.

Time (A) Records Processed (B)
1.5 500
3.5 1600
20 3600
??? 30000
Does anyone know how given these this small dataset with uneven timings
to extrapolate on how minute minutes that 30,000 is likely to take?

Any help would be greatly appreciated.Thanks
Steve FranklinUsing the forecast function

=FORECAST(30000,A2:A4,B2:B4)

with time in A2:A40 and records processed in B2:B4

returns 183.8161

--
Regards,

Peo Sjoblom

Northwest Excel Solutions

Portland, Oregon

quot;Honkey Lipsquot; gt; wrote in message oups.com...
gt; Hi folks ...any help here would be much appreciated.
gt;
gt; Simply in column a I have time and column b is the number of records
gt; processed within this time period.
gt;
gt; What I would like to do is to extrapolate time against the number of
gt; records to get an idea of how long 30,000 records is likely to take.
gt;
gt;
gt; The data I have is as follows.
gt;
gt; Time (A) Records Processed (B)
gt; 1.5 500
gt; 3.5 1600
gt; 20 3600
gt; ??? 30000
gt;
gt;
gt;
gt; Does anyone know how given these this small dataset with uneven timings
gt; to extrapolate on how minute minutes that 30,000 is likely to take?
gt;
gt; Any help would be greatly appreciated.
gt;
gt;
gt; Thanks
gt; Steve Franklin
gt;