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.

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.