Not content with plotting the past, the numbers are now encouraging me to predict the future.
The genius of Excel allow you calculate a trendline based on past achievements, and plot your future with a high degree of mathematical certainty. I’d say a precision level of certainty, found only in the Rolls Royce factories of Derby and the East Midlands.
This now means the end of idle guess work and those moments of anxiety fuelled by What the Heck? (or worse); Why On Earth? You’re ‘avin’ a laff’ can be replaced by the cool scientific endeavour of the linear forecast equation.
y = 1.8393x + 2.019
If you’ve been following the rather tortured trail of the last 15 days, you’ll have spotted the ever-increasing mountain of statistics which have led to the above statement.
It means in short, that I can be guaranteed that on day 20, I will have shot 39.8976 baskets; and by day 26 (the pinnacle of this challenge) I can safely predict a final score of 51.26118 baskets. There’s a thought! What 0.26118 of a basket consists of still has to be figured out but I’m guessing it’ll be something to do with those balls that spiral downwards, only to leap out again when you least expect it and when your invigilator has ticked it off as a score.
Praise the Lord for the Linear Forecast Equation and for the glimpse of the future it predicts!
|Day||Attempts||Near Misses||Baskets||Effort (Baskets/ Attempt)||Baskets/ Minute (BPM)||FeelGood Factor||Total time||Total Shots||Total Baskets||Success rate|