Dr Nick Owen MBE PLUS

Working in and on the Business of Cultural Education

Day 16 of the Basketball 2.6 Challenge: y = 1.8393x + 2.019

Leave a comment

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!

DayAttemptsNear MissesBasketsEffort (Baskets/ Attempt)Baskets/ Minute (BPM)FeelGood FactorTotal timeTotal ShotsTotal BasketsSuccess rate
1N/A08N/A0.308N/A268
21940157.73%0.577N/A5219423
31898721.06%0.07746.03%78383256.5%
419010773.68%0.26956.32%104573325.6%
5192105115.73%0.42354.69%130765435.6%
616710863.59%0.23164.67%156932495.3%
7174114148.05%0.53865.52%1821,106635.7%
9180108168.89%0.61560.00%2341,286634.9%
101661181810.84%0.69271.08%2601,452795.4%
111811212011.05%0.76966.85%2861,633975.9%
121761152413.64%0.92365.34%3121,8091176.5%
131791112413.41%0.92362.01%3381,9881417.1%
141761251910.80%0.73171.02%3642,1641607.4%
151671013219.16%1.23160.48%3902,3311928.2%
16147903523.81%1.34661.22%4162,4782279.2%

You can find out why I’m taking the 2.6 Basketball Challenge here  Any help you can offer is much appreciated!.

Author: drnicko

Cultural Architect

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s