My Math Forum Integer harmonized data in other scale
 User Name Remember Me? Password

 Probability and Statistics Basic Probability and Statistics Math Forum

 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 = 0 Bar = 23 Baz = 47 Qux = 88 Quxx = 100And I want to put it on another list in which not all my elements but only some L1 = 321 Bar = 427 L3 = 430 Qux = 432 L5 = 552What 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: 2,549 Thanks: 1399 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: =((E2-min(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: 2,549
Thanks: 1399

Quote:
 Originally Posted by ulises2010 Thanks romsek... but I don't understand. I normalize the data with this excel formula: =((E2-min(E2:E28))/(MAX(E2:E28)-min(E2:E28)))*100 What do you propose?
Are you saying that bar was 427 before you rescaled it?

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.95924 B 10533.13138 C 6577.410098 D 1485.161134 E 4783.793628 F 605.5022578 G 3075.351796 H 5297.838888 I 3665.250456 J 8078.53943 K 9568.715523 L 24241.96974 M 4018.821608 N 19765.286 O 6272.29431 P 5900.627335 Q 4186.309794 R 12744.83994 S 10051.84912 T 12032.2509 U 11787.90014 V 4855.601458 W 6773.989664 X 8946.267047 Y 5304.473946 Z 5641.43848 A1 4368.112301I normalize A 57.1551438 B 42.00132329 C 25.26565293 D 3.721617357 E 17.6773089 F 0 G 10.44931752 H 19.85210621 I 12.94503166 J 31.61655682 K 37.92112028 L 100 M 14.44090304 N 81.06026737 O 23.97478412 P 22.40235383 Q 15.14950378 R 51.35851068 S 39.96513808 T 48.34372416 U 47.30993703 V 17.98110992 W 26.09733206 X 35.28769599 Y 19.88017749 Z 21.30579041 A1 15.91866486And now have to put in other scale we only have this data A B C D 56.88 E F 48.18 G H I J K L M N O P Q R S T U V W X Y Z A1 50.38 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 Linear Mode

 Similar Threads Thread Thread Starter Forum Replies Last Post taylor_1989_2012 Physics 2 June 6th, 2016 03:52 AM Dev Dorian Computer Science 6 September 1st, 2013 11:25 PM lumpa Real Analysis 0 October 19th, 2012 08:07 AM haftakhan Algebra 3 June 17th, 2011 09:44 AM BigLRIP Advanced Statistics 1 May 18th, 2009 10:01 AM

 Contact - Home - Forums - Cryptocurrency Forum - Top