The true power of the LINEST function lies in using dynamic input data. Keep in mind, I’m using static data in this example. Don’t worry if you’re unfamiliar with baseball, we’re really just using them as arbitrary numbers. I’d also like to know if this linear equation is generally good at prediction runs or not. I’d like to produce and estimation of the number of runs a player would score given their number of plate appearances.
Specifically, plate appearances (PA) and runs scored (R). I’m going to use a few baseball numbers for the sake of an example.
