normalizing data

[Vance]

I have a data set of roughly 3600 data points and would like to convert it to
1000 data points while still maintaining the shape of the curve. I am
currently using excel 2007, but I need the file to be compatible with the
older versions of excel as well.

 

[Vance]

Unfortunately my data sets will not always be 3600 data points. What I am
doing is recording subjects completing a specific task, there time to
completion is going to vary from subject to subject, and therefore I will
have a different number of data points for each subject. I want to normalize
each subjects data to the same number of points so that I can graph them for
easy comparison. Because of the varying number of data points I don't think
your method of deleting a pre-determined ratio of the data points would be
effective.

 

[smartin]

Unfortunately my data sets will not always be 3600 data points. What I am
doing is recording subjects completing a specific task, there time to
completion is going to vary from subject to subject, and therefore I will
have a different number of data points for each subject. I want to normalize
each subjects data to the same number of points so that I can graph them for
easy comparison. Because of the varying number of data points I don't think
your method of deleting a pre-determined ratio of the data points would be
effective.

You could try this modification of Sean's technique. This adjusts the
ratio using the actual number of observations in column A:

=IF(INT(MOD(ROW(A2),COUNT(A:A)/1000))=0,"","X")