Statistics function to reprofile/redistribute a data set over diff time period

[Vilok Kusumakar]

We have a series of data over a time interval. We want to
maintain the profile over a reduced interval.

We want to total value of the data series to remain the
same, but have a new profile with a similar distribution.

Simple Example. A data set over 6 (x) month period like
this
1 2 2 2 2 1

becomes the following over a 3 (y) month period.
3 4 3

Our problem set has various values of x and y and data set
is distributed randomly.

Thanks,
Vilok

 

[Tushar Mehta]

I am sure what you are asking for makes sense to you, but I don't know
what you mean by 'maintain the profile.' In the original data set, the
mean and std dev are 1.5 and 0.516 respectively, whereas the 2nd data
set has a mean of 3.33 and a std dev of 0.577. The first data set has
an an initial increase of 100% and a subsequent decrease of 50%. The
corresponding values for the 2nd data set are 33% and 25%.

It would appear that all you are doing is aggregating the data for
sufficient periods to reduce the number of data points. Is that how
you want to 'reprofile' the distribution?

How would you expect the example below to be adjusted?
0 4 2 2 4 0

Finally, you might want to consider sharing the actual data instead of
a 'simple example.'


--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions