Analyzing Time-Series of Individual Data – Part2: Using Harmful/Trivial/Beneficial Chances - Complementary Training
Analyzing Time-Series of Individual Data – Part2: Using Harmful/Trivial/Beneficial Chances

Click Here to Read the First Part »

Analyzing Time-Series of Individual Data

Part 2: Using Harmful/Trivial/Beneficial Chances

Just a quick update – after a comment by John Fitzpatrick (@JFitz138) on the use of Will Hopkins’s approach of calculating chances I decided to give it a shot.

For a Typical Error (used together with SWC to calculate chances) I used SD of the Rolling Average. 

To calculate chances I have coded simple VBA function that use NORM.DIST function of Excel. 

To calculate chances, one must assume that data points in Rolling average are normally distributed (and that might not be the case!) around their mean with SD. Here is my sketch:

My wonderful drawing skills

Even simpler approach than this might involve pure counting of days (data points) above, within and below baseline and SWC, especially for non-normally distributed data set (someone correct me if I said something stupid). Using Box and Whisker plot and interquartile ranges might also seem possible solution.

Anyway, here is the short video of the workbook and below you can find updated download link.

Members Only! Join Us Today and Watch This Video »

Start Your Membership Today

Join Us Today And Claim 2 Bonuses

Standard Membership
$35 per month


Go Annual and Get All Bonuses for FREE!

Join Us TodayAnd Instantly Save $2140

Premium Membership
$350 per year

I am a physical preparation coach from Belgrade, Serbia, grew up in Pula, Croatia (which I consider my home town). I was involved in physical preparation of professional, amateur and recreational athletes of various ages in sports such as basketball, soccer, volleyball, martial arts and tennis. Read More »