I have numerous x/y series that aren't regularly sampled, I need to create an average of these series on a regularly sampled output. Here's the beginning of 3 example series: x1 y1 x2 y2 x3 y3 2.055 1542.36 1.013 1540.924 1.185 1541.119 3.077 1542.382 2.028 1540.778 2.002 1541.082 4 1542.418 3.078 1540.729 3.002 1541.06 5.009 1542.47 4.077 1540.721 4.072 1541.078 6.045 1542.463 5.005 1540.737 5.06 1541.101 The full dataset when plotted looks like this: What I would like is a moving average of all those series output as a new set of x/y pairs, ideally incrementing by 1. Making a brand new snakey trend line that hangs out in the middle of all those other curves. The best I've figured out how to do is make a moving average trendline of a single series appear, and I can't actually get the values any way other than visual.

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Creating and exporting moving average values from multiple series

Thread starter Dooarazumas
Start date Aug 21, 2023
Tags

moving average multiple series trend

Dooarazumas

New Member

Aug 21, 2023

I have numerous x/y series that aren't regularly sampled, I need to create an average of these series on a regularly sampled output. Here's the beginning of 3 example series:

x1	y1	x2	y2	x3	y3
2.055	1542.36	1.013	1540.924	1.185	1541.119
3.077	1542.382	2.028	1540.778	2.002	1541.082
4	1542.418	3.078	1540.729	3.002	1541.06
5.009	1542.47	4.077	1540.721	4.072	1541.078
6.045	1542.463	5.005	1540.737	5.06	1541.101

The full dataset when plotted looks like this:

What I would like is a moving average of all those series output as a new set of x/y pairs, ideally incrementing by 1. Making a brand new snakey trend line that hangs out in the middle of all those other curves.

The best I've figured out how to do is make a moving average trendline of a single series appear, and I can't actually get the values any way other than visual.