Great video. For me I get a 0.989 R^2 value, but when I copy the formula into the cell, I get horribly, horribly inaccurate numbers...Sigh, thanks Google.
Quickly browsed this on google's recommended page when I was looking up how to do this. Had to come to your youtube to thank you for this video. +1 sub!
Actually the next size up would be 9/16. 1/2” is too small so the next size up is 9/16 not 5/8 which could possibly be too large. A better way to do this is to take the half inch and multiply times 8/8 so ......... 1/2 X 8/8 = 8/16. Now just add one to the top number and get the next size up which is 9/16
Also well presented as "Zooming out/in" when dealing with the Efficient Frontier, in financial modelling by Simon Benninga. Same concept, different usage..