Forum Discussion
Challenge: Find the largest Sub-Array (7 consecutive elements) within a 1,000 element vector
The challenge is simple. Find the sub-array (7 consecutive elements) within a 1,000 array vector with the largest SUM total. The vector was randomly generated and there are no duplicates. My s...
This is intended as an alternative solution to your first problem using convolution. The implementation took me days but that was a while back. To use the function is not so bad!
Before I opened the file, my guess is you did it with 'rolling average' trendline but I see you took it a step further and produced something that really works well visually (I did try adding a 'moving average' trend line but it didn't look as good as your version here). This Scatter chart is really sharp!
It's interesting Excel has some tools tucked away for analyzing data like this. Data Analysis's Moving Average (w/7 set as interval) does produce a rolling average for the data set but does so with scalars and not silky arrays,
