Yes, FORECAST would be OK if you believe in a linear best fit and
extrapolating.

If your game numbers 1 to 4 are in column A, & your distances in column B,
then use =FORECAST(5,B1:B4,A1:A4)

You can, of course, also show this graphically by selecting the range with
the game numbers & distances, Insert/ Chart/ XY (& choose an appropriate
sub-type). Finish the chart, then select the series, right-click/ Add
Trendline, and choose the option to extend forward by 1 unit.
--
David Biddulph

"RobertStanke" wrote in message
...
I thought I was using the right function command, but perhaps not. Here is
my issue: I have a roster of football players who have stats set-up in
Excel.
I want to be able to, after a series of games already played, forecast or
predict the what the outcome of the next game might be. For example:

A running back runs for 97 yards, 36 yards, 97 yards, and 102 yards in the
first four games of the season. I want to forecast what he might rush for
in
the 5th game. How do I do this in Excel?