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?