
Probability and Statistics Basic Probability and Statistics Math Forum 
 LinkBack  Thread Tools  Display Modes 
April 20th, 2017, 01:31 AM  #1 
Newbie Joined: Apr 2017 From: Spain Posts: 4 Thanks: 0  Integer harmonized data in other scale
I have n data and harmonize them to be between 1 and 100. These data I have to integrate into another data scale, some of which correspond to some of mine. For example, I have already normalized these data: Foo = 0And I want to put it on another list in which not all my elements but only some L1 = 321What I need to get is the values of foo, baz and quux on that new scale (of course it's just an example, the lists would have many more records and could be repeated in both of them. 
April 20th, 2017, 01:45 AM  #2 
Senior Member Joined: Sep 2015 From: USA Posts: 1,781 Thanks: 919 
can't you just divide these new values by the same normalization factor you used in the first batch?

April 20th, 2017, 01:52 AM  #3 
Newbie Joined: Apr 2017 From: Spain Posts: 4 Thanks: 0 
Thanks romsek... but I don't understand. I normalize the data with this excel formula: =((E2min(E2:E28))/(MAX(E2:E28)min(E2:E28)))*100 What do you propose? Last edited by skipjack; April 20th, 2017 at 03:25 AM. 
April 20th, 2017, 01:56 AM  #4  
Senior Member Joined: Sep 2015 From: USA Posts: 1,781 Thanks: 919  Quote:
And that Qux was 432? But after rescaling you end up with bar=23 Qux=88 ? Last edited by skipjack; April 20th, 2017 at 03:26 AM.  
April 20th, 2017, 02:58 AM  #5 
Newbie Joined: Apr 2017 From: Spain Posts: 4 Thanks: 0 
No, I don't know exactly the number before normalize, it's only an example... ok, I do it with real data: I have this numbers: A 14114.95924I normalize A 57.1551438And now have to put in other scale we only have this data A Last edited by skipjack; April 20th, 2017 at 03:27 AM. 
April 20th, 2017, 03:12 AM  #6 
Newbie Joined: Apr 2017 From: Spain Posts: 4 Thanks: 0 
No, I rescale bar and qux and obtain 23 and 88... but in the new scale I have to put all the number I know bar and qux value is 427 and 432 but not the value of others. I try to explain better but is revision the post 

Tags 
data, harmonized, integer, scale 
Thread Tools  
Display Modes  

Similar Threads  
Thread  Thread Starter  Forum  Replies  Last Post 
centigrade scale, Celsius scale and thermodynamic scale  taylor_1989_2012  Physics  2  June 6th, 2016 03:52 AM 
Compacting data into a 16bit integer  Dev Dorian  Computer Science  6  September 1st, 2013 11:25 PM 
Rolling 3 months YOY data to Monthly YOY data  lumpa  Real Analysis  0  October 19th, 2012 08:07 AM 
Scale on Map  haftakhan  Algebra  3  June 17th, 2011 09:44 AM 
How to regress actual data towards projected data.  BigLRIP  Advanced Statistics  1  May 18th, 2009 10:01 AM 