The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
Username:
 Password:
Save Password
Forgot your Password? | Admin Options

 All Forums
 Origin Forum
 Origin Forum
 Normalizing data in different columns		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

queeni1

Spain
1 Posts
Posted - 09/10/2012 :  08:18:32 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Origin Ver.8.0988 and Service Release 6:
Operating System: Win XP

Hi there,

I would like to normalize data in different columns and each column should be normalized to its data. Somehow I am facing problems by doing this automatically. Choosing Analysis:Mathematics:Normalize:Open Dialog opens the normalization dialog. If I set

Recalculate: Manual
Input: [Workbook]Sheet1!2:20
Normalize Methods: Normalize to [0,1]
Output: Input

the data in all columns is normalized to column 2.

Does anyone know which setting is wrong, or which setting I have to change to normalize all columns automatically?

Thanks in advance for your help!

JessieWoo

China
46 Posts
Posted - 09/11/2012 :  01:08:41 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi,
Origin 8.0 does not support normalizing multiple columns in the vnormalize dialog.
You can try running the following scripts in the Script Window (from menu, Window: Script Window, if its not opened).

for(ii=2; ii<21; ii++)
{
vnormalize ix:=wcol(ii) method:=range;
}


Origin 8.6 supports normalizing multiple columns from the dialog. If youre interested, you can download a free demo here:
http://www.originlab.com/index.aspx?go=Downloads/OriginEvaluation

Best Regard,
Jessie
Originlab Corp.
Go to Top of Page
  Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000