|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
August 12th, 2009, 06:24 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
normalizing data
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. 
|
|
#2
August 13th, 2009, 04:31 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
normalizing data
So, you are looking to remove, say, 2 of every three data points...
Try this... assuming your data is in cells A2 - A3600 =IF(MOD(ROW(A2),3)=0,"","X") Then, filter your data, use the drop-down to select your X fields, then delete those rows. this will leave @ 1000 records acrosss your spectrum. "Vance" wrote: 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.
|
|
#3
August 13th, 2009, 06:23 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
normalizing data
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. "Sean Timmons" wrote: So, you are looking to remove, say, 2 of every three data points... Try this... assuming your data is in cells A2 - A3600 =IF(MOD(ROW(A2),3)=0,"","X") Then, filter your data, use the drop-down to select your X fields, then delete those rows. this will leave @ 1000 records acrosss your spectrum. "Vance" wrote: 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.
|
|
#4
August 16th, 2009, 12:25 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
normalizing data
Vance wrote:
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. "Sean Timmons" wrote: So, you are looking to remove, say, 2 of every three data points... Try this... assuming your data is in cells A2 - A3600 =IF(MOD(ROW(A2),3)=0,"","X") Then, filter your data, use the drop-down to select your X fields, then delete those rows. this will leave @ 1000 records acrosss your spectrum. "Vance" wrote: 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. 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")
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
