Pace Insights | See The Hidden Value – Sort Your Noisy Data
Helping Sports professionals master their data with data science services.
Data Science for Sports Teams
15957
page-template-default,page,page-id-15957,ajax_fade,page_not_loaded,,qode-child-theme-ver-1.0.0,qode-theme-ver-11.1,qode-theme-bridge,wpb-js-composer js-comp-ver-4.12,vc_responsive
 

See The Hidden Value – Sort Your Noisy Data

You’ve got noisy data.

 

You can see the underlying trend but there’s no obvious function in Excel (or your other tools) to help you.

 

We’ve developed some tools to help.

 

Watch the video [6:50] below and scroll down for more information.

Moving Averages

 

You’re familiar with moving averages, likely used them before, but what is the right number of points to average over?

 

It takes a while to iterate through this and involves lots of copy and pasting in cells.

 

If you’ve a lot of data, Excel struggles and it takes a long time.

 

You also know that moving averages offset the data by the number of points you’re averaging over.

 

If your data is time dependant then this can create a big issue – even if you’re not always aware of it.

A “Proper” Filter

 

You may also know that moving averages are not really proper filters at all.

 

They don’t actually filter anything, they just smooth all the data – signal and noise – together.

 

You know that there are potentially better data filters but you’ve not been able to implement them easily within Excel.

 

If you have tried then it’s also likely taken an age to do, they’re unlikely to be dynamic and easy to change or port to other data sources.

 

We’ve been there.

 

We’ve faced these same challenges, time and again.

 

There is good news though. We’ve now made three tools available to help you.

PREMIUM BUNDLE

  • Advanced version of the tool.
  • Auto-load data
  • Apply both the filter and average.
  • Adjust settings with a live slider.
  • Instantly compare results.
  • Unlocked VBA code.
  • Detailed video tour of the code.
  • Tips for your own projects.
  • Test data.
  • The Butterworth Filtering LITE tool, and
  • The Moving Average LITE tool.

FILTER ONLY

  • Butterworth Filtering LITE tool

MOVING AVE. ONLY

  • Moving Average LITE tool

Tools & Lessons You Can Apply Immediately

 

These tools will enable you too:

 

    • rapidly apply a moving average to your data

 

    • rapidly iterate through moving average settings to find the best result

 

    • apply a butterworth filter to your data, a true filter and we’ve set it up with no time offset, so the time will line up exactly with your underlying noisy data.

 

    • iterate through the butterworth filter settings to see the best result

 

    • compare the results of these filters all together to choose the best one

 

    • have access to the code to use in your own projects

 

    • have access to a dedicated code walk through video, to explain how it works.

 

  • have access to sample data to see the format and experiment with the settings

Tools We Use All The Time

 

Measured sensor data is so often noisy.

 

Having the ability to quickly run ‘look see’ evaluations, find features and trends is invaluable.

 

Perhaps Excel and other tools should have this feature baked in.

 

However they don’t so we’ve done it for you.

PREMIUM BUNDLE

  • Advanced version of the tool.
  • Apply both the filter and average.
  • Adjust settings with a live slider.
  • Instantly compare results.
  • Unlocked VBA code.
  • Detailed video tour of the code.
  • Tips for your own projects.
  • Test data.
  • The Butterworth Filtering LITE tool, and
  • The Moving Average LITE tool.

FILTER ONLY

  • Butterworth Filtering LITE tool

MOVING AVE. ONLY

  • Moving Average LITE tool

“The signal is the truth. The noise is what distracts us from the truth.”
― Nate Silver, The Signal and the Noise: Why So Many Predictions Fail - But Some Don't