Data Manipulation Question

Greatgraddage · March 11th, 2008, 03:02 PM

OK, this is driving me mad, so I thought I could ask here.

I have a set of data, about 1000 points with the x axis running from -10 to 10 and the y axis being the variable data that plots a simple bell shaped curve.

Now, I want to spread that data over a larger number of points, say around 2000. Now I know I can't just make more points so I'd like to average the curve over a larger number of points. Is there anyway to do this in excel or other graph software like Origin?

Will be grateful for any ideas.

DavidHyde · March 11th, 2008, 09:17 PM

DPlot: http://www.dplot.com. Trial version at http://www.dplot.com/dplotsetup.exe.

The Equal Intervals command on the Edit menu will do what you want, with several options for how the new data is interpolated.

Greatgraddage · March 12th, 2008, 12:32 AM

You sir are an angel, especially for joining purely to help me! I'll give you some rep, but I hardly feel that expresses my gratitude!

March 11th, 2008, 03:02 PM	#1
Greatgraddage Joined: Jun 7th, 2004 Last Online: Yesterday Location: Wales, UK Age: 22 Posts: 952 Car: 205 1.9 GTI Rep Power: 21	Data Manipulation Question OK, this is driving me mad, so I thought I could ask here. I have a set of data, about 1000 points with the x axis running from -10 to 10 and the y axis being the variable data that plots a simple bell shaped curve. Now, I want to spread that data over a larger number of points, say around 2000. Now I know I can't just make more points so I'd like to average the curve over a larger number of points. Is there anyway to do this in excel or other graph software like Origin? Will be grateful for any ideas. __________________ Currently Drive - 205 GTI Currently Want - 1967 Mustang GT500 (Eleanor!)

March 12th, 2008, 12:32 AM	#3
Greatgraddage Joined: Jun 7th, 2004 Last Online: Yesterday Location: Wales, UK Age: 22 Posts: 952 Car: 205 1.9 GTI Rep Power: 21	You sir are an angel, especially for joining purely to help me! I'll give you some rep, but I hardly feel that expresses my gratitude! __________________ Currently Drive - 205 GTI Currently Want - 1967 Mustang GT500 (Eleanor!)

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Keeping Exif - Data after editing a picture	mautzel	Photography	6	March 3rd, 2007 12:34 PM
Cell Phone- USB Data Cable Question	No Boss	Technology	14	June 3rd, 2006 12:04 PM
Data Retention in the EU	Cruzz563	Off-Topic	9	August 26th, 2005 12:32 AM
DATA CABLE HELP	Raheel	Technology	4	April 3rd, 2005 10:55 PM
99.9 % and Error: Data missing	Rallye	Problems	2	June 14th, 2004 10:02 PM

March 11th, 2008, 09:17 PM	#2
DavidHyde Joined: Mar 11th, 2008 Last Online: March 11th, 2008 Posts: 1 Rep Power: 0	DPlot: http://www.dplot.com. Trial version at http://www.dplot.com/dplotsetup.exe. The Equal Intervals command on the Edit menu will do what you want, with several options for how the new data is interpolated.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)